File Ages
Not logged in

Files in [38852f15] ordered by check-in time

Times are relative to the check-in time for [38852f15] which is 2013-01-17 17:20:49.

37.3 minutes src/sqliteInt.h
[593d67c8] Add the ability to disable transitive constraints using the sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS) interface. (user: drh, branch: transitive-constraints)
61.9 minutes test/transitive1.test
[56549f45] Avoid unnecessary collating sequence and affinity restrictions on the use of transitivity. Add test cases to show that the restrictions are not needed. (user: drh, branch: transitive-constraints)
2.3 hours test/autoindex1.test
[d9676284] Make more aggressive use of transitivity in optimizing queries. Add a test case. (user: drh, branch: transitive-constraints)
14.0 hours ext/rtree/rtree.c
[652233d6] Enhance RTree virtual table creation error messages that involve the getNodeSize() function. (user: mistachkin, branch: rtreeErrMsg)
14.0 hours Makefile.msc
[dd473cae] Make the 'fs' virtual table module portable to Windows. (user: mistachkin, branch: fsVfsWin)
20.8 hours src/pragma.c
[6195ebd8] Fix the activate_extensions pragma so that it is a no-op when the required argument is omitted. (user: drh, branch: trunk)
6.3 days main.mk
[7e6007a0] Add another test for the fts4 content= option. (user: dan, branch: trunk)
8.2 days test/orderby3.test
[7249bfc2] Fix the date on the new orderby3.test test case. (user: drh, branch: trunk)
9.2 days src/resolve.c
[cda79028] Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. (user: drh, branch: trunk)
12.0 days src/test_regexp.c
[7695b88f] More bug fixes to the test_regexp.c module. Bring test_regexp.c into alignment with the regexp.c file in the Fossil sources. (user: drh, branch: trunk)
12.8 days test/tkt3457.test
[e9ac5339] Remove superfluous text from a comment. (user: mistachkin, branch: trunk)
12.9 days src/os_unix.c
[6c4c2b7d] Do not use umask() since it change the umask for the entire process, not just the thread using SQLite. Make whatever permission changes are needed using fchmod() after the file is created, instead. (user: drh, branch: trunk)
14.0 days src/select.c
[20730bad] Further corner-case fixes to the name resolution logic. (user: drh, branch: name-resolution-fix)
14.0 days test/selectD.test
[afe96a11] Remove an incorrect assert() statement (ticket [beba9cae6345a]). Fix other minor problems in the name resolution logic. (user: drh, branch: name-resolution-fix)
14.7 days src/expr.c
[4cf5ed7e] Now supports result sets of the form "TABLE.*" with nested FROM clauses. (user: drh, branch: name-resolution-fix)
16.1 days test/pragma.test
[3076a890] Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. (user: drh, branch: trunk)
16.9 days src/shell.c
[a611c750] More test cases for the REGEXP operator. Fix minor bugs uncovered by these test cases. (user: drh, branch: trunk)
16.9 days Makefile.in
[46c8c01b] Add the test_regexp.c module containing a cross-platform implementation of the REGEXP operator. (user: drh, branch: trunk)
27.0 days src/backup.c
[ff6857b6] Ensure the database size field in the db header of a backup database is set correctly. Fix for [0cfd98ee201]. (user: dan, branch: trunk)
29.0 days test/tkt-a7b7803e.test
[0ae14217] A couple more test cases. (user: drh, branch: tkt-a7b7803e)
29.9 days src/parse.y
[7fecced4] Optimize the degenerate case of a FROM clause table name enclosed all by itself inside parentheses. Generate code as if the parentheses did not exist, rather than the old behavior of manifesting the parenthesized table into a transient table. Also, tag every FROM-clause SELECT subquery that is generated by a parenthesized FROM-clause expression using the SF_NestedFrom flag. The new SF_NestedFrom flag is not yet used for anything. (user: drh, branch: trunk)
30.1 days test/auth2.test
[9b67c633] Resolve names in FROM-clause subqueries prior to resolving names in the result set expressions of a SELECT statement. (user: drh, branch: trunk)
30.2 days src/journal.c
[8183d8d7] On atomic-write capable systems, if copying the contents of an in-memory journal to disk fails, close the (on disk) journal file before returning the error to the caller. This causes the subsequent rollback operation to use the in-memory journal. Fix for [df678d738adb]. (user: dan, branch: trunk)
30.8 days test/fkey5.test
[25411f83] Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. (user: drh, branch: foreign-key-check)
30.8 days test/fkey_malloc.test
[97f7f737] Add to the foreign_key_check pragma an extra output column "parent" that contains the name of the parent table for the constraint that failed. (user: drh, branch: foreign-key-check)
30.9 days src/fkey.c
[0f996352] Enhance the error message for "foreign key mismatch" to include the names of the child and parent tables. Begin adding test cases for PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check gets all necessary table locks. (user: drh, branch: foreign-key-check)
34.1 days test/vtab1.test
[6d507e4d] Merge in all the trunk changes that have occurred since this branch was opened. (user: drh, branch: vtab-IN-opt)
34.9 days VERSION
[8bcf5f51] Increase the version number to 3.7.16 in advance of adding new features for the next release. (user: drh, branch: trunk)
35.0 days test/minmax.test
[7280e14c] Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause. (user: dan, branch: minmax-opt)
36.1 days src/btree.c
[120c82d5] Allow the error message from "PRAGMA integrity_check" to be longer than 20,000 bytes. (user: drh, branch: trunk)
36.9 days test/e_insert.test
[81d9ee0f] Update requirements marks and test cases for multi-VALUE INSERT and to fix typos in requirements text. (user: drh, branch: trunk)
36.9 days src/sqlite.h.in
[e38adb60] Fix a typo in a comment that is used to generate documentation. No changes to code. (user: drh, branch: trunk)
37.8 days src/vdbe.c
[bd7aeeb6] When an arithmetic operation with two integer operands must give a floating-point answer due to overflow, make sure the answer is not rounded back to integer by affinity. (user: drh, branch: trunk)
38.3 days test/releasetest.tcl
[75e545a9] Modify releasetest.tcl so that it runs the "checksymbols" test on a build without SQLITE_DEBUG defined. If SQLITE_DEBUG is defined, the sqlite3WhereTrace variable causes the test to fail. (user: dan, branch: trunk)
39.8 days src/build.c
[8542e618] Refactor collating-sequence handling as a fix for ticket [71e333e7d2e642]. The Expr.pColl field is removed from the Expr object. The COLLATE operator now becomes a separate instance of Expr in the expression tree. The code generator looks up the correct collating function as needed, rather than referring to Expr.pColl. (user: drh, branch: trunk)
39.8 days src/vdbeaux.c
[cdbfa664] Adjustments to the collating-sequence refactoring to facilitate full-coverage testing and to fix some minor issues found by TH3. (user: drh, branch: ticket-71e333e7)
40.5 days src/insert.c
[1a9db8dc] Duplicating check constraint expressions prior to code generation is no longer required, and so it is removed. (user: drh, branch: ticket-71e333e7)
40.6 days test/distinct.test
[7b96115e] Veryquick passes all tests now. (user: drh, branch: ticket-71e333e7)
40.7 days test/tkt2822.test
[bd960d93] Improved error messages when column integers in an ORDER BY clause are out of range. (user: drh, branch: ticket-71e333e7)
40.9 days test/subquery2.test
[2d5f37c9] Ensure the VerifyCookie sub-routine has been run before the database is accessed in an obscure case. Fix for ticket [d6b36be38]. (user: dan, branch: trunk)
40.9 days test/collate1.test
[972443b4] Some errors in veryquick resolved. Many more to go. (user: drh, branch: ticket-71e333e7)
41.3 days test/malloc3.test
[df1827b1] Do not run test file malloc3.test as part of the inmemory_journal permutation. Explanation is in a comment at the top of malloc3.test. (user: dan, branch: trunk)
41.3 days ext/async/README.txt
[930ba852] Spelling and header fixes for the async extension. (user: mistachkin, branch: trunk)
41.8 days ext/async/sqlite3async.c
[c507ca4a] In the async VFS, treat the new error code SQLITE_IOERR_DELETE_NOENT as success for xDelete. (user: mistachkin, branch: trunk)
41.9 days src/trigger.c
[0c31a468] Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. (user: dan, branch: constant-refactoring-in-triggers)
41.9 days src/os_win.c
[1a63b1d5] Add the SQLITE_FCNTL_TEMPFILENAME file control that asks the underlying VFS to return a new temporary filename. Per request from NSS team at Mozilla. (user: drh, branch: trunk)
42.1 days test/shared9.test
[cc6e0785] Add a test case that demonstrates ticket [71e333e7d2e642]. (user: drh, branch: ticket-71e333e7)
42.7 days configure.ac
[e1feab98] Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command. (user: mistachkin, branch: noTclLibs)
42.9 days test/where.test
[5e961e37] Disable a couple of tests in where.test when running the "no_optimization" permutation. (user: dan, branch: trunk)
43.0 days test/thread001.test
[51cbddd5] Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. (user: dan, branch: trunk)
43.1 days test/shared_err.test
[40c14395] Fixes to a test case in shared_err.test. The fix is to prevent sqlite3_prepare() from being called when the test intends to test the response of sqlite3_step() to an OOM condition. (user: dan, branch: trunk)
43.1 days src/attach.c
[9f6c6885] Make sure memory is freed using a routine that is compatible with the routine used to allocate the memory. The SQLITE_MEMDEBUG compile-time option enforces this. (user: drh, branch: trunk)
43.2 days src/pager.c
[bdceca27] Since errors are ignored anyway, use sqlite3OsFileControlHint() instead of OsFileControl() to invoke the SQLITE_FCNTL_BUSY_HANDLER file-control. (user: dan, branch: trunk)
43.3 days test/backup4.test
[04ab2dc6] Update a couple of test scripts so that they work in auto-vacuum mode. (user: dan, branch: trunk)
44.3 days src/func.c
[12693deb] Fix a harmless compiler warning. (user: drh, branch: trunk)
44.7 days ext/fts3/fts3_write.c
[ffd1e514] Fix an uninitialized variable detected by valgrind. (user: drh, branch: trunk)
44.7 days src/test_malloc.c
[6d315578] Fix an out-of-order function declaration when compiled with MEMDEBUG. (user: mistachkin, branch: trunk)
44.7 days test/shell1.test
[41fd9dd2] Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (user: mistachkin, branch: tclMode)
51.1 days test/fts3conf.test
[e38fb02d] Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly by REPLACE queries. (user: dan, branch: trunk)
51.3 days src/main.c
[429c5b20] Fix problems in test_sqllog.c. Clarify the experimental SQLITE_CONFIG_SQLLOG interface. Handle at least the more likely error conditions in test_sqllog.c. (user: dan, branch: sqllog)
51.9 days src/global.c
[cd501bbc] Add an option to register global hooks used for logging all SQL executed by an application. (user: dan, branch: sqllog)
69.0 days test/orderby1.test
[94255634] Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (user: drh, branch: inner-loop-cost)
71.9 days src/status.c
[82eb7ead] Adjust the SQLITE_DBSTATUS_STMT_USED calculation to take the modified usage of sqlite3VdbeClearObject() into account. (user: mistachkin, branch: trunk)
71.9 days src/test_quota.c
[6b4979e8] In test_quota.c, provide a work-around for the missing _chsize_s() function in mingw. (user: drh, branch: trunk)
75.9 days test/aggnested.test
[62ebfa74] Adding test cases for ticket [bfbf38e5e9956a] (user: drh, branch: ticket-bfbf38e5e9)
79.7 days src/delete.c
[7af3acbb] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (user: drh, branch: subquery-as-coroutine)
80.1 days src/test_intarray.h
[cbd8fddf] Make the multiplexor and the IntArray extensions callable from C++. (user: drh, branch: trunk)
80.9 days tool/mkvsix.tcl
[99f27d64] Merge VSIX tooling and packaging enhancements to trunk. (user: mistachkin, branch: trunk)
82.9 days src/vdbesort.c
[e24ba5be] Fix a 32-bit integer overflow problem that could cause an error in a CREATE INDEX statement that writes more than 16GB of data. (user: dan, branch: trunk)
83.7 days src/vdbe.h
[f7c5abe8] Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. (user: drh, branch: deferred-close-order)
83.9 days ext/fts3/fts3.c
[33f4f981] Fix a bug in fts3 causing it to return SQLITE_NOMEM when NEAR, OR and some auxiliary functions were used together. Also a segfault in vtab.c that could follow an OOM condition. (user: dan, branch: trunk)
84.6 days test/instr.test
[49ccae96] Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. (user: drh, branch: instr)
85.7 days tool/win/sqlite.vsix
[5023a7ad] Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. (user: mistachkin, branch: vsixFlavor)
89.4 days tool/build-all-msvc.bat
[702ebc64] Modify VSIX build tools in support of an additional package flavor. (user: mistachkin, branch: vsixFlavor)
90.6 days ext/fts2/fts2_icu.c
[aaa2d9b0] Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. (user: drh, branch: trunk)
91.3 days src/hash.c
[51a6a797] More warning fixes. (user: mistachkin, branch: warnings)
91.9 days ext/fts3/fts3_snippet.c
[b5f5ba31] Add a comment to fts3_snippet.c. (user: dan, branch: trunk)
91.9 days ext/fts3/fts3_expr.c
[514505a8] Initialize variables used as outputs of custom tokenizer method calls in fts4. (user: dan, branch: trunk)
92.0 days test/crash7.test
[db9b1fa5] Add a test for the problem fixed by [bf44d73d3e]. (user: dan, branch: trunk)
94.0 days src/vacuum.c
[629a42d4] Hold the mutex on the shared-cache for the duration of a VACUUM operation. (user: dan, branch: trunk)
94.2 days src/wal.c
[8745530b] Fix a failing assert() in wal.c. (user: dan, branch: trunk)
95.9 days src/btree.h
[af5c9ee4] Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. (user: dan, branch: zero-byte-backup-fix)
96.3 days tool/showdb.c
[dce391fc] Allow the showdb tool to be compiled with MSVC. (user: mistachkin, branch: trunk)
99.1 days test/whereD.test
[1182b54a] Fix duplicate test name in whereD.test. (user: mistachkin, branch: trunk)
99.3 days tool/spaceanal.tcl
[6dc987d3] Add support for URI filenames in sqlite3_analyzer. (user: drh, branch: trunk)
99.3 days src/pager.h
[f7437153] Move a couple of WAL-related function declarations in sqliteInt.h and pager.h into "#ifndef SQLITE_OMIT_WAL" blocks. Otherwise, the amalgamation fails to build using some compilers with SQLITE_OMIT_WAL (static function declared but not defined). (user: dan, branch: trunk)
99.9 days src/lempar.c
[7b1a6e6c] Attempt to suppress warnings generated by Coverity. (user: drh, branch: trunk)
102.5 days test/trigger1.test
[50679889] Corrections to test names to eliminate duplicates and follow naming conventions. (user: mistachkin, branch: trunk)
104.1 days src/callback.c
[8ea67522] Consolidate all occurrences of the "no such collation sequence" error message into a single spot. (user: drh, branch: trunk)
104.9 days src/alter.c
[2b370dea] Shared-cache mode fixes for views and virtual tables. (user: dan, branch: shared-cache-fix)
106.2 days test/orderby2.test
[956e4d7f] 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. (user: drh, branch: trunk)
106.3 days test/tclsqlite.test
[c1f10a26] Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. (user: drh, branch: trunk)
106.7 days test/fuzzer1.test
[6744d9a3] Further attempts to optimize out unnecessary ORDER BY clauses. (user: drh, branch: qp-enhancements)
110.1 days test/bigfile.test
[d869edda] Disable the bigfile tests on Macs. (user: drh, branch: trunk)
110.1 days src/test_intarray.c
[fd74d3d9] Fix compiler warnings found on Lion. (user: drh, branch: trunk)
111.9 days test/e_select.test
[0d573320] More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. (user: drh, branch: qp-enhancements)
112.0 days test/collate5.test
[75cda864] Test cases and bug fixes applied to the ORDER BY optimization for joins. Some test cases fail, but except for the new orderby1.test failures, all failures appear to be issues with the tests, not with the core code. (user: drh, branch: qp-enhancements)
120.7 days src/prepare.c
[c5cee969] Silence harmless compiler warning seen with SQLITE_OMIT_DEPRECATED. (user: mistachkin, branch: trunk)
120.9 days test/in5.test
[5ded9b68] Enhance IN processing to allow efficient use of indices with numeric affinities. Add test cases for IN processing that would have spotted the error in the [2be661a48023f4] check-in. (user: drh, branch: trunk)
121.1 days tool/stack_usage.tcl
[030013ff] Add the stack_usage.tcl script for analyzing the output of objdump on the amalgamation and estimating the sizes of stack frames on each function. (user: drh, branch: trunk)
121.2 days tool/vdbe-compress.tcl
[e7db056a] Update the vdbe-compress.tcl script so that it accepts variable declarations inside of #ifdef...#endif. This enhancement is needed due to the change of check-in [39866c0ede5d6ef4]. (user: drh, branch: trunk)
121.9 days test/coveridxscan.test
[ccb8ecc3] Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. (user: drh, branch: fullscan-covering-index)
121.9 days src/utf.c
[8b962c94] Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight performance increase. (user: drh, branch: trunk)
123.9 days test/analyze6.test
[cfaa7bc1] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (user: drh, branch: fullscan-covering-index)
126.0 days test/backcompat.test
[0ebe7cc5] Fix WAL capability checking in one of the test files. (user: mistachkin, branch: trunk)
126.2 days src/ctime.c
[98b971fb] Add the RTREE_INT_ONLY configuration parameter to the compile-time options logic. (user: drh, branch: trunk)
126.6 days Makefile.vxworks
[c1a85570] Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. (user: mistachkin, branch: trunk)
131.9 days test/lock.test
[43e474d3] Correct two test names to make them unique. (user: mistachkin, branch: busy-timeout-pragma)
134.8 days src/vdbeapi.c
[39f763bf] Avoid repeating calls to the sqlite3_trace() callback when the same statement is evaluted multiple times by sqlite3_step() due to an SQLITE_SCHEMA reprepare. (user: drh, branch: trunk)
136.2 days src/test_spellfix.c
[ebb08d0b] Fix compiler warnings in test_spellfix1.c (user: drh, branch: trunk)
136.3 days src/sqlite3.rc
[e2f27d28] Add Win32 version resources to the applicable binaries built by the MSVC makefile. (user: mistachkin, branch: win32Resources)
139.1 days test/spellfix.test
[75361013] In the spellfix phonehash() function, add letter W into the same character class as V. (user: drh, branch: trunk)
142.1 days test/select6.test
[200a8135] Fix a case where SQLite was failing to detect a syntax error in queries like "SELECT ... FROM (<select-1> UNION ALL <select-2>)" when <select-1> and <select-2> return different numbers of result columns. (user: dan, branch: trunk)
145.3 days doc/lemon.html
[9b19b847] Fix all known instances of 'repeated the' style typos in comments. No changes to code. (user: mistachkin, branch: trunk)
145.9 days src/update.c
[a3e26038] Fix a problem to do with multi-or queries and automatic indexes. (user: dan, branch: multi-or-covering-index)
146.9 days src/walker.c
[00b1dc71] Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. (user: drh, branch: nested-agg)
150.0 days ext/fts3/fts3Int.h
[e799222f] Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (user: dan, branch: trunk)
150.0 days tool/checkSpacing.c
[be1faade] Change the checkSpacing utility program to ignore whitespace at end-of-line unless the --wseol option is used. (user: drh, branch: trunk)
150.1 days src/test_multiplex.c
[7653973a] Silence harmless compiler warnings in the test code. (user: drh, branch: trunk)
150.1 days src/mem1.c
[7edd10a9] Remove tab characters from source code files. Replace them with spaces. (user: drh, branch: trunk)
162.3 days test/securedel2.test
[1e6f5ea4] Change to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (user: dan, branch: trunk)
163.1 days test/walro.test
[26428b45] Do not run test script spellfix.test if SQLITE_OMIT_VIRTUAL_TABLE is defined. Fix walro.test so that it works if DEFAULT_AUTOVACUUM is defined. (user: dan, branch: trunk)
163.1 days test/walthread.test
[a192a718] Fix a bug in walthread.test causing intermittent failures. (user: dan, branch: trunk)
163.9 days src/analyze.c
[d045f8b2] When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. (user: dan, branch: sorter-coalesce-writes)
167.3 days src/os.h
[335e91e5] Correct comment about WinRT compiler define. No changes to code. (user: mistachkin, branch: trunk)
171.1 days src/bitvec.c
[305b6667] Replace a few sqlite3_malloc()+memset() sequences with calls to sqlite3MallocZero(). (user: dan, branch: trunk)
184.1 days test/wal3.test
[e4163596] Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. (user: dan, branch: trunk)
184.8 days src/test8.c
[f96d4e7b] Fix compiler warnings about unused code in spellfix. Fix the editDist3Core() routine to return the matchlen in characters instead of bytes. (user: drh, branch: spellfix-matchlen)
210.1 days test/loadext.test
[eebd594d] Remove more references to OS/2. (user: mistachkin, branch: trunk)
210.1 days test/atof1.test
[0f706acf] Disable the atof1.test module when compiling on MSVC. (user: drh, branch: floating-point-conversions)
210.2 days src/mutex.h
[ff828c67] Remove support for OS/2 from the source tree. (user: drh, branch: trunk)
212.4 days test/fts4unicode.test
[bfb2d473] Add tests to check that the "unicode61" and "icu" tokenizers both identify white-space codepoints outside the ASCII range. (user: dan, branch: trunk)
212.6 days test/func.test
[963eb24f] Fix an incorrect testcase for the round() function. All tests are passing now, including new real->text->real round-trip tests. (user: drh, branch: floating-point-conversions)
212.6 days src/printf.c
[fd7bd4a5] Round-trip conversions of real->text->real are now lossless on x64 with GCC. Untested on other platforms so far. Still a corner-case problem with round(). (user: drh, branch: floating-point-conversions)
212.6 days test/date.test
[8ecffca9] Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases. (user: drh, branch: floating-point-conversions)
212.7 days src/test_func.c
[699b792c] Improved rounding accuracy on text-to-float conversions. (user: drh, branch: trunk)
212.9 days test/fts3atoken.test
[892b7411] Fix a problem with identifying white-space characters outside of the ascii range in the ICU tokenizer. (user: dan, branch: trunk)
213.0 days src/mutex_w32.c
[21266c68] Allow the SQLITE_API macro to apply to the sqlite3_win32_sleep function. (user: mistachkin, branch: compiler-compat)
213.4 days ext/fts3/fts3_unicode2.c
[f970a3de] Fix a few compilation issues that can occur with certain compilers (e.g. GCC 2.95.3, MSVC). (user: mistachkin, branch: compiler-compat)
224.0 days test/shared.test
[7caca193] Fix a problem preventing a shared in-memory database from being attached to a read-only connection. (user: dan, branch: trunk)
224.1 days ext/fts3/fts3_unicode.c
[e56fb462] Add the "tokenchars=" and "separators=" options, for customizing the set of characters considered to be token separators, to the unicode61 tokenizer. (user: dan, branch: trunk)
224.4 days test/capi3.test
[506008f0] Fix a malloc/free mismatch in pager.c (sqlite3_free() called on a buffer allocated by sqlite3DbMalloc()). (user: dan, branch: trunk)
224.7 days tool/warnings-clang.sh
[31fe1985] Fix harmless Clang warnings. (user: drh, branch: trunk)
224.7 days test/quota2.test
[61360ca6] Merge the changes need to compile on WinRT into trunk. (user: drh, branch: trunk)
224.9 days ext/fts3/unicode/mkunicode.tcl
[790f76a5] Have the FTS unicode61 strip out diacritics when tokenizing text. This can be disabled by specifying the tokenizer option "remove_diacritics=0". (user: dan, branch: trunk)
226.1 days src/test_quota.h
[61669c95] Add sqlite3_quota_ferror() and sqlite3_quota_file_available() interfaces to test_quota.c. Change sqlite3_quota_fwrite() to use a const input buffer. (user: drh, branch: trunk)
229.0 days test/backup.test
[c4b86211] Revert sqlite3_close() to legacy behavior. Create a new sqlite3_close_v2() interface that exhibits the deferred-close behavior. This minimizes the chance of breakage in legacy apps. (user: drh, branch: deferred-close)
235.7 days src/test_btree.c
[595dfdbf] Have user interfaces report out the filename of in-memory databases as an empty string, as it always has. This simplifies the changes. (user: drh, branch: shared-cache-memdb)
236.0 days test/fts3fault2.test
[e71495a8] If SQLITE_DISABLE_FTS3_UNICODE is defined, do not build the "unicode61" tokenizer. (user: dan, branch: fts4-unicode)
236.1 days ext/fts3/README.tokenizers
[8f3e60aa] Change the name of the "unicode" tokenizer to "unicode61" to emphasize that the case folding and separator-character identification routines are based on unicode version 6.1. (user: dan, branch: fts4-unicode)
237.0 days ext/fts3/unicode/CaseFolding.txt
[0c13570e] Add an experimental tokenizer to fts4 - "unicode". This tokenizer works in the same way except that it understands unicode "simple case folding" and recognizes all characters not classified as "Letters" or "Numbers" by unicode as token separators. (user: dan, branch: fts4-unicode)
240.8 days test/fuzz-oss1.test
[5519cc5e] Increase the version number to Minor changes to test scripts. (user: drh, branch: trunk)
240.9 days test/subquery.test
[f3dd1faf] Candidate fix for the nested aggregate query problem of ticket [c2ad16f997ee9c8e]. (user: drh, branch: nested-agg)
241.0 days src/malloc.c
[3869aef6] Make sure lookaside memory allocations are unusable after they are freed. (user: drh, branch: trunk)
244.8 days test/wal.test
[224c65e4] Merge updates from trunk. (user: mistachkin, branch: winrt)
247.0 days test/shared8.test
[46f4eb54] When a connection disconnects from a shared-cache database, only delete the in-memory schema if there are no other connections. (user: dan, branch: shared-schema)
250.0 days test/schema5.test
[e536ac04] Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. (user: drh, branch: trunk)
250.5 days test/tkt-bdc6bbbb38.test
[f84d87bc] Before running each test script, make sure the FTS enhanced query syntax is disabled. (user: dan, branch: trunk)
251.1 days src/test_stat.c
[e68a3527] Fix a harmless compiler warning inside an assert() statement within test code. (user: drh, branch: trunk)
261.1 days test/io.test
[bfa61e78] Update a test in io.test to account for [05f98d4eec]. (user: dan, branch: trunk)
265.7 days test/select9.test
[a49e909c] Enhance the processing of ORDER BY clauses on compound queries to better match terms of the order by against expressions in the result set, in order to enable better query optimization. (user: drh, branch: trunk)
268.2 days test/shell2.test
[9fb7da69] Move the shell test scripts into the test/ subfolder so that they are run automatically by "make test". (user: drh, branch: trunk)
272.1 days test/tkt-2a5629202f.test
[9870e4c4] Fix for [2a5629202f]. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values. (user: dan, branch: trunk)
273.0 days ext/fts3/fts3_term.c
[3281972e] Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in tclsqlite.c and in the FTS4 module. (user: drh, branch: trunk)
273.0 days test/fts4merge3.test
[de3f7187] Fix a harmless compiler warning in tclsqlite.c for MSVC x64. Fix a test case associated with the FTS4 merge feature. (user: drh, branch: trunk)
274.3 days tool/mkkeywordhash.c
[6015200b] Fix a harmless compiler warning in the mkkeywordhash.c utility program. (user: drh, branch: trunk)
289.0 days ext/rtree/rtree6.test
[221fe4a8] Fix a typo in the rtree6.test script that prevented it from running. (user: drh, branch: trunk)
289.8 days ext/rtree/rtree1.test
[02b7640f] The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. (user: drh, branch: trunk)
292.0 days test/savepoint7.test
[d2bf0efa] Test cases for RELEASE and ROLLBACK TO of a nested savepoint while queries are pending. Ticket [27ca74af3c083] (user: drh, branch: trunk)
292.3 days src/vdbemem.c
[c9342ca5] Fix a bug in the EXPLAIN code for listing trigger programs that was causing an out-of-bounds read. (user: dan, branch: trunk)
292.6 days test/in.test
[f9a7e179] Do more aggressive optimization of the AND operator where one side or the other is always false. (user: drh, branch: trunk)
293.1 days src/test_wholenumber.c
[cb7a8504] Fix MSVC compiler warnings in test code. (user: drh, branch: trunk)
296.0 days ext/fts3/tool/fts3view.c
[e3107631] Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. (user: drh, branch: fts4-incr-merge)
296.1 days test/fts3_common.tcl
[5c447e22] Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables. (user: dan, branch: fts4-incr-merge)
299.6 days test/bc_common.tcl
[ed69434c] An attempt at automatic incremental merging for FTS4. (user: drh, branch: fts4-auto-incr-merge)
300.2 days test/trace2.test
[02a8e423] Fix another test case issue in trace2.test. (user: dan, branch: fts4-incr-merge)
300.3 days test/incrblob4.test
[82c3f2ba] When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. (user: dan, branch: fts4-incr-merge)
303.0 days test/fts4langid.test
[f61d5fb0] Merge trunk changes into the fts4-incr-merge branch. (user: drh, branch: fts4-incr-merge)
304.1 days ext/fts3/fts3_aux.c
[4fd68647] Suppress harmless compiler warnings on windows in FTS4 and RTREE. (user: drh, branch: trunk)
306.3 days test/ioerr2.test
[affaebde] Modify a test in ioerr2.test to account for the new SQLITE_ABORT_ROLLBACK extended error code. (user: dan, branch: trunk)
307.7 days ext/fts3/fts3_porter.c
[74eadeec] Fix harmless compiler warnings. (user: drh, branch: trunk)
308.9 days test/fts4merge2.test
[57047372] Add tests for incremental merge code. (user: dan, branch: fts4-incr-merge)
313.8 days test/where7.test
[0dc4cb93] Candidate fix for the optimizer problem described in ticket [b7c8682cc17f3] which can causes a LEFT JOIN to be changed into a INNER JOIN if there are OR terms in the WHERE clause. (user: drh, branch: trunk)
314.9 days test/uri.test
[88963c33] Merge test current directory value fix from trunk and fix uri tests. (user: mistachkin, branch: winrt)
314.9 days test/quota.test
[5eecdb44] Merge and manually resolve testing updates from trunk. (user: mistachkin, branch: winrt)
314.9 days test/crash5.test
[82bcd7ec] 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. (user: mistachkin, branch: trunk)
317.8 days test/misc1.test
[86c049a1] Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not). Avoid using the GetTempPath and GetFullPathName APIs on WinRT. Some tests still need adjustments. (user: mistachkin, branch: winrt)
319.9 days ext/fts3/fts3_tokenizer.h
[f8e9c445] Add the xLanguageid method to sqlite3_fts3_tokenizer versions 1 and greater. (user: dan, branch: fts4-languageid)
320.7 days test/select4.test
[4f34d707] Add a test case for ticket [3557ad65a076c]. (user: drh, branch: trunk)
324.2 days test/multiplex3.test
[c267893a] Fix a case where an error code was being overwritten in multiplexDelete(). (user: dan, branch: trunk)
328.1 days src/wal.h
[3130275c] Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. (user: drh, branch: trunk)
329.0 days test/select1.test
[c8c7846f] Fix an obscure bug that causes a crash when parsing certain invalid SQL statements. (user: drh, branch: trunk)
331.0 days test/fuzzerfault.test
[969095ca] Prevent the fuzzer from ever returning a string longer than 100 bytes. (user: dan, branch: trunk)
338.9 days test/journal3.test
[84b32460] On unix, ignore the umask when creating journal files. That way, journal files will have exactly the same permissions as the original database and any process that has permission to write to the database can also recover hot journals. (user: drh, branch: trunk)
339.0 days test/tkt-f777251dc7a.test
[549f4fd0] Add the new SQLITE_ABORT_ROLLBACK extended error code to be returned for statements that are cancelled due to a rollback. (user: drh, branch: nonblocking-rollback)
339.0 days test/savepoint.test
[9b66c79e] 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. (user: drh, branch: nonblocking-rollback)
339.3 days test/cache.test
[76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (user: dan, branch: trunk)
344.2 days config.h.in
[16a47112] Add an autoconf test for malloc.h and use the results of that test to conditionally #include the malloc.h header file. (user: drh, branch: trunk)
350.1 days src/pcache.h
[0bc594e8] Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. (user: drh, branch: trunk)
351.7 days test/alter.test
[0d78ebb8] Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. (user: drh, branch: trunk)
353.0 days src/test5.c
[c4cd38a0] Fix compiler warnings in the TCL test harness. (user: drh, branch: trunk)
358.0 days test/fts3prefix2.test
[c05c3fd2] Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. (user: dan, branch: trunk)
1.01 years test/backup2.test
[227cfe11] Fix backup2.test so that it passes on OpenBSD (which produces a slightly different error message in one case). (user: dan, branch: trunk)
1.01 years test/malloc5.test
[5afbcd49] Fix test case issues related to errors in file-controls and the PSOW flag. (user: dan, branch: trunk)
1.02 years test/shrink.test
[a298465c] Fix issues in test cases so that they work with DEFAULT_AUTOVACUUM defined. And with a small default cache-size. (user: dan, branch: trunk)
1.02 years test/corruptF.test
[7654ae71] Remove some assert() statements that can fail with corrupt databases. (user: dan, branch: trunk)
1.02 years src/os.c
[722735a4] Refactor sqlite3OsFileControlNoFail() into sqlite3FileControlHint(). (user: drh, branch: trunk)
1.03 years test/multiplex.test
[12386197] Make sure the multiplexor does not create unnecessary overflow files. (user: drh, branch: trunk)
1.04 years src/mutex.c
[e9d05cbb] Fix typos and comments and make minor changes to a few function names, as suggested by readership. (user: drh, branch: trunk)
1.04 years src/pcache.c
[17c30634] Make sure large negative arguments to PRAGMA cache_size do not cause 32-bit signed integer overflow. Also correct a requirements mark. (user: drh, branch: trunk)
1.05 years test/e_droptrigger.test
[1bb23a3b] Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (user: drh, branch: trunk)
1.05 years src/tokenize.c
[f945c41a] Update the text of requirements associated with sqlite3_pcache_methods2. Update requirements marks embedded in code. All of the above are comment changes only; there are no changes to code in this check-in. (user: drh, branch: trunk)
1.07 years test/journal2.test
[6191c5e4] Change the name ZERO_DAMAGE to the more descriptive POWERSAFE_OVERWRITE. The query parameter used to control this device characteristic is now "psow". (user: drh, branch: statvfs)
1.08 years test/superlock.test
[68684495] Modify test cases to account for the ZERO_DAMAGE change. (user: dan, branch: statvfs)
1.08 years test/incrvacuum2.test
[41891b23] Some fixes to the test suite so that it works with ZERO_DAMAGE set to true. Still lots more problems remain. (user: drh, branch: statvfs)
1.09 years test/walcrash3.test
[d7688042] Add tests to walcrash3.test. (user: dan, branch: trunk)
1.09 years test/walpersist.test
[49d21ce5] Add code for a test that was failing before the persistent-wal related changes of [09ccc4a1be]. (user: dan, branch: trunk)
1.10 years src/loadext.c
[ce55f250] When an sqlite3_auto_extension() function fails, report back its actual error code, not the generic SQLITE_ERROR. (user: drh, branch: nx-devkit)
1.10 years test/multiplex2.test
[ee1e0122] Change the multiplexor VFS so that xTruncate is a no-op on database files. (user: dan, branch: trunk)
1.11 years test/selectB.test
[5061d85f] Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery. (user: drh, branch: trunk)
1.13 years test/quota-glob.test
[fa718960] Documentation improvements and additional test cases. (user: drh, branch: quota-stdio)
1.15 years test/capi3d.test
[95cc4af6] Add the sqlite3_stmt_busy() interface. (user: drh, branch: trunk)
1.17 years test/attach.test
[93a94798] Add the sqlite3_db_filename() interface. (user: drh, branch: trunk)
1.17 years src/test_pcache.c
[457513f2] Merge the PCACHE2 changes into trunk. (user: drh, branch: trunk)
1.17 years test/whereC.test
[3b58f5f0] Where possible, take advantage of the rowid at the end of index records to optimize range constraints (<, >, <=, >=) on the rowid column. (user: dan, branch: trunk)
1.18 years src/test_init.c
[9f839ac0] Add a version number to the sqlite3_pcache_methods2 object. Other PCACHE2 documentation improvements. (user: drh, branch: experimental-pcache)
1.21 years test/insert4.test
[e3f368cd] Update the xfer optimization code so that the xfer optimization can be used with INTEGER PRIMARY KEY ON CONFLICT ... as long as the destination table is initially empty. Improvements to the comments on the xfer optimization. New test cases added. (user: drh, branch: trunk)
1.22 years ext/fts3/README.content
[13a9d085] Add new file ext/fts3/README.content, describing the experimental FTS4 content option. (user: dan, branch: trunk)
1.22 years test/fts3fault.test
[3f2d49c6] Update fts3fault.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347]. (user: dan, branch: trunk)
1.22 years src/sqlite3ext.h
[3ec20c30] Fix some code formatting in sqlite3Ext.h to avoid lines longer than 80 characters. (user: drh, branch: trunk)
1.22 years test/fts3drop.test
[3565fcf8] Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a]. (user: dan, branch: trunk)
1.23 years test/errmsg.test
[8f88cc4e] If an error occurs within sqlite3_step() on a statement prepared using sqlite3_prepare_v2(), transfer both the error code and error message to the database handle before sqlite3_step() returns (so that they are available via sqlite3_errcode() and sqlite3_errmsg(). Prior to this commit, only the error code was transfered. The error message was not available until after either sqlite3_reset() or sqlite3_finalize() had been called on the statement handle. (user: dan, branch: trunk)
1.24 years test/analyze3.test
[aed2bf7a] Purge lingering references to SQLITE_STAT2 from the code and test scripts. (user: drh, branch: trunk)
1.25 years test/fts3first.test
[df36ac94] Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables. (user: dan, branch: fts4-content)
1.25 years test/fts3d.test
[d65f6353] Fix the virtual table rename logic so that it works even if the database encoding is something other than UTF8. Ticket [8290242b2a9a81683] (user: drh, branch: trunk)
1.25 years test/where3.test
[551ce407] Improved handling of USING and NATURAL JOIN in 3-way and higher joins. Ticket [3338b3fa19ac4ab] (user: drh, branch: trunk)
1.25 years test/nan.test
[4becc47e] Avoid 32-bit integer overflow when evaluating the exponent of a floating point value during ascii to binary conversion. (user: drh, branch: trunk)
1.26 years test/tkt3793.test
[39408702] Added the tool/warnings-clang.sh script. Changes so that there are no warnings with either gcc or clang even including FTS4 and RTREE and both with and without SQLITE_THREADSAFE=0. (user: drh, branch: trunk)
1.27 years test/fts-9fd058691.test
[7e24645b] Handle updating the only row of an FTS table correctly. Fix for [9fd058691]. (user: dan, branch: trunk)
1.27 years test/tkt-fa7bf5ec.test
[e43da426] Make sure the query optimizer for aggregate queries knows that expressions (x='a') and (x='A') are different. Ticket [fa7bf5ec94801e7e] (user: drh, branch: trunk)
1.27 years tool/symbols-mingw.sh
[c41d1d46] Adjust the symbols.sh script for STAT3. Add the symbols-mingw.sh script for testing on windows with MinGW. (user: drh, branch: trunk)
1.27 years src/date.c
[c96651dd] The date/time functions return NULL if the xCurrentTime or xCurrentTimeInt64 VFS methods fail. Ticket [0b803bff856c644c] (user: drh, branch: trunk)
1.27 years test/printf.test
[1f843fb3] Remove all precision and width limits from formatting fields in the sqlite3_mprintf() family of functions. Malloc for space as necessary. The prevents a stack overflow on very large numbers using %f. (user: drh, branch: trunk)
1.28 years test/corrupt3.test
[2ab14a84] Add the SQLITE_DIRECT_OVERFLOW_READ compile time option. (user: dan, branch: trunk)
1.28 years test/table.test
[589f3f56] Change the ANALYZE command so that it no longer tried to delete unused sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. (user: drh, branch: trunk)
1.29 years test/fts3ao.test
[0f439944] Improve test coverage of fts3.c. (user: dan, branch: fts4-content)
1.30 years test/tkt-c48d99d690.test
[9ddfe1e4] Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (user: dan, branch: trunk)
1.32 years test/misc3.test
[87946c62] Fix misc3.test so that it works with OMIT_MERGE_SORT builds. (user: dan, branch: trunk)
1.32 years test/attach4.test
[a38668dc] Fix some test files so that they work with SQLITE_OMIT_WAL builds. (user: dan, branch: trunk)
1.32 years test/pcache2.test
[4eb46898] Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. (user: dan, branch: trunk)
1.34 years src/vdbeblob.c
[7f00552b] Add the new OP_Once opcode. Use it to clean up and simplify various one-time initialization sections in the code, including the fix for ticket [002caede898ae]. (user: drh, branch: tkt-002caede898)
1.38 years test/index4.test
[7769fb98] Instead of a temporary b-tree, use a linked-list and merge-sort to sort records in main memory in vdbesort.c. (user: dan, branch: merge-sort)
1.38 years src/os_common.h
[64898485] The server1.test script should only run if mutexes are functional. Fix to the #ifdef change of check-in [9e6a4c1473]. (user: drh, branch: trunk)
1.38 years tool/tostr.awk
[df550066] Backslash escaping is not working right in tostr.awk on the latest ubuntu. The easiest fix is to simply not use any backslashes in the spaceanal.tcl script. (user: drh, branch: trunk)
1.39 years test/thread002.test
[20ddfb47] Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time option. (user: drh, branch: trunk)
1.39 years mkopcodec.awk
[f1bd5bba] Change the build process so that it does not require the unix "sort" command. This avoids confusion between ms-sort and mingw-sort on windows systems. (user: drh, branch: trunk)
1.40 years tool/warnings.sh
[63f2c785] Merge the stat3-enhancement branch with trunk, but keep the resulting merge in a separate branch for now. (user: drh, branch: stat3-trunk)
1.40 years test/win32lock.test
[5ed7633d] In the MSVC makefile, allow symbols to be enabled without NDEBUG defined. Also, for the win32lock test, make sure the database is closed prior to shutdown. (user: mistachkin, branch: winNativeHeap)
1.41 years test/walbak.test
[35e6ac18] When copying a rollback mode database over a WAL database using the backup API, leave the destination database in WAL mode (instead of switching it to rollback mode). Fix for [af95b8c609]. (user: dan, branch: trunk)
1.41 years test/tkt-b1d3a2e531.test
[3f3acee4] Fix for [b1d3a2e531]. (user: dan, branch: trunk)
1.42 years src/test_syscall.c
[21452f3a] When retrying a write() after an EINTR error on unix, be sure to also rerun the previous lseek(). Ticket [e59bdf6116036a] (user: drh, branch: trunk)
1.43 years test/analyze8.test
[2c83ac89] Add the analyze8.test test module for sqlite_stat3. (user: drh, branch: stat3-enhancement)
1.43 years test/analyze.test
[89b2f708] Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. (user: drh, branch: stat3-enhancement)
1.44 years test/indexfault.test
[4ced2394] Add the SQLITE_OMIT_MERGE_SORT pre-processor directive. To omit the code in vdbesort.c. (user: dan, branch: experimental)
1.44 years tool/extract.c
[dfa22ed4] Add command-line utilities "offsets.c" and "extract.c" for use in low-level analyzsis of database files. (user: drh, branch: trunk)
1.46 years test/tkt-d635236375.test
[a2135ad1] Update the OP_Move opcode to shift the pScopyFrom pointer of aliases when compiled with SQLITE_DEBUG. Ticket [d63523637517386191]. (user: drh, branch: trunk)
1.46 years test/malloc_common.tcl
[cd20b4ef] Replace the missed 'file copy' in malloc_common.tcl with copy_file. (user: mistachkin, branch: winopen-retry-logic)
1.46 years test/vtabF.test
[a55f4ab9] Make sure IS NOT NULL constraints work on virtual tables. Fix for ticket [6c14288a473ceff]. (user: drh, branch: trunk)
1.46 years test/8_3_names.test
[9007586f] 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. (user: mistachkin, branch: winopen-retry-logic)
1.52 years test/wal6.test
[89f1848d] Update the anti-virus retry logic for DeleteFile(). Invoke sqlite3_log() for each anti-virus retry. Make the retry delay configurable at compile-time. (user: drh, branch: av-defense)
1.53 years test/tkt-54844eea3f.test
[9f14fa56] Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries. (user: dan, branch: trunk)
1.54 years src/mem3.c
[a68b6580] Add a target to main.mk that will fail if the amalgamation contains any exported symbols that do not begin with "sqlite3_". Run this target from within releasetest.tcl. Add "static" to a couple of private functions in mem3.c. (user: dan, branch: trunk)
1.54 years test/func3.test
[6c51bad0] Adjust a couple of test scripts so that they work with OMIT_UTF16 builds. (user: dan, branch: trunk)
1.56 years ext/fts3/fts3_hash.c
[29e69f38] Changes to allow FTS to be compiled as a loadable module again. (user: dan, branch: trunk)
1.56 years test/all.test
[d9f7993b] Add a case to permutations.test to run the veryquick test suite using sqlite3_prepare() instead of sqlite3_prepare_v2(). This helps to test the fix for bug [25ee812710]. (user: dan, branch: trunk)
1.57 years test/incrblob_err.test
[afbe9023] Fix a Windows line ending issue in a test case that was causing an incrblob test to fail. (user: shaneh, branch: trunk)
1.57 years test/tkt-91e2e8ba6f.test
[c271f7e8] Add a test for ticket [91e2e8ba6f]. No changes to code. (user: dan, branch: trunk)
1.58 years test/types3.test
[6e1f4df5] Change a test case in types3.test slightly so that it works with the latest versions of Tcl. (user: dan, branch: trunk)
1.58 years test/tkt-bd484a090c.test
[0e82175f] Change the error message returned when localtime_r() fails to "local time unavailable". Ticket [bd484a090c8077] (user: dan, branch: trunk)
1.59 years tool/mksqlite3h.tcl
[a4adc7f7] Force almagamation gen scripts to use unix line endings for consistency across platforms. (user: shaneh, branch: trunk)
1.59 years test/wal7.test
[177e2d72] Further tweaks to the wal7.test test case. (user: drh, branch: trunk)
1.61 years test/fkey3.test
[2b3d9996] When updating a field that requires foreign key constraints be checked, ensure that the indexes and tables are consistent when the FK logic is run. Otherwise, it may detect the inconsistency and report database corruption. (user: dan, branch: trunk)
1.61 years test/fts3rnd.test
[4e8dd19e] Fix problems to do with using both OR and NEAR operators in a single expression. (user: dan, branch: fts3-prefix-search)
1.66 years src/test_demovfs.c
[a65d043a] Minor cleanups to the header comments on various test_*.c file, to make the suitable for programmer-level documentation. (user: drh, branch: trunk)
1.67 years test/fts3corrupt.test
[8844e8bf] Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent. (user: dan, branch: trunk)
1.69 years test/lock_common.tcl
[bb59f986] Add experimental support for read-only connections to WAL databases. (user: dan, branch: wal-readonly)
1.71 years test/cast.test
[1586244b] Changes to various test scripts so that they pass on windows. (user: dan, branch: win32-test-fixes)
1.73 years test/fts3aux1.test
[6d2633a6] Add support for on conflict clauses to fts3/fts4. (user: dan, branch: vtab-conflict)
1.74 years tool/getlock.c
[0ab24b13] Add the "getlock" utility for determining if a database file (on unix) is currently locked. (user: drh, branch: trunk)
1.78 years tool/rollback-test.c
[a65a7a59] Add a simple test program to aid in verifying that journals are cross-platform. (user: drh, branch: trunk)
1.78 years test/thread1.test
[532ae32e] Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined. (user: dan, branch: trunk)
1.78 years test/thread_common.tcl
[e4e99606] Do not run multi-threaded Tcl tests if the library was built with SQLITE_MUTEX_NOOP defined. (user: dan, branch: trunk)
1.79 years src/btmutex.c
[614de91a] Fix a performance regression: Keep two btree masks in each prepared statement; one for btrees used and another for btrees that require locks. Only try to lock the btrees identified by the second mask. (user: drh, branch: trunk)
1.79 years src/test_server.c
[2039ed95] Changes to support building with various SQLITE_OMIT_XXX options defined. (user: dan, branch: trunk)
1.79 years src/sqliteLimit.h
[b7296fd3] Update a comment in sqliteLimit.h. No changes to code or tests. (user: dan, branch: trunk)
1.79 years ext/icu/icu.c
[3eeb0ff7] Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. (user: drh, branch: trunk)
1.79 years src/test7.c
[78b6eee2] Changes for consistent use of SQLITE_OS_UNIX and removal of legacy OS_UNIX from testfixture source; (user: shaneh, branch: trunk)
1.80 years test/memdb.test
[20afd81a] Do not attempt to run tests that use the 'wholenumber' virtual table if the build does not support virtual tables. (user: dan, branch: trunk)
1.80 years test/pagerfault3.test
[139bc565] Fix additional test cases so that they work with DEFAULT_AUTOVACUUM. (user: dan, branch: trunk)
1.80 years tool/split-sqlite3c.tcl
[5d34e64d] Add a script that will break the amalgamation source file up into 4 or 5 smaller source files, each 32K lines or fewer, and a single "sqlite3-all.c" source file that #includes the others. (user: drh, branch: trunk)
1.80 years test/sysfault.test
[ff6dfe6e] In os_unix.c, do not return SQLITE_BUSY to SQLite following an error in fcntl(F_UNLCK), regardless of the value of errno. (user: dan, branch: trunk)
1.80 years test/badutf2.test
[8088031b] Fix some problems in os_unix.c when compiled with ENABLE_LOCKING_STYLE on OSX. Also some minor issues with test scripts. (user: dan, branch: trunk)
1.82 years test/tableapi.test
[69fe0c87] Fix problem with tableapi.test on Windows. (user: shaneh, branch: trunk)
1.84 years test/tkt-f7b4edec.test
[eedbcf0a] Add a test case to verify that ticket [f7b4edece25c994857] is fixed. (user: drh, branch: trunk)
1.86 years test/mem5.test
[d7dae06f] Fix issue with mem5 allocator when min request size is larger thatn 2^30. (user: shaneh, branch: trunk)
1.86 years test/index.test
[f000c9b2] Omit unnecessary OP_Next and OP_Prev operators when uniqueness constraints guarantee that the code will only make one pass through the loop. (user: drh, branch: trunk)
1.93 years test/capi3e.test
[b04304b9] Skip some tests in capi3e.test when compiled with SQLITE_OMIT_UTF16. (user: shaneh, branch: trunk)
1.93 years test/tkt-752e1646fc.test
[55973999] Skip flattening if subquery has LIMIT and outer query is DISTINCT. Fix for ticket [752e1646fc]. (user: shaneh, branch: trunk)
1.94 years test/tkt3824.test
[d78949fc] Allow an index paired with an IS NULL constraint to be used for sorting under the condition that the index be treated as a non-unique index. (user: drh, branch: trunk)
1.95 years test/fts3comp1.test
[3996f92a] Change fts4aux to (additionally) report on term frequency in individual columns of an fts table. (user: dan, branch: trunk)
1.95 years test/fkey4.test
[2f94d462] If a deferred foreign key constraint fails on a statement that is not part of a larger transation, make sure that the statement fully ends so that subsequent invocations of the same statement will not pass the constraint because they think the transaction is not closed. This is a merge of the deferred-fk-quirk branch together with a test case. (user: drh, branch: trunk)
1.97 years test/indexedby.test
[4847c6cb] 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. (user: drh, branch: stat2-enhancement)
1.98 years test/mutex1.test
[c86e46f4] Update test file mutex1.test to account for [e3b500fb5d]. (user: dan, branch: trunk)
1.98 years src/test_mutex.c
[456bd5c6] Update mutex1.test so that it works with the memsubsys1 permutation (pagecache memory). Change a few instances of SQLITE_MUTEX_STATIC_LRU2 in comments and test code to STATIC_PMEM. (user: dan, branch: trunk)
2.00 years test/pcache.test
[2dc98d29] Get all test cases working with the mutex-free-pcache implementation. (user: drh, branch: mutex-free-pcache)
2.00 years test/capi2.test
[053ce76d] Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes the sqlite3_step() routine to return SQLITE_MISUSE if it is called after it has previously returned anything other than SQLITE_ROW, SQLITE_BUSY, or SQLITE_LOCKED. (user: drh, branch: trunk)
2.02 years test/pager2.test
[b3f2f465] Add the SQLITE_FCNTL_SYNC file-control. (user: dan, branch: trunk)
2.04 years test/analyze4.test
[a5867cfc] Fix the ANALYZE command so that it takes collating sequences into account when gathering index statistics. (user: drh, branch: trunk)
2.08 years test/lookaside.test
[b0888047] Add test cases for the new lookaside hit and miss status outputs. Add the output of lookaside hit and miss to the command-line shell statistics. (user: drh, branch: trunk)
2.12 years src/test_superlock.c
[fe441df9] Work around restriction in Windows file locking. (user: shaneh, branch: trunk)
2.12 years test/incrblob3.test
[476a8b49] Have sqlite3_blob_bytes() return 0 following a failed call to sqlite3_reopen_blob(). (user: dan, branch: trunk)
2.13 years test/e_resolve.test
[6858df9c] Add test file e_resolve.test. (user: dan, branch: trunk)
2.14 years test/fts3aa.test
[d23ef9b8] Add new test file e_droptrigger.test. (user: dan, branch: trunk)
2.15 years test/fts3query.test
[9cf0f2b7] Experimental changes to fts3 function matchinfo(). (user: dan, branch: fts3-experimental)
2.17 years test/threadtest3.c
[648dd157] Add file test/tt3_checkpoint.c that adds a multi-threaded test for blocking checkpoints to threadtest3. (user: dan, branch: blocking-checkpoint)
2.17 years test/wal_common.tcl
[7e3fc2c8] Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. (user: dan, branch: blocking-checkpoint)
2.18 years test/tkt3442.test
[6611b76b] Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (user: dan, branch: experimental)
2.21 years art/sqlite370.ico
[62c494f6] Fix icon size so it's really 32x32. (user: shaneh, branch: experimental)
2.22 years test/fts3corrupt2.test
[b7702905] Test cases and minor changes to make fts3 more robust in the face of a corrupt database. (user: dan, branch: trunk)
2.23 years test/incrblobfault.test
[97c6b261] Structural coverage tests for vdbeblob.c. Including experimental new API sqlite3_blob_reopen(). (user: dan, branch: experimental)
2.23 years test/fts3cov.test
[7a2f2864] More coverage tests for fts3.c. (user: dan, branch: experimental)
2.25 years ext/fts3/fts3speed.tcl
[d0a450ce] Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms. (user: dan, branch: experimental)
2.29 years test/lock6.test
[759c954f] Fix minor test suite problems causing errors on OSX. (user: dan, branch: trunk)
2.30 years tool/showjournal.c
[fa97d895] Updates to the showjournal.c utility in order to bring it up to version 3. (user: drh, branch: trunk)
2.30 years test/tkt-3998683a16.test
[ca154f97] Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. (user: drh, branch: experimental)
2.30 years test/tkt-8454a207b9.test
[ce6cc16e] Fix the handling of default values for ALTER TABLE ADD COLUMN columns so that is able to deal with negative numbers, including large negative numbers. Ticket [8454a207b9fd2243c4] (user: drh, branch: experimental)
2.31 years test/schema4.test
[655991ec] Fix some problems that can occur if a trigger has the same name as another database object. (user: dan, branch: trunk)
2.31 years test/tkt-b351d95f9.test
[57789cfe] Test case and fix for the specific failure of ticket [b351d95f9cd5ef17e9d9dbae]. (user: drh, branch: bug-b351d95f9c)
2.31 years test/misc4.test
[a7645d29] Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. (user: drh, branch: trunk)
2.32 years test/e_select2.test
[30801892] Add new file e_vacuum.test. Move part of e_select.test into e_select2.test. (user: dan, branch: experimental)
2.32 years ext/rtree/rtreeA.test
[fab3b383] Add tests to e_delete.test. (user: dan, branch: trunk)
2.33 years test/conflict.test
[ba8ca9c9] Changes to test scripts to work with SQLITE_TEMP_STORE=2. (user: dan, branch: trunk)
2.33 years test/tkt-313723c356.test
[4ea134a8] Add a test case to verify that bug [313723c356] has been fixed. (user: dan, branch: trunk)
2.34 years ext/fts2/fts2_porter.c
[ee52589c] Remove additional occurrences of <ctype.h> from FTS2. (user: drh, branch: trunk)
2.34 years test/fts3shared.test
[a207f744] Add new test file fts3shared.test to test the previous change. (user: dan, branch: trunk)
2.34 years src/memjournal.c
[9b272ed4] Fix a comment typo in memjournal.c (user: drh, branch: trunk)
2.37 years test/releasetest.mk
[e1d4a87e] Remove proprietary information from the releasetest.tcl script and add it to the public repository. (user: drh, branch: trunk)
2.38 years src/mem2.c
[53b0c03f] Add evidence mark comments to source code. Add additional information to the documentation of sqlite3_release_memory(). Fix a minor inefficiency in mem1.c that was discovered while writing requirements tests. (user: drh, branch: trunk)
2.39 years ext/rtree/rtree3.test
[b06f4695] Add tests (and associated fixes) to restore coverage of rtree.c. (user: dan, branch: trunk)
2.39 years test/types.test
[0900e353] Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. (user: drh, branch: trunk)
2.40 years ext/rtree/rtree2.test
[1975a27c] Fix a couple of memory leaks in r-tree that can occur following an OOM condition. (user: dan, branch: trunk)
2.40 years test/walshared.test
[d1ed743b] Changes to support building with SQLITE_OMIT_WAL. (user: shaneh, branch: trunk)
2.41 years test/tkt-5e10420e8d.test
[255f1eef] Fix for ticket [5e10420e8d]. (user: dan, branch: trunk)
2.42 years test/ioerr5.test
[56cc883d] Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. (user: dan, branch: trunk)
2.45 years test/pager3.test
[6217b607] Fix a bug to do with deleting the journal file when exiting exclusive-locking mode. (user: dan, branch: experimental)
2.47 years test/icu.test
[451d9657] Add tests to check that the ICU regexp() function can only be called with exactly two arguments. (user: dan, branch: trunk)
2.47 years ext/icu/README.txt
[d37443d3] Updates to the README.txt file for ICU. (user: drh, branch: trunk)
2.48 years Makefile.arm-wince-mingw32ce-gcc
[8118de2a] Update the makefiles to prefer TCL version 8.5 instead of 8.4. (user: drh, branch: trunk)
2.49 years src/notify.c
[ac1f37a6] Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). (user: drh, branch: malloc-enhancement)
2.50 years test/fts3.test
[d692434b] Re-introduce the prefix-search optimization of [feef1b15d6], which was lost in a reorganization of FTS3 code. (user: dan, branch: trunk)
2.51 years test/tkt-80e031a00f.test
[6851c517] Additional test cases and evidence marks for the empty RHS bug on the IN operator - ticket [80e031a00f45dca877] (user: drh, branch: trunk)
2.52 years src/test_devsym.c
[c2d27cf5] Change the name of the xShmClose VFS method to xShmUnmap, everywhere. (user: drh, branch: experimental)
2.52 years test/lock2.test
[05ac2548] Fix problems with running the async.test script. (user: dan, branch: trunk)
2.52 years src/test_async.c
[e6cd1545] Fix makefiles so that they build sqlite3_analyzer again. Tweaks to comments in test_stat.c. Fix tclsqlite.c to build the sqlite3_analyzer again. (user: drh, branch: trunk)
2.53 years test/backup_malloc.test
[aef26438] Fix test case numbering in backup_malloc.test and issue when running under Windows. (user: shaneh, branch: trunk)
2.53 years test/index3.test
[f553c8ed] Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a]. (user: dan, branch: trunk)
2.53 years tool/showwal.c
[0e4bd446] Add the write-ahead log viewer/debugger tool to the tools/ folder. (user: drh, branch: trunk)
2.53 years test/mallocI.test
[dd59cea6] Fix issue in mallocI test script where db handle not released. (user: shaneh, branch: trunk)
2.55 years test/pagerfault2.test
[50f2f7df] Further changes to test scripts so that the "inmemory_journal" permutation works. (user: dan, branch: trunk)
2.56 years test/schema3.test
[a85ae332] Remove debugging code from test script. (user: dan, branch: trunk)
2.57 years test/ctime.test
[c6db3b30] Modify ctime.test to work with SQLITE_THREADSAFE=2. (user: dan, branch: trunk)
2.57 years test/walcrash2.test
[8d0f8a7f] 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. (user: dan, branch: trunk)
2.58 years test/async4.test
[85dd51a7] Some changes to test scripts related to codec enabled versions of sqlite. (user: dan, branch: trunk)
2.59 years test/tkt-fc62af4523.test
[7c3a86b9] Fix the tkt-fc62af4523.test to work around non-randomness of the randomblob() function when in testing mode. (user: drh, branch: trunk)
2.59 years test/quick.test
[6e43eed9] Add test file pager1.test, containing tests of inter-process locking in non-wal mode. (user: dan, branch: trunk)
2.59 years test/veryquick.test
[2c5e48a4] Changes to the way tcl test scripts work. No changes to production code. (user: dan, branch: experimental)
2.61 years art/sqlite370.eps
[af353bd8] Adding original art for the new SQLite logo. (user: drh, branch: trunk)
2.61 years test/tkt-f973c7ac31.test
[6eb058dd] Fix for ticket [f973c7ac31]. (user: dan, branch: trunk)
2.62 years test/avtrans.test
[7c33eb5a] Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file. (user: dan, branch: trunk)
2.62 years test/capi3b.test
[c2edf8e1] Refactor some of the global variables and commands used by tester.tcl. (user: dan, branch: trunk)
2.63 years test/rowhash.test
[28efe0a4] In the rowhash.test, make sure global variables are cleared prior to use. (user: drh, branch: trunk)
2.69 years doc/vfs-shm.txt
[2b00152c] Refactoring the VFS-SHM methods used by WAL. This version compiles and runs non-WAL test cases but crashes and burns on wal.test. (user: drh, branch: wal-refactor)
2.69 years test/tkt-26ff0c2d1e.test
[7838163d] Remove the OP_Variable optimization of check-in [48b77b04935d894] since it can lead to malfunctions as described in ticket [26ff0c82d1e90]. (user: drh, branch: trunk)
2.72 years test/where2.test
[946e06cd] Avoid assertion faults in queries using indices with redundant columns. Ticket [3dbdcdb14e7f41]. (user: drh, branch: trunk)
2.73 years test/savepoint2.test
[205e5d8a] Add the "wal" permutation to run existing test files savepoint.test and savepoint2.test in WAL mode. (user: dan, branch: wal)
2.76 years test/select2.test
[defaf0d9] Further refinements to table order selection on join query planning. (user: drh, branch: trunk)
2.82 years test/fts3ac.test
[d37034f7] Fix for [9861b74ab9]. Correctly handle strings with zero tokens in the fts3 offsets() function. (user: dan, branch: trunk)
2.83 years test/init.test
[ad68fa65] Disable the "init.test" test script when compiled with SQLITE_THREADSAFE=0. (user: drh, branch: trunk)
2.85 years test/fts3ag.test
[bea92586] Improved error message when the right-hand operand of MATCH in FTS3 is not a valid search expression. Ticket [170872f1c3]. (user: drh, branch: trunk)
2.87 years test/select7.test
[8858042f] Modify the vdbe so that the comparison operator opcodes do not modify the data type of operands. Fix for [aa92c76cd4]. (user: dan, branch: trunk)
2.90 years test/where6.test
[f0ae251a] 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] (user: drh, branch: trunk)
2.90 years test/schema.test
[a8c984c1] Fix an incorrect ALWAYS() macro in vdbeapi.c. Fix the output of a few test cases that changed due to better error propagation out of reprepare. (user: drh, branch: trunk)
2.90 years test/vtabA.test
[ff61e0fd] Fix an assertion fault that occurs when two different virtual tables are used in a single UPDATE statement. Ticket [d2f02d37f52b]. (user: drh, branch: trunk)
2.90 years src/legacy.c
[edea3bb7] Continuing improvements to error reporting and the sqlite3_log() routine. (user: drh, branch: trunk)
2.90 years src/complete.c
[7c4cca6d] Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging output for CORRUPT, and CANTOPEN errors. (user: drh, branch: trunk)
2.90 years test/vacuum4.test
[86d50ce5] Fix an assertion-fault/segfault problem that comes up when trying to VACUUM an auto-vacuumed database with a large schema. Ticket [da1151f97df244]. (user: drh, branch: trunk)
3.02 years test/whereA.test
[0209f171] Make sure internal queries are well ordered, even when the reverse_unordered_selects pragma is in effect. Ticket [eb942c64a157]. (user: drh, branch: trunk)
3.03 years tool/restore_jrnl.tcl
[08c545f0] Added option to restore_jrnl.tcl utility to hex dump journal pages. (user: shaneh, branch: trunk)
3.03 years test/fts3al.test
[8a208223] Change the fts3 snippet function to return (hopefully) more relevant snippets in less time. (user: dan, branch: trunk)
3.05 years test/fuzz2.test
[97f8a886] Minor changes to test scripts to support various SQLITE_OMIT options. (user: shaneh, branch: trunk)
3.09 years test/trace.test
[85e3c734] Fixed some TCL test cases to work if SQLITE_OMIT_TRIGGER is defined. (user: shaneh, branch: trunk)
3.11 years ext/fts3/fts3_hash.h
[48c0db0e] Changes to fts3 to avoid flushing data to disk within a SELECT statement. (user: dan, branch: trunk)
3.12 years test/fts3ad.test
[5030ba2e] Add extra tests for parsing of whitespace in tokenizer declarations,. (user: dan, branch: trunk)
3.13 years test/fts3b.test
[ef5b7450] Modify a test in fts3b.test to reflect the fact that the docid field may now be updated. (user: dan, branch: trunk)
3.15 years src/test_tclvar.c
[83dc7d38] Make sure registers computed for the VFilter opcode are marked invalid after the VFilter opcode finishes. Ticket [16fbf14cb2]. (user: drh, branch: trunk)
3.18 years mkopcodeh.awk
[3352b3eb] Simplify the OPFLG processing logic in the VDBE for a speed boost in the VDBE processing loop and a reduction in code size. (user: drh, branch: trunk)
3.18 years test/fts3ab.test
[30a92f11] Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.). (user: dan, branch: fts3-refactor)
3.18 years test/func2.test
[d7b3801d] Update comment for substrFunc(). Added additional SUBSTR() test cases. (user: shaneh, branch: trunk)
3.19 years test/coalesce.test
[d0591258] Additional test cases for the coalesce() and ifnull() functions. (user: drh, branch: trunk)
3.19 years test/intarray.test
[0c8db5d8] Additional intarray test cases and tweaks to comments. (user: drh, branch: trunk)
3.19 years ext/rtree/rtree_perf.tcl
[f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (user: drh, branch: trunk)
3.21 years tool/lempar.c
[27d8e684] Enhancements to lemon to generate more compact action tables and to avoid making array bounds tests that can never fail on action table calculations. (user: drh, branch: trunk)
3.25 years test/join.test
[6fe63711] When generating WHERE clause terms internally for NATURAL and USING joins, identify the table by its position in the FROM list, not by its name or alias. Fix for [b73fb0bd64]. (user: dan, branch: trunk)
3.28 years tool/genfkey.test
[273ccbf1] Fix a problem in the legacy genfkey code to do with column names that require quoting. (user: dan, branch: trunk)
3.31 years test/boundary4.tcl
[e4eb227b] Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (user: dan, branch: trunk)
3.32 years test/tkt-4a03edc4c8.test
[f0c56fa9] Make sure a transaction is available for rollback whenever a REDUCE conflict resolution occurs and there is the possibility to ABORT. Ticket [4a03edc4c8c] (user: drh, branch: trunk)
3.32 years addopcodes.awk
[98853f61] Generalize the IS and IS NOT operators so that their right-hand side can be an arbitrary expression and not simple the constant NULL. They work like = and <> except that NULL values compare equal to one another an unequal to everything else. (user: drh, branch: trunk)
3.33 years test/tkt3201.test
[fb6ceed3] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (user: dan, branch: trunk)
3.33 years test/fkey1.test
[d5d39981] Check in implementation of foreign key constraints. (user: dan, branch: trunk)
3.36 years README
[ba20091a] Update the README file to state that TCL is required in order to run the makefiles for SQLite. Ticket [7d96113ff]. (user: drh, branch: trunk)
3.36 years test/notnull.test
[135d656a] Add a test case to show that 29ab7be99f is fixed. (user: dan, branch: trunk)
3.38 years test/tkt-2ea2425d34.test
[f22e3887] Do not reuse function parameters in subsequent expressions since the function call might have triggered a text encoding change. Fix for ticket [2ea2425d34be]. (user: drh, branch: trunk)
3.38 years test/tkt3731.test
[e016cca3] Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (user: dan, branch: trunk)
3.39 years test/trigger9.test
[9eb91efd] Fixes for new triggers scheme. (user: dan, branch: trunk)
3.39 years test/trigger8.test
[9b9c1921] Changes to support recursive triggers. (user: dan, branch: trunk)
3.41 years test/tkt4018.test
[aa6acfa8] Fix a problem in os_unix.c where a malloc failure could lead to a leaked file descriptor. (user: dan, branch: trunk)
3.42 years test/lock7.test
[78dfe832] Add a test to verify that 3.6.17 releases read-locks obtained to read the database schema even if the connection is not currently in auto-commit mode. (user: dan, branch: trunk)
3.43 years test/whereB.test
[06098505] Tweak to the new whereB.test file to make it more consistent. (user: drh, branch: trunk)
3.43 years test/vtab6.test
[19f799b3] Changes to the query planner that improve the order in which tables/indexes are scanned in join queries. (user: dan, branch: trunk)
3.48 years test/tkt3997.test
[b2784cf5] When flattening a SELECT query, do not discard collation sequences explicitly attached to expressions in the parent query. Fix for #3997. (CVS 6949) (user: danielk1977, branch: trunk)
3.49 years test/bind.test
[7f3fc7f2] Changes to test code (only) to allow veryquick.test to run with OMIT_UTF16 builsd. Ticket #3985. (CVS 6919) (user: danielk1977, branch: trunk)
3.52 years test/zeroblob.test
[25dd3422] Make sure the IN operator works with zeroblobs. Ticket #3965. Other simplifications associated with structural testing. (CVS 6890) (user: drh, branch: trunk)
3.55 years test/sharedlock.test
[611e704f] When a b-tree transaction is committed when there are open cursors, downgrade shared-cache write-locks to read-locks instead of relinquishing all locks. Fix for #3942. (CVS 6837) (user: danielk1977, branch: trunk)
3.55 years test/tkt3935.test
[29b48972] Report an error if a USING or ON clause is specified following a from-list element that is not to the right of a join operator. Fix for #3846. (CVS 6832) (user: danielk1977, branch: trunk)
3.56 years test/incrblob2.test
[f17ef378] Cause incremental-blob read/write operations lock shared-cache tables in the same way as normal SQL read/writes. Add complex assert statements to make sure tehe correct shared-cache locks are held when accessing the database. Eliminate some redundant checks from btree.c. (CVS 6830) (user: danielk1977, branch: trunk)
3.59 years test/tkt3841.test
[3d7327fd] Fix a problem in vdbe.c that could cause a double-free of memory if the SQLITE_LIMIT_LENGTH is changed after a statement is prepared but before it is run. Also remove debugging statements from tkt3841.test. (CVS 6777) (user: drh, branch: trunk)
3.59 years test/tkt3918.test
[368e44ec] Fix for #3918. Also, fix the TRACE macros in balance_nonroot(). (CVS 6772) (user: danielk1977, branch: trunk)
3.60 years test/tkt3911.test
[bd341a10] Make sure nested queries with USING clauses do not leak memory. Preliminary fix for ticket #3911. (CVS 6750) (user: drh, branch: trunk)
3.61 years test/savepoint4.test
[ed1d4f47] Change savepoint4.test to limit database growth. Otherwise the test can take a very long time to run, depending on the prng. (CVS 6737) (user: danielk1977, branch: trunk)
3.62 years test/count.test
[1fef16ec] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (user: drh, branch: trunk)
3.63 years test/corrupt5.test
[453ff88f] Minor updates to comments in test scripts. (CVS 6714) (user: shane, branch: trunk)
3.63 years test/colname.test
[2472f6db] Add a test case for ticket #3893 and ticket #3894. (CVS 6705) (user: drh, branch: trunk)
3.65 years test/tkt3508.test
[4ac2bdfb] 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) (user: drh, branch: trunk)
3.65 years test/tkt1514.test
[7cb1c3ba] 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) (user: drh, branch: trunk)
3.71 years test/auth3.test
[694662f7] Work toward cleaning up the authorizer interface. Work is on-going. This is an incremental check-in. (CVS 6598) (user: drh, branch: trunk)
3.72 years test/unique.test
[8f3cac76] Simplifications to the uniqueness constraint failure error message generation code. (CVS 6595) (user: drh, branch: trunk)
3.73 years test/blob.test
[e8556542] Fix an out-of-order test number in blob.test. Cosmetic change. No changes to code. Ticket #3830. (CVS 6564) (user: drh, branch: trunk)
3.74 years test/insert3.test
[e71fb0fb] 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) (user: danielk1977, branch: trunk)
3.74 years test/alias.test
[dd4d67a6] Rework the column-cache mechanism to be more robust (and more correct). The column-alias cache is currently disabled, (CVS 6538) (user: drh, branch: trunk)
3.75 years test/make-where7.tcl
[f61e4cd9] Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) (user: danielk1977, branch: trunk)
3.76 years test/bindxfer.test
[c29b37ea] Check-in (6514) did not completely remove the obsolete test, resulting in a segfault. This check-in finishes the job. Ticket #3802. (CVS 6516) (user: drh, branch: trunk)
3.78 years test/speed1.test
[0c41f7cf] 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) (user: drh, branch: trunk)
3.78 years test/tkt3791.test
[8362d883] Do not attempt to walk a TokenOnly or SpanOnly expression tree node. Ticket #3791. (CVS 6469) (user: drh, branch: trunk)
3.78 years test/tkt2767.test
[277dace4] Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464) (user: danielk1977, branch: trunk)
3.80 years test/bitvec.test
[ca3aa3ba] Increase test coverage of bitvec.c slightly. Fix the line length on a comment in bitvec.c. (CVS 6432) (user: drh, branch: trunk)
3.80 years test/tkt3761.test
[8c1d0c6a] Make sure a ROLLBACK that follows an incremental vacuum works. Ticket #3761. (CVS 6416) (user: drh, branch: trunk)
3.80 years test/tkt3762.test
[7f40576d] Added a test case for ticket #3672. (CVS 6414) (user: drh, branch: trunk)
3.81 years test/lock3.test
[767a7f7b] Back out check-in (6380). Replace it with a proper fix to the xFullPathname method in the async VFS. (CVS 6398) (user: drh, branch: trunk)
3.88 years ext/fts1/fts1.c
[6404afa0] Corrected typos and misspellings. Ticket #3702. (CVS 6336) (user: shane, branch: trunk)
3.90 years tool/genfkey.README
[36d69966] Remove genfkey.c. Change genfkey.README to talk about the new shell dot-command, not the old standalone genfkey program. (CVS 6326) (user: danielk1977, branch: trunk)
3.91 years test/default.test
[d9f6ffbc] Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) (user: danielk1977, branch: trunk)
3.94 years test/distinctagg.test
[e20bf384] Better error message when DISTINCT is used on an aggregate function that takes two or more arguments. Ticket #3641. (CVS 6269) (user: drh, branch: trunk)
3.95 years test/schema2.test
[f92405af] Simplify wording of backup API error message. Decapitalize some other error messages. (CVS 6256) (user: drh, branch: trunk)
3.96 years test/substr.test
[cd2e7f6c] Check-in (6230) introduced a bugs in SUBSTR() which was caught by the fuzz tester. Fixed by this check-in. Related to ticket #3628. (CVS 6234) (user: drh, branch: trunk)
3.96 years test/tkt3630.test
[3b0a2554] Omit the TEMP keyword from the schema of TEMP tables created using CREATE TEMP TABLE AS SELECT ..... Ticket #3630. (CVS 6232) (user: drh, branch: trunk)
3.97 years test/keyword1.test
[6041ca87] Add test cases to make sure that keywords that we say can be used as identifiers really can be used as identifiers. These tests were inspired by ticket #3612, but they do not directly address ticket #3612. (CVS 6214) (user: drh, branch: trunk)
3.97 years aclocal.m4
[813a3c96] regenerate autotools (CVS 6211) (user: vapier, branch: trunk)
4.01 years test/tkt3581.test
[f5f5ef64] Here is the test case to prove that ticket #3581 is fixed. (CVS 6174) (user: drh, branch: trunk)
4.03 years test/mallocJ.test
[6e171c0a] More coverage improvements. (CVS 6148) (user: drh, branch: trunk)
4.03 years test/mallocK.test
[1e5725c5] Increased test coverage in where.c. (CVS 6146) (user: drh, branch: trunk)
4.04 years test/fuzz_common.tcl
[e02323b3] Reenable fuzz testing for all.test. Make sure the query flattener copies over aggregate information from expressions on outer query terms while flattening. (CVS 6112) (user: drh, branch: trunk)
4.04 years test/fuzz3.test
[77dc19cf] Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110) (user: drh, branch: trunk)
4.04 years test/savepoint5.test
[3e9efb76] Reinitialize page 1 of the database file following a ROLLBACK TO of a transactional SAVEPOINT on an initially empty database. (CVS 6103) (user: drh, branch: trunk)
4.04 years test/boundary1.tcl
[b1a4a17f] Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099) (user: shane, branch: trunk)
4.05 years ext/fts2/fts2_tokenizer.c
[afac4293] Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094) (user: drh, branch: trunk)
4.05 years ext/fts3/README.syntax
[ac8258da] Fix the name in the documentation of the compile-time macro for enabling FTS3 parenthesis processing. (CVS 6089) (user: drh, branch: trunk)
4.09 years test/randexpr1.tcl
[4685ffcc] Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029) (user: drh, branch: trunk)
4.09 years test/tkt3541.test
[ea9b747e] Convert the "~" and "NOT" operators to be two-address instructions. Ticket #3541. (CVS 6028) (user: drh, branch: trunk)
4.11 years test/tkt3346.test
[4f10f19d] Additional test cases for nested subqueries in a WHERE clause. (CVS 5999) (user: drh, branch: trunk)
4.12 years test/tkt3522.test
[06d206ef] Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979) (user: drh, branch: trunk)
4.20 years test/utf16align.test
[3f657e88] Prevent buffer overruns when converting malformed UTF16 to UTF8. Ticket #3482. (CVS 5869) (user: drh, branch: trunk)
4.20 years test/tkt3080.test
[51f04aaf] 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) (user: drh, branch: trunk)
4.22 years test/altermalloc.test
[0996783b] Fix a crash that can follow a malloc failure in sqlite3ValueFromExpr(). Ticket #3468. (CVS 5851) (user: danielk1977, branch: trunk)
4.23 years test/laststmtchanges.test
[e68e4282] Make sqlite3_count_changes() and total_changes() work with "DELETE FROM ". (CVS 5844) (user: danielk1977, branch: trunk)
4.27 years test/eval.test
[b055bfc4] If sqlite3_column_value() is called to obtain a value with the MEM_Static flag set, clear it and set the MEM_Ephem flag before returning. Otherwise, if the value is passed to sqlite3_bind_value() or sqlite3_result_value(), sqlite may attempt to use the buffer after the statement has been finalized. This is not always valid, as MEM_Static only guarantees that a MEM.z buffer will be valid for the lifetime of the owner statement, not that it is actually a static buffer. (CVS 5812) (user: danielk1977, branch: trunk)
4.27 years mkdll.sh
[66f57ecb] Added -DSQLITE_ENABLE_RTREE=1 to the mkdll.sh script. Ticket #3427. (CVS 5810) (user: shane, branch: trunk)
4.27 years test/wherelimit.test
[282c6a46] Further simplifications of the code for the LIMIT clause on an UPDATE or DELETE. Added a few test cases to wherelimit.test. (CVS 5797) (user: shane, branch: trunk)
4.28 years tool/mkspeedsql.tcl
[2d427746] New speed testing tools. (CVS 5786) (user: drh, branch: trunk)
4.28 years test/mutex2.test
[02a12eb1] 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) (user: drh, branch: trunk)
4.29 years test/tkt3419.test
[c3cf54a1] Add a test script to verify that ticket #3419 stays fixed. (CVS 5771) (user: drh, branch: trunk)
4.31 years sqlite.pc.in
[efe095e0] fix #3077: use full version in pkg-config files (CVS 5746) (user: vapier, branch: trunk)
4.36 years ext/icu/sqliteicu.h
[79364b96] Add header file sqliteicu.h to the ICU extension. This is analogous to the rtree.h and fts3.h headers used by other extensions to declare their entry points. Fix for ticket #3361. (CVS 5680) (user: danielk1977, branch: trunk)
4.39 years test/tkt2409.test
[44193b92] Partial fix for a bug in recovery from xStress failures in pcache. (CVS 5635) (user: drh, branch: trunk)
4.39 years test/trans2.test
[39c34e22] Add the trans2.test script designed to stress statement rollback and no-write optimizations on large transactions with a small cache. (CVS 5627) (user: drh, branch: trunk)
4.40 years test/tkt3334.test
[4995a1d1] Do not flatten subqueries where the subquery has a LIMIT and the outer query has a WHERE clause. Ticket #3334. (CVS 5613) (user: drh, branch: trunk)
4.40 years test/collate8.test
[0d61960a] Additional coverage testing in the new name resolver module. (CVS 5608) (user: drh, branch: trunk)
4.40 years test/crash2.test
[16f612d6] 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) (user: danielk1977, branch: trunk)
4.41 years test/selectA.test
[b46267ff] Add test cases to verify that ticket #3314 has been fixed. (CVS 5579) (user: drh, branch: trunk)
4.41 years test/select5.test
[68557115] Reinsert an SCopy operation that was removed in (5523) because coverage testing indicated that it was dead code. Ticket #3324 shows that the code was not as dead as we thought it was. (CVS 5578) (user: drh, branch: trunk)
4.41 years test/collate2.test
[daf730d1] Refactor the name resolution procedures in the code generator. (CVS 5569) (user: drh, branch: trunk)
4.43 years test/tkt3292.test
[055f173a] A partial fix for ticket #3292. This fixes the original problem but there are other similar problems lurking in the code still. (CVS 5561) (user: drh, branch: trunk)
4.45 years mkso.sh
[ce5daa03] Revise build scripts in set SQLITE_ENABLE_COLUMN_METADATA on DLLs. (CVS 5539) (user: drh, branch: trunk)
4.46 years test/cse.test
[9ca975c8] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (user: danielk1977, branch: trunk)
4.46 years test/limit.test
[f1e44eb3] Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) (user: drh, branch: trunk)
4.47 years test/mallocH.test
[2cd6bae8] Bring test coverage up to 99%. (CVS 5522) (user: drh, branch: trunk)
4.47 years test/mallocG.test
[b65f493c] Fix problems in test scripts. Add new test cases to improve test coverage. (CVS 5521) (user: drh, branch: trunk)
4.47 years test/fts2r.test
[02870ed2] Backport http://www.sqlite.org/cvstrac/chngview?cn=5489 from fts3. Re-used prepared statement from fts2 cursor. (CVS 5499) (user: shess, branch: trunk)
4.47 years test/fts3e.test
[ae96d960] Add some simple tests to make sure that the different fulltextFilter query paths are being exercised. (CVS 5498) (user: shess, branch: trunk)
4.49 years test/fts2q.test
[c16900dc] Implement optimize() function. Backports check-in (5417) from fts3. (CVS 5458) (user: shess, branch: trunk)
4.49 years test/fts2p.test
[4e47394b] fts2 functions for testing scripts. Backports (5340) from fts3. (CVS 5456) (user: shess, branch: trunk)
4.49 years ext/fts2/fts2_hash.c
[ecf2dec6] Changes fts2 to use only sqlite3_malloc() and not system malloc. Backports (4554) and (4555) from fts3. (CVS 5454) (user: shess, branch: trunk)
4.49 years ext/fts2/fts2_hash.h
[e31d2f87] Cleanup the hash functions in FTS2. Backports (4440) from fts3. (CVS 5452) (user: shess, branch: trunk)
4.52 years test/in2.test
[dcb16024] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (user: drh, branch: trunk)
4.53 years test/collate9.test
[636cd723] 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) (user: drh, branch: trunk)
4.53 years test/delete2.test
[96df0a5f] 3 more coverage tests for btree.c. (CVS 5370) (user: danielk1977, branch: trunk)
4.53 years test/tokenize.test
[fe80aa58] Testing coverage enhancements. (CVS 5358) (user: drh, branch: trunk)
4.57 years tool/soak1.tcl
[1e3b8308] Change the TEMP_STORE preprocessor symbol to SQLITE_TEMP_STORE. (CVS 5312) (user: danielk1977, branch: trunk)
4.57 years mkextw.sh
[cdd4cf4c] Change the OS_XXX pre-processor symbols to SQLITE_OS_XXX. Symbols "OS_UNIX", "OS_WIN", "OS_WINCE", "OS_OS2" and "OS_OTHER" are now "SQLITE_OS_UNIX", "SQLITE_OS_WIN", "SQLITE_OS_WINCE", "SQLITE_OS_OS2" and "SQLITE_OS_OTHER", respectively. (CVS 5311) (user: danielk1977, branch: trunk)
4.57 years spec.template
[66529ae3] Added ldconfig invocations for postinstall and postuninstall. Updated package URL and description to match the current website. (CVS 5287) (user: mihailim, branch: trunk)
4.61 years tool/speedtest8inst1.c
[98bdc7b4] Update utility program speedtest8inst1.c. (CVS 5201) (user: danielk1977, branch: trunk)
4.62 years ext/rtree/README
[9ab87b7b] Fix another typo in the rtree README file. (CVS 5187) (user: drh, branch: trunk)
4.64 years tool/speedtest16.c
[9883b406] Consolidated inline assembly versions of "hwtime()" into hwtime.h. Provided MSVC version. Modified code for consistent use of hwtime(). Changed implementation to use sqlite_uint64 and sqlite_int64 instead of unsigned long long int and long long int for MSVC compiler support. (CVS 5178) (user: shane, branch: trunk)
4.65 years ext/rtree/rtree.h
[aa8eba33] Update the amalgamation builder to incorporate the RTREE extension. (CVS 5160) (user: drh, branch: trunk)
4.65 years test/like2.test
[33548744] Fix the LIKE query optimizer so that it works with LIKE patterns ending in '@%' on NOCASE columns. Ticket #3139. (CVS 5158) (user: drh, branch: trunk)
4.71 years config.guess
[2b1e455c] Add AC_SYS_LARGEFILE to ensure large file support, update autotools-related files. Ticket #3094. (CVS 5087) (user: mlcreech, branch: trunk)
4.72 years test/tkt3093.test
[3dc334aa] Make sure that when a connection is blocking on a RESERVED lock that it continues after the lock is released. Ticket #3093. (CVS 5078) (user: drh, branch: trunk)
4.73 years test/vtabB.test
[776e7024] Add test cases to prove that ticket #3082 has been fixed. (CVS 5048) (user: drh, branch: trunk)
4.76 years test/speed1p.explain
[d11f5daf] Add speed-test scripts that also show EXPLAIN output. (CVS 5017) (user: drh, branch: trunk)
4.76 years test/collateA.test
[c5435f71] 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) (user: drh, branch: trunk)
4.78 years test/update.test
[1aaed6a4] Enhancements to the change counter tests. Ticket #3013. (CVS 4986) (user: drh, branch: trunk)
4.78 years test/speed4p.test
[a2da7f9a] Add three new test cases to speed4p.test. Two of the three do single-row updates based on rowid and on primary key. (CVS 4972) (user: drh, branch: trunk)
4.79 years test/malloc9.test
[9987a7b1] Fix the output labels on the tests in malloc9. (CVS 4966) (user: drh, branch: trunk)
4.84 years test/loadext2.test
[e90c4cc8] Move SQL functions used for testing only out of func.c and into a new test file named test_func.c. Use sqlite3_auto_extension() to make sure the test functions appear in every database connection. (CVS 4883) (user: drh, branch: trunk)
4.85 years test/busy.test
[5e4df441] Add tests to make sure the busy handler resets. (CVS 4865) (user: drh, branch: trunk)
4.92 years test/malloc4.test
[63da5d97] 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) (user: drh, branch: trunk)
4.93 years test/tkt2942.test
[6d33cbd9] 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) (user: drh, branch: trunk)
4.96 years test/tkt2920.test
[b3259e87] 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) (user: drh, branch: trunk)
4.97 years ext/fts3/mkfts3amal.tcl
[72411043] Version number to 3.5.5. Include FTS3 in the amalgamation by default (but disabled unless compiled with -DSQLITE_ENABLE_FTS3). Fix a memory allocation problem. (CVS 4757) (user: drh, branch: trunk)
4.99 years test/colmeta.test
[9f95d79d] Improvements to test coverage in the lemon-generated parser and in the sqlite3_get_table() interface. (CVS 4745) (user: drh, branch: trunk)
4.99 years test/exec.test
[720bc20a] Miscellaneous test coverage improvements. (CVS 4734) (user: drh, branch: trunk)
5.00 years test/ioerr3.test
[010f7b78] Additional test coverage improvements. Test coverage now stands at 98.73%. (CVS 4731) (user: drh, branch: trunk)
5.01 years test/insert2.test
[3a289b6d] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (user: danielk1977, branch: trunk)
5.02 years test/select8.test
[a6dddebc] Continuing work toward converting the VM into a register machine. (CVS 4707) (user: drh, branch: trunk)
5.10 years ext/fts2/README.tokenizers
[4e91a267] Change all instances of "it's" in comments to either "its" or "it is", as appropriate, in case the comments are ever again read by a pedantic grammarian. Ticket #2840. (CVS 4629) (user: drh, branch: trunk)
5.10 years test/null.test
[2f88b9b3] Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) (user: danielk1977, branch: trunk)
5.11 years test/where4.test
[0b34a186] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (user: danielk1977, branch: trunk)
5.18 years test/fts2g.test
[75cb46f8] Don't do anything when input doclists are both empty. Ticket #2774 (CVS 4546) (user: shess, branch: trunk)
5.35 years test/shortread1.test
[995c63b5] Add tests to prevent a regression of the short read problem discovered in version 3.2.2. (CVS 4428) (user: drh, branch: trunk)
5.35 years test/tkt2643.test
[2cfdbfe6] Fix incorrect index cost assumptions that occur after an ANALYZE. Ticket #2643. (CVS 4424) (user: drh, branch: trunk)
5.35 years test/badutf.test
[c8405b15] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (user: danielk1977, branch: trunk)
5.38 years test/vtab_err.test
[d66e08fd] Enable threadsafe builds by default in configure. Ticket #2606. Changes to test scripts to do better testing under all configurations. (CVS 4379) (user: drh, branch: trunk)
5.42 years test/fts3af.test
[24739f14] Replicate the fts2*.test files as fts3a*.test, and convert fts2 to fts3 in the text of the files. (CVS 4251) (user: shess, branch: trunk)
5.42 years ext/fts3/fts3.h
[216c91d2] Copy fts2 to fts3, renaming, and replacing references to fts2 with fts3, including capitalization variants. (CVS 4249) (user: shess, branch: trunk)
5.44 years test/fts2k.test
[16730cb1] Convert fts2 to use sqlite3_prepare_v2() to prevent certain logic errors around SQLITE_SCHEMA handling. This also allows sql_step_statement() and sql_step_leaf_statement() to be replaced with sqlite3_step().    Also fix a logic error in flushPendingTerms() which was clearing the term table in case of error. This was wrong in the face of SQLITE_SCHEMA. Even though the change to sqlite3_prepare_v2() should cause us not to see SQLITE_SCHEMA any longer, it was still a logic error... (CVS 4205) (user: shess, branch: trunk)
5.47 years ext/fts1/fts1_porter.c
[3f9a6661] Fix ticket #2439: the FTS1 and FTS2 extensions use the non-standard, unportable and highly deprecated <malloc.h> header on all platforms except Apple Mac OS X. The <malloc.h> actually is never required on any OS with an at least partly POSIX-conforming API as the malloc(3) & friends functions officially live in <stdlib.h> since over 10 years. Under some platform like FreeBSD the inclusion of <malloc.h> since a few years even causes an "#error" and this way a build failure. So, just get rid of the bad <malloc.h> usage in FTS1 and FTS2 extensions at all and stick with <stdlib.h> there only. (CVS 4191) (user: rse, branch: trunk)
5.47 years test/collate6.test
[7b699686] 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) (user: danielk1977, branch: trunk)
5.49 years test/fts1n.test
[f9020cff] Replicates http://www.sqlite.org/cvstrac/chngview?cn=4151 which modified fts2:    Modify handling of SQLITE_SCHEMA in fts2 code. An SQLITE_SCHEMA error may cause SQLite to reload the internal schema, deleting and recreating v-table objects. So the sqlite3_vtab structure can be deleted out from under a v-table implementation. (CVS 4183) (user: shess, branch: trunk)
5.49 years test/fts1m.test
[c2ba3cc0] Apply change 4095 to fts1. Fix snippet generation when the left-most column of an fts table is used in the MATCH clause. Fix for ticket #2429. (CVS 4181) (user: shess, branch: trunk)
5.50 years mkextu.sh
[e269f6e9] Updates to build scripts. Added scripts for building FTS2 shared libraries. (CVS 4171) (user: drh, branch: trunk)
5.57 years ext/fts2/fts2_tokenizer.h
[b331e303] Reorganize comments in fts2_tokenizer.h. No code changes. (CVS 4132) (user: danielk1977, branch: trunk)
5.57 years ext/fts2/mkfts2amal.tcl
[bbdcf372] Remove the unused EXTSRC variable from the non-configure makefile. (CVS 4129) (user: danielk1977, branch: trunk)
5.57 years ext/fts2/fts2.h
[c795e6fd] Put #ifdefs in fts2_tokenizer so that the build works even when FTS2 is omitted. Add the SQLite blessing to the header comments on all FTS2 source files. (CVS 4120) (user: drh, branch: trunk)
5.57 years test/fts2token.test
[fbcf2d75] Add a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118) (user: danielk1977, branch: trunk)
5.57 years test/tkt2450.test
[d5b7224f] When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111) (user: danielk1977, branch: trunk)
5.60 years test/progress.test
[115e19fe] Fix for #2415. The progress handler should abandon only the current query, not all active queries. (CVS 4067) (user: danielk1977, branch: trunk)
5.62 years test/where5.test
[72612a03] Additional test cases for comparisons against NULL in the WHERE clause and elsewhere in a SELECT. (CVS 4051) (user: drh, branch: trunk)
5.62 years test/join5.test
[46fdd195] Fix the query optimizer so that it correctly handles constant expressions in the ON clause of a LEFT JOIN. Ticket #2403. (CVS 4049) (user: drh, branch: trunk)
5.64 years test/tkt2391.test
[f9a95e92] Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040) (user: danielk1977, branch: trunk)
5.66 years test/enc.test
[0595319c] Add some code to MemTranslate() to prevent the READ_UTF8() macro from overreading a buffer. (CVS 4033) (user: danielk1977, branch: trunk)
5.67 years test/fts2a.test
[ed3a131f] Fix overzealous fts2 assertions WRT rowid 0 or lower. Only check that docids are ascending if there was a prior docid set for the doclist, ignore the initial docid of 0. (CVS 4026) (user: shess, branch: trunk)
5.71 years test/format4.test
[b94d39e4] Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918) (user: drh, branch: trunk)
5.74 years test/quote.test
[0935cdf8] Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869) (user: drh, branch: trunk)
5.74 years test/misc6.test
[25c1c7aa] Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865) (user: drh, branch: trunk)
5.76 years test/vtab9.test
[8d6c3bfc] Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845) (user: danielk1977, branch: trunk)
5.76 years test/speed2.test
[e44995de] Detect database file changes using a 128-bit segment of the file header that includes the change counter. Ticket #2303. (CVS 3844) (user: drh, branch: trunk)
5.78 years test/fts1l.test
[81be7290] Fix crash in delete when existing row has null fields. Previous code assumed that the row had values in all columns, sigh. Fixes bug http://www.sqlite.org/cvstrac/tktview?tn=2289 . (CVS 3833) (user: shess, branch: trunk)
5.89 years test/vtab8.test
[52885ed8] Handle the case where the estimated cost of a virtual table scan is larger than SQLITE_BIG_DBL. Ticket #2253. (CVS 3670) (user: danielk1977, branch: trunk)
5.91 years test/types2.test
[da81725c] Clarify the documentation on how comparisons occur in an IN operator. Fix the comparison operators when both sides of an IN operator are expressions (ticket #2248). Changes to main.mk for adding FTS2 into the standard build also got mixed in with this check-in by mistake. (CVS 3656) (user: drh, branch: trunk)
5.91 years test/fts1f.test
[16cb00ad] Fix typos in test naming (was using 'e' instead of 'f'). (CVS 3655) (user: shess, branch: trunk)
5.94 years tool/fragck.tcl
[bd6bc3b8] Changes to support fragmentation analysis in sqlite3_analyzer. (CVS 3634) (user: drh, branch: trunk)
5.99 years test/fts2i.test
[310f6858] Do not run the fts2i.test unless the FTS2 module is available. (CVS 3601) (user: drh, branch: trunk)
5.99 years test/fts1i.test
[810c0176] Do not run test fts1i.test if FTS1 is not installed. (CVS 3600) (user: drh, branch: trunk)
6.04 years test/threadtest2.c
[06216d0d] Get threadtest2.c working again after being long neglected. (CVS 3562) (user: drh, branch: trunk)
6.14 years test/fts2h.test
[66581162] Test that terms longer than interior nodes work correctly. A bug prior to fts2.c r1.10 meant that such large terms caused an eventual stack overflow. (CVS 3523) (user: shess, branch: trunk)
6.25 years test/fts2b.test
[2806c341] dup fts1 tests and edit for fts2. fts1porter.test omitted because it depends on being able to poke through to %_term table. (CVS 3482) (user: shess, branch: trunk)
6.25 years test/fts1e.test
[b01c4371] Add tests for delete and update in fts1. (CVS 3481) (user: shess, branch: trunk)
6.28 years ext/fts2/README.txt
[d0d1e7cd] Copy fts1/ to fts2/, changing reference from fts1 to fts2. For future reference, the source versions copied were:    README.txt r1.1 fts1.c r1.37 fts1.h r1.2 fts1_hash.c r1.1 fts1_hash.h r1.1 fts1_porter.c r1.1 fts1_tokenizer.h r1.4 fts1_tokenizer1.c r1.6 (CVS 3471) (user: shess, branch: trunk)
6.29 years test/fts1c.test
[6cf1fb9f] The snippet generator adds ellipsis between text from different columns. (CVS 3465) (user: drh, branch: trunk)
6.30 years test/fts1porter.test
[df1a4b48] Make DL_POSITION the default mode in FTS1. Remove the need to compile with SQLITE_CORE when SQLITE_ENABLE_FTS1 is used. (CVS 3462) (user: drh, branch: trunk)
6.30 years ext/fts1/fts1_tokenizer.h
[936b06aa] Add a Porter stemmer option to the FTS1 module. (CVS 3452) (user: drh, branch: trunk)
6.31 years test/fts1a.test
[8cdf1d6a] Fix a bug in the handling of the OR operator in FTS1. Test cases added to prevent a repeat. (CVS 3450) (user: drh, branch: trunk)
6.34 years test/fts1b.test
[5e35dc1f] Modify FTS1 so that the "magic" column has the same name as the virtual table. Offsets are retrieved using a special "offsets" function whose first argument is the magic column. Snippets will ultimately be retrieved in the same way. (CVS 3427) (user: drh, branch: trunk)
6.35 years ext/fts1/fts1.h
[d4edb803] Earlier refactoring changed name in fts1.c but not fts1.h. (CVS 3413) (user: shess, branch: trunk)
6.39 years ext/fts1/fts1_hash.c
[e1891f0d] Refactor the FTS1 module so that its name is "fts1" instead of "fulltext", so that all symbols with external linkage begin with "sqlite3Fts1", and so that all filenames begin with "fts1". (CVS 3377) (user: drh, branch: trunk)
6.39 years ext/fts1/simple_tokenizer.c
[6c77c2d5] Just don't run tolower() on hi-bit characters. This shouldn't cause us to break any UTF-8 code points, unless they were already broken in the input. (CVS 3376) (user: shess, branch: trunk)
6.39 years ext/fts1/fulltext.c
[58006e38] Make static some symbols which shouldn't have been exported. (CVS 3371) (user: shess, branch: trunk)
6.41 years ext/fts1/ft_hash.c
[b0d8e0d3] A first implementation of a full-text search module for SQLite. (CVS 3363) (user: adamd, branch: trunk)
6.41 years ext/README.txt
[7f152f9f] Add the ext/fts1 subdirectory for holding the first full-text search extension. (CVS 3360) (user: drh, branch: trunk)
6.58 years test/tkt1444.test
[0534f6e1] Modify the test cases in tkt1444.test that were failing. I am convinced that the test cases were incorrect. (CVS 3288) (user: danielk1977, branch: trunk)
6.58 years test/lastinsert.test
[d50c3797] Make the last_insert_rowid method in the TCL interface work with 64-bit rowids. (CVS 3283) (user: drh, branch: trunk)
6.71 years test/aggerror.test
[8f820e43] Faster :memory: database COMMITs. Ticket #1790. (CVS 3178) (user: drh, branch: trunk)
6.88 years test/index2.test
[cdca3383] Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) (user: drh, branch: trunk)
6.94 years test/tkt1644.test
[c468aa34] Minor test file modifications for builds compiled with OMIT options. (CVS 3077) (user: danielk1977, branch: trunk)
7.01 years test/between.test
[3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (user: danielk1977, branch: trunk)
7.01 years test/tkt1537.test
[8e79a0c2] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (user: danielk1977, branch: trunk)
7.09 years test/tkt1567.test
[e6106cc1] Tentative fix for ticket #1567: disable the sqlite3pager_dont_write() optimization when a statement transaction is active. We continue to look for a better fix. (CVS 2827) (user: drh, branch: trunk)
7.15 years test/tkt1536.test
[a2e55a38] Fix incorrect type conversions when copying from a table into itself. Ticket #1536. (CVS 2773) (user: drh, branch: trunk)
7.18 years test/sort.test
[ce06c123] Create separate affinities for INTEGER and REAL. (CVS 2766) (user: drh, branch: trunk)
7.32 years contrib/sqlitecon.tcl
[079c6348] Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) (user: drh, branch: trunk)
7.41 years test/delete3.test
[7c599bae] Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620) (user: drh, branch: trunk)
7.71 years test/trigger6.test
[c2af7d2c] Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454) (user: drh, branch: trunk)
7.81 years test/join4.test
[c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (user: danielk1977, branch: trunk)
7.90 years sqlite3.1
[5c99bea5] Revised man page from Bill Bumgarner. (CVS 2360) (user: drh, branch: trunk)
8.00 years test/join2.test
[bb0254ab] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (user: danielk1977, branch: trunk)
8.00 years test/join3.test
[d8b2a7e0] Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (user: drh, branch: trunk)
8.22 years test/trigger5.test
[be661acf] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (user: drh, branch: trunk)
8.45 years test/bigrow.test
[d33771a3] Do not invoke the busy callback when trying to promote a lock from SHARED to RESERVED. This avoids a deadlock. (CVS 1879) (user: drh, branch: trunk)
8.56 years test/threadtest1.c
[ffd3312b] Bug-fixes to get the two threadtest C programs working again. (CVS 1756) (user: danielk1977, branch: trunk)
8.67 years test/varint.test
[61bdb53a] New varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395) (user: drh, branch: trunk)
8.95 years test/crashtest1.c
[597a59a7] 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) (user: drh, branch: trunk)
9.75 years tool/mkopts.tcl
[6289b863] Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a "trace" method to the TCL interface. (CVS 929) (user: drh, branch: trunk)
10.16 years tool/space_used.tcl
[83b2c27a] Add the "space_used.tcl" script to the tools directory. This script is used to measure how much disk space is used by each table and index of a database. (CVS 789) (user: drh, branch: trunk)
10.54 years tool/diffdb.c
[00f83c25] Prepare for the 2.5.5 release. (CVS 661) (user: drh, branch: trunk)
10.70 years tool/speedtest.tcl
[232b7ef2] Update the misuse.test script so that it will work under Windows. Changes to the speed testing script to support version 2.4.12. (CVS 560) (user: drh, branch: trunk)
10.88 years tool/speedtest2.tcl
[161c0c5f] Added the default_cache_size and default_synchronous pragmas. Added additional tests for pragmas. Added a new speedtest script. (CVS 421) (user: drh, branch: trunk)
11.31 years install-sh
[00575d16] Put in the new LIBTOOL build system. (CVS 271) (user: drh, branch: trunk)
12.65 years tool/opcodeDoc.awk
[6f3655f7] initial check-in of the new version (CVS 1) (user: drh, branch: trunk)