niceSOFT/sqlite: Official Git mirror of the SQLite source tree | Gitverse

/

/

Обзор ДокументацияВойти

/

/

Аналитика

Безопасность

Update JSON performance testing procedures for clarity and to describe how to do performance testing of JSONB.

3 года назад

Make test_wholenumber.c into a loadable extension and move it to ext/misc/wholenumber.c.

13 лет назад

Avoid running a couple of tests in affinity2.test as part of the valgrind permutations, as the way floating point computations are simulated by valgrind causes them to fail.

7 лет назад

If the SELECT that implements a subquery or a VIEW or a CREATE TABLE AS is a compound with different result datatypes on two or more arms of the compound, then the overall column type becomes BLOB (ANY).

4 года назад

Faster :memory: database COMMITs. Ticket #1790. (CVS 3178)

20 лет назад

Fix an error in new test script test/aggfault.test.

3 года назад

New test case based on Chromium bug report 1511689.

3 года назад

aggorderby.test

Pass subtype information through the aggregate ORDER BY sorter for aggregate functions that use subtype information.

3 года назад

Rework the column-cache mechanism to be more robust (and more correct). The column-alias cache is currently disabled, (CVS 6538)

17 лет назад

In all.test, do not attempt to run the RBU tests in non-RBU builds.

8 лет назад

Another assertion fault fix, similar to [a9443dbfbe25e588]. dbsqlfuzz 2d9af4e94aca188e0092900eec711401c5d51687.

3 года назад

Ensure that values generated by DEFAULT clauses that specify real numbers that can be expressed as 64-bit integers (e.g. -1234.0) are not silently converted to integers.

3 года назад

Fix issues in the new ADD COLUMN constraint checking. Add preliminary test cases.

5 лет назад

RETURNING bug fix: Correctly deal with RETURNING statements on changes to TEMP tables that also have triggers. dbsqlfuzz 78b9400770ef8cc7d9427dfba26f4fcf46ea7dc2

5 лет назад

Fix a compilation issue in the "userauth" extension. Also fix a few test script errors that occur with SQLITE_USER_AUTHENTICATION=1 builds.

8 лет назад

alterauth2.test

Fix a test result for alterauth2.test due to the recent fix to authorizer calls for ALTER TABLE DROP COLUMN.

5 лет назад

Test case for alter column that is used in the ORDER BY of an aggregate.

3 года назад

altercorrupt.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

alterdropcol.test

Ensure that all records are updated by setting the OPFLAG_SAVEPOSITION flag when updating records as part of ALTER TABLE DROP COLUMN.

5 лет назад

alterdropcol2.test

Fix broken requirement marks.

5 лет назад

alterfault.test

Do not attempt to run the tests in alterfault.est with SQLITE_OMIT_ALTERTABLE builds.

5 лет назад

alterlegacy.test

Fix various issues with the changes on this branch. Add test cases for the same.

5 лет назад

altermalloc.test

Enhance tester.tcl so that when "--malloctrace=1" is specified, the test generates self-contained Tcl scripts that present GUIs instead of *.sql files that require a separate program to interpret.

8 лет назад

altermalloc2.test

Update some OOM tests of the ALTER TABLE command to account for an error message which may be returned if opening the temp db fails.

4 года назад

altermalloc3.test

Test module altermalloc3.test requires DQS_DDL to be turned on.

3 года назад

Fix a test case broken by the previous check-in.

3 года назад

Fix an obscure issue with ALTER TABLE RENAME that comes up with triggers that have UPDATE statements that contain errors. [forum:/forumpost/ff3840145a|Forum post ff3840145a].

3 года назад

Fix a case where an error in the ORDER BY clause of an aggregate function that is part of a trigger body might cause an assert() to fail in an ALTER TABLE command.

2 года назад

Avoid expanding integer values in columns with real affinity to the full 8-byte representation when editing records as part of a DROP COLUMN command.

2 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Add some timing tests to the amatch test script.

13 лет назад

Fix an assert that can go bad if STAT4 content is corrupt. This is a follow-up to the previous check-in.

3 года назад

Do not overflow the Index.aSample[] array if the same index appears in the sqlite_stat4 table under multiple names because it is a WITHOUT ROWID primary key index. [forum:/info/537d8ab118df7edd|Forum post 537d8ab118df7edd]

3 года назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Minor STAT4 test case change due to the ANALYZE enhancement of [eb59c46a5aed69bc|check-in eb59c46a5aed69bc].

4 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

When reading sqlite_stat4 data during query planning, be sure to expand zeroblobs prior to running comparisons. Fix for the issue identified by [forum:/forumpost/5275207102|forum post 5275207102].

3 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Changes to test/analyzeG.test to conform to the new EXPLAIN QUERY PLAN syntax.

5 лет назад

Run TCL tests in a subdirectory "testdir".

10 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Some changes to test scripts related to codec enabled versions of sqlite.

16 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Remove all code that makes use of the C-language "long double" datatype.

2 года назад

Add new test file test/atomic.test.

9 лет назад

If an SQLITE_IOERR error is encountered as part of an atomic commit on an F2FS file-system, retry the commit in legacy journal mode.

8 лет назад

Extend the refactoring into extensions. Clean up stray newlines.

6 лет назад

Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of schemas. Add the new SQLITE_MAX_DB constant for the maximum number of schemas. [forum:/forumpost/a006d86f72|Forum post a006d86f72].

5 лет назад

Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize().

4 года назад

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

10 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

attachmalloc.test

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.

4 года назад

Disable the authorizer callback when reparsing the schema. This avoids undesirable authorization failures following an ALTER TABLE.

10 лет назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

autoanalyze1.test

Do not run test file autoanalyze1.test if OMIT_VIRTUALTABLE is defined.

9 лет назад

Add test cases to improve coverage of VDBE branches. Still some to go.

7 лет назад

autoindex1.test

Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output.

2 года назад

autoindex2.test

Do not use an automatic index on an outer loop that only runs once.

10 лет назад

autoindex3.test

Avoid creating an automatic index on a column that is known to be not very selective.

2 года назад

autoindex4.test

Fix the LEFT JOIN strength reduction for IN operators in the WHERE clause. Further simplifications and refinement of the algorithm.

3 года назад

autoindex5.test

Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid.

5 лет назад

autovacuum.test

Demostrate a prototype sqlite3_autovacuum_pages() interface.

5 лет назад

autovacuum2.test

Demostrate a prototype sqlite3_autovacuum_pages() interface.

5 лет назад

autovacuum_ioerr2.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2 года назад

Fix a typo preventing test script avtrans.test from running in auto-vacuum mode.

8 лет назад

backcompat.test

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix a segfault that could occur if a non-empty in-memory database was the destination of a backup operation from a database with a smaller page size.

3 года назад

Fix an error in the test case fix in [ecd71203].

5 лет назад

Many test cases fixed to work with encryption.

10 лет назад

Have calls to sqlite3_backup_init() fail if there is already a read or read-write transaction open on the destination database.

12 лет назад

backup_ioerr.test

Many spelling fixes in comments. No changes to code.

13 лет назад

backup_malloc.test

Fix the backup_malloc.test script so that it works on Windows.

10 лет назад

Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)

19 лет назад

Test case changes so that they work with both Tcl8.6 and Tcl8.7.

7 лет назад

Speed up base64 conversions, and add test with more data for the baseNN conversion to grind.

4 года назад

Fix the backcompat.test script so that it works with the --testdir test option.

10 лет назад

bestindex1.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex2.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex3.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex4.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex5.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex6.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex7.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

bestindex8.test

Allow virtual table implementations to handle OFFSET but not LIMIT, but not LIMIT but not OFFSET.

2 года назад

bestindex9.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

bestindexA.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

bestindexB.test

Handle the case where a virtual table xBestIndex method called while coding a trigger fired by a top-level statement with a RETURNING clause prepares a statement that also contains a RETURNING clause.

3 года назад

bestindexC.test

Further tests for OR constraints on virtual tables.

2 года назад

bestindexD.test

Ensure the sqlite3_index_info.colUsed mask always includes the PK fields of WITHOUT ROWID vtabs in cases where they may be used.

2 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Disable the bigfile tests on Macs.

14 лет назад

Fix test issues for Windows portability.

13 лет назад

Change the fake_big_file test command so that it fails for files larger than 2MB on Windows, as we have observed that Window10 will sometimes bluescreen when operating on very large sparse files.

4 года назад

Do not invoke the busy callback when trying to promote a lock from SHARED to RESERVED. This avoids a deadlock. (CVS 1879)

22 года назад

Avoid running bigsort.test with SQLITE_DEBUG builds. The assert() statements added in [7c96a56] make it too slow.

4 года назад

Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case.

9 лет назад

Fix the bind2.test test script so that it works even if SQLITE_ENABLE_PREUPDATE_HOOK is not defined. Fix for test-case breakage from check-in [c006515ae6faff65].

5 лет назад

Check-in (6514) did not completely remove the obsolete test, resulting in a segfault. This check-in finishes the job. Ticket #3802. (CVS 6516)

17 лет назад

Increase test coverage of bitvec.c slightly. Fix the line length on a comment in bitvec.c. (CVS 6432)

17 лет назад

Fix an out-of-order test number in blob.test. Cosmetic change. No changes to code. Ticket #3830. (CVS 6564)

17 лет назад

Fix Bloom filters on an expression index. [forum:/forumpost/2e427099d5|forum post 2e427099d5] and [forum:/forumpost/d47a0e8e3a|forum post d47a0e8e3a].

3 года назад

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

18 лет назад

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

18 лет назад

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

18 лет назад

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

18 лет назад

Update the boundary3.tcl script so that it can be run with tcl 8.5 or 8.6 to regenerate boundary3.test.

13 лет назад

Improvements to ORDER BY handling in the NGQP. Fix an "exit" mistakenly left in a test script during the previous check-in.

13 лет назад

Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.

17 лет назад

Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.

17 лет назад

New test cases added.

4 года назад

Modify the btree02.test module so that it does not depend on whether TCL interprets a value as a string or as an integer.

8 лет назад

btreefault.test

Remove a NEVER() macro for a condition that is actually reachable following an OOM. dbsqlfuzz crash-6ef3cd3b18ccc5de86120950a0498641acd90a33.txt.

4 года назад

Change the 0x20000 bit (use analysis limit) to 0x10, meaning that this feature is on by default. The default analysis limit is changed to 2000 which is almost always sufficient for accurate analysis results.

2 года назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Many spelling fixes in comments. No changes to code.

13 лет назад

cacheflush.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

cachespill.test

Add new test file cachespill.test.

9 лет назад

Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and "BLOB") and if a column has one of those datatypes, store the type part of the bit-field information in the Column structure to save space.

5 лет назад

Omit a capi3 test from 2007 that depends upon undefined behavior (UAF).

2 года назад

Refactor some of the global variables and commands used by tester.tcl.

16 лет назад

Fix sqlite3_prepare() so that it only invokes the progress handler on every N-th call to sqlite3ProgressCheck(), where N is the progress handler step count. Also fix faulty asserts exposed by the ability to interrupt in the middle of sqlite3_prepare().

4 года назад

Enhance the documentation on sqlite3_stmt_readonly() to explain that EXPLAIN and EXPLAIN QUERY PLAN do not affect the return value. Add test cases to verify this. Add new test cases and requirements marks for complete requirements test coverage on this interface.

4 года назад

Revise how the Tcl system encoding is handled by the test suite.

12 лет назад

Extend the carray extension to allow the use of BLOB values to be bound as an array of "struct iovec" objects.

4 года назад

Remove all code that makes use of the C-language "long double" datatype.

2 года назад

Fixes for OOM and IO error handling with temp file databases.

10 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

checkfault.test

When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9].

7 лет назад

Add a test case for the unix SQLITE_FCNTL_CHUNK_SIZE file-control.

7 лет назад

Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build.

2 года назад

Fix a problem that could cause a crash if a blob handle were closed after the associated database handle was closed using sqlite3_close_v2().

7 лет назад

Fix a problem in the xBestIndex method of the closure extension causing it to allocate non-contiguous argvIndex values in some cases (an "xBestIndex malfunction" error).

8 лет назад

Additional test cases for the coalesce() and ifnull() functions.

17 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

New test cases added.

4 года назад

Correctly deal with an unknown collating sequence on an indexed DISTINCT query.

11 лет назад

Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now.

11 лет назад

Fix a problem with using the push-down optimization on compound SELECTs where component SELECTs use different collation sequences. dbsqlfuzz 11516f050100243e5a845f5a2b48a90ed2efaf2e.

4 года назад

Fix a bug with explicit collation sequences attached to a column reference expression that is on the right-hand-side of a binary comparison operator. (CVS 4187)

19 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Propagate the COLLATE operator upward through function calls. Initial fix for ticket [ca0d20b6cdddec5e8].

12 лет назад

Remove unused code. Test coverage enhancements. Modify the algorithm used to select column names for VIEWs of joins so that the constructed column names omits the underlying table names. (CVS 5386)

18 лет назад

Fix a bug in the RTRIM collating sequence discovered while working on condition/decision branch coverage. Increase test coverage of the date/time functions. (CVS 5010)

18 лет назад

Remove an invalid assert() statement failing when VACUUMing a database that contains an index on a column explicitly declared "COLLATE BINARY".

9 лет назад

Fix the sqlite3_table_column_metadata() routine so that it gives the correct answer for the "rowid" column in a WITHOUT ROWID table. Enhance it so that it can be used to check for the existence of a table by setting the column name parameter to NULL. The routine is now included in the build by default, even without the SQLITE_ENABLE_COLUMN_METADATA compile-time option.

12 лет назад

Allow arbitrary expressions as the second argument to RAISE().

2 года назад

columncount.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Add test cases to confirm that the schema parsing quirk in which an ON CONFLICT clause is accepted and ignored on table CHECK constraints but raises an error on column CHECK constraints. We want to continue supporting this harmless quirk to avoid breaking legacy applications and databases that accidentally use it.

4 года назад

Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints.

6 лет назад

Do not allow triggers that run as part of REPLACE conflict resolution during an UPDATE to modify the the table being updated. Otherwise, those triggers might delete content out from under the update operation, leading to all kinds of problems. Ticket [314cc133e5ada126]

7 лет назад

Add a test case contributed on the mailing list that works in NGQP but fails in legacy.

13 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Improved error messages from PRAGMA integrity_check. Identify the root of the tree when a problem is found in a b-tree, making it easier to track the problem to a specific table or index.

3 года назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Many test cases fixed to work with encryption.

10 лет назад

Improved error messages from PRAGMA integrity_check. Identify the root of the tree when a problem is found in a b-tree, making it easier to track the problem to a specific table or index.

3 года назад

Add a new sqlite3_test_control() that indicates that database files are always well-formed. Use this during testing to enable assert() statements that prove conditions that are always true for well-formed databases.

13 лет назад

Add a new sqlite3_test_control() that indicates that database files are always well-formed. Use this during testing to enable assert() statements that prove conditions that are always true for well-formed databases.

13 лет назад

Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case.

9 лет назад

Add a new sqlite3_test_control() that indicates that database files are always well-formed. Use this during testing to enable assert() statements that prove conditions that are always true for well-formed databases.

13 лет назад

Change test results in corruptC.test to account for the added detail in the output of "PRAGMA integrity_check" from [b736519d3d2e93c7].

2 года назад

Have "PRAGMA quick_check" compare the number of entries in tables and indexes.

3 года назад

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

Add a new sqlite3_test_control() that indicates that database files are always well-formed. Use this during testing to enable assert() statements that prove conditions that are always true for well-formed databases.

13 лет назад

Many test cases fixed to work with encryption.

10 лет назад

Many test cases fixed to work with encryption.

10 лет назад

Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625.

3 года назад

Many test cases fixed to work with encryption.

10 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix a case where a corrupt stat4 record could go unrecognized due to integer overflow.

2 года назад

Update corruptM.test to account for the fact that the database schema may be loaded from within the "sqlite3" command for some test permutations.

7 лет назад

Fix an assert() failure in "PRAGMA integrity_check" that could occur when checking a corrupt database.

2 года назад

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2 года назад

Allow a HAVING clause on any aggregate query, even if there is no GROUP BY clause. This brings SQLite into closer agreement with PostgreSQL and fixes the concern raised by [forum:/forumpost/1a7fea4651|forum post 1a7fea4651].

4 года назад

countofview.test

Omit the the count-of-view optimization if there is a HAVING clause. dbsqlfuzz 6a107e3055bd22afab31cfddabc2d9d54fcbaf69

3 года назад

coveridxscan.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

If the sector size is greater than the database page size, SQLite journals all pages that lie within a sector before writing to any of them. This change ensure that a journal sync does not occur halfway through journalling the set of pages that belong to a single sector. (CVS 5605)

18 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Update test helper procedure 'get_pwd' to handle the ComSpec environment variable being absent.

6 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Add a test for the problem fixed by [bf44d73d3e].

14 лет назад

Avoid running a couple of tests in crash8.test that depend on the presence of the journal file if running on an F2FS file-system that does not require a journal file.

8 лет назад

Disable multiplexing of master-journal files in the test_multiplex.c module.

11 лет назад

Add the crashtest1.c program used to test the ability of the database to survive a program crash or power failure. Ticket #599. (CVS 1210)

23 года назад

Early detection of too many columns in an index avoid a possible 16-bit signed integer overflow.

7 лет назад

Avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values.

6 лет назад

Avoid ignoring the last line of a csv file if the final field is empty and there is no trailing CFLS. Also have the csv extension treat the last line of a file in the same way as any other line if it is short fields.

4 года назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

cursorhint.test

Fix a bug in cursor hints that can cause references to tables that have not been opened. Cursor hints are intended for use by COMDB2 only and should not appear in production builds, so this should not be a factor for the vast majority of users.

3 года назад

cursorhint2.test

Fix a problem causing ENABLE_CURSOR_HINTS builds to segfault.

8 лет назад

dataversion1.test

Add the SQLITE_FCNTL_DATA_VERSION file control

8 лет назад

Adjust date/time functions so that they do a better job of keeping track of whether the current time is UTC or localtime, and no-op the 'utc' and 'localtime' modifiers accordingly. See [forum:/info/e7a939e074|forum post e7a939e074]. Also add the datedebug() function, available only under -DSQLITE_DEBUG, for improved visibility of the DateTime object during debugging and testing.

2 года назад

Date/time functions with no arguments (ex: date() or time()) should be non-deterministic. Fix for ticket [2c6c8689fb5f3d2f].

5 лет назад

Enforce the restriction that 'unixepoch' only works as the first modifier after the time-value. This has been documented since 2004, but has never actually been enforced before. Also add new test cases for date/time functions with evidence marks.

5 лет назад

Make sure that %V and %G are testing for every since day in between 1970-01-01 and 2023-01-19.

3 года назад

New date/time test cases to validate ancient dates.

2 года назад

Fix an incompatibility with -DSQLITE_OMIT_LOAD_EXTENSION=1 in dbdata.test.

7 лет назад

Fix harmless compiler warnings in dbfuzz.

10 лет назад

Add test case for [29937081].

3 года назад

dbfuzz2-seed1.db

Initial code for a fuzzing tool on database file that works with the -fsanitize=fuzzer option of clang.

8 лет назад

Enable the sqlite3_serialize() and sqlite3_deserialize() interfaces by default. Omit the SQLITE_ENABLE_DESERIALIZE option and replace it with the SQLITE_OMIT_DESERIALIZE option.

5 лет назад

Check-in [642a0b4752743216] fixing sqlite_dbpage is not exactly correct. This patch should fix it.

4 года назад

dbpagefault.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

Fix a duplicate test number and cleanup a bit of Makefile whitespace.

8 лет назад

Rename the decimal_sci() function to decimal_exp(). [forum:/forumpost/fa027bb0ab|Forum post fa027bb0ab].

3 года назад

Fix test cases due to an error message change.

2 года назад

Do not use the one-pass optimization on an UPDATE if there is a subquery in the WHERE clause, since if the subquery is hidden behind a short-circuit operator, the subquery might not be evaluated until after one or more rows have been updated. Fix for the problem reported by [forum:/forumpost/0007d1fdb1|forum post 0007d1fdb1]. This is the same problem that was fixed by [73f0036f045bf371] only for UPDATE instead of DELETE.

3 года назад

3 more coverage tests for btree.c. (CVS 5370)

18 лет назад

Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620)

21 год назад

Fix the truncate optimization so that PRAGMA count_changes and changes() return correct values even for a WITHOUT ROWID table. [forum:/forumpost/07dedbf9a1|Forum post 07dedbf9a1].

5 лет назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. Fix for these tickets: [c36cdb4afd504dc1], [4051a7f931d9ba24], [d6fd512f50513ab7].

3 года назад

Do not convert an expression node that is already TK_REGISTER into a new TK_REGISTER. This is a follow-up to [663f5dd32d9db832] that fixes a bug discovered by dbsqlfuzz.

2 года назад

distinctagg.test

Consider an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records.

3 года назад

e_blobbytes.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

e_blobclose.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

e_blobopen.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

e_blobwrite.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

e_createtable.test

Fix stale requirement marks and fix a typo in the documentation for sqlite3_preupdate_hook().

3 года назад

Update evidence marks due to wording changes in requirements text. No changes to code.

11 лет назад

e_droptrigger.test

Update requirement marks due to wording improvements in the documentation.

6 лет назад

e_dropview.test

Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias.

6 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Update evidence marks for the latest changes to the documentation.

5 лет назад

More test-case adjustments for defensive mode.

8 лет назад

Minor updates to requirements marks and documention. No changes to code.

9 лет назад

Have "PRAGMA quick_check" compare the number of entries in tables and indexes.

3 года назад

Update evidence marks due to wording changes in requirements text. No changes to code.

11 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Update some requirements marks to conform with improvements in the documentation.

13 лет назад

e_totalchanges.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Update evidence marks due to wording changes in requirements text. No changes to code.

11 лет назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

Fix requirements marks that changed due to typo fixes in the documentation.

4 года назад

Handle recovery of virtual tables by recovering each shadow table individually, then writing the CREATE VIRTUAL TABLE statement directly into the sqlite_schema table.

4 года назад

Many more test cases fixed. Only a few remain.

10 лет назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

emptytable.test

Query planner optimization to detect empty tables in a join early and bail out without doing excess work.

9 лет назад

Report an error if the main, or any other, database encoding is modified by an external process (perhaps using the backup API) after the db has been opened.

6 лет назад

Do not allow the "PRAGMA encoding" statement to change the database encoding if TEMP content exists, or content in any other attached database. Formerly, encoding changes were allowed if just the main database file was empty. Ticket [a08879a4a476eea9].

7 лет назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort.

2 года назад

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2 года назад

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

Do not report an sqlite3_error_offset() for errors that occur inside of views or triggers, since the text of those elements is not part of the original query.

2 года назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Update test file exclusive.test so that it works with the "journaltest" permutation.

7 лет назад

exclusive2.test

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Miscellaneous test coverage improvements. (CVS 4734)

19 лет назад

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

10 лет назад

Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which are equivalent to IS and IS NOT, respectively, for compatability with PostgreSQL and hence standard SQL.

4 года назад

Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3].

7 лет назад

Add experimental user function unhex().

4 года назад

exprfault2.test

Add a test for the fixes on this branch.

2 года назад

extension01.test

Fix the extension01.test script so that it works on windows. Fix a harmless compiler warning in the fileio extension.

12 лет назад

external_reader.test

Add experimental SQLITE_FCNTL_EXTERNAL_READER file control.

5 лет назад

extraquick.test

"test" targets on all makefiles use --verbose=file --output=test-out.txt. Add the new "quicktest" target to all makefiles - designed to run in under three minutes. The --quick option on releasetest.tcl now uses quicktest.

11 лет назад

Minor fix the fallocate.test module change from [7cd56cad5efead5]

8 лет назад

Corrections to a couple recently added 'filectrl.test' results.

10 лет назад

Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case.

9 лет назад

Fix a harmless typo in the test case added by [29fc06465efb948f].

3 года назад

Add tests for the FILTER clause. And a bugfix.

7 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

filterfault.test

Fix a memory leak that could follow an OOM in the new FILTER code.

7 лет назад

Avoid double de-quoting of table names when processing RESTRICT actions in foreign key constraints. [https://bugs.chromium.org/p/chromium/issues/detail?id=1405220|Chromium 1405220].

3 года назад

Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints.

6 лет назад

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes.

14 лет назад

Changes to busy2.test, corruptL.test and fkey5.test so that new test cases pass with all test permutations.

6 лет назад

Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set.

10 лет назад

Do not commit an "OR FAIL" statement that causes foriegn key constraint violations.

7 лет назад

Fix a problem with "ON DELETE RESTRICT" and "ON UPDATE RESTRICT" foreign keys in attached databases scanning child tables in the wrong schema.

4 года назад

fkey_malloc.test

Update a few test cases to account for the new error message formats.

13 лет назад

Test script changes to account for the fact that the "p5" column in the EXPLAIN output is now an integer, not a text values containing a 2-digit hex value.

6 лет назад

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

Remove all code that makes use of the C-language "long double" datatype.

2 года назад

New test cases for floating-point conversions.

3 года назад

fts-9fd058691.test

Handle updating the only row of an FTS table correctly. Fix for [9fd058691].

15 лет назад

Re-introduce the prefix-search optimization of [feef1b15d6], which was lost in a reorganization of FTS3 code.

16 лет назад

fts3_common.tcl

Fix a broken assert() in fts3. Also some test script issues causing failures with builds that do not support fts3.

8 лет назад

Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks.

8 лет назад

Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years.

13 лет назад

Fix for [9861b74ab9]. Correctly handle strings with zero tokens in the fts3 offsets() function.

16 лет назад

Add extra tests for parsing of whitespace in tokenizer declarations,.

17 лет назад

Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.).

17 лет назад

Replicate the fts2*.test files as fts3a*.test, and convert fts2 to fts3 in the text of the files. (CVS 4251)

19 лет назад

Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years.

13 лет назад

Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms.

16 лет назад

Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16.

13 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Change the fts3 snippet function to return (hopefully) more relevant snippets in less time.

17 лет назад

Replicate the fts2*.test files as fts3a*.test, and convert fts2 to fts3 in the text of the files. (CVS 4251)

19 лет назад

Re-introduce the prefix-search optimization of [feef1b15d6], which was lost in a reorganization of FTS3 code.

16 лет назад

Fix a test script issue in fts3ao.test.

8 лет назад

fts3atoken.test

Check for whether or not it is safe to use non-innocuous functions as the function is being coded, not when its name is resolved.

7 лет назад

Fix a case in fts3auto.test that fails for SQLITE_DISABLE_FTS4_DEFERRED builds.

7 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Do not assume that text parameters passed to fts4aux queries do not contain embedded nul characters.

8 лет назад

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.).

17 лет назад

Change fts4aux to (additionally) report on term frequency in individual columns of an fts table.

16 лет назад

Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables.

3 года назад

fts3corrupt.test

Fix to test case in fts3corrupt.test. No changes to source code.

4 года назад

fts3corrupt2.test

Fix a buffer overread in fts3 that could occur when decoding a corrupted record.

6 лет назад

fts3corrupt3.test

Enable DEFENSIVE mode by default for tests. This requires lots of case of turning DEFENSIVE off in order to dodgy things to the database for testing purposes. No all of those cases are yet handled, so "make test" does not run to completion.

8 лет назад

fts3corrupt4.test

Fix a test in fts3corrupt4.test that would fail if SQLITE_ENABLE_FTS5 was not defined.

2 года назад

fts3corrupt5.test

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

fts3corrupt6.test

Fix a test case in fts3corrupt6.test. Was failing due to [f1dfbc4f].

4 года назад

fts3corrupt7.test

Fix a case in fts3 where a corrupt database record was not being handled correctly.

2 года назад

Fix an assert() in fts3 that could fail due to corrupt database records.

7 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

fts3defer2.test

Fix a problem with fts3 auxiliary functions and one or more NEAR expressions ORed together.

4 года назад

fts3defer3.test

Add new test file fts3defer3.test.

13 лет назад

Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a].

15 лет назад

fts3dropmod.test

Fix a typo in the result of one of the new test cases.

5 лет назад

Add some simple tests to make sure that the different fulltextFilter query paths are being exercised. (CVS 5498)

18 лет назад

Fix compiler warnings in FTS3.

8 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Update fts3 so that expressions to the left and right of a NOT operator are balanced. This prevents relatively small expressions (a dozen terms or so) that are children of NOT operators from triggering the "expression tree is too large" error.

11 лет назад

Fix a test case in fts3expr4.test to account for different locales.

4 года назад

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

Fix a use-after-free in fts3 that could follow an optimize() in the middle of a SELECT statement when the hash table is non-empty.

5 лет назад

Fix a problem handling OOM errors in fts3 that could occur when parsing multi-token strings.

2 года назад

fts3fault2.test

Fix another test case error message similar to those fixed in [b3d6b3c3].

4 года назад

fts3fault3.test

Ensure the fts3 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements.

3 года назад

Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables.

15 лет назад

fts3fuzz001.test

Fix an fts3 problem caused by reducing the page size using the undocumented "nodesize" option, then running an incremental-merge.

3 года назад

fts3integrity.test

Avoid expiring prepared statements in the middle of an integrity-check.

3 года назад

Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default.

3 года назад

fts3malloc.test

Cut over the next generation query planner. Increase the version number to 3.8.0.

13 лет назад

fts3matchinfo.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

fts3matchinfo2.test

Fix a null pointer deference that can occur on a strange matchinfo() query.

6 лет назад

Fix an integer overflow in fts3 causing a usan error.

6 лет назад

Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years.

13 лет назад

fts3offsets.test

Fix a crash that could occur in fts3 when processing a corrupt database.

5 лет назад

fts3prefix.test

Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids.

11 лет назад

fts3prefix2.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Adjust the fts3rank.test module so that it works on big-endian systems (hopefully - I don't have a big-endian machine to test the change on.)

9 лет назад

Fix problems to do with using both OR and NEAR operators in a single expression.

15 лет назад

fts3shared.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

fts3snippet.test

Add assert() statements and reorganize code slightly in fts3 and fts5 to make it easier to follow.

2 года назад

fts3snippet2.test

Fix a "shift exponent is too large" usan error that could occur in the fts3 snippet() function when a query phrase contains more than 64 tokens.

2 года назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

fts3tok_err.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

fts3varint.test

Fix the fts3varint.test script so that it works even on versions of TCL for which Tcl_GetWideIntFromObj() does not work.

7 лет назад

Improve corruption detection in fts3 shadow tables earlier in order to prevent an assert() from failing.

6 лет назад

Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables.

3 года назад

fts4content.test

Prevent direct and indirect recursive content= options in fts3/4 and fts5.

7 лет назад

Have fts4 full-text queries consider "docid<?" and similar constraints.

13 лет назад

fts4growth.test

Enable DEFENSIVE mode by default for tests. This requires lots of case of turning DEFENSIVE off in order to dodgy things to the database for testing purposes. No all of those cases are yet handled, so "make test" does not run to completion.

8 лет назад

fts4growth2.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Remove possibly stray output from various tests.

11 лет назад

fts4intck1.test

Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases.

3 года назад

fts4langid.test

Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables.

3 года назад

fts4lastrowid.test

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

fts4merge2.test

Add tests for incremental merge code.

14 лет назад

fts4merge3.test

Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error.

10 лет назад

fts4merge4.test

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

fts4merge5.test

Fix a long-standing problem in fts4 incrmental merge.

7 лет назад

Optimization for "SELECT min(x) FROM tbl" where "x" is indexed and NOT NULL. This also allows similar queries on NOT NULL virtual table columns to be optimized.

6 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

fts4onepass.test

Ensure that multiple updates of the same FTS4 row (i.e. the row with the same rowid) within a single transaction are written to separate segments. Fix for [d6ec09ec].

8 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

fts4record.test

Add extra tests for the handling of corrupt records in fts3.

7 лет назад

fts4rename.test

Merge changes from trunk into the alter-table-drop-column branch.

5 лет назад

fts4umlaut.test

Fix cut-and-paste error in test file fts4umlaut.test.

8 лет назад

fts4unicode.test

Add extra test for handling of embedded nul characters in the fts4 unicode61 tokenizer.

6 лет назад

fts4upfrom.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled.

14 лет назад

Remove a few more traces of long double from the code.

2 года назад

Avoid slowdown when exprNodeIsConstant() is called on deeply nested SQL functions.

2 года назад

Fix an assert() that might fail if sqlite3_create_function_v2() is invoked with NULL xStep and xFinal callbacks and a non-NULL xDestroy.

5 лет назад

Remove all code that makes use of the C-language "long double" datatype.

2 года назад

Do not factor out constant functions into the initialization section at the end of the prepared statement, be cause if they throw an exception, it will abort the statement even if the function is never called. Better to put constant functions in an OP_Once block.

6 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix a typo in testrunner_data.tcl that prevented --with-tcl specifications from being carried through into sub-builds. Adjust test cases to account for new floating-point differences discovered when --with-tcl was fixed.

2 года назад

Add test cases for functions named the same as join keywords.

3 года назад

Add support for the CONCAT() and CONCAT_WS() SQL functions, modeled after the PostgreSQL behavior.

3 года назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Update fuzz.test to account for a change in error message made in the core.

4 года назад

Make sure errors in the FROM clause of a SELECT cause analysis to abort and unwind the stack before those errors have a chance to mischief in the "*" column-name wildcard expander. Fix for ticket [32b63d542433ca67].

12 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix another problem found by Matthew Denton's new fuzzer.

8 лет назад

fuzz_common.tcl

Fix a case in "fuzz.test" that could fail, as non-deterministic functions may no longer appear in CHECK constraints.

7 лет назад

fuzz_malloc.test

Enhance tester.tcl so that when "--malloctrace=1" is specified, the test generates self-contained Tcl scripts that present GUIs instead of *.sql files that require a separate program to interpret.

8 лет назад

Fix an off-by-one error in the routines that bind the special $test_TTT and $int_NNN parameters for fuzz testing. Fix to testing logic only - no changes to the SQLite core.

2 года назад

Fix a faulty assert() statement identified by [forum:/forumpost/0b91a75039|forum post 0b91a75039].

4 года назад

Add the --info option to the fuzzcheck test utility.

8 лет назад

Add a corrupt database to test/fuzzdata3.db to validate the previous check-in.

11 лет назад

Fix an overzealous assert() statement discovered by OSSFuzz.

8 лет назад

Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz.

8 лет назад

Change the debugging "json_parse(X)" function so that it shows a more complete description of the JsonParse object on standard output and returns the mimified JSON. Former behavior was to return the text of a decode of the aNode array.

3 года назад

Remove a NEVER() macro and add a test case to cause its argument to be true.

6 лет назад

Add a test case to prevent a regression of the leak fixed in the previous trunk check-in.

3 года назад

Avoid running some particularly time-consuming tests as part of veryquick.test.

11 лет назад

Avoid running some particularly time-consuming tests as part of veryquick.test.

11 лет назад

fuzzerfault.test

Add OOM test case associated with the fix in the previous commit.

5 лет назад

fuzzinvariants.c

Fix an off-by-one error in the routines that bind the special $test_TTT and $int_NNN parameters for fuzz testing. Fix to testing logic only - no changes to the SQLite core.

2 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Immediately fail a CREATE TABLE statement that attempts to create a table that has a generated column loop. Legacy allows the table to be created but the table would not be usable for anything.

3 года назад

Fix memory leaks in the amatch extension. Add a few simple test cases.

13 лет назад

New test case for the HAVING fix of check-in [f62f983b56623f0e].

6 лет назад

Fix then handling of the (oversized) integer literal -0x8000000000000000.

10 лет назад

Fix a problem with VACUUM and __hidden__ columns.

11 лет назад

Fix the preupdate hook so that it works when the "old.*" row has a column with a non-NULL default value that was added by ALTER TABLE ADD COLUMN after the current record was created.

2 года назад

Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are written.

10 лет назад

Add an optional 3rd argument to the icu_load_collation() function that specifies the "strength" of the comparison.

2 года назад

Add the ieee754_to_blob() and ieee754_from_blob() functions. Fix the handling of subnormal forms in the two-argument version of ieee754().

6 лет назад

Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased.

12 лет назад

Add a test case for the ALWAYS() macro removed by the previous check-in.

3 года назад

Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400)

18 лет назад

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

18 лет назад

Omit the "noop(X)" test SQL function. Accomplish the same thing using the idiom: "coalesce(X,random())".

2 года назад

Slight performance improvement for the new code on this branch.

2 года назад

Fix the IN-early-out optimization so that it works even for the corner case where the NULL bypass fires before the affinity of the LHS operator has been set. Fix for the problem described in [forum:/forumpost/6a3ec138e9|forum post 6a3ec138e9].

5 лет назад

If a subquery is copied and then changes are made to the copy, be sure to give the copy a unique Select.selId value so that the original will not be substituted in place of the modified copy.

2 года назад

Many more test cases fixed. Only a few remain.

10 лет назад

Handle a real OOM condition when incrblob2.test is run on a low-memory machine.

9 лет назад

Fix a minor problem in the Tcl "incrblob" command. This does not affect the SQLite core.

4 года назад

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

10 лет назад

incrblob_err.test

Enhance tester.tcl so that when "--malloctrace=1" is specified, the test generates self-contained Tcl scripts that present GUIs instead of *.sql files that require a separate program to interpret.

8 лет назад

incrblobfault.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

incrcorrupt.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

incrvacuum.test

Fix an assert() that can be false when doing an incremental vacuum on a corrupt database file. dbsqlfuzz cced0668cfd4da4eb2382cb9dd26c17c64aaff76.

5 лет назад

incrvacuum2.test

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

10 лет назад

incrvacuum3.test

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

incrvacuum_ioerr.test

Fix a problem in incrvacuum_ioerr.test. Do not run ioerr6.test with an in-memory journal.

13 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints.

11 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

Remove possibly stray output from various tests.

11 лет назад

Do not allow a partial index scan on the left table of a RIGHT JOIN, because since the index is partial, some rows will be omitted from the scan, and those rows will subsequently be picked up by the no-match logic in the right-join post-processing loop. [forum:/forumpost/c4676c4956|forum post c4676c4956].

4 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Minor fix to test/index9.test so that it can be invoked with other index tests using a wildcard.

4 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

indexexpr1.test

Functions that pass through the sqlite3_value of one of their arguments must also be marked as SQLITE_RESULT_SUBTYPE, in case one of their arguments has a subtype.

2 года назад

indexexpr2.test

When translating arguments of aggregate functions into references to expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. [forum/forumpost/409ebc7368|Forum post 409ebc7368].

3 года назад

indexexpr3.test

Allow expressions with subtypes to be read from indexes unless they are being used as direct or indirect parameters to SQLITE_SUBTYPE functions.

2 года назад

indexfault.test

In sqlite3NestedParse() be sure to detect all SQLITE_NOMEM and SQLITE_TOOBIG errors and to distinguish between them.

7 лет назад

Disable the "init.test" test script when compiled with SQLITE_THREADSAFE=0.

16 лет назад

Add missing VdbeCoverage() macro. Fix an off-by-one error in partial index handling. New test cases. Ticket [c1e19e12046d23fe]

7 лет назад

Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns.

11 лет назад

Move the asynchronous IO code from src/test_async.c to ext/async/. Refactor it to be a standalone module and to support windows. (CVS 6539)

17 лет назад

Fix the Xfer-optimization on the INSERT statement so that it is omitted if there is a RETURNING clause, since that optimization is not able to deal with RETURNING. See [forum:/forumpost/595e132f71|forum thread 595e132f71] for details.

4 года назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

insertfault.test

Fix a segfault that could follow an OOM when querying a table that has one or more columns with default values "true" or "false".

8 лет назад

Test cases for ticket [587791f92620090e]

7 лет назад

instrfault.test

Update test script instrfault.test to account for the fact that bound blob values cast to text values are now intepreted using the text encoding of the database, instead of always as utf-8.

7 лет назад

Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer.

7 лет назад

Add a new sqlite3_is_interrupted() interface that can be used by long-running app-defined functions and similar to see if they need to exit early due to an sqlite3_interrupt() call.

4 года назад

interrupt2.test

Disable new test modules nockpt.test and interrupt2.test for incompatible permutations. Add a CORRUPT_DB term to an assert() in vdbe.c.

10 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Fix a problem with applying integer affinity to a MEM_IntReal value. Forum post [forum:/forumpost/d270125fae|forum post d270125fae].

4 года назад

Update test scripts to unregister the test devsim VFS after it is used.

5 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Update a couple of test cases to account for the fact that ROLLBACK does not always abort all running SELECT statements.

12 лет назад

Additional test coverage improvements. Test coverage now stands at 98.73%. (CVS 4731)

19 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Add [/info/cec6a06508239c09e363?ln=5525-5531|restriction (5)] to the omit-noop-join optimization. Fix for the issue reported by [forum/forumpost/49f2c7f690|forum post 49f2c7f690].

3 года назад

Ensure that the WhereInfo.revMask bitmap is adjusted when tables are removed from the FROM clause by the Omit-Noop-Join optimization of [0cd82ee9a8413cf1]. Fix for the issue described by [forum:/forum/8a1e467e905b8d27|format post 8a1e467e905b8d27].

2 года назад

Continued refactoring of the name resolution logic and query optimizer. (CVS 2236)

22 года назад

Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)

21 год назад

Update test scripts to account for [8fcea4cd].

2 года назад

Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself.

6 лет назад

New FULL JOIN test cases. No changes to code.

4 года назад

Update test scripts to account for [8fcea4cd].

2 года назад

Fix the query flattener so that it does not flatten a RIGHT or FULL JOIN into any position of the outer query other than the first.

4 года назад

Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOIN as well. Rename it to the "OUTER JOIN strength reduction" optimization.

3 года назад

Add 512 new join test cases derived from PostgreSQL output.

4 года назад

Tweaks to the name resolution on parenthesized joins. A small number of tests fail now due to extra columns appearing in the expansion of "*".

4 года назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Corrections to the header comment to the new joinE.test script. Add the generator TCL as a comment at the bottom of the script.

4 года назад

More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb].

4 года назад

Check-in [a9657c87c53c1922] is wrong: the IndexedExpr.bMaybeNullRow flag is required for virtual columns if they are part of an outer join. Add a test case (derived from dbsqlfuzz b9e65e2f110df998f1306571fae7af6c01e4d92b) to prove it.

2 года назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

10 лет назад

Modify journal3.test so that it can handle Tcl command "file attr <file> -perm" returning octal values in either "00755" or "0o755" format.

7 лет назад

Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on. Ticket [f4ec250930342e0c].

7 лет назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Fix the subtype on the value column from json_each/json_tree for cases when the value is an array or object. Fix for the bug reported by [forum:/forumpost/ecb94cd210|forum post ecb94cd210].

2 года назад

Fix the -> and ->> operators so that when the RHS is a string that looks like a number, it is still treated as a string, because that is what PG does. [forum:/forumpost/9e52cdfe15c3926e|Forum post 9e52cdfe15c3926e].

2 года назад

Always enable all JSON tests, now that JSON is included by default.

5 лет назад

Fix a problem with json_patch() when one side or the other is JSON5. dbsqlfuzz bc10593a4ba8e7a7862593532285be31f00f8e41

3 года назад

Add randomjson.c to testfixture. Use it for a new set of invariant tests against JSON functions.

3 года назад

Add test cases for json_pretty().

2 года назад

If a BLOB looks like JSON when cast to text, then treat it as if it really were JSON. This replicates a long-standing bug in the JSON processing routines, and thereby avoids breaking legacy.

3 года назад

Add test cases for json_pretty().

2 года назад

Allow control characters in JSON5 string literals. [forum:/forumpost/05182119f69c3a92|Forum thread 05182119f69c3a92].

3 года назад

Fix a bug in the parsing of some corner-case JSON PATH strings that contain escaped double-quotes.

2 года назад

Avoid a potential buffer overread when handling corrupt json blobs.

3 года назад

Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still be used as table and column names.

13 лет назад

Fix harmless typo in a comment.

3 года назад

lastinsert.test

Add additional test cases and requirements evidence marks for WITHOUT ROWID.

13 лет назад

laststmtchanges.test

Make sqlite3_count_changes() and total_changes() work with "DELETE FROM <table-name>". (CVS 5844)

18 лет назад

Fix a compilation error in test/lemon-test01.y, reported in [forum:f0ad095705|forum post f0ad095705].

2 года назад

Fix handling of U+fffd in the LIKE optimization. dbsqlfuzz eee57fb9eea1dfa5aa40dfa87865cf8c84d12f96.

2 года назад

Fix a problem in the LIKE and GLOB operators that may occur when the character immediately following a "%" or "*" wildcard is U+80. Reported by [forum:61bf7ccbdf].

4 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Fix the processing of implied LIMIT clauses when flattening a compound query.

5 лет назад

Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25].

8 лет назад

Always convert 32-bit integer literals into EP_IntValue notation, even if they contain "_" separators.

2 года назад

Fix a problem in the previous commit with hex literals that start with "0X" instead of "0x".

3 года назад

Fix a problem in the previous commit with hex literals that start with "0X" instead of "0x".

3 года назад

Fix the regexp used to recognize libdl errors on OS-X.

8 лет назад

Add the sqlite3_cancel_auto_extension(X) interface which will undo a prior call to sqlite3_auto_extension(X).

13 лет назад

Fix a problem in test script lock.test. Fix minor issues in pager.c.

10 лет назад

Fix problems with running the async.test script.

16 лет назад

Back out check-in (6380). Replace it with a proper fix to the xFullPathname method in the async VFS. (CVS 6398)

17 лет назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Avoid running some new tests in lock5.test with the inmemory_journal permutation.

2 года назад

Fix minor test suite problems causing errors on OSX.

16 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

lock_common.tcl

Copy some extra test infrastructure from the mutexfree-shmlock branch to trunk.

8 лет назад

Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open() returns. Fix test script problem in lookaside.test.

8 лет назад

Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing.

9 лет назад

make-where7.tcl

Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527)

17 лет назад

Update a couple of test scripts so that they work on F2FS file-systems that support atomic transactions.

9 лет назад

In SQLITE_ENABLE_BATCH_ATOMIC_WRITE builds on F2FS file-systems, invoke SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE if an SQLITE_FCNTL_COMMIT_ATOMIC_WRITE call fails. Also, do not use an atomic transaction to create the initial database. This is because if an error occurs while writing to the db file, any changes to the file-size do not seem to be rolled back automatically. The only time this matters is when the file was 0 bytes in size to start with.

9 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Update a test case in malloc5.test to take into account that malloc() sometimes returns slightly more space than requested.

8 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Fix the output labels on the tests in malloc9. (CVS 4966)

18 лет назад

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file.

16 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Refactor some of the global variables and commands used by tester.tcl.

16 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c. Limit the size of hash tables and the vdbefifo when using mem5.c. (CVS 4795)

18 лет назад

Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16.

13 лет назад

Bring test coverage up to 99%. (CVS 5522)

18 лет назад

Add a test case for the fix in [a596b7c6cc].

10 лет назад

More coverage improvements. (CVS 6148)

18 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Fix a crash that could follow an OOM condition in the instr() SQL function.

9 лет назад

malloc_common.tcl

Update the expected error messages in some OOM test cases to account for [44d77a7f807].

4 года назад

malloctraceviewer.tcl

Fixes for the generated "mallocs.tcl" and "leaks.tcl" scripts generated by running tcl tests with the --malloctrace=1 option.

4 года назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Fix issue with mem5 allocator when min request size is larger thatn 2^30.

15 лет назад

Simplify the page recycling condition in pcache1. Fix test cases to work with the latest changes.

11 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

memjournal.test

Fix a problem in the in-memory journal code that could occasionally lead to a segfault when a sub-transaction that modified zero pages was committed.

5 лет назад

memjournal2.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Refactor some of the global variables and commands used by tester.tcl.

16 лет назад

memsubsys1.test

An attempt to enhance PRAGMA integrity check so that it does data type checking on non-STRICT tables. Specifically: (1) Columns with TEXT affinity should not contain numeric values, and (2) columns with numeric affinity should not contain text values that can be converted to numeric.

4 года назад

memsubsys2.test

Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4.

4 года назад

Enhance the generate_series() table-valued function such that it is able to recognize equality and inequality constraints on the "value" column and optimize its operating accordingly.

2 года назад

Defer deleting subqueries in the compound-SELECT code generator until the end of code generation, in order to avoid deleting expressions out from under the aggregation function sanity checking assert()s that occur near the end of SELECT code generation. This fixes the assertion fault described by [forum:/forumpost/cfcb4b461d|forum post cfcb4b461d].

5 лет назад

Also prohibit the use of rowid from a subquery. Add the SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it.

5 лет назад

Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1.

16 лет назад

Add tests to ensure that this branch really does fix ticket [f8a7060ece].

7 лет назад

Allow underscores to occur in hex literals.

3 года назад

Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.

2 года назад

Minor adjustments to get Tcl9-based testing working on Macs.

2 года назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Improvements to parser stack overflow testing. [forum:/forumpost/99e181b5bf|Forum post 99e181b5bf].

3 года назад

Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865)

19 лет назад

Test result adjustments in test/misc7.test due to the EQP format change.

5 лет назад

Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW.

2 года назад

Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case.

9 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Slight adjustment to test results for Windows in mmap1.test due to the previous check-in.

3 года назад

Add extra "PRAGMA mmap_size = N" statements to mmap1.test and mmap2.test.

13 лет назад

Many more test cases fixed. Only a few remain.

10 лет назад

Avoid running some particularly time-consuming tests as part of veryquick.test.

11 лет назад

mmapcorrupt.test

Do not attempt to run mmapcorrupt.test with builds that do not support mmap().

2 года назад

Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years.

13 лет назад

Update some test cases to work with SQLITE_OMIT_VIRTUALTABLE and DEFAULT_AUTOVACUUM builds.

9 лет назад

Add pragmas "multiplex_enabled", "multiplex_chunksize", and "multiplex_filecount" to the multiplexer implementation.

5 лет назад

multiplex2.test

Add a hard limit to the number of chunks a multiplexed database may consist of if ENABLE_8_3_NAMES is defined.

15 лет назад

multiplex3.test

Update multiplex3.test to account for the fact that the multiplexor xDelete method may return an error even if it manages to delete the first chunk of a file.

4 года назад

multiplex4.test

Clearification of some documentation text. Added requirements marks.

11 лет назад

Fix mutex1.test to take into account that the prng mutex is not (as of [c84e4483cb4]) taken when writing a header to an in-memory journal.

3 года назад

Remove the SQLITE_MUTEX_APPDEF compile-time option. The SQLITE_THREADSAFE=0 option always removes all mutex code. For application-defined mutexes only, use SQLITE_THREADSAFE=1 with SQLITE_MUTEX_NOOP=1. Ticket #3421. (CVS 5779)

18 лет назад

Adjust a few tests that don't work even with the new floating point comparison routine.

2 года назад

Fix a problem in test file nockpt.test causing errors with SQLITE_DEFAULT_AUTOVACUUM builds.

8 лет назад

Skip recently added test cases in nolock.test when running in the inmemory_journal permutation.

10 лет назад

Enhancements to SQL query normalization for UPDATE statements.

7 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Change notify2.test to check that sqlite3_blocking_step() uses CPU more efficiently than sqlite3_step(), not that it results in greater overall throughput for any specific number of threads.

12 лет назад

Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize().

4 года назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] should be applied to the WHERE clause only. Otherwise, the operand of the IS NULL or IS NOT NULL operator might be a reference to a bare column of an aggregate table, and we can't tell if it is NULL or not based only on its NOT NULL attribute. [forum:/forumpost/440f2a2f17|Forum post 440f2a2f17].

2 года назад

notnullfault.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as ticket [5c4e7aa793943803] reports a case where the optimization does not work.

6 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Fix text-to-numeric type casting so that it works correctly on UTF16 strings that contain characters where the LSB is numeric but the MSB is non-zero. Ticket [689137afb6da41]

13 лет назад

More test cases for indexes on large numeric values.

11 лет назад

Fix a problem with the query optimizer for LIMIT/OFFSET queries when underlying query is a UNION ALL and both arms of the UNION ALL are subqueries with an ORDER BY clause. This bug was reported at [forum:/forumpost/6b5e9188f0657616|forum post 6b5e9188f0657616]. The problem was introduced in 2015 (SQLite version 3.9.0) by check-in [4b631364354068af]. See also ticket [b65cb2c8d91f6685].

4 года назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Extend the refactoring into extensions. Clean up stray newlines.

6 лет назад

optfuzz-db01.txt

Add the optfuzz.c program for verifying the query planner using a fuzzer. This is an initial code check-in.

8 лет назад

Enable the sqlite3_serialize() and sqlite3_deserialize() interfaces by default. Omit the SQLITE_ENABLE_DESERIALIZE option and replace it with the SQLITE_OMIT_DESERIALIZE option.

5 лет назад

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2 года назад

Update the query planner to recognize more cases where ORDER BY clauses can be optimized out. Add test cases to verify correct behavior of the ORDER BY optimization when the covering-index-scan optimization is disabled. Fix a harmless compiler warning in the TCL interface.

14 лет назад

Fix the date on the new orderby3.test test case.

14 лет назад

A fix an test-case for the ORDER BY problem identified by ticket [a179fe7465]. This change causes sorting to occur in some cases where it is not strictly necessary. Further work is needed to avoid those extra sorts.

13 лет назад

Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a].

6 лет назад

New test case for block-sorting.

12 лет назад

Add test cases to ensure correct operation of joins with a virtual table that include DISTINCT and ORDER BY clauses. Verification for ticket [388d01d4bb8f9].

12 лет назад

There are asserts in place now that will prevent a recurrence of ticket [f97c4637102a3ae7]. Nevertheless, it is good to add some test cases as well.

12 лет назад

Fix the orderby9.test case so that it works with 32-bit versions of TCL

11 лет назад

Allow SQLite to omit redundant ORDER BY sorts in the case where a SELECT statement has GROUP BY and ORDER BY clauses that use the same expressions, even when the ORDER BY expressions are marked "DESC".

7 лет назад

Fix handling of COLLATE. Add test cases for the same. Code cleanup for improved understandability and maintainability.

2 года назад

Changes to oserror.test so that it works even on systems that allow an unusually large number of file descriptors.

7 лет назад

Fix a bug in the hard_heap_limit pragma so that it returns the new value of the hard_heap_limit, not the soft_heap_limit. Change SQLITE_MAX_MEMORY so that it works by setting the default hard_heap_limit value.

7 лет назад

Fix utility compilation issues with MSVC.

8 лет назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Increase the max_page_count on ROLLBACK, if necessary, so that it is sufficient to cover the entire database. Fix for the problem identified by [forum:/forumpost/3b9e894312|forum post 3b9e894312].

4 года назад

Fix the pager2-3.1 test case so that it does not run if a required dependence (shared-cache) is omitted from the build. Fix for [forum:/forumpost/7a028538a7|forum post 7a028538a7].

3 года назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Fix a couple of problems with new test scripts causing the permutations test to fail.

13 лет назад

pagerfault.test

In SQLITE_ENABLE_BATCH_ATOMIC_WRITE builds on F2FS file-systems, invoke SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE if an SQLITE_FCNTL_COMMIT_ATOMIC_WRITE call fails. Also, do not use an atomic transaction to create the initial database. This is because if an error occurs while writing to the db file, any changes to the file-size do not seem to be rolled back automatically. The only time this matters is when the file was 0 bytes in size to start with.

9 лет назад

pagerfault2.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

pagerfault3.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

More test-case changes so that everything works when the reserved_bytes value in the header is non-zero.

10 лет назад

Fix a faulty assert() in the btree part of the "PRAGMA page_size = ?" code.

11 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Defer the bulk pcache1 memory allocation until the first page allocation request. Limit the size of the pcache1 bulk allocation to the cache_size setting. Deallocate the bulk allocation on a sqlite3_db_release_memory() request, if the bulk allocation is completely unused.

11 лет назад

Modify a few test scripts to avoid leaving the sqlite3Config structure in a non-default state.

11 лет назад

pendingrace.test

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

percentile.test

Improved error messages on percentile functions. More tests cases for percentile and for ordered-set aggregates.

2 года назад

permutations.test

Ensure intck tests are run by testrunner.tcl.

2 года назад

Allow a FROM clause in UPDATE statements.

6 лет назад

Add a test case to the fix to PRAGMA integrity_check in the previous check-in.

2 года назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Fix "PRAGMA data_version" so that it works the same way with locking_mode=PERSIST and journal_mode=PERSIST configured. Fix for 7a458c2a5f.

7 лет назад

Ensure successive scans of pragma virtual tables return consistent rowids.

2 года назад

Enhance PRAGMA function_list so that it shows all instances of each FuncDef, the number of arguments, the encoding, the type, and the flags. Use this capability to locate and fix incorrect function flags in the standard build.

7 лет назад

Fix pragma6.test so that it works with ENABLE_OVERSIZE_CELL_CHECK builds.

2 года назад

pragmafault.test

Fix a problem causing "PRAGMA integrity_check" to disable the xfer optimization for subsequent VACUUM operations on tables with one or more CHECK constraints. This could result in VACUUM producing slightly larger database files.

9 лет назад

Add scalar function "prefix_length()" to ext/misc/prefixes.c.

8 лет назад

Fix rounding in zero-precision %f and %g printf conversions. [forum:/info/393708f4a8|Forum post 393708f4a8]. This bug was introduced by check-in [32befb224b254639] and first appeared in version 3.43.0.

2 года назад

Fix some of the new date/time function features to comply with the spec. Update requirement marks.

5 лет назад

More test output refinements.

11 лет назад

Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400)

18 лет назад

Be more aggressive about reusing subqueries that appear on the RHS of IN operators that have been replicated due to the predicate push-down optimization.

2 года назад

Add the experimental "query_only" pragma.

13 лет назад

Add test file pager1.test, containing tests of inter-process locking in non-wal mode.

16 лет назад

quickcheck.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

quota-glob.test

Documentation improvements and additional test cases.

15 лет назад

Ensure that quota.test deletes the directory named "test.db" that it creates.

10 лет назад

Fix test issues for Windows portability.

13 лет назад

Improved error message when a double-quoted string is used and it seems likely that the user wanted a single-quoted string literal.

3 года назад

Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029)

18 лет назад

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

Change the name of the OTA extension to RBU: Resumable Bulk Update.

11 лет назад

Clearification of some documentation text. Added requirements marks.

11 лет назад

Fix problems uncovered while testing Tcl9 on Windows.

2 года назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix corner cases in UTF8 handling in the REGEXP extension. [forum:/forumpost/3ffe058b04|Forum post 3ffe058b04].

4 года назад

Fix more cases in the regexp extension where the 0x00 terminator at the end of the input string is being pattern matched. [forum/forumpost/9104f0d9e7|Forum post 9104f0d9e7].

5 лет назад

Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt.

7 лет назад

Add tests for changing the database encoding via RESET_DATABASE/VACUUM. And test that it is not possible to trick another connection with this.

4 года назад

resolver01.test

Fix a faulty assert() in the "AS" alias resolution logic of the parser.

11 лет назад

returning1.test

Fix a very obscure issue where the name resolver could get confused if aliases like "sqlite_schema" or "sqlite_master" were used in a query involving the sqlite_temp_schema table.

2 года назад

returningfault.test

Fix an assert() failure that could follow an OOM when coding a RETURNING trigger. dbsqlfuzz case 5d3e2438f15dc32b473d9f29413157857efa1212.

5 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

rollbackfault.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Improved rounding policy.

3 года назад

Fix the rowallock.test script so that it works with builds that do not support mmap mode.

11 лет назад

In the rowhash.test, make sure global variables are cleared prior to use.

16 лет назад

Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW.

2 года назад

Fix the whereKeyStats() routine (part of STAT4 processing only) so that it is able to cope with row-value comparisons against the primary key index of a WITHOUT ROWID table. [forum:/forumpost/3607259d3c|Forum post 3607259d3c].

4 года назад

Add test cases to rowvalue2.test.

10 лет назад

New test cases for row values and RIGHT JOIN.

4 года назад

Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output.

2 года назад

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

5 лет назад

Fix a SQL NULL handling bug in the vector IN operator code generation.

10 лет назад

Improved detection of number of column mismatch for vector assignment in UPDATE statements. Ticket [78acc9d40f0786e8]

7 лет назад

Fix the vector BETWEEN operator so that it only evaluates the left-most vector expression once. Add support for vector comparisons in the CASE operator.

10 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

rowvaluefault.test

Improve the error message in cases where there is a row-value on the LHS of an IN() operator, the RHS is a list (not a sub-select) and at least one element of the list is not a row-value with the correct number of elements.

5 лет назад

rowvaluevtab.test

Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds.

7 лет назад

Fix a couple of memory leaks in r-tree that can occur following an OOM condition.

16 лет назад

run-wordcount.sh

Modify wordcount so that timer information appears on standard error instead of standard output. Rename the run-wordcount.bash script to run-wordcount.sh and simplify it so that it stands a better chance of running on non-GNU systems.

13 лет назад

Further fixes to comments in sqlite3recover.h. Also rework some data structures in sqlite3recover.c.

4 года назад

savepoint2.test

Add the "wal" permutation to run existing test files savepoint.test and savepoint2.test in WAL mode.

16 лет назад

savepoint4.test

Change savepoint4.test to limit database growth. Otherwise the test can take a very long time to run, depending on the prng. (CVS 6737)

17 лет назад

savepoint5.test

Reinitialize page 1 of the database file following a ROLLBACK TO of a transactional SAVEPOINT on an initially empty database. (CVS 6103)

18 лет назад

savepoint6.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

savepoint7.test

Add test cases for ticket [7f7f8026eda387d544].

10 лет назад

savepointfault.test

Avoid running some particularly time-consuming tests as part of veryquick.test.

11 лет назад

scanstatus.test

Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default.

3 года назад

scanstatus2.test

Under Tcl9, the %x format letter truncates to 32-bits. Must use %llx in order to get a 64-bit rendering.

2 года назад

The sqlite3_set_authorizer() interface should only expire prepared statements when it is setting a new authorizer, not when clearing the authorizer. And statements that are running when sqlite3_set_authorizer() is invoked should be allowed to continue running to completion.

7 лет назад

Simplify wording of backup API error message. Decapitalize some other error messages. (CVS 6256)

18 лет назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

10 лет назад

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

Updates to test procedures so that they all work with encryption. No changes to the core SQLite code.

9 лет назад

schemafault.test

Avoid leaving view-definitions with an incomplete set of column names/types in the in-memory schema if an OOM strikes while allocating the same.

8 лет назад

Update tests to deal with SQLITE_FAST_SECURE_DELETE.

9 лет назад

securedel2.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Avoid having OP_SeekScan jump over an OP_IdxGT or OP_IdxGE that follows the OP_SeekGE opcode. Fix for [b50528af4468237c].

3 года назад

Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by distinguishing between "subquery" and "join" and using consistent names across EQP and bytecode.

4 года назад

Further refinements to table order selection on join query planning.

16 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Defer deletion of expressions that are optimized out by the AND optimizer in the sqlite3ExprAnd() routine until the corresponding Parse object is deleted. This avoids a dangling pointer in AggInfo if sqlite3ExprAnd() is invoked by the push-down optimization. The dangling pointer appears to be harmless in release builds, only showing up in debug builds. Problem found by dbsqlfuzz.

5 лет назад

When doing the optimization that attempts to avoid sorting on a GROUP BY, do not assume that the values in an index on an expression are non-NULL. Bug discovered by Wang Ke's fuzzer and reported at [forum:/forumpost/74330094d8|forum post 74330094d8].

5 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Do not let the number of terms on a VALUES clause be limited by SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements that appear to be variables due to the use of double-quoted string literals. [https://issues.chromium.org/issues/358174302|Chromium issue 358174302].

2 года назад

Remove possibly stray output from various tests.

11 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2 года назад

Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery.

15 лет назад

Do not perform the omit-unused-subquery-columns optimizations on a subquery that is DISTINCT, as that can lead to incorrect results.

3 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Fix a faulty assert() statement in the name resolver associated with the optimization that converts compound selects with ORDER BY COLLATE into subqueries.

11 лет назад

Change an OP_SCopy into an OP_Copy in a case where the destination might be used after the source has changed.

12 лет назад

Avoid excess stack usage when a VALUES clause with lots of rows occurs within a scalar expression. This fixes a problem discovered by OSSFuzz.

9 лет назад

Do not disable unused columns in a UNION ALL sub-query if any component of the sub-query is DISTINCT.

3 года назад

Change the names of the stream interface APIs to be of the form "_strm" instead of "_str". In other words, added an "m" to the end, to try to make it clear that we are talking about a "stream" and not a "string.

12 лет назад

sessionfuzz-data1.db

Add the sessionfuzz test program and data obtained from a week of running AFL. Automatically run this test program on any "make test" on unix.

8 лет назад

Enhancements to testrunner.tcl: (1) Add the "--config CONFIGS" option, to that only configuration named on the comma-separated list CONFIGS are run. (2) Add the "--omit CONFIGS" to omit configuration on the CONFIGS list (3) Add the Android configuration to "release"

2 года назад

Enhance the unix VFS so that it removes extra "/", "/./" and "/../" from the database filename.

6 лет назад

Change the ROLLBACK command so that pending statements to not block it. The pending statements instead return SQLITE_ABORT upon next access. Note: This causes separate shared-cache connections in read_uncommitted mode to abort as well.

14 лет назад

More test case changes so that shared-cache mode tests all work with normalized database names.

6 лет назад

Remove possibly stray output from various tests.

11 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Identify requirements text in the SQLITE_CONFIG_ documentation. Fix a typo (a duplicated word) in part of that documentation. Add some requirements marks for DETACH to the test scripts. No code changes.

13 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

shared_err.test

Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case.

9 лет назад

sharedlock.test

Obtain the required shared-cache write-lock when executing "DELETE FROM tbl" statements. Fix for [1e1321ee98].

13 лет назад

An improved method for statically linking sqlite3_analyzer.exe using Tcl9. Enable wildcard expansion of arguments to testfiture on Windows.

2 года назад

Disable shell test cases that require virtual tables when testfixture is built using SQLITE_OMIT_VIRTUALTABLE.

2 года назад

Fix a couple of memory leaks in the shell tool code that could occur when processing errors.

2 года назад

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2 года назад

Disable shell test cases that require virtual tables when testfixture is built using SQLITE_OMIT_VIRTUALTABLE.

2 года назад

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2 года назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

When extracting links from sqlar archives, clobber any existing file or link, and do not call utimes() to set the timestamp - it looks through the link and operates on the target.

2 года назад

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2 года назад

Fix the shmlock.test script so that it works with the Windows restriction that UnlockFile must exactly correspond to a prior LockFile.

8 лет назад

shortread1.test

Add tests to prevent a regression of the short read problem discovered in version 3.2.2. (CVS 4428)

19 лет назад

show_speedtest1_rtree.tcl

Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (Cherrypick from the sessions branch.)

12 лет назад

Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4.

4 года назад

sidedelete.test

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

18 лет назад

If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort.

2 года назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Enhancements to skip-scan such that it is operable when a middle column of an index is skipped while the left-most column is constrained in the WHERE clause.

12 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

If a call to sqlite3_snapshot_open() fails because the requested snapshot no longer exists, return SQLITE_ERROR_SNAPSHOT instead of SQLITE_BUSY_SNAPSHOT.

8 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

When possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get().

2 года назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

snapshot_fault.test

If SQLITE_USE_SEH is defined, handle structured-exceptions thrown by MSVC builds if the *-shm file mapping is accessed after it becomes invalid for some reason.

5 лет назад

snapshot_up.test

Fix an assert() that could fail within calls to sqlite3_snapshot_open() in SQLITE_ENABLE_SETLK_TIMEOUT builds.

3 года назад

Fix a test script error causing tests to fail in soak.test.

8 лет назад

More test cases and requirements marks for pragmas.

11 лет назад

Add a test case to show that ticket [e8b674241947eb3b] has been fixed.

4 года назад

Avoid running test case sort2.2.3 under address-sanitizer. It runs out of memory on some 32-bit platforms.

3 года назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

Update testrunner.tcl to use a separate process for each test script. And to run some extra tests too.

4 года назад

Fix a few small test script issues affecting SQLITE_TEMP_STORE=3 builds.

8 лет назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Add the SQLITE_CONFIG_PMASZ start-time option.

12 лет назад

Update test scripts speed1.test and speed1p.test so they may be run by testrunner.tcl.

4 года назад

speed1p.explain

Add speed-test scripts that also show EXPLAIN output. (CVS 5017)

18 лет назад

Update test scripts speed1.test and speed1p.test so they may be run by testrunner.tcl.

4 года назад

Detect database file changes using a 128-bit segment of the file header that includes the change counter. Ticket #2303. (CVS 3844)

19 лет назад

Rename a test procedure in 'speed3.test' to avoid a name collision.

10 лет назад

Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400)

18 лет назад

speed4p.explain

Add speed-test scripts that also show EXPLAIN output. (CVS 5017)

18 лет назад

Avoid running a couple of tests in crash8.test that depend on the presence of the journal file if running on an F2FS file-system that does not require a journal file.

8 лет назад

Remove all code that makes use of the C-language "long double" datatype.

2 года назад

Try to optimize spellfix1 by storing a NULL in the k1 column of %_vocab if it would otherwise have the same value as the word column.

8 лет назад

Adjustments to spellfix2.test so that it works reliably on mac.

11 лет назад

Update spellfix1_scriptcode() to output 215 (latin) for pure numeric text.

10 лет назад

Improve performance of editdist3() by keeping the costs in sorted order. Also add a new regression test to editdist3().

8 лет назад

Fix an issue with sqldiff reported by [forum:/info/9bd2155bdfae25a7|forum post 9bd2155bdfae25a7].

3 года назад

sqllimits1.test

Fix testcase to account for new behaviors with this branch.

2 года назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

starschema1.test

Fix typos in the star-schema test cases.

2 года назад

Add the "startup" test program designed to measure startup performance, and in particular schema parsing time.

6 лет назад

There are two possible error messages from stat-9.1, depending on compile-time options. Adjust the test case to accept either one.

5 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Add the stmtrand() extension function for use in testing.

2 года назад

Add a missing "finish_test" to the end of the stmtvtab1.test script.

9 лет назад

Allow an "IntReal" value to count as a REAL when checking types for insertion into a generated column on a STRICT table. [forum:/forumpost/fa012c77796d9399|Forum post fa012c77796d9399].

5 лет назад

Fix an issue in PRAGMA integrity_check associated reporting NULL values in a NOT NULL column of type ANY in a STRICT table.

5 лет назад

subjournal.test

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

Further improvements to the computation of affinity for compound subqueries: make sure that the selected affinity is compatible with a literal values in arms to the left of the arm that is used to determine affinity.

2 года назад

Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46].

7 лет назад

Catch vector size mismatch problems during name resolution to avoid later problems.

10 лет назад

Allow "substring()" as an alias for "substr()" for compatibility with other SQL engines.

6 лет назад

Follow-up to [bbaf1f2eb1e1637b]: Make sure subtypes do not cross a subquery boundary even if the function that returned the value with a subtype is buried down inside a larger expression. This fixes a problem identified by [forum:/forumpost/37dd14a538|forum post 37dd14a538].

3 года назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

swarmvtab2.test

Enhance the "swarmvtab" extension. See header comments in ext/misc/unionvtab.c for details.

9 лет назад

swarmvtab3.test

Fix a problem in test file swarmvtab3.test causing occasional failures.

4 года назад

swarmvtabfault.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Fix handling of unix paths that contain ".." components such that "/" is considered its own parent directory.

4 года назад

Document that -nofollow does not work on Windows. Fix Windows symlink test cases for when the test suite is run as administrator.

2 года назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

A unix VFS change replaces fsync() with fstat() when using SQLITE_NO_SYNC, so set PRAGMA synchronous=OFF in the sysfault-3 test to avoid erroneously causing errors in xSync.

11 лет назад

Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0.

2 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Enhance tester.tcl so that when "--malloctrace=1" is specified, the test generates self-contained Tcl scripts that present GUIs instead of *.sql files that require a separate program to interpret.

8 лет назад

Throw an error if AUTOINCREMENT appears in a WITHOUT ROWID table. Updates to API documentation to discuss WITHOUT ROWID.

13 лет назад

Make the sqlite3_error_offset() interface accessible from TCL using the new "erroroffset" method on the sqlite3 object.

4 года назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

Fix some problems to do with temp-file databases and recovering from IO and SQLITE_FULL errors.

10 лет назад

Many spelling fixes in comments. No changes to code.

13 лет назад

temptable2.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

temptable3.test

Add another test case to temptable3.test.

10 лет назад

temptrigger.test

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

10 лет назад

Testrunner.tcl enhancements: (1) Attempt to build the SQLite tcl extension if it is not already available. (2) testrunner target "devtest" is added as an alias for "mdevtest". (3) Try to keep summary information at the end of a test below 80-characters per line. (4) Update the Makefile.in so that the "clean" target removes the tcl extension built by item 1 above.

2 года назад

Add a case to testrunner.tcl so that mdevtest can run on openbsd.

2 года назад

testrunner_data.tcl

Remove all code that makes use of the C-language "long double" datatype.

2 года назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time option.

15 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined.

15 лет назад

Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined.

15 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

thread_common.tcl

Changes to the TCL extension and how it is built, suggested by Jan Nijtmans.

2 года назад

Bug-fixes to get the two threadtest C programs working again. (CVS 1756)

22 года назад

Fix some problems in test code detected by cppcheck.

11 лет назад

Fix compilation of 'threadtest3' for some older versions of MSVC.

5 лет назад

Add extra tests to threadtest4.c. Fix a benign data race accessing the text encoding using ENC(db).

12 лет назад

Add the new threadtest5 test program for stressing multiple database connections in the same process hammering on a single database. Primarily designed to test memdb, but works on any database.

5 лет назад

time-wordcount.sh

Update the wordcount.c test program and add a new script "time-wordcount.sh" for additional performance testing.

10 лет назад

Extended the time-diff format so that it can have a 5-digit year. This enables time differences to span the full range of dates supported by SQLite. Also fix some inaccuracies in the computation of time differences and add new test cases.

3 года назад

tkt-02a8e81d44.test

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

tkt-18458b1a.test

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

tkt-26ff0c2d1e.test

Add some missing "finish_test" lines to the end of test scripts.

9 лет назад

tkt-2a5629202f.test

"make test" now passing.

13 лет назад

tkt-2d1a5c67d.test

All tests in "make test" now pass with Tcl9, except for about 198 cases where the error involves small differences in the rendering to floating point values.

2 года назад

tkt-2ea2425d34.test

Do not reuse function parameters in subsequent expressions since the function call might have triggered a text encoding change. Fix for ticket [2ea2425d34be].

17 лет назад

tkt-31338dca7e.test

Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table.

14 лет назад

tkt-313723c356.test

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

10 лет назад

tkt-385a5b56b9.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

tkt-38cb5df375.test

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

tkt-3998683a16.test

Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5].

16 лет назад

tkt-3a77c9714e.test

Always clear the temporary register cache after coding a subroutine.

7 лет назад

tkt-3fe897352e.test

Back out the change from [7fab1393c2b22b1f] that tries to convert invalid surrogate characters in UTF16 into the replacement character 0xfffd, as we find that this breaks some software.

6 лет назад

tkt-4a03edc4c8.test

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

tkt-4c86b126f2.test

Make sure that virtual WHERE-clause terms do not get transformed into real terms when processing set of OR-connected terms. Fix for ticket [4c86b126f22ad].

13 лет назад

tkt-4dd95f6943.test

Enhance tests for ticket [4dd95f6943].

13 лет назад

tkt-4ef7e3cfca.test

Fix comment in test.

12 лет назад

tkt-54844eea3f.test

Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries.

15 лет назад

tkt-5d863f876e.test

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

10 лет назад

tkt-5e10420e8d.test

Fix for ticket [5e10420e8d].

16 лет назад

tkt-5ee23731f.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

tkt-6bfb98dfc0.test

Candidate fix for ticket [6bfb98dfc0c]: Make sure invalid cursors drop all references to database pages prior to doing any insert or update.

13 лет назад

tkt-752e1646fc.test

Skip flattening if subquery has LIMIT and outer query is DISTINCT. Fix for ticket 752e1646fc.

15 лет назад

tkt-78e04e52ea.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

tkt-7a31705a7e6.test

Add some missing "finish_test" lines to the end of test scripts.

9 лет назад

tkt-7bbfb7d442.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

tkt-80ba201079.test

Remove debugging pragmas accidently left in by a prior change.

8 лет назад

tkt-80e031a00f.test

Fix requirements marks so that they match documentation corrections.

4 года назад

tkt-8454a207b9.test

Ensure that values generated by DEFAULT clauses that specify real numbers that can be expressed as 64-bit integers (e.g. -1234.0) are not silently converted to integers.

3 года назад

tkt-868145d012.test

Add a missing test that prevented double LEFT JOINs with transitive constraints from working correctly. Fix for ticket [868145d012].

13 лет назад

tkt-8c63ff0ec.test

Do not allow temporary registers to be in use across an OP_Yield within a co-routine. Fix for ticket [8c63ff0eca81a9132d8].

12 лет назад

tkt-91e2e8ba6f.test

Add a test for ticket [91e2e8ba6f]. No changes to code.

15 лет назад

tkt-94c04eaadb.test

Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years.

13 лет назад

tkt-99378177930f87bd.test

Another fix to the indexed expressions in aggregate queries with GROUP BY enhancement of ticket [99378177930f87bd] and implemented by check-in [b9190d3da70c4171] to address a problem described by [forum:/forumpost/f34e32d120|forum post f34e32d120],

3 года назад

tkt-9a8b09f8e6.test

Add some more IN operator tests.

12 лет назад

tkt-9d68c883.test

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

10 лет назад

tkt-9f2eb3abac.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

tkt-a7b7803e.test

A couple more test cases.

14 лет назад

tkt-a7debbe0.test

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

tkt-a8a0d2996a.test

When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa].

7 лет назад

tkt-b1d3a2e531.test

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

tkt-b351d95f9.test

Test case and fix for the specific failure of ticket [b351d95f9cd5ef17e9d9dbae].

16 лет назад

tkt-b72787b1.test

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

tkt-b75a9ca6b0.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

tkt-ba7cbfaedc.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

tkt-bd484a090c.test

Adjust date/time functions so that they do a better job of keeping track of whether the current time is UTC or localtime, and no-op the 'utc' and 'localtime' modifiers accordingly. See [forum:/info/e7a939e074|forum post e7a939e074]. Also add the datedebug() function, available only under -DSQLITE_DEBUG, for improved visibility of the DateTime object during debugging and testing.

2 года назад

tkt-bdc6bbbb38.test

Before running each test script, make sure the FTS enhanced query syntax is disabled.

14 лет назад

tkt-c48d99d690.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

tkt-c694113d5.test

Do not abort running queries due to a CREATE INDEX statement. Allow them to run to completion before being reprepared. Fix for ticket [c694113e50321afdf9].

8 лет назад

tkt-cbd054fa6b.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

tkt-d11f09d36e.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

tkt-d635236375.test

Update the OP_Move opcode to shift the pScopyFrom pointer of aliases when compiled with SQLITE_DEBUG. Ticket [d63523637517386191].

15 лет назад

tkt-d82e3f3721.test

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

tkt-f3e5abed55.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

tkt-f67b41381a.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

tkt-f777251dc7a.test

This is a cherry-pick of version [b5df5ac052].

12 лет назад

tkt-f7b4edec.test

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

tkt-f973c7ac31.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

tkt-fa7bf5ec.test

Make sure the query optimizer for aggregate queries knows that expressions (x='a') and (x='A') are different. Ticket [fa7bf5ec94801e7e]

15 лет назад

tkt-fc62af4523.test

Fix the tkt-fc62af4523.test to work around non-randomness of the randomblob() function when in testing mode.

16 лет назад

tkt-fc7bd6358f.test

Fix a bug (ticket [fc7bd6358f59]) that caused incorrect query results in three way queries that involved comparing INTEGER and TEXT columns for equality.

13 лет назад

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

21 год назад

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

21 год назад

Modify the test cases in tkt1444.test that were failing. I am convinced that the test cases were incorrect. (CVS 3288)

20 лет назад

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

21 год назад

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

21 год назад

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

21 год назад

Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)

19 лет назад

Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681)

17 лет назад

Fix incorrect type conversions when copying from a table into itself. Ticket #1536. (CVS 2773)

21 год назад

Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943)

21 год назад

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

Minor test file modifications for builds compiled with OMIT options. (CVS 3077)

21 год назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)

19 лет назад

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

18 лет назад

Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400)

18 лет назад

Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)

19 лет назад

Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400)

18 лет назад

Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)

19 лет назад

Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)

19 лет назад

Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040)

19 лет назад

Many spelling fixes in comments. No changes to code.

13 лет назад

When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111)

19 лет назад

Enhance sqlite3_shutdown() so that it automatically invokes sqlite3_reset_auto_extension(). This is a harmless no-op if applications are already calling sqlite3_reset_auto_extension() prior to sqlite3_shutdown(). And it prevents possible memory corruption if they do not. So it works either way. Most of the changes are to the test cases. (CVS 6475)

17 лет назад

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

18 лет назад

Fix incorrect index cost assumptions that occur after an ANALYZE. Ticket #2643. (CVS 4424)

19 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

17 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Bare identifiers in ORDER BY clauses bind more tightly to output column name, but identifiers in expressions bind more tightly to input column names. This is a compromise between SQL92 and SQL99 behavior and is what PostgreSQL and MS-SQL do. Ticket [f617ea3125e9c].

13 лет назад

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

17 лет назад

More test case changes so that shared-cache mode tests all work with normalized database names.

6 лет назад

Add more test cases to prove that ticket #2920 does not exist in CVS HEAD. The problem was previously fixed by the changes to ticket #2686. Ticket #2920 is a duplicate of #2686. (CVS 4772)

19 лет назад

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

18 лет назад

Do not apply the query flattening optimization when the outer query is an aggregate and the inner query contains an ORDER BY clause. Ticket #2943. (CVS 4791)

18 лет назад

The COMMIT command now works even if there are pending queries, as long as the pending queries are reading and not writing the database. (CVS 5864)

18 лет назад

Make sure that when a connection is blocking on a RESERVED lock that it continues after the lock is released. Ticket #3093. (CVS 5078)

18 лет назад

Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400)

18 лет назад

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

17 лет назад

Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab]

7 лет назад

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

17 лет назад

Add some missing "finish_test" lines to the end of test scripts.

9 лет назад

Additional test cases for nested subqueries in a WHERE clause. (CVS 5999)

18 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Add a test script to verify that ticket #3419 stays fixed. (CVS 5771)

18 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682)

17 лет назад

Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979)

18 лет назад

Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table.

14 лет назад

Convert the "~" and "NOT" operators to be two-address instructions. Ticket #3541. (CVS 6028)

18 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Here is the test case to prove that ticket #3581 is fixed. (CVS 6174)

18 лет назад

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

10 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined.

17 лет назад

Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices.

16 лет назад

Make sure a ROLLBACK that follows an incremental vacuum works. Ticket #3761. (CVS 6416)

17 лет назад

If a rollback mode transaction reduces the size of the database file, avoid actually truncating the file until after the transaction has been committed (but before the db has been unlocked). This means pages that are removed from the database by truncating the file need not be journalled.

13 лет назад

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

Do not attempt to walk a TokenOnly or SpanOnly expression tree node. Ticket #3791. (CVS 6469)

17 лет назад

More test case changes so that shared-cache mode tests all work with normalized database names.

6 лет назад

Suppress errors associated with TEMP triggers that reference objects in non-TEMP databases. This is a continuation of the fix for ticket #3810 shown in check-in [ba1afc040171810d] from [/timeline?c=trunk:200908061743|2009-08-06], based on a bug report in [forum:/forumpost/157dc791df|forum post 157dc791df]

6 лет назад

Allow an index paired with a NOT NULL constraint to be used for sorting under the condition that the index be treated as a non-unique index.

16 лет назад

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

17 лет назад

Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404].

15 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan.

11 лет назад

Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721)

17 лет назад

Make sure nested queries with USING clauses do not leak memory. Preliminary fix for ticket #3911. (CVS 6750)

17 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Changes to various test scripts so that they pass on windows.

15 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Improved technique for parsing the ON and USING clauses of a join is faster and uses less memory.

4 года назад

Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.

17 лет назад

When flattening a SELECT query, do not discard collation sequences explicitly attached to expressions in the parent query. Fix for #3997. (CVS 6949)

17 лет назад

Many more test cases fixed. Only a few remain.

10 лет назад

Testing coverage enhancements. (CVS 5358)

18 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Show the text of individual statements within a trigger, as they execute, as comments in the output from sqlite3_trace() and sqlite3_trace_v2().

9 лет назад

Fix a problem causing the fts3 integrity-check to fail if run inside a transaction.

11 лет назад

Fix the trace3-4.4 test to be more rebust against timing quirks.

3 года назад

Add support for the sqlite3_txn_state() interface.

6 лет назад

Update a few test cases to account for the new error message formats.

13 лет назад

This is a cherry-pick of version [b5df5ac052].

12 лет назад

transitive1.test

Once corner case for the fix at [8b24c177061c3836] was not quite right. Caught overnight by both OSSFuzz and dbsqlfuzz and repaired here.

5 лет назад

Allow arbitrary expressions as the second argument to RAISE().

2 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes.

14 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034)

22 года назад

Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454)

21 год назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Changes to support recursive triggers.

17 лет назад

Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.

2 года назад

Enhance tester.tcl so that when "--malloctrace=1" is specified, the test generates self-contained Tcl scripts that present GUIs instead of *.sql files that require a separate program to interpret.

8 лет назад

Additional coverage testing in the new name resolver module. (CVS 5608)

18 лет назад

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement.

7 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Fix a problem caused by using an SQL variable in an OVER clause within a trigger program.

6 лет назад

Remove unnecessary whitespace from testcase result strings.

8 лет назад

Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds.

7 лет назад

triggerupfrom.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

trustschema1.test

Fix JSON functions so that they work correctly under PRAGMA trusted_schema. [forum:/forumpost/c88a671ad083d153|Forum thread c88a671ad083d153].

4 года назад

tt3_checkpoint.c

Updates so that "threadtest3[.exe]" can be built for windows with MSVC.

5 лет назад

Further enhancements to threadtest3 stress tests.

12 лет назад

tt3_lookaside1.c

Further enhancements to threadtest3 stress tests.

12 лет назад

Fix a tsan error that could occur when using shared-cache mode.

6 лет назад

Extend the refactoring into extensions. Clean up stray newlines.

6 лет назад

Fix compilation of 'threadtest3' for some older versions of MSVC.

5 лет назад

Remove the sqlite3BtreeFactor() wrapper routine. All modules now call sqlite3BtreeOpen() directly.

16 лет назад

Fix a problem causing the affinity of sub-select row-value elements to be ignored in some contextes.

10 лет назад

All tests in "make test" now pass with Tcl9, except for about 198 cases where the error involves small differences in the rendering to floating point values.

2 года назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

In the name resolver when SQLITE_ALLOW_ROWID_IN_INDEX is enabled, if there are multiple views that might resolve to the "rowid" but only one real table, then use that one real table and ignore the views.

2 года назад

Avoid coding unindexed WHERE constraints if an equivalent transitive term has already been coded by an outer loop.

5 лет назад

unionallfault.test

When flattening UNION ALL subqueries into a join query, ensure that separate cursor numbers are used for each segment of the newly flattened query.

6 лет назад

Remove unnecessary whitespace from testcase result strings.

8 лет назад

unionvtabfault.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the same behavior exhibited by all prior releases.)

11 лет назад

If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as SQLITE_DEFAULT_SYNCHRONOUS and the application has not run "PRAGMA synchronous", then set synchronous to the SQLITE_DEFAULT_WAL_SYNCHRONOUS setting when entering WAL mode for the first time.

10 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Restore part of the UPDATE one-pass optimization that was removed by check-in [2c56b984a0bd3be5]: only disable one-pass if the WHERE clause contains a subquery. Allow subqueries in the SET expressions. Fix for performance problem reported by [forum:/forumpost/8ab195fd44e75ed0|forum post 8ab195fd44e75ed0].

3 года назад

Make sure cursors are opened on all indexes for an UPDATE OR REPLACE regardless of whether or not the indexes are partial or contain columns that might need to be updated.

8 лет назад

Make it an error to repeat the target object/alias of an UPDATE statement in its FROM clause.

6 лет назад

Fix a faulty assert() statement in sqlite3ExprListDup(). This is a continuation of the fix at [59812e7ef705226c].

5 лет назад

Fix the assert() that attempts to verify that the table-reference to index-reference translator finds all required translations. [forum:/forumpost/929168fdd6|Forum post 929168fdd6].

4 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Avoid performing aggregate processing more than once for a single expression. [forum:/info/36ff78b2a3|Forum post 36ff78b2a3].

3 года назад

upfromfault.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Test case for the fix in the previous check-in.

2 года назад

Add function format() as an alias for printf(), for compatibility with other systems.

5 лет назад

Fix the table name aliasing on INSERT so that it occurs before the column list rather than afterwards, just as it does for PostgreSQL. Add table name aliasing to UPDATE and DELETE.

8 лет назад

A few more tests for upsert.

8 лет назад

Silently ignore redundant ON CONFLICT clauses in an UPSERT. Only the first ON CONFLICT for each index is active. Do not issue an error, since that might break legacy queries. But ignore the redundant ON CONFLICT clauses to prevent problems such as described in [forum:/forumpost/919c6579c8|forum post 919c6579c8].

2 года назад

upsertfault.test

A few more tests for upsert.

8 лет назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

Add extra tests to check the result of including a %00 escape in a URI when ENABLE_URI_00_ERROR is defined.

10 лет назад

userauth01.test

Enhance the sqlite3_user_add() interface to initialize the user authentication logic. Add test cases for the extra argument on the end of the authorizer callback.

12 лет назад

utf16align.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

vacuum-into.test

The read-only CHECK-constraint optimization of [34ddf02d3d21151b] inhibits the xfer optimization for tables with CHECK constraints. However, the xfer optimization is required for correct operation of VACUUM INTO on tables that contain generated columns. Fix this by ignoring CHECK constraints when qualifying the xfer optimization while running VACUUM. Problem reported by [forum:/forumpost/3ec177d68fe7fa2c|forum post 3ec177d68fe7fa2c].

2 года назад

Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690].

15 лет назад

Avoid loading large intkey rows when VACUUMing, even if the page-size is changing.

6 лет назад

Fix vacuum3.test so that it works with SQLITE_OMIT_ALTERTABLE builds.

5 лет назад

Add some missing "finish_test" lines to the end of test scripts.

9 лет назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Fix an "ifcapable" expression in values.test.

2 года назад

valuesfault.test

Attempt to reduce the memory used by VALUES clauses in as many statements as possible, not just INSERT. This branch still has problems.

2 года назад

Add some missing "finish_test" lines to the end of test scripts.

9 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Back out the previous change on this branch. In its place: Determine the affinity of a subquery by the left-most arm of the subquery that has an affinity other than NONE. In other words, scan from left to right looking for an arm of the compound subquery with an affinity of BLOB, TEXT, INTEGER, or REAL and pick the first one found. Or stay with NONE if no arm has a defined affinity. Test cases added.

2 года назад

Ensure that objects within view definitions are not incorrectly resolved to CTEs that are part of the statement using the view.

5 лет назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Further enhancements to make sure the correct returnning trigger is run when there are nested INSERT RETURNING statements.

3 года назад

Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3).

5 лет назад

Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key.

9 лет назад

Add support for the extra parameter on the sqlite3_set_authorizer() callback and support for failing an ATTACH with an authentication-required database using bad credentials. The extension is now feature complete, but much testing and bug-fixing remains.

12 лет назад

Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan.

11 лет назад

Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.

17 лет назад

New requirement marks.

4 года назад

Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case.

9 лет назад

Handle the case where the estimated cost of a virtual table scan is larger than SQLITE_BIG_DBL. Ticket #2253. (CVS 3670)

19 лет назад

Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845)

19 лет назад

Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and "BLOB") and if a column has one of those datatypes, store the type part of the bit-field information in the Column structure to save space.

5 лет назад

Add test cases to prove that ticket #3082 has been fixed. (CVS 5048)

18 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

14 лет назад

Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key.

9 лет назад

Fix typos in 'vtabF.test' file. No changes to code.

10 лет назад

Remove obsolete testfixture TCL commands formerly required by Windows but now handled by Tcl itself. Update tests case accordingly.

2 года назад

Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan.

11 лет назад

Fix UPDATE FROM statements on virtual tables that are declared WITHOUT ROWID.

6 лет назад

Improved the error message that results when a schema parse fails after ALTER TABLE ADD COLUMN.

5 лет назад

Add extra tests for the error messages generated by sqlite3_declare_vtab() when passed something other than a well-formed CREATE TABLE statement.

2 года назад

vtab_alter.test

Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0).

9 лет назад

Fix a failing assert() in sqlite3ResetAllSchemasOfConnection().

8 лет назад

vtab_shared.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

vtabdistinct.test

Bring sqlite3_vtab_distinct() up to spec so that it works as described in the documentation.

5 лет назад

Fix a problem causing the sqlite_master entry corresponding to a virtual table to be removed by a DROP TABLE even if the call to the vtabs xDestroy() method failed.

8 лет назад

Update stale evidence marks on sqlite3_vtab_rhs_value() test cases.

5 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

All tests in "make test" now pass with Tcl9, except for about 198 cases where the error involves small differences in the rendering to floating point values.

2 года назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

More test-case changes so that everything works when the reserved_bytes value in the header is non-zero.

10 лет назад

Adjust the MSVC makefile to use Tcl8.6 by default.

10 лет назад

In the unix VFS, fix the heap shm allocator (used for unix-excl) so that it works even on systems where the page size is larger than 32KB.

8 лет назад

Further tweaks to the wal7.test test case.

15 лет назад

Many more test cases fixed. Only a few remain.

10 лет назад

Update a couple of test scripts so that they work in auto-vacuum mode.

14 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Many more test cases fixed. Only a few remain.

10 лет назад

On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file.

14 лет назад

Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and is not yet ready for release.

11 лет назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times.

11 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost.

13 лет назад

Minor test infrastructure changes to better support SEE testing.

10 лет назад

Fix duplicate test names in 'walfault.test'.

9 лет назад

Avoid attempting to delete a file while it is still open in walfault2.test.

8 лет назад

Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned.

16 лет назад

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

15 лет назад

waloverwrite.test

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

walpersist.test

It turns out that pagerExclusiveLock() can be called with the lock state already set to RESERVED if the SQLITE_FCNTL_PERSIST_WAL setting is set and a specific sequence of multiple journal mode changes occur. Enhance pagerExclusiveLock() to deal with this. [forum:/forumpost/8130545bc6|Forum post 8130545bc6]

3 года назад

walprotocol.test

Fix a couple of test scripts to match the new wal recovery behaviour on this branch.

6 лет назад

walprotocol2.test

In wal mode, if a "BEGIN EXCLUSIVE" command (or any other command that upgrades from no transaction directly to a write transaction) hits an SQLITE_BUSY_SNAPSHOT error, change the error code to SQLITE_BUSY to indicate to the caller that the condition may be transient.

8 лет назад

On unix, if the *-shm file cannot be opened for read/write access, open it read-only and proceed as if the readonly_shm=1 URI option were specified.

9 лет назад

Fix the ability to read read-only WAL-mode database when -shm is present, ([00ec95fcd02bb415|check-in 00ec95fcd02bb415]) so that it works for the case of 64K page size.

5 лет назад

walrofault.test

Get read-only SHM file tests passing on Win32.

9 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Reduce a timeout in walsetlk.test from 2000ms to 1100ms so that the test runs a bit faster.

4 года назад

In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled.

4 года назад

Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead.

2 года назад

In SQLITE_ENABLE_BATCH_ATOMIC_WRITE builds on F2FS file-systems, invoke SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE if an SQLITE_FCNTL_COMMIT_ATOMIC_WRITE call fails. Also, do not use an atomic transaction to create the initial database. This is because if an error occurs while writing to the db file, any changes to the file-size do not seem to be rolled back automatically. The only time this matters is when the file was 0 bytes in size to start with.

9 лет назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.

4 года назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Improvements to the query planner to address the inefficiency described by [forum/forumpost/2568d1f6e6|forum post 2568d1f6e6].

3 года назад

Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now.

11 лет назад

Additional test cases for comparisons against NULL in the WHERE clause and elsewhere in a SELECT. (CVS 4051)

19 лет назад

Make sure the ON clause of a LEFT JOIN does not cause an index to be used to speed access to a table to the left of the join. Ticket [ebdbadade5]

16 лет назад

Fix a test case whose value changes under the no_optimization permutation due to the recent change to add the ability for SQLITE_TESTCTRL_OPTIMIZATION to disable one-pass.

3 года назад

Add the "sorter-reference" optimization, allowing SQLite to be configured so that some required values may be loaded from the database after external sorting occurs for SELECT statements with ORDER BY clauses that are not satisfied by database indexes.

8 лет назад

Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.

4 года назад

Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us.

6 лет назад

Tweak to the new whereB.test file to make it more consistent.

17 лет назад

Simplified implementation of indexing with the IS operator.

11 лет назад

In the OP_Column opcode, if the cursor is marked NullRow (due to being the right table of a LEFT JOIN that does not match) and the cursor is the table cursor for an OR-optimization with a covering index, then do not substitute the covering index cursor, since the covering index cursor does not have the NullRow flag set. Ticket [aa4378693018aa99]

6 лет назад

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Back out an incorrect change to the sqlite3ExprCompareSkip() function that was added way back on 2019-08-22 for [44578865fa7baf97|check-in 44578865fa7ba] and which was only today discovered to be incorrect by [forum:/forumpost/45ec3d9788|forum post 45ec3d9788].

3 года назад

Also make sure an index that is a proper subset of some other index has a higher cost than that other index. Add test cases.

12 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

Omit the "noop(X)" test SQL function. Accomplish the same thing using the idiom: "coalesce(X,random())".

2 года назад

Add new test file whereM.test. Containing tests for the change on this branch.

5 лет назад

Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise.

2 года назад

wherefault.test

Add extra test case for OOM handling in where.c.

5 лет назад

wherelfault.test

Add further tests for the code on this branch.

9 лет назад

wherelimit.test

Fix incorrect RETURNING test cases in wherelimit.test

5 лет назад

wherelimit2.test

Omit bogus tests accidentally added by the privious commit.

2 года назад

wherelimit3.test

Better optimize queries that use parameters in the LIMIT clause.

2 года назад

Test cases for covering indexes on wide tables.

4 года назад

Fix test script comment. No changes to code.

9 лет назад

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

4 года назад

win32longpath.test

Make extra efforts to delete the over-size directory names created by the win32longpath.test module.

2 года назад

win32nolock.test

Initial work on a Win32 VFS with NOP locking.

10 лет назад

Fix the window-function group_concat() so that it returns an empty string if it has one or more empty string inputs. This fixes a bug introduced by [c6da39115d3e2b0f] on 2019-03-26 (version 3.28.0) and reported by [forum/forumpost/bf8f43aa522c2299|forum post bf8f43aa522c2299].

2 года назад

Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement.

7 лет назад

Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement.

7 лет назад

Implement the EXCLUDE clause for window frames.

7 лет назад

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG.

3 года назад

Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3].

6 лет назад

Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3].

6 лет назад

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled.

8 лет назад

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

5 лет назад

Support some "ROWS BETWEEN N PRECEDING AND M FOLLOWING" window functions without caching entire partitions.

7 лет назад

Fix problems with window frames that use ORDER BY ... NULLS LAST etc.

7 лет назад

Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions.

5 лет назад

Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions.

5 лет назад

Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...).

5 лет назад

Back out the change at [47cd634c98b502d4] which was incorrect. Add a test case so that we don't accidently back out that change again.

7 лет назад

Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.

4 года назад

Fix windowC tests to specify little-endian or big-endian UTF16, for cross-platform portability. [forum post 559b84a5c6|forum:/forumpost/559b84a5c6]

5 лет назад

Fix a problem with flattening and window functions causing an "IS <column>" to be transformed to "IS TRUE" or "IS FALSE" when <column> is a view or sub-select expression that is the literal value "TRUE" or "FALSE".

4 года назад

Fix a case where the BTCF_AtLast flag was being left set incorrectly. This was causing obscure window function queries to fail.

2 года назад

Fix error handling for the case where a window function is passed the wrong number of arguments.

7 лет назад

Fix error handling for the case where a window function is passed the wrong number of arguments.

7 лет назад

windowfault.test

Add extra tests for the group_concat() fix on this branch.

5 лет назад

windowpushd.test

If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort.

2 года назад

Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [/tktview/baa5bb76c35a124c|ticket baa5bb76c35a124c].

3 года назад

Fix a name resolution issue with CTEs.

2 года назад

The view-scan optimization was added to enhance the performance of one specific query, but it causes performance regressions on a host of others. Disable it (at least temporarily) in order to try to find an alternative way of fixing the one specific query that it was created to fix - an alternative way that does not cause performance problems for other unrelated queries.

3 года назад

Do not allow parameters or schema references inside of WITH clause of triggers and views. This fixes a bug discovered by OSSFuzz and present since common-table-expressions were first added in 2014-02-03.

8 лет назад

New test cases for recursive CTEs with multiple recursive terms.

6 лет назад

If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort.

2 года назад

From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files.

11 лет назад

without_rowid1.test

Fix a test in without_rowid1.test so that it is disabled without ALTER TABLE support, as it uses ALTER TABLE.

4 года назад

without_rowid2.test

Many new test cases added, that mostly work. Currently 18 errors in without_rowid3.test. Also there is a hack marked by a /*FIXME*/ comment on at fkey.c:547 that needs fixing.

13 лет назад

without_rowid3.test

Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints.

6 лет назад

without_rowid4.test

Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases.

13 лет назад

without_rowid5.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

without_rowid6.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

5 лет назад

without_rowid7.test

Fix some test script issues that come up with SQLITE_OMIT_VIRTUALTABLE builds.

7 лет назад

Add the --upsert option to the wordcount test program.

8 лет назад

writecrash.test

Disable the writecrash.test module on Windows.

9 лет назад

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

zeroblobfault.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

5 лет назад

zerodamage.test

Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature.

9 лет назад

All tests in "make test" now pass with Tcl9, except for about 198 cases where the error involves small differences in the rendering to floating point values.

2 года назад

All tests in "make test" now pass with Tcl9, except for about 198 cases where the error involves small differences in the rendering to floating point values.

2 года назад

zipfilefault.test

Fix a test case in zipfilefault.test so that it only runs if JSON1 is available.

8 лет назад