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

/

/

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

/

/

Аналитика

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

Fix a 32-bit integer overflow in sqlite3changegroup_change_blob() that could lead to a buffer overwrite.

3 месяца назад

Minor patch to test/json/json-speed-check.sh. That script is not maintained, but this fix at least gets it working for now.

4 месяца назад

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

13 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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

Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table.

год назад

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

17 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 года назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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

Add tests for ALTER TABLE authorization callbacks and other things.

10 месяцев назад

Fix some problems with DROP CONSTRAINT and DROP NOT NULL on generated columns.

10 месяцев назад

Prevent internal-use-only SQL functions from being used inside of a CHECK constraint added using ALTER TABLE ADD CONSTRAINT.

3 месяца назад

altercons2.test

Various minor bug fixes cherrypicked from trunk.

4 месяца назад

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

Merge latest trunk changes into this branch.

8 месяцев назад

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 года назад

When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See [forum:/forumpost/f4878de3e7dd4764|forum thread f4878de3e7].

год назад

Fix a problem with ALTER TABLE DROP COLUMN commands where the column being dropped is the rightmost in table and is immediately preceded by a comment containing a "," character.

8 месяцев назад

Experimental change to allow triggers in the temp schema to use fully qualified table names in INSERT/UPDATE/DELETE statements.

9 месяцев назад

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 года назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 года назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

On x64 hardware, round-trip uint64_t→double→uint64_t conversions fail for values greater than UINT64_MAX-2047. This caused the SQLite text-to-float converter routine to give incorrect results for values between '1.8446744073709550592eNNN' and '1.8446744073709551609eNNN' for any exponent NNN. This problem was introduced by check-in [761d8fd18b0ee868] and first appeared in version 3.47.0 and was reported by [forum:/forumpost/569a7209179a7f5e|forum post 569a7209179a7f5e]. Fixed by this check-in.

2 года назад

Improved rounding of floating-point conversions in some corner cases.

6 месяцев назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 года назад

If the argument to REINDEX is EXPRESSIONS (with no schema prefix) then it updates both expression indexes, and any indexes named "expressions" or all indexes of any tables name "expressions".

5 месяцев назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

autoindex1.test

Do a better job of not generating unnecessary Bloom filters associated with IN operators.

6 месяцев назад

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

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Fix test cases impacted by the use of ~/.sqliterc

9 месяцев назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 года назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

Many test cases fixed to work with encryption.

10 лет назад

Revert the recent fixes to backup code and instead fix the problem reported by forum post [forum:15d82885e2 | 15d82885e2] (that a call to sqlite3_deserialize() after sqlite3_backup_init() but before the first call to sqlite3_backup_step() on the destination db of a backup could cause a crash) by deferring caching the pointer to the destination Btree until after it is locked.

2 месяца назад

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 лет назад

Fix some integer overflow warnings in the base64 and base85 extensions.

10 месяцев назад

More ==/!= => eq/ne fixes

год назад

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 queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt from ASC/DESC sort-orders to be optimized using a single index. Also allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause.

8 месяцев назад

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

Omit explain_i calls from TCL test scripts.

5 месяцев назад

bestindexC.test

Do not attempt the OR-optimization on conjuncts that contain COLLATE operators.

3 месяца назад

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 года назад

bestindexE.test

Add better test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement.

9 месяцев назад

bestindexF.test

Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt from ASC/DESC sort-orders to be optimized using a single index. Also allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause.

8 месяцев назад

Add test case to between.test.

год назад

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 года назад

Fix an assert() that could fail when reading a blob or text value larger than 1GiB from the database (requires a non-default build configuration). This is an assert() fix only, production builds were functioning correctly.

10 месяцев назад

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].

4 года назад

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 an issue in Bloom filters on RHS subsqueries to IN operators. See [forum:/forumpost/792a09cb3df9e69f|forum post 792a09cb3d] for a description of the problem. Also improve comments related to [baa83b460c677c21] which was origin of the problem.

год назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Disable a test case that (intentionally) does use-after-free, as it does occasionally cause problems even for non-sanitizer builds.

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 лет назад

Do not allow the argument to a table-valued function to reference a table to its right, even if the SELECT is inside a common table expression.

2 месяца назад

Were we to choose to integrate the carray() table-valued function into the amalgamation, that integration might look something like this.

10 месяцев назад

carrayfault.test

Fix the carrayfault.test script so that it works in configurations that do not support virtual tables.

10 месяцев назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix.

год назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Fix cksumvfs test case added by [e3bd1feccaee8ff2] so that it works with varying page sizes. Test case change only - no changes to code.

год назад

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 the (non-deliverable, testing-use-only) closure extension so that it parses quoted instantiation arguments correctly.

2 месяца назад

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

17 лет назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 лет назад

Minor fixes. Tests are passing now.

7 месяцев назад

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 лет назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

columncount.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

5 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Guard against oversized index entries in databases larger than 2GiB.

7 месяцев назад

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 лет назад

Attempt to reduce divergence with begin-concurrent.

2 года назад

Do not reduce the estimated truth probability of LIKE and GLOB operators by quite so much. Fix a single test case whose output changed.

6 месяцев назад

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 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

Ensure that a hot journal is rolled back in the case where a process or system crash resulted in a corrupt super-journal record where the magic and length values are correct but the super-journal name and checksum fields are both zeroed. Frorum post [forum:/info/2026-07-20T18:27:00Z | 2026-07-20T18:27:00Z].

21 день назад

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 лет назад

In the date/time functions, a timezone suffix of "+00:00" should work the same as "Z". [forum:/forumpost/2025-09-17T10:12:14z|Forum post 2025-09-17T10:12:14z].

год назад

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 лет назад

Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected.

год назад

New date/time test cases to validate ancient dates.

2 года назад

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

7 лет назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 лет назад

In the CLI, if a command-line argument names a file and the filename ends with .sql or .txt, then process that file as an SQL script. Use this feature for better testing.

8 месяцев назад

Have the sqlite_dbpage module correctly handle constraints of the form "WHERE pgno=$pgno" when $pgno is an integer that cannot be represented as a signed, 32-bit value.

3 месяца назад

dbpagefault.test

Improvements to the way that truncation is implemented in sqlite_dbpage().

2 года назад

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 лет назад

Adjust the dbstatus2.test module so that it works on 32-bit builds in addition to 64-bit builds.

9 месяцев назад

Fix unbounded whitespace skip in the decimal extension.

2 месяца назад

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 год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Fix a long-standing problem with DISTINCT LEFT JOIN queries.

5 месяцев назад

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 года назад

Revamp the QRF insert-mode optimization of [659ff6ab55802507]. The control value is now nMultiInsert. Multiple rows are added to each INSERT statement until the number of bytes in that statement exceeds the nMultiInsert value. The CLI uses a default value of 3000, which provides a good balance between speed and prepare-statement size. The output from ".dump" now loads nearly 2x faster in some cases.

5 месяцев назад

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 лет назад

Increase the precision of double → text conversions that happen in sqlite3_column_text(), or sqlite3_value_text(), or in the CAST() operator, or similar, so that round-tripping the value back to double results in exactly the same value.

6 месяцев назад

Fix compiler warnings.

2 месяца назад

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 лет назад

Experimental change to allow triggers in the temp schema to use fully qualified table names in INSERT/UPDATE/DELETE statements.

9 месяцев назад

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 лет назад

Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE.

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 лет назад

emptytable.test

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

9 лет назад

Ensure that the database encoding is detected before the code generator gets too far down into byte-code generation and execution, but not so early that it interferes with initialization. [forum:/forumpost/bc75a4d20b756044|Forum thread bc75a4d20b756044].

2 года назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 лет назад

Minor fixes. Tests are passing now.

7 месяцев назад

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 лет назад

existsexpr.test

When using the OR-optimization on a loop created by exists-to-join, do the early-exit logic for the whole loop, not for each individual OR branch.

3 месяца назад

existsexpr2.test

Add tests for the change on this branch.

2 года назад

existsfault.test

Add extra tests for the changes on this branch.

2 года назад

Fix a logic error introduced by [cea8bf79e18d55a8] which caused "0 OR 2" to be evaluated as "2" instead of as "1". Problem reported at [forum:/forumpost/d5f32040c5d50d2d|forum post d5f32040c].

9 месяцев назад

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 года назад

Improve the integrity-check error message when floating point index values are off by one or two ULPs. Change the name of the eiib1.test test module to expridx1.test.

5 месяцев назад

extension01.test

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

external_reader.test

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT was short-lived and has been discontinued for a long time.

8 месяцев назад

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 лет назад

Fix problems in test script fkey6.test.

год назад

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

7 лет назад

Properly fix temp triggers created as part of FK processing to their schemas. Otherwise they may become confused by similarly named child tables in other attached databases. Fix for forum post [forum:636bd0180a | 636bd0180a].

5 месяцев назад

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 лет назад

Add the test/fork-test.c test program.

2 года назад

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 лет назад

Enhancements to the fp-speed-N.c programs, suggested by Andreas Kupries.

4 месяца назад

Remove a harmless unused variable from the fp-speed-2.c benchmark.

4 месяца назад

New sqlite3_db_config(SQLITE_DBCONFIG_FP_DIGITS) that let's the application specify the number of significant digits that double→text conversions will attempt to preserve.

6 месяцев назад

Add a comment to test/fptest01.sql to remind us that failures in that script might not be the fault of SQLite.

4 месяца назад

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 лет назад

fts3atoken2.test

Add tests to check that SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER is working.

год назад

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 лет назад

Add test for fts3 compress= and uncompress= options.

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 года назад

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

Improved detection of corrupt freelist chains on btree pages. Plus, add assert()s to verify that the min-heap does not overflow inside of PRAGMA integrity_check.

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 cast in fts3_write so that it is applied as intended.

2 месяца назад

fts3corrupt7.test

Fix a buffer overwrite in fts3 that could occur while processing NEAR queries against corrupt records.

2 месяца назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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

8 лет назад

Fix the size of an allocation in fts3 to take into account that when merging a phrase doclist, each entry may grow by up to 1 byte if the rhs position of the merged lists is stored.

2 месяца назад

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 лет назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 года назад

Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This was previously disallowed by [9dbae1df75219e2a] as a performance optimization. It turns out that the constraint causes performance issues, and we do not have a record of any performance issue that it solves.

год назад

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

Add the SQLITE_PREPARE_FROM_DDL flag to sqlite3_prepare_v3(). Use this to prevent fts3/4 tables in non-trusted schemas from calling unsafe SQL functions.

8 месяцев назад

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

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 typo in fts3/4 debugging code allowing 'maxpendinXY' to act as a synonym for 'maxpending=' in special INSERT statements.

9 месяцев назад

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 unnecessary "www." prefixes on domain names in URLs.

год назад

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

2 года назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Fix a bug in concat_ws() in which an initial empty string was treated as if it was a NULL value.

10 месяцев назад

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

5 лет назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 лет назад

Give the fuzzcheck test program access to all the same extensions that dbsqlfuzz has access to.

5 месяцев назад

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 лет назад

Fix a problem in the sqlite_dbpage() table-valued function when it is trying to truncate a file in locking-mode=EXCLUSIVE and the file was obtained via sqlite3_deserialize(). Problem found by dbsqlfuzz.

год назад

Fixes for three separate AI-discovered bugs in non-deliverable extensions.

2 месяца назад

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

Try to prevent false positives in fuzzinvariants.c due to scalar subqueries.

7 месяцев назад

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

3 года назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Similar fix to the previous check-in, but this time for sqlite3_preupdate_new().

год назад

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 года назад

In the ieee754 extension, render -0.0 as 'ieee754(-1,-3071)' instead of 'ieee754(1,-3071)' as that makes the sign clearer. Both strings still convert back to -0.0. Note that negative zero and positive zero are distinct values in ieee754. [forum:/forumpost/1eab7e4a08|Forum post 1eab7e4a08].

год назад

Remove the data type ANY added to the shell's CSV imports.

2 месяца назад

CLI: The .imposter command matches the index name regardless of case. Minor fixes to .check.

8 месяцев назад

Improvements to imposter tables: (1) They are read-only unless writable-schema is enabled. (2) Because they are now read-only, the ".imposter" command in the CLI no longer requires the --unsafe-testing command-line option. (3) Imposter tables do not participate in a PRAGMA integrity_check and hence do not cause false-positive errors. However, you can still do an integrity_check on the the imposter table itself by naming the imposter table as the argument to integrity_check.

год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

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 лет назад

The reuse-subroutine optimization [c9a3498113074bbc] might have generated byte-code that loops forever. This check-in fixes the problem.

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 года назад

Adjustments to test/incrblob4.test so that it works on both Linux and Mac in spite of error message differences between those platforms. Minor change to termIsEquivalent() to provide 100% MC/DC.

год назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

год назад

indexexpr1.test

Fix to the interaction between indexes-on-expressions, subtypes, and the unary "+" operator.

18 дней назад

indexexpr2.test

Fix a NULL pointer dereference that can occur when misusing a extension virtual table that was created for testing purposes.

2 месяца назад

indexexpr3.test

Experimental change to explain query plan to identify covering indexes on expressions.

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Enable an ORDER BY clause to refer to columns in outer queries.

8 месяцев назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Fix the parse_create_index() SQL function created by the incremental integrity_check extension so that it works for widely correct CREATE INDEX statements. Also fix the extension so that it removes the parse_create_index() function. Add the sqlite3_intck_register() API function so that the parse_create_index() function can be more easily tested.

месяц назад

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

Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand().

4 месяца назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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

4 года назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

Enhance the omit-noop-join optimization so that it is able to omit a chain of noop-joins. Optimization improvement suggested by [forum:/forumpost/11a53f2bad|forum post 11a53f2bad].

8 месяцев назад

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 год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Detect some cases of ambiguous column references in USING clauses that can come up with nested joins.

9 месяцев назад

When two tables are joined by USING, the affinity and collating sequence of the join column will be the same as one or the other of the columns in the two tables (which are hopefully the same).

3 месяца назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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

10 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

The jsonSkipLabel() routine, part of json_each() and json_next(), should never return an index outside of the range of bytes of the input JSONB.

месяц назад

Avoid unsigned integer overflow when evaluating an array index in a JSON path expression. [forum:/forumpost/2026-01-27T14:18:49z|Forum post 2026-01-27T14:18:49z].

6 месяцев назад

Fix the jsonb_group_array() and jsonb_group_object() functions so that they return JSONB as they should, and not text JSON, when the array or object is empty. [forum:/forumpost/2026-01-25T00:47:06z|Forum post 2026-01-25T00:47:06z].

7 месяцев назад

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

3 года назад

Avoid unsigned integer overflow when evaluating an array index in a JSON path expression. [forum:/forumpost/2026-01-27T14:18:49z|Forum post 2026-01-27T14:18:49z].

6 месяцев назад

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 года назад

Raise an error if any PATH argument to json_array_insert() is not the path of an array element. Add some test cases for json_array_insert().

7 месяцев назад

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 года назад

Fix possible 1-byte OOB read when decoding a malformed FLOAT5 element in JSONB.

месяц назад

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 года назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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

5 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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

13 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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

Fix a test script problem causing errors with Tcl 9.

год назад

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

8 лет назад

Omit the antiquated and long-unsupport async extension since it has been superseded by WAL mode for over a decade.

2 года назад

make-where7.tcl

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

17 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

Fix a crash that could occur if sqlite3_deserialize() was used to overwrite a database with an open transaction on it. Bug introduced by [fc42d31d6fca21ab] on 2018-03-07 and first released in version 3.23.0. This is not a vulnerability as an attacker that can exploit this already has the ability to execute arbitrary code. Forum post [forum:39134ba029 | 39134ba029].

3 месяца назад

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 года назад

Omit the antiquated and long-unsupport async extension since it has been superseded by WAL mode for over a decade.

2 года назад

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 года назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Add the SQLITE_LIMIT_PARSER_DEPTH value for sqlite3_limit(). This isn't something that many applications will need, but it is useful for testing.

9 месяцев назад

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

19 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW.

2 года назад

Have sqlite3_set_errmsg() return SQLITE_MISUSE if a NULL db handle is passed to it, as documented.

9 месяцев назад

When rolling back a journal that contains a super-journal pointer, only attempt to unlink the super-journal if (a) the filename looks like one that SQLite might have generated, and (b) the super-journal contains the name of the journal being rolled back. This is to limit the extent to which SQLite can be caused to delete arbitrary files by supplying it with a crafted hot-journal.

2 месяца назад

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

3 года назад

Cygwin-centric test script tweaks from Jan Nijtmans.

год назад

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 лет назад

Fix QRF so that it works sensibly with "--wrap 1"

3 месяца назад

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 лет назад

Rename SQLITE_ENABLE_MULTITHREADED_CHECKS to SQLITE_THREAD_MISUSE_WARNINGS. Run test cases with that option. Also add the SQLITE_THREAD_MISUSE_ABORT option.

6 месяцев назад

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 года назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

In the cost metrics of the query planner, the estimated number of output rows from an EXISTS-to-JOIN loop should not be more than 1. [forum:/forumpost/989880d0aa|Forum post 989880d0aa].

7 месяцев назад

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 лет назад

Fix problems with expressions like "(?,?,?) IN (SELECT c,b,a FROM ...)" when there is an index on columns "c", "b" and "a", but not in that order.

2 месяца назад

Fix problems with expressions like "(?,?,?) IN (SELECT c,b,a FROM ...)" when there is an index on columns "c", "b" and "a", but not in that order.

2 месяца назад

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 лет назад

Minor fixes. Tests are passing now.

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 лет назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Cygwin-centric test script tweaks from Jan Nijtmans.

год назад

Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test module to avoid false-positive infinite loop reports from OSS-Fuzz based on long and complex fuzzer-generated LIKE/GLOB patterns that are not actually infinite loops, but which do take a long time to resolve.

10 месяцев назад

Fix utility compilation issues with MSVC.

8 лет назад

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

11 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

pagerfault.test

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See [forum:/forumpost/f4878de3e7dd4764|forum thread f4878de3e7].

год назад

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 лет назад

Fix a crash that could be caused by configuring the pager-cache with a bulk allocation too small to fit even one page.

2 месяца назад

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

Use tail recursion on the larger of the two partitions when doing a quicksort as part of the implementation of the median() function, to avoid excess stack usage on pathological inputs.

2 месяца назад

permutations.test

Ensure that a hot journal is rolled back in the case where a process or system crash resulted in a corrupt super-journal record where the magic and length values are correct but the super-journal name and checksum fields are both zeroed. Frorum post [forum:/info/2026-07-20T18:27:00Z | 2026-07-20T18:27:00Z].

21 день назад

Allow a FROM clause in UPDATE statements.

6 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

Fix a memory error in test logic introduced by [8704034254938662].

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 лет назад

The prefix_length() function should stop at the first NUL terminator.

2 месяца назад

Fix a buffer overflow bug in a recent check-in, reported by unsolicted email from OpenAI/Codex.

4 месяца назад

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 лет назад

Ensure that the query flattener does not change an ON clause term to a WHERE clause term.

2 года назад

Fix HTML ">" quoting in QRF.

3 месяца назад

Further testing and bug fixing.

9 месяцев назад

Update test cases to work with the new box format and with --quote relaxed.

8 месяцев назад

New test case for bSplitColumn in QRF.

9 месяцев назад

New test cases for QRF

8 месяцев назад

Update test cases to work with the new box format and with --quote relaxed.

8 месяцев назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Fix test cases impacted by the use of ~/.sqliterc

9 месяцев назад

Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. [forum:/forumpost/2026-03-10T19:26:06z|Forum post 2026-03-10T19:26:06z].

5 месяцев назад

Update the regexp extension so that the "-" character may be escaped with a backslash. Forum post [forum:c5e7358f82 | c5e7358f82].

7 месяцев назад

Limit the complexity of a REGEXP pattern using SQLITE_LIMIT_LIKE_PATTERN_LENGTH

год назад

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

7 лет назад

reservebytes.test

Update test script reservebytes.test so that it works with the "prepare" permutation.

год назад

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

Avoid dropping RETURNING triggers when the schema is reset while preparing a statement.

9 месяцев назад

returningfault.test

Add an OOM test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement that uses an eponymous vtab.

9 месяцев назад

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 upward propagation of expression properties into row-value expressions.

3 месяца назад

Add test cases to rowvalue2.test.

10 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

Do a better job of not generating unnecessary Bloom filters associated with IN operators.

6 месяцев назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Correction to the bugfix at [212c68249cc0e890] so that it works for 2nd and subsequent terms of a row value.

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

Attempt to reduce divergence with the wal2 branch.

2 года назад

savepoint7.test

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 года назад

Immediately reset all pending prepared statements on any call to sqlite3_set_authorizer(), even if the authorizer is being disabled.

6 месяцев назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Fix another test case to work with union-by-merge.

7 месяцев назад

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 года назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Remove possibly stray output from various tests.

11 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

Fix CLI CSV test cases so that they suppress the CR on windows and thus work cross-platform. Test case changes only - no changes to code.

2 месяца назад

Improvements to the .import command of the CLI.

7 месяцев назад

Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. [forum:/forumpost/2026-03-10T19:26:06z|Forum post 2026-03-10T19:26:06z].

5 месяцев назад

Fix a bug in ".show". Adjust test cases for the new default mode.

9 месяцев назад

Enhance the ".timer" command in the CLI to accept the "once" argument, and so that it leaves its last real-time result in the $TIMER variable. Also fix a harmless warning from an earlier check-in.

6 месяцев назад

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 года назад

Adjust the changes to shell8.test from [5da9bf09cc00faf9] so that they work with older versions of TCL.

6 месяцев назад

Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. [forum:/forumpost/2026-03-10T19:26:06z|Forum post 2026-03-10T19:26:06z].

5 месяцев назад

Back out the --compat option from the CLI.

8 месяцев назад

Fix the parse_create_index() SQL function created by the incremental integrity_check extension so that it works for widely correct CREATE INDEX statements. Also fix the extension so that it removes the parse_create_index() function. Add the sqlite3_intck_register() API function so that the parse_create_index() function can be more easily tested.

месяц назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

Add an ORDER BY to a test case for skip-scan to make the output consistent.

год назад

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 лет назад

Update a few test scripts so that they run on windows.

год назад

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 лет назад

Fix the sort4.test module so that the first two test cases are omitted when SQLite has been compiled using SQLITE_MAX_WORKER_THREADS=0.

2 года назад

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 лет назад

Update speedtest.md to point out xdg-open on Linux.

7 месяцев назад

Fix a help text typo in speedtest1.tcl, pointed out off-list by BrickViking.

7 месяцев назад

In speedtest1, always use fatal_error() to exit fatally, instead of an fprintf/exit() pair, so that stdout/stderr get flushed consistently (which is significant for the WASM build).

год назад

Fix parsing of quoted instantiation arguments in the spellfix extension.

2 месяца назад

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

11 лет назад

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

10 лет назад

Limit the size of input strings to the (disused) spellfix extension to avoid excessive runtime and integer overflows.

3 месяца назад

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

3 года назад

sqllimits1.test

Fix a test case in sqllimits1.test so that it works with the Apple configuration which changes the default SQLITE_MAX_LENGTH.

2 года назад

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

11 лет назад

starschema1.test

Small size and complexity reduction on the star-query heuristic. Improved comments for the star-query heuristic.

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 лет назад

Extend the pedantic enforcement of type to VIRTUAL columns.

год назад

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 лет назад

Improved estimate on the number of output rows in a recursive common table expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries.

год назад

Fix a problem that could occur when a scalar subquery had both a DISTINCT and OFFSET clause. First reported by [forum:41bd7af485 | forum post 41bd7af485].

8 месяцев назад

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 лет назад

Fix false-negatives in the sqlite3ExprCanReturnSubtype() routine having to do with CASE, CAST, and COLLATE expressions and the "+" no-op operator.

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 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

Improvements to handling of inequality constraints on generate_series().value against very large floating-point values.

2 месяца назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

Various typo fixes reported by Daniel Dumitriu. No functional changes.

год назад

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

13 лет назад

New build product "tclsqlite-ex.c" is the tclsqlite.c file with QRF added. This is now used whereever tclsqlite.c was used. Hence QRF is now in the testfixture and in the tclextension. The sqlite3 method is "format". That method is currently just a non-functional stub.

9 месяцев назад

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 лет назад

temptrigfault.tes

Add further test cases for temp triggers to this branch.

9 месяцев назад

temptrigger.test

Add further test cases for temp triggers to this branch.

9 месяцев назад

When rolling back a journal that contains a super-journal pointer, only attempt to unlink the super-journal if (a) the filename looks like one that SQLite might have generated, and (b) the super-journal contains the name of the journal being rolled back. This is to limit the extent to which SQLite can be caused to delete arbitrary files by supplying it with a crafted hot-journal.

2 месяца назад

Add the test/testloadext.c loadable extension to test the ability to use the latest APIs using the loadable extension mechanism.

10 месяцев назад

Fix a 32-bit integer overflow in sqlite3changegroup_change_blob() that could lead to a buffer overwrite.

3 месяца назад

testrunner_data.tcl

When generating make.sh for testrunner, correctly quote the value of any options passed via environment variable OPTS.

4 месяца назад

testrunner_estwork.tcl

Add a new direct CLI testing script in test/modeA.clitest to demonstration that can be done. Rig this this to be run by test/shellB.test during normal testing.

9 месяцев назад

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-99378177930f87bd.test

Fix a missed optimization opportunity due to a typo in check-in [898bfa1afd8260ea]. Reported by [forum:/forumpost/2026-01-31T00:49:53z|forum post 2026-01-31T00:49:53z].

6 месяцев назад

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 лет назад

Minor fixes. Tests are passing now.

7 месяцев назад

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 лет назад

Cygwin-centric test script tweaks from Jan Nijtmans.

год назад

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 лет назад

Remove an assert() that is not true if a trace-callback is deregistered while there are active statements.

2 года назад

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

Disable transitive WHERE constraints when there are explicit COLLATE operators.

2 месяца назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Enhance SQLITE_LIMIT_TRIGGER_DEPTH so that it also limits a chain of distinct triggers during code generation.

2 месяца назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Fix a NULL pointer dereference that could occur in the unionvtab virtual table if the configuration SQL returned an SQL NULL value in place of a table name.

2 месяца назад

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 лет назад

Cygwin-centric test script tweaks from Jan Nijtmans.

год назад

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

5 лет назад

Various minor bug fixes cherrypicked from trunk.

4 месяца назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

Fix a problem sometimes causing an UPSERT to incorrectly convert an excluded.* column from type REAL to INT in cases where doing so does not cause data loss.

2 месяца назад

upsertfault.test

A few more tests for upsert.

8 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Add extra tests to check the result of including a %00 escape in a URI when ENABLE_URI_00_ERROR is defined.

10 лет назад

utf16align.test

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

5 лет назад

vacuum-into.test

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Fix VACUUM so that it works even when ATTACH_WRITE is disabled.

год назад

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 года назад

Omit explain_i calls from TCL test scripts.

5 месяцев назад

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 лет назад

Limit VIEW recursion depth to SQLITE_LIMIT_EXPR_DEPTH to prevent static overflow in malicious schemas with tens of thousands of levels of recursive views.

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 года назад

Bug fix in the vt02.c test virtual table.

8 месяцев назад

Fix the test/vt100-a.sql script to use .testcase and .check.

8 месяцев назад

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 лет назад

Fix vtabH.test so that it works on windows even if there are files that begin with "$" in the root directory.

год назад

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 лет назад

Back out minor changes not required by this branch.

2 года назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

Cygwin-centric test script tweaks from Jan Nijtmans.

год назад

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 лет назад

Attempt to reduce divergence with begin-concurrent.

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

walckptnoop.test

Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE.

8 месяцев назад

Update walcksum.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds.

год назад

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 лет назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

Cygwin-centric test script tweaks from Jan Nijtmans.

год назад

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 лет назад

walrestart.test

Uninstall faultsim at the end of the walrestart.test script.

5 месяцев назад

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

год назад

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 года назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle.

год назад

Fix test script errors in walsetlk3.test. Tests still don't all pass.

год назад

walsetlk_recover.test

Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows.

год назад

walsetlk_snapshot.test

Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows.

год назад

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 года назад

Update the test/walthread.test testing script so that it uses a random database name.

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 unnecessary "www." prefixes on domain names in URLs.

год назад

Do not attempt the OR-optimization on conjuncts that contain COLLATE operators.

3 месяца назад

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 лет назад

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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 лет назад

The optimization at [8bdda827a3d26800] is incorrect for the case where one of the two expressions has been commuted such that the collating sequence has changed. This check-in fixes the problem. Problem reported by [forum:/forumpost/2026-01-16T11:35:28Z|forum post 2026-01-16T11:35:28Z].

7 месяцев назад

Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity.

год назад

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 года назад

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

The win32lock and win32longpath tests don't work on Cygwin

год назад

win32longpath.test

Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT was short-lived and has been discontinued for a long time.

8 месяцев назад

win32nolock.test

Merge trunk. Some additional test-fixes for Cygwin

год назад

Improve performance of window function queries that use "BETWEEN :x FOLLOWING AND :y FOLLOWING" where :y is a very large number.

год назад

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 лет назад

Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

2 года назад

Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

2 года назад

Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

2 года назад

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 the window-function variant of the json_group_object() function so that it correctly handles NULL entries.

3 месяца назад

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 года назад

Have window functions sum(), total() and avg() correctly handle the obscure case where integer overflow occurs as part of the same step that adds the first real value to the running total. Fix for forum post [forum:ec538b04ce | ec538b04ce].

3 месяца назад

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 года назад

Fix a code-generator bug introduced by the UNION/INTERSECT/EXISTS optimization of check-in [132ba781b031972c] and reported in [forum:/forumpost/2026-03-04T05:06:26Z|forum post 2026-03-04T05:06:26Z].

5 месяцев назад

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 лет назад

Do not assume that a recursive CTE emits rows in ORDER BY order. Forum [forum:deb1eadf4d677bd5 | deb1eadf4d677bd5].

5 месяцев назад

Enhance a comment on a test case to add recent context.

2 года назад

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

11 лет назад

without_rowid1.test

Remove unnecessary "www." prefixes on domain names in URLs.

год назад

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

Avoid returning SQLITE_ERROR_RETRY if collation sequences associated with the table's PK cannot be found when creating an index. Possible fix for [forum:aa61ab56ad | forum post aa61ab56ad].

год назад

Add the --upsert option to the wordcount test program.

8 лет назад

writecrash.test

In Tcl, always use eq/ne for comparing strings, not ==/!=

год назад

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 лет назад

Fix a potential UAF bug in the zipfile extension.

2 месяца назад

Fix a possible 9-byte buffer overread in the zipfile extension hit when processing a corrupt zip file. Forum post [forum:/forumpost/721a05d2c5 | 721a05d2c5].

5 месяцев назад

zipfilefault.test

Fix a test case in zipfilefault.test so that it only runs if JSON1 is available.

8 лет назад