File Ages
Not logged in

Files in [096ae1d8] ordered by check-in time

Times are relative to the check-in time for [096ae1d8] which is 2013-06-21 18:36:44.

current ext/fts3/fts3Int.h
[096ae1d8] Remove an unused function declaration from the FTS3 source code. (user: drh, branch: trunk)
18.4 minutes test/fts3malloc.test
[b53c0c41] Add a few more tests for the fts4 notindexed option. (user: dan, branch: fts4-notindexed)
65.9 minutes ext/fts3/fts3.c
[8ff2b8f5] Add the "notindexed" option to fts4. (user: dan, branch: fts4-notindexed)
28.5 hours src/os_unix.c
[b6744622] Disable posix_fallocate() for all systems, all the time, unless the HAVE_POSIX_FALLOCATE compile-time macro is supplied. (user: drh, branch: trunk)
10.2 days ext/fts3/fts3_expr.c
[24fc9d44] Add the SQLITE_FTS3_MAX_EXPR_DEPTH compile time option. (user: dan, branch: trunk)
11.9 days test/collate1.test
[0a60212c] Add test cases to demonstrate the memory leak on the COLLATE clause. (user: drh, branch: memleak)
12.9 days src/build.c
[60fc77bc] Candidate fix for a memory leak that occurs if a CREATE TABLE statement contains two or more COLLATE clauses on the same column definition. (user: drh, branch: memleak)
13.9 days tool/build-all-msvc.bat
[d5bc1fe1] Improve manual cleaning step performed by the multi-platform build tool for MSVC. (user: mistachkin, branch: trunk)
16.1 days ext/fts3/fts3_unicode2.c
[6cfd9af5] Up until now the fts4 "unicode61" tokenizer has treated all private use codepoints except the first and last of each of the three ranges as alphanumeric (eligible to be part of tokens). This commit fixes this so that all private use codepoints are considered alphanumeric. In other words, it fixes the handling of codepoints 0xE000, 0xF8FF, 0xF0000, 0xFFFFD, 0x100000 and 0x10FFFD. (user: dan, branch: trunk)
17.9 days test/e_reindex.test
[4d74fccf] Fix a typo in a collating function inside the e_reindex.test script. (user: drh, branch: trunk)
18.2 days src/shell.c
[3bd5ad09] Enhance the shell to provide more flexibility when entering numeric arguments on dot-commands. In particular, allow hexadecimal arguments to .wheretrace and .testctrl commands. Cherrypick from [b9578c371ee5]. (user: drh, branch: trunk)
18.3 days src/tclsqlite.c
[7cc0c4ee] Further improvements to error handling of the run-time loading of SQLite into TCL. (user: drh, branch: trunk)
23.0 days src/pager.c
[d5b084e9] Updates to the Codec interface to support codecs on attached databases and to allow rekeying in the middle of a transaction. These changes are only applicable if SQLite is compiled with SQLITE_HAS_CODEC. (user: drh, branch: trunk)
23.2 days test/fts4merge4.test
[09e5a7ad] Add tests for running FTS 'merge' and 'optimize' commands in shared cache mode. (user: dan, branch: trunk)
23.9 days Makefile.in
[a64d760d] Add the percentile() SQL function as a loadable extension in the ext/misc directory. (user: drh, branch: trunk)
24.0 days src/main.c
[2f97e38a] Finish removing the sqlite3.inTrans field. In the previous check-in, it was merely commented out because I failed to select File->Save on my text editor. (user: drh, branch: trunk)
24.0 days src/sqliteInt.h
[c3381cd4] Remove the obsolete and unused sqlite3.inTrans field. (user: drh, branch: trunk)
24.3 days ext/icu/icu.c
[a0d5cc93] Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. (user: drh, branch: trunk)
25.0 days tool/mkautoconfamal.sh
[3fdc8b56] Add the "dist" target to main.mk. For building the amalgamation autoconf package. (user: dan, branch: autoconf-package)
25.1 days autoconf/INSTALL
[048865e8] Add the files used to build the amalgamation-autoconf package. (user: dan, branch: autoconf-package)
25.4 days test/fts3shared.test
[3cd2da42] When writing to an FTS table, take an exclusive shared-cache lock on the %_segdir table before writing. Otherwise, an xCommit() call may report an SQLITE_LOCKED error. (user: dan, branch: trunk)
28.9 days magic.txt
[dab6a328] Add OGC GeoPackage files to the magic.txt database. (user: drh, branch: trunk)
29.3 days test/all.test
[82ad373f] Have the "make fulltest" command run the "mmap" permutation test. (user: dan, branch: trunk)
29.7 days src/os_win.c
[76117792] Cause the mmap_size PRAGMA to immediately change the mmap space if the database connection is already active. In particular, reducing mmap_size will immediately free up process address space. (user: drh, branch: trunk)
34.9 days ext/misc/closure.c
[7a9aa21c] Remove a stray tab character from the transitive_closure extension source code. (user: drh, branch: trunk)
35.1 days src/vdbetrace.c
[cec2bcb4] Fix a bug in SQLITE_TRACE_SIZE_LIMIT that was introduced by check-in [1a1cf5aa86734c8]. That check-in was to remove harmless compiler warnings. So once again, we have introduced a real bug into SQLite by attempting to eliminate a harmless compiler warning. (user: drh, branch: trunk)
35.1 days src/test_syscall.c
[0f355bb1] In test file test_syscall.c, include sqliteInt.h before any tcl or system include files. This ensures that the magical defines in sqliteInt.h really do enable large file support (and set things up so that sizeof(off_t)==8). (user: dan, branch: trunk)
35.2 days mptest/multiwrite01.test
[d0c2288c] Use sum() instead of total() in mptest/multiwrite01.test too. (user: drh, branch: trunk)
35.2 days mptest/crash01.test
[8ba0fc98] Use sum() instead of total() in the mptest/crash01.test script. (user: drh, branch: trunk)
35.3 days test/mmap1.test
[cec0a06c] Add extra "PRAGMA mmap_size = N" statements to mmap1.test and mmap2.test. (user: dan, branch: trunk)
36.0 days test/io.test
[d8ded9d8] Fix minor test script issues causing releasetest.tcl to fail. (user: dan, branch: trunk)
36.2 days test/btreefault.test
[e97d744b] Several releasetest.tcl related fixes to test cases. No code changes. (user: dan, branch: trunk)
36.3 days test/close.test
[d11e7607] In sqlite3_close_v2(), do not attempt to roll back a transaction if there exist active statement objects. Any open transaction will be rolled back when the last of these statement objects is finalized. (user: dan, branch: trunk)
36.7 days src/resolve.c
[9ffff3d0] Treat identifiers in the HAVING clause the same as in the WHERE clause. Only consider AS names from the result set to match if there are no other matches. Continuation of the fix for [2500cdb9be05]. This check-in fixes a bug found by SqlLogicTest during release testing for version 3.7.17. (user: drh, branch: trunk)
37.0 days ext/misc/amatch.c
[00231fb0] Fixes to allow testfixture to be compiled with SQLITE_OMIT_VIRTUAL_TABLE defined. (user: dan, branch: trunk)
37.1 days test/collate3.test
[b10b9e75] Extra test for commit [6dae62c4e5]. (user: dan, branch: trunk)
37.1 days test/sharedA.test
[65ff754e] Fix the sharedA.test module so that it does not attempt to run TCL callbacks on a different thread from where the interpreter was originally created. (user: drh, branch: shared-cache-fixes)
37.2 days ext/misc/rot13.c
[8f9bd8e7] Add the rot13.c loadable extension. (user: drh, branch: trunk)
43.2 days src/where.c
[1128575d] Do not move WHERE clause terms inside OR expressions that are contained within an ON clause of a LEFT JOIN. Fix for ticket [f2369304e47167e3e]. (user: drh, branch: trunk)
44.1 days ext/fts3/fts3_tokenize_vtab.c
[1fa8c457] Fix a couple of harmless compiler warnings in the fts3_tokenize virtual table. (user: drh, branch: trunk)
44.2 days ext/misc/wholenumber.c
[7227b615] Fix the wholenumber virtual table so that it returns higher costs for unconstrained usage. Cherrypick from [ceff8955020cd13]. (user: drh, branch: trunk)
45.0 days test/selectA.test
[fc3630cd] Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Candidate fix for ticket [6709574d2a8d8]. (user: drh, branch: tkt-6709574)
45.3 days test/fts3tok1.test
[0ba67b64] Modify the fts3tokenize table implementation so that it does not use the SQL function fts3_tokenizer. The user may have installed an authorizer callback that prohibits this. (user: dan, branch: trunk)
46.2 days src/update.c
[26a59bb8] Make sure the authorizer callback gets a valid pointer to "ROWID" for the column-name parameter when doing an UPDATE that changes the rowid. Fix for ticket [0eb70d77cb05bb2272]. (user: drh, branch: trunk)
50.0 days src/wal.h
[b81e87e7] Minor fixes for compilation with SQLITE_OMIT_WAL defined. (user: dan, branch: trunk)
50.9 days src/vacuum.c
[4a190bea] Preserve the application-ID across VACUUM. Updates to the magic number file. (user: drh, branch: application-id)
50.9 days src/btree.h
[28c9e7fd] Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. (user: drh, branch: application-id)
53.1 days test/fts3expr3.test
[72ac7318] Fix an off-by-one in the code for limiting the depth of FTS expression trees. (user: dan, branch: trunk)
53.5 days test/fuzzerfault.test
[e81e9ca1] Update 'fuzzerfault' test for its new module loading command. Fix several test names in 'io.test' and make sure the database gets closed between tests. (user: mistachkin, branch: trunk)
53.6 days src/test2.c
[05ba5e23] More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. (user: mistachkin, branch: winOsTrace)
57.0 days ext/misc/nextchar.c
[56b9a417] Added the nextchar.c extension. Minor changes to the spellfix.c extension so that it can be appended to an amalgamation and compiled without duplicating symbols. (user: drh, branch: trunk)
57.0 days tool/build-shell.sh
[aabeea98] Fix the tool/build-shell.sh script to remove references to files that are now loadable extensions. (user: drh, branch: trunk)
57.1 days ext/misc/ieee754.c
[84018099] Added the transitive_closure, ieee754, and amatch extensions. (user: drh, branch: std-ext)
57.2 days test/fuzzer1.test
[c8c69307] Convert the fuzzer virtual table into a loadable extension and move it to the ext/misc/fuzzer.c file. (user: drh, branch: std-ext)
57.3 days test/8_3_names.test
[efcc9dd0] Make test_wholenumber.c into a loadable extension and move it to ext/misc/wholenumber.c. (user: drh, branch: std-ext)
57.7 days src/walker.c
[39b4e6ff] Make sure the affinity and datatype of sub-subqueries are initialized prior to subqueries as the latter relies on the former. (user: drh, branch: trunk)
58.9 days test/regexp1.test
[860fc393] Make "test_regexp.c" into a loadable extension and move it over to ext/misc/regexp.c. Add the "load_static_extension" command for testing purposes. (user: drh, branch: std-ext)
59.8 days src/memjournal.c
[1a1cf5aa] Fix harmless compiler warnings. (user: drh, branch: trunk)
60.1 days test/fts3tok_err.test
[c5a4b21a] Add virtual table module 'fts3tokenize' to fts3. fts3tokenize provides SQL access to FTS tokenizer implementations. (user: dan, branch: trunk)
60.2 days src/test_sqllog.c
[206caf21] Enhanced documentation for the SQLITE_CONFIG_SQLLOG mechanism and the test_sqllog.c demonstration file. No changes to code. (user: drh, branch: trunk)
63.3 days test/loadext.test
[514adbbd] Add the "warning" command to the TCL test infrastructure. Fix problems with the loadext.test module. (user: drh, branch: trunk)
63.7 days src/sqlite3ext.h
[86eb3eed] Make the SQLITE_EXTENSION_INIT1 and SQLITE_EXTENSION_INIT2 macros into no-ops if the extension is statically linked. (user: drh, branch: loadext)
63.8 days src/loadext.c
[6cfa1d73] Experiments in making loadable extensions easier to program. The shared library filename tries various operating-system specific extensions if the bare library name does not work. And the entry point is derived from the filename is the legacy entry point name "sqlite3_extension_init" is not found. (user: drh, branch: loadext)
63.9 days mptest/mptest.c
[e94783f3] Fix an incorrect comment (a copy/paste error) in the mptester. No code changes. (user: drh, branch: trunk)
64.6 days src/ctime.c
[e9f9d84b] Fix a compiler warning in sqlite3_compileoption_used(). (user: drh, branch: trunk)
66.2 days src/os.h
[16f7ba4a] Remove the unused SQLITE_CURDIR macro. (user: drh, branch: trunk)
67.1 days mptest/config01.test
[ea1404a1] Refactoring the mmap interface. The controlling pragma is now "mmap_size" instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. (user: drh, branch: trunk)
68.9 days test/resolver01.test
[ad53924d] Only consider AS names from the result set as candidates for resolving identifiers in the WHERE clause if there are no other matches. In the ORDER BY clause, AS names take priority over any column names. Candidate fix for ticket [2500cdb9be]. (user: drh, branch: tkt-2500cdb9be)
70.1 days test/fts3aux1.test
[6d6f0592] Add a test case for detaching a database referenced by an fts4aux table created in the temp schema. (user: dan, branch: trunk)
70.1 days ext/fts3/fts3_aux.c
[546a187f] Change the fts4aux virtual table module so that fts4aux tables created in the temp database may report on fts3/fts4 tables in any attached database. (user: dan, branch: trunk)
71.8 days src/wal.c
[be7d2c54] Add new primary error codes SQLITE_NOTICE and SQLITE_WARNING for use with sqlite3_log(). Add new extended error codes SQLITE_NOTICE_RECOVER_WAL and SQLITE_NOTICE_RECOVER_ROLLBACK to use with sqlite3_log() messages that occur on each recovery. (user: drh, branch: trunk)
72.3 days mptest/crash02.subtest
[f0d95afc] Use symbolic names for tasks in mptester. (user: drh, branch: trunk)
72.7 days ext/rtree/rtree1.test
[0adf8a3a] Correct test numbering on several rtree tests. (user: mistachkin, branch: trunk)
76.0 days src/legacy.c
[c1d7304c] Increase the default SQLITE_MAX_SCHEMA_RETRY to 50. Make sure that macro covers every case where a prepared statement might need to be reprepared due to a schema change. The sqlite3_exec() interface now uses sqlite3_prepare_v2(). (user: drh, branch: trunk)
76.3 days test/pager2.test
[07a0e4e9] Add tests to "permutations.test coverage-pager" to cover uncovered branches. (user: dan, branch: trunk)
76.9 days src/test_vfs.c
[b095e2cd] Improve the code coverage of "permutations.test coverage-pager". (user: dan, branch: trunk)
78.7 days VERSION
[5c8c5a2a] Increase the version number to 3.7.17. (user: drh, branch: trunk)
79.6 days src/backup.c
[83bc37af] Make use of xFetch, if it is available when doing a VACUUM or a backup. (user: drh, branch: experimental-mmap)
80.3 days test/speed1p.test
[3098a3c1] Add test cases for errors in mmap() or mremap() is os_unix.c. (user: dan, branch: experimental-mmap)
83.9 days Makefile.vxworks
[5687e5ee] For the clean target, tidy up a couple more generated (or copied) source files. (user: mistachkin, branch: trunk)
85.3 days src/util.c
[39534b4b] Adjustment to an extreme corner case in the sqlite3Atoi64() routine. (user: drh, branch: trunk)
85.9 days src/test_fs.c
[274d2a22] Fix harmless compiler warnings coming from MSVC64 in test code. No changes to the core. (user: drh, branch: trunk)
86.1 days test/orderby4.test
[488089e6] A fix and test-case for the ORDER BY problem identified by ticket [a179fe7465]. This change causes sorting to occur in some cases where it is not strictly necessary. Further work is needed to avoid those extra sorts. (user: drh, branch: orderby-fix)
86.6 days test/tkt-6bfb98dfc0.test
[322a5f08] Candidate fix for ticket [6bfb98dfc0c]: Make sure invalid cursors drop all references to database pages prior to doing any insert or update. (user: drh, branch: trunk)
87.8 days src/pager.h
[1b37c4ef] Memory-mapped I/O is now on by default. The "PRAGMA mmap_limit(N)" can be used to issue a hint to the VFS to limit mmap space to N bytes. The VFS is free to ignore that hint if desired. However, if "PRAGMA mmap_limit(0)" is used, xFetch is never called. (user: drh, branch: experimental-mmap)
87.9 days test/syscall.test
[8776047b] Add munmap and mremap to the set of os interfaces that can be overloaded in os_unix.c. (user: drh, branch: experimental-mmap)
87.9 days test/incrblob.test
[a607d63f] Merge all recent trunk changes into the experimental-mmap branch. (user: drh, branch: experimental-mmap)
88.0 days test/malloc_common.tcl
[6ec7367d] Add a test that simulates an error in mmap(). (user: dan, branch: experimental-mmap)
88.3 days test/fts3near.test
[5062db67] Add a second test for [38b1ae018f]. (user: dan, branch: trunk)
91.9 days ext/fts1/ft_hash.h
[6f6e2d50] Many spelling fixes in comments. No changes to code. (user: mistachkin, branch: trunk)
93.3 days test/numcast.test
[5b22053f] Fix text-to-numeric type casting so that it works correctly on UTF16 strings that contain characters where the LSB is numeric but the MSB is non-zero. Ticket [689137afb6da41] (user: drh, branch: trunk)
94.0 days test/dbstatus2.test
[6183f1bd] Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also "PRAGMA mmap_size". (user: dan, branch: experimental-mmap)
94.1 days tool/mksqlite3h.tcl
[d1f41089] Bring makefiles and build scripts into alignment with the sessions branch. No changes to code. (user: drh, branch: trunk)
99.0 days src/pcache.h
[6f21d9cb] Use mmap() to read from the database file in rollback mode. This branch is unix only for now. (user: dan, branch: experimental-mmap)
100.5 days test/tkt-4dd95f6943.test
[0b452734] Enhance tests for ticket [4dd95f6943]. (user: dan, branch: trunk)
100.8 days test/descidx3.test
[38c6bddf] Fix a test case that had an ambiguous result. (user: drh, branch: desc-orderby-fix-1)
104.2 days test/triggerA.test
[e899b058] Add a test case for the problem fixed by the previous commit. (user: dan, branch: trunk)
104.2 days src/delete.c
[ddee56c9] Fix a problem with resolving "db.view.column" references that appear in UPDATE or DELETE statements executed against views. (user: dan, branch: trunk)
106.4 days test/fts3ai.test
[e3939142] Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16. (user: mistachkin, branch: trunk)
106.5 days src/vdbemem.c
[10ace06b] Fix two compilation issues, one warning and one error, that occur only when SQLITE_OMIT_UTF16 is defined. (user: mistachkin, branch: trunk)
107.3 days test/incrvacuum_ioerr.test
[66576b45] Fix a problem in incrvacuum_ioerr.test. Do not run ioerr6.test with an in-memory journal. (user: dan, branch: trunk)
107.7 days test/tkt-fc7bd6358f.test
[7097241c] Fix a bug (ticket [fc7bd6358f59]) that caused incorrect query results in three way queries that involved comparing INTEGER and TEXT columns for equality. (user: drh, branch: trunk)
108.1 days test/misc7.test
[39247b14] Add extended error code SQLITE_READONLY_ROLLBACK. Returned if a read-only connection cannot read the database because doing so would require it to roll back a hot-journal. (user: dan, branch: experimental)
109.0 days test/view.test
[f40552ad] Omit a test that uses the progress handler callback from view.test if OMIT_PROGRESS_HANDLER is defined. (user: dan, branch: trunk)
109.9 days test/index5.test
[b457c887] Add the test_fs.c test module to Makefile.in. Adjust the success criteria on index5-1.3 so that it works under auto_vacuum configurations. (user: drh, branch: trunk)
115.0 days test/incrvacuum3.test
[cd806723] In the incrvacuum3 test, add missing call to the Tcl close command. (user: mistachkin, branch: trunk)
115.2 days test/tkt-7a31705a7e6.test
[c2d5a23b] When comparing names during name resolution, make sure the names match exactly and that one name isn't merely a prefix of the other. Fix for ticket [7a31705a7e6c95d51]. (user: drh, branch: trunk)
118.1 days src/btreeInt.h
[b73847f1] If a rollback mode transaction reduces the size of the database file, avoid actually truncating the file until after the transaction has been committed (but before the db has been unlocked). This means pages that are removed from the database by truncating the file need not be journalled. (user: dan, branch: incr-vacuum-opt)
132.1 days test/capi2.test
[3f674375] Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. (user: drh, branch: constraint-error-codes)
132.2 days src/fkey.c
[54611046] Add extended error codes for constraint errors. (user: drh, branch: constraint-error-codes)
133.0 days test/where.test
[f78395c8] Loop through the elements on the RHS of an IN operator in reverse order when the ORDER BY clauses specifies DESC. (user: drh, branch: IN-with-ORDERBY)
142.7 days test/limit.test
[7d346250] Remove some debugging logic accidently left in the limit.test module. (user: drh, branch: trunk)
144.0 days test/shell1.test
[b4d94947] Cause the command-line shell to issue an error message if you give something that does not look like a boolean value to a dot-command that wants a boolean argument. (user: drh, branch: trunk)
147.1 days tool/showwal.c
[93b159da] Add btree-page decoding logic to showwal.c. Commands of the form: "showwal $FILE 123bmc" show the content of the btree page in frame 123. "b" means decode the btree. "c" means show cell content. "m" means give a map of the btree page. (user: drh, branch: trunk)
155.1 days 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)
155.1 days test/autoindex1.test
[d9676284] Make more aggressive use of transitivity in optimizing queries. Add a test case. (user: drh, branch: transitive-constraints)
161.4 days test/fts4content.test
[7e6007a0] Add another test for the fts4 content= option. (user: dan, branch: trunk)
163.3 days test/orderby3.test
[7249bfc2] Fix the date on the new orderby3.test test case. (user: drh, branch: trunk)
164.2 days test/check.test
[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)
167.8 days test/tkt3457.test
[e9ac5339] Remove superfluous text from a comment. (user: mistachkin, branch: trunk)
182.1 days test/filefmt.test
[ff6857b6] Ensure the database size field in the db header of a backup database is set correctly. Fix for [0cfd98ee201]. (user: dan, branch: trunk)
184.1 days test/tkt-a7b7803e.test
[0ae14217] A couple more test cases. (user: drh, branch: tkt-a7b7803e)
185.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)
185.3 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)
185.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)
185.9 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)
189.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)
190.1 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)
192.0 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)
193.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)
195.6 days test/distinct.test
[7b96115e] Veryquick passes all tests now. (user: drh, branch: ticket-71e333e7)
196.0 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)
196.4 days ext/async/README.txt
[930ba852] Spelling and header fixes for the async extension. (user: mistachkin, branch: trunk)
196.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)
197.0 days test/triggerC.test
[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)
197.0 days src/test_vfstrace.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)
197.1 days test/shared9.test
[cc6e0785] Add a test case that demonstrates ticket [71e333e7d2e642]. (user: drh, branch: ticket-71e333e7)
197.8 days configure.ac
[e1feab98] Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command. (user: mistachkin, branch: noTclLibs)
198.1 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)
198.2 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)
198.4 days test/backup4.test
[04ab2dc6] Update a couple of test scripts so that they work in auto-vacuum mode. (user: dan, branch: trunk)
206.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)
224.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)
226.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)
231.0 days test/aggnested.test
[62ebfa74] Adding test cases for ticket [bfbf38e5e9956a] (user: drh, branch: ticket-bfbf38e5e9)
234.8 days test/minmax2.test
[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)
235.2 days src/test_intarray.h
[cbd8fddf] Make the multiplexor and the IntArray extensions callable from C++. (user: drh, branch: trunk)
236.0 days tool/mkvsix.tcl
[99f27d64] Merge VSIX tooling and packaging enhancements to trunk. (user: mistachkin, branch: trunk)
238.8 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)
239.0 days src/vtab.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)
239.6 days test/instr.test
[49ccae96] Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. (user: drh, branch: instr)
240.7 days tool/win/sqlite.vsix
[5023a7ad] Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. (user: mistachkin, branch: vsixFlavor)
245.7 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)
246.3 days src/hash.c
[51a6a797] More warning fixes. (user: mistachkin, branch: warnings)
247.1 days test/crash7.test
[db9b1fa5] Add a test for the problem fixed by [bf44d73d3e]. (user: dan, branch: trunk)
254.2 days test/whereD.test
[1182b54a] Fix duplicate test name in whereD.test. (user: mistachkin, branch: trunk)
254.3 days tool/spaceanal.tcl
[6dc987d3] Add support for URI filenames in sqlite3_analyzer. (user: drh, branch: trunk)
255.0 days src/lempar.c
[7b1a6e6c] Attempt to suppress warnings generated by Coverity. (user: drh, branch: trunk)
259.2 days src/callback.c
[8ea67522] Consolidate all occurrences of the "no such collation sequence" error message into a single spot. (user: drh, branch: trunk)
260.0 days src/alter.c
[2b370dea] Shared-cache mode fixes for views and virtual tables. (user: dan, branch: shared-cache-fix)
261.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)
261.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)
265.1 days test/bigfile.test
[d869edda] Disable the bigfile tests on Macs. (user: drh, branch: trunk)
266.9 days test/tkt-cbd054fa6b.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)
267.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)
276.0 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)
276.2 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)
276.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)
276.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)
277.0 days src/utf.c
[8b962c94] Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight performance increase. (user: drh, branch: trunk)
279.0 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)
281.1 days test/backcompat.test
[0ebe7cc5] Fix WAL capability checking in one of the test files. (user: mistachkin, branch: trunk)
281.7 days test/full.test
[c1a85570] Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. (user: mistachkin, branch: trunk)
286.9 days test/lock.test
[43e474d3] Correct two test names to make them unique. (user: mistachkin, branch: busy-timeout-pragma)
291.3 days src/sqlite3.rc
[e2f27d28] Add Win32 version resources to the applicable binaries built by the MSVC makefile. (user: mistachkin, branch: win32Resources)
297.2 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)
300.4 days doc/lemon.html
[9b19b847] Fix all known instances of 'repeated the' style typos in comments. No changes to code. (user: mistachkin, branch: trunk)
305.0 days test/fts3auto.test
[e799222f] Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (user: dan, branch: trunk)
305.1 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)
305.1 days src/mem1.c
[7edd10a9] Remove tab characters from source code files. Replace them with spaces. (user: drh, branch: trunk)
317.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)
318.2 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)
318.2 days test/walthread.test
[a192a718] Fix a bug in walthread.test causing intermittent failures. (user: dan, branch: trunk)
339.2 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)
1.00 years tool/mksqlite3c-noext.tcl
[eebd594d] Remove more references to OS/2. (user: mistachkin, branch: trunk)
1.00 years test/atof1.test
[0f706acf] Disable the atof1.test module when compiling on MSVC. (user: drh, branch: floating-point-conversions)
1.00 years src/mutex.h
[ff828c67] Remove support for OS/2 from the source tree. (user: drh, branch: trunk)
1.01 years 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)
1.01 years src/test_func.c
[699b792c] Improved rounding accuracy on text-to-float conversions. (user: drh, branch: trunk)
1.01 years 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)
1.01 years src/mutex_w32.c
[21266c68] Allow the SQLITE_API macro to apply to the sqlite3_win32_sleep function. (user: mistachkin, branch: compiler-compat)
1.04 years 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)
1.04 years 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)
1.04 years tool/warnings-clang.sh
[31fe1985] Fix harmless Clang warnings. (user: drh, branch: trunk)
1.04 years test/quota2.test
[61360ca6] Merge the changes need to compile on WinRT into trunk. (user: drh, branch: trunk)
1.04 years 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)
1.05 years 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)
1.07 years 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)
1.07 years test/fts3fault2.test
[e71495a8] If SQLITE_DISABLE_FTS3_UNICODE is defined, do not build the "unicode61" tokenizer. (user: dan, branch: fts4-unicode)
1.07 years 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)
1.07 years 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)
1.08 years test/fuzz-oss1.test
[5519cc5e] Increase the version number to Minor changes to test scripts. (user: drh, branch: trunk)
1.09 years src/malloc.c
[3869aef6] Make sure lookaside memory allocations are unusable after they are freed. (user: drh, branch: trunk)
1.10 years 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)
1.11 years 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)
1.11 years test/tkt-bdc6bbbb38.test
[f84d87bc] Before running each test script, make sure the FTS enhanced query syntax is disabled. (user: dan, branch: trunk)
1.11 years src/test_stat.c
[e68a3527] Fix a harmless compiler warning inside an assert() statement within test code. (user: drh, branch: trunk)
1.15 years 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)
1.16 years 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)
1.17 years 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)
1.17 years 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)
1.17 years 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)
1.18 years tool/mkkeywordhash.c
[6015200b] Fix a harmless compiler warning in the mkkeywordhash.c utility program. (user: drh, branch: trunk)
1.22 years ext/rtree/rtree6.test
[221fe4a8] Fix a typo in the rtree6.test script that prevented it from running. (user: drh, branch: trunk)
1.22 years ext/rtree/rtree4.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)
1.22 years 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)
1.23 years 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)
1.24 years 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)
1.24 years 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)
1.25 years test/bc_common.tcl
[ed69434c] An attempt at automatic incremental merging for FTS4. (user: drh, branch: fts4-auto-incr-merge)
1.25 years 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)
1.25 years test/fts4langid.test
[f61d5fb0] Merge trunk changes into the fts4-incr-merge branch. (user: drh, branch: fts4-incr-merge)
1.26 years 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)
1.27 years ext/fts3/fts3_porter.c
[74eadeec] Fix harmless compiler warnings. (user: drh, branch: trunk)
1.27 years test/fts4merge2.test
[57047372] Add tests for incremental merge code. (user: dan, branch: fts4-incr-merge)
1.28 years 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)
1.29 years test/uri.test
[88963c33] Merge test current directory value fix from trunk and fix uri tests. (user: mistachkin, branch: winrt)
1.29 years test/quota.test
[5eecdb44] Merge and manually resolve testing updates from trunk. (user: mistachkin, branch: winrt)
1.29 years test/tkt-94c04eaadb.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)
1.30 years 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)
1.30 years test/select4.test
[4f34d707] Add a test case for ticket [3557ad65a076c]. (user: drh, branch: trunk)
1.31 years test/multiplex3.test
[c267893a] Fix a case where an error code was being overwritten in multiplexDelete(). (user: dan, branch: trunk)
1.33 years test/select1.test
[c8c7846f] Fix an obscure bug that causes a crash when parsing certain invalid SQL statements. (user: drh, branch: trunk)
1.35 years 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)
1.35 years 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)
1.35 years 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)
1.35 years test/dbstatus.test
[76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (user: dan, branch: trunk)
1.37 years 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)
1.39 years 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)
1.39 years src/test5.c
[c4cd38a0] Fix compiler warnings in the TCL test harness. (user: drh, branch: trunk)
1.41 years 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.44 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.44 years test/malloc5.test
[5afbcd49] Fix test case issues related to errors in file-controls and the PSOW flag. (user: dan, branch: trunk)
1.44 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.44 years test/corruptF.test
[7654ae71] Remove some assert() statements that can fail with corrupt databases. (user: dan, branch: trunk)
1.45 years test/multiplex.test
[12386197] Make sure the multiplexor does not create unnecessary overflow files. (user: drh, branch: trunk)
1.46 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.47 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.48 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.48 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.50 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.51 years test/superlock.test
[68684495] Modify test cases to account for the ZERO_DAMAGE change. (user: dan, branch: statvfs)
1.51 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.51 years test/walcrash3.test
[d7688042] Add tests to walcrash3.test. (user: dan, branch: trunk)
1.52 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.53 years test/multiplex2.test
[ee1e0122] Change the multiplexor VFS so that xTruncate is a no-op on database files. (user: dan, branch: trunk)
1.53 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.55 years test/quota-glob.test
[fa718960] Documentation improvements and additional test cases. (user: drh, branch: quota-stdio)
1.57 years test/capi3d.test
[95cc4af6] Add the sqlite3_stmt_busy() interface. (user: drh, branch: trunk)
1.60 years test/attach.test
[93a94798] Add the sqlite3_db_filename() interface. (user: drh, branch: trunk)
1.60 years src/test_pcache.c
[457513f2] Merge the PCACHE2 changes into trunk. (user: drh, branch: trunk)
1.60 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.61 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.63 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.64 years ext/fts3/README.content
[13a9d085] Add new file ext/fts3/README.content, describing the experimental FTS4 content option. (user: dan, branch: trunk)
1.64 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.65 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.67 years test/analyze3.test
[aed2bf7a] Purge lingering references to SQLITE_STAT2 from the code and test scripts. (user: drh, branch: trunk)
1.67 years test/fts3first.test
[df36ac94] Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables. (user: dan, branch: fts4-content)
1.68 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.68 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.68 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.69 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.69 years test/fts-9fd058691.test
[7e24645b] Handle updating the only row of an FTS table correctly. Fix for [9fd058691]. (user: dan, branch: trunk)
1.69 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.69 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.69 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.70 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.70 years test/corrupt3.test
[2ab14a84] Add the SQLITE_DIRECT_OVERFLOW_READ compile time option. (user: dan, branch: trunk)
1.71 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.71 years test/fts3ao.test
[0f439944] Improve test coverage of fts3.c. (user: dan, branch: fts4-content)
1.73 years test/tkt-c48d99d690.test
[9ddfe1e4] Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (user: dan, branch: trunk)
1.74 years test/misc3.test
[87946c62] Fix misc3.test so that it works with OMIT_MERGE_SORT builds. (user: dan, branch: trunk)
1.74 years test/attach4.test
[a38668dc] Fix some test files so that they work with SQLITE_OMIT_WAL builds. (user: dan, branch: trunk)
1.75 years test/pcache2.test
[4eb46898] Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. (user: dan, branch: trunk)
1.80 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.81 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.81 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.81 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.81 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.82 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.83 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.83 years test/tkt-b1d3a2e531.test
[3f3acee4] Fix for [b1d3a2e531]. (user: dan, branch: trunk)
1.85 years test/analyze8.test
[2c83ac89] Add the analyze8.test test module for sqlite_stat3. (user: drh, branch: stat3-enhancement)
1.86 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.86 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.87 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.89 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.89 years test/vtabF.test
[a55f4ab9] Make sure IS NOT NULL constraints work on virtual tables. Fix for ticket [6c14288a473ceff]. (user: drh, branch: trunk)
1.89 years test/alter2.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.95 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.96 years test/tkt-54844eea3f.test
[9f14fa56] Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries. (user: dan, branch: trunk)
1.96 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.97 years test/func3.test
[6c51bad0] Adjust a couple of test scripts so that they work with OMIT_UTF16 builds. (user: dan, branch: trunk)
1.98 years ext/fts3/fts3_hash.c
[29e69f38] Changes to allow FTS to be compiled as a loadable module again. (user: dan, branch: trunk)
1.99 years test/exists.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)
2.00 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)
2.00 years test/tkt-91e2e8ba6f.test
[c271f7e8] Add a test for ticket [91e2e8ba6f]. No changes to code. (user: dan, branch: trunk)
2.00 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)
2.00 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)
2.02 years test/wal7.test
[177e2d72] Further tweaks to the wal7.test test case. (user: drh, branch: trunk)
2.03 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)
2.04 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)
2.08 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)
2.10 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)
2.12 years test/lock_common.tcl
[bb59f986] Add experimental support for read-only connections to WAL databases. (user: dan, branch: wal-readonly)
2.13 years test/cast.test
[1586244b] Changes to various test scripts so that they pass on windows. (user: dan, branch: win32-test-fixes)
2.17 years tool/getlock.c
[0ab24b13] Add the "getlock" utility for determining if a database file (on unix) is currently locked. (user: drh, branch: trunk)
2.20 years tool/rollback-test.c
[a65a7a59] Add a simple test program to aid in verifying that journals are cross-platform. (user: drh, branch: trunk)
2.21 years test/thread1.test
[532ae32e] Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined. (user: dan, branch: trunk)
2.21 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)
2.21 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)
2.21 years src/test_server.c
[2039ed95] Changes to support building with various SQLITE_OMIT_XXX options defined. (user: dan, branch: trunk)
2.21 years src/sqliteLimit.h
[b7296fd3] Update a comment in sqliteLimit.h. No changes to code or tests. (user: dan, branch: trunk)
2.21 years src/mem5.c
[3eeb0ff7] Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. (user: drh, branch: trunk)
2.22 years test/pagerfault3.test
[139bc565] Fix additional test cases so that they work with DEFAULT_AUTOVACUUM. (user: dan, branch: trunk)
2.22 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)
2.23 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)
2.25 years test/tableapi.test
[69fe0c87] Fix problem with tableapi.test on Windows. (user: shaneh, branch: trunk)
2.26 years test/tkt-f7b4edec.test
[eedbcf0a] Add a test case to verify that ticket [f7b4edece25c994857] is fixed. (user: drh, branch: trunk)
2.29 years test/mem5.test
[d7dae06f] Fix issue with mem5 allocator when min request size is larger thatn 2^30. (user: shaneh, branch: trunk)
2.29 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)
2.35 years test/capi3e.test
[b04304b9] Skip some tests in capi3e.test when compiled with SQLITE_OMIT_UTF16. (user: shaneh, branch: trunk)
2.36 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)
2.36 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)
2.38 years test/fts3comp1.test
[3996f92a] Change fts4aux to (additionally) report on term frequency in individual columns of an fts table. (user: dan, branch: trunk)
2.40 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)
2.40 years test/mutex1.test
[c86e46f4] Update test file mutex1.test to account for [e3b500fb5d]. (user: dan, branch: trunk)
2.42 years test/pcache.test
[2dc98d29] Get all test cases working with the mutex-free-pcache implementation. (user: drh, branch: mutex-free-pcache)
2.46 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.50 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.54 years src/test_superlock.c
[fe441df9] Work around restriction in Windows file locking. (user: shaneh, branch: trunk)
2.54 years test/incrblob3.test
[476a8b49] Have sqlite3_blob_bytes() return 0 following a failed call to sqlite3_reopen_blob(). (user: dan, branch: trunk)
2.56 years test/e_resolve.test
[6858df9c] Add test file e_resolve.test. (user: dan, branch: trunk)
2.56 years test/fts3aa.test
[d23ef9b8] Add new test file e_droptrigger.test. (user: dan, branch: trunk)
2.58 years test/fts3query.test
[9cf0f2b7] Experimental changes to fts3 function matchinfo(). (user: dan, branch: fts3-experimental)
2.59 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.60 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.61 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.63 years art/sqlite370.ico
[62c494f6] Fix icon size so it's really 32x32. (user: shaneh, branch: experimental)
2.64 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.65 years test/incrblobfault.test
[97c6b261] Structural coverage tests for vdbeblob.c. Including experimental new API sqlite3_blob_reopen(). (user: dan, branch: experimental)
2.66 years test/fts3cov.test
[7a2f2864] More coverage tests for fts3.c. (user: dan, branch: experimental)
2.67 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.71 years test/lock6.test
[759c954f] Fix minor test suite problems causing errors on OSX. (user: dan, branch: trunk)
2.72 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.73 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.73 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.73 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.73 years test/tkt-b351d95f9.test
[57789cfe] Test case and fix for the specific failure of ticket [b351d95f9cd5ef17e9d9dbae]. (user: drh, branch: bug-b351d95f9c)
2.74 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.74 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.75 years ext/rtree/rtreeA.test
[fab3b383] Add tests to e_delete.test. (user: dan, branch: trunk)
2.75 years test/stmt.test
[ba8ca9c9] Changes to test scripts to work with SQLITE_TEMP_STORE=2. (user: dan, branch: trunk)
2.75 years test/tkt-313723c356.test
[4ea134a8] Add a test case to verify that bug [313723c356] has been fixed. (user: dan, branch: trunk)
2.76 years ext/fts2/fts2_porter.c
[ee52589c] Remove additional occurrences of <ctype.h> from FTS2. (user: drh, branch: trunk)
2.79 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.81 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.81 years ext/rtree/rtree3.test
[b06f4695] Add tests (and associated fixes) to restore coverage of rtree.c. (user: dan, branch: trunk)
2.81 years test/types.test
[0900e353] Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. (user: drh, branch: trunk)
2.82 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.83 years test/walshared.test
[d1ed743b] Changes to support building with SQLITE_OMIT_WAL. (user: shaneh, branch: trunk)
2.83 years test/tkt-5e10420e8d.test
[255f1eef] Fix for ticket [5e10420e8d]. (user: dan, branch: trunk)
2.84 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.88 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.90 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.90 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.91 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.93 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.94 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.94 years src/test_devsym.c
[c2d27cf5] Change the name of the xShmClose VFS method to xShmUnmap, everywhere. (user: drh, branch: experimental)
2.94 years test/lock2.test
[05ac2548] Fix problems with running the async.test script. (user: dan, branch: trunk)
2.96 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.96 years test/index3.test
[f553c8ed] Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a]. (user: dan, branch: trunk)
2.96 years test/mallocI.test
[dd59cea6] Fix issue in mallocI test script where db handle not released. (user: shaneh, branch: trunk)
2.97 years test/pagerfault2.test
[50f2f7df] Further changes to test scripts so that the "inmemory_journal" permutation works. (user: dan, branch: trunk)
2.98 years test/schema3.test
[a85ae332] Remove debugging code from test script. (user: dan, branch: trunk)
2.99 years test/ctime.test
[c6db3b30] Modify ctime.test to work with SQLITE_THREADSAFE=2. (user: dan, branch: trunk)
3.00 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)
3.00 years test/async4.test
[85dd51a7] Some changes to test scripts related to codec enabled versions of sqlite. (user: dan, branch: trunk)
3.01 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)
3.02 years test/quick.test
[6e43eed9] Add test file pager1.test, containing tests of inter-process locking in non-wal mode. (user: dan, branch: trunk)
3.02 years test/veryquick.test
[2c5e48a4] Changes to the way tcl test scripts work. No changes to production code. (user: dan, branch: experimental)
3.03 years art/sqlite370.eps
[af353bd8] Adding original art for the new SQLite logo. (user: drh, branch: trunk)
3.04 years test/tkt-f973c7ac31.test
[6eb058dd] Fix for ticket [f973c7ac31]. (user: dan, branch: trunk)
3.04 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)
3.04 years test/capi3b.test
[c2edf8e1] Refactor some of the global variables and commands used by tester.tcl. (user: dan, branch: trunk)
3.06 years test/rowhash.test
[28efe0a4] In the rowhash.test, make sure global variables are cleared prior to use. (user: drh, branch: trunk)
3.11 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)
3.11 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)
3.16 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)
3.19 years test/select2.test
[defaf0d9] Further refinements to table order selection on join query planning. (user: drh, branch: trunk)
3.25 years test/fts3ac.test
[d37034f7] Fix for [9861b74ab9]. Correctly handle strings with zero tokens in the fts3 offsets() function. (user: dan, branch: trunk)
3.25 years test/init.test
[ad68fa65] Disable the "init.test" test script when compiled with SQLITE_THREADSAFE=0. (user: drh, branch: trunk)
3.27 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)
3.30 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)
3.32 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)
3.32 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)
3.32 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)
3.33 years src/complete.c
[7c4cca6d] Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging output for CORRUPT, and CANTOPEN errors. (user: drh, branch: trunk)
3.33 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.44 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.45 years tool/restore_jrnl.tcl
[08c545f0] Added option to restore_jrnl.tcl utility to hex dump journal pages. (user: shaneh, branch: trunk)
3.46 years test/fts3al.test
[8a208223] Change the fts3 snippet function to return (hopefully) more relevant snippets in less time. (user: dan, branch: trunk)
3.47 years test/fuzz2.test
[97f8a886] Minor changes to test scripts to support various SQLITE_OMIT options. (user: shaneh, branch: trunk)
3.51 years test/trace.test
[85e3c734] Fixed some TCL test cases to work if SQLITE_OMIT_TRIGGER is defined. (user: shaneh, branch: trunk)
3.54 years test/fts3ad.test
[5030ba2e] Add extra tests for parsing of whitespace in tokenizer declarations,. (user: dan, branch: trunk)
3.55 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.58 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.61 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.61 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.61 years test/func2.test
[d7b3801d] Update comment for substrFunc(). Added additional SUBSTR() test cases. (user: shaneh, branch: trunk)
3.61 years test/coalesce.test
[d0591258] Additional test cases for the coalesce() and ifnull() functions. (user: drh, branch: trunk)
3.61 years test/intarray.test
[0c8db5d8] Additional intarray test cases and tweaks to comments. (user: drh, branch: trunk)
3.62 years ext/rtree/rtree_perf.tcl
[f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (user: drh, branch: trunk)
3.63 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.67 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.70 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.73 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.74 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.75 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.75 years test/tkt3201.test
[fb6ceed3] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (user: dan, branch: trunk)
3.76 years test/fkey1.test
[d5d39981] Check in implementation of foreign key constraints. (user: dan, branch: trunk)
3.78 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.80 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.81 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.81 years test/trigger9.test
[9eb91efd] Fixes for new triggers scheme. (user: dan, branch: trunk)
3.82 years test/trigger8.test
[9b9c1921] Changes to support recursive triggers. (user: dan, branch: trunk)
3.83 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.85 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.86 years test/whereB.test
[06098505] Tweak to the new whereB.test file to make it more consistent. (user: drh, branch: trunk)
3.86 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.90 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.92 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.94 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.97 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.98 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.98 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)
4.01 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)
4.01 years test/tkt3918.test
[368e44ec] Fix for #3918. Also, fix the TRACE macros in balance_nonroot(). (CVS 6772) (user: danielk1977, branch: trunk)
4.03 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)
4.04 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)
4.05 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)
4.05 years test/corrupt5.test
[453ff88f] Minor updates to comments in test scripts. (CVS 6714) (user: shane, branch: trunk)
4.06 years test/colname.test
[2472f6db] Add a test case for ticket #3893 and ticket #3894. (CVS 6705) (user: drh, branch: trunk)
4.07 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)
4.07 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)
4.14 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)
4.15 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)
4.16 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)
4.16 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)
4.17 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)
4.18 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)
4.20 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)
4.21 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)
4.21 years test/tkt2767.test
[277dace4] Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464) (user: danielk1977, branch: trunk)
4.22 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)
4.23 years test/tkt3761.test
[8c1d0c6a] Make sure a ROLLBACK that follows an incremental vacuum works. Ticket #3761. (CVS 6416) (user: drh, branch: trunk)
4.24 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)
4.30 years ext/fts1/fts1.c
[6404afa0] Corrected typos and misspellings. Ticket #3702. (CVS 6336) (user: shane, branch: trunk)
4.32 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)
4.34 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)
4.36 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)
4.38 years test/schema2.test
[f92405af] Simplify wording of backup API error message. Decapitalize some other error messages. (CVS 6256) (user: drh, branch: trunk)
4.38 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)
4.38 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)
4.39 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)
4.40 years aclocal.m4
[813a3c96] regenerate autotools (CVS 6211) (user: vapier, branch: trunk)
4.44 years test/tkt3581.test
[f5f5ef64] Here is the test case to prove that ticket #3581 is fixed. (CVS 6174) (user: drh, branch: trunk)
4.45 years test/mallocJ.test
[6e171c0a] More coverage improvements. (CVS 6148) (user: drh, branch: trunk)
4.45 years test/mallocK.test
[1e5725c5] Increased test coverage in where.c. (CVS 6146) (user: drh, branch: trunk)
4.46 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.46 years test/fuzz3.test
[77dc19cf] Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110) (user: drh, branch: trunk)
4.47 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.47 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.47 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.52 years test/randexpr1.tcl
[4685ffcc] Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029) (user: drh, branch: trunk)
4.52 years test/tkt3541.test
[ea9b747e] Convert the "~" and "NOT" operators to be two-address instructions. Ticket #3541. (CVS 6028) (user: drh, branch: trunk)
4.53 years test/tkt3346.test
[4f10f19d] Additional test cases for nested subqueries in a WHERE clause. (CVS 5999) (user: drh, branch: trunk)
4.55 years test/tkt3522.test
[06d206ef] Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979) (user: drh, branch: trunk)
4.62 years test/utf16align.test
[3f657e88] Prevent buffer overruns when converting malformed UTF16 to UTF8. Ticket #3482. (CVS 5869) (user: drh, branch: trunk)
4.63 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.64 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.65 years test/laststmtchanges.test
[e68e4282] Make sqlite3_count_changes() and total_changes() work with "DELETE FROM ". (CVS 5844) (user: danielk1977, branch: trunk)
4.69 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.70 years mkdll.sh
[66f57ecb] Added -DSQLITE_ENABLE_RTREE=1 to the mkdll.sh script. Ticket #3427. (CVS 5810) (user: shane, branch: trunk)
4.70 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.70 years tool/mkspeedsql.tcl
[2d427746] New speed testing tools. (CVS 5786) (user: drh, branch: trunk)
4.71 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.71 years test/tkt3419.test
[c3cf54a1] Add a test script to verify that ticket #3419 stays fixed. (CVS 5771) (user: drh, branch: trunk)
4.73 years sqlite.pc.in
[efe095e0] fix #3077: use full version in pkg-config files (CVS 5746) (user: vapier, branch: trunk)
4.79 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.82 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.82 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.83 years test/collate8.test
[0d61960a] Additional coverage testing in the new name resolver module. (CVS 5608) (user: drh, branch: trunk)
4.83 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.84 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.84 years test/collate2.test
[daf730d1] Refactor the name resolution procedures in the code generator. (CVS 5569) (user: drh, branch: trunk)
4.86 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.88 years mkso.sh
[ce5daa03] Revise build scripts in set SQLITE_ENABLE_COLUMN_METADATA on DLLs. (CVS 5539) (user: drh, branch: trunk)
4.88 years test/cse.test
[9ca975c8] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (user: danielk1977, branch: trunk)
4.89 years test/mallocH.test
[2cd6bae8] Bring test coverage up to 99%. (CVS 5522) (user: drh, branch: trunk)
4.90 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.90 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.92 years test/fts2q.test
[c16900dc] Implement optimize() function. Backports check-in (5417) from fts3. (CVS 5458) (user: shess, branch: trunk)
4.92 years test/fts2p.test
[4e47394b] fts2 functions for testing scripts. Backports (5340) from fts3. (CVS 5456) (user: shess, branch: trunk)
4.92 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.95 years test/in2.test
[dcb16024] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (user: drh, branch: trunk)
4.95 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.96 years test/delete2.test
[96df0a5f] 3 more coverage tests for btree.c. (CVS 5370) (user: danielk1977, branch: trunk)
4.96 years test/tokenize.test
[fe80aa58] Testing coverage enhancements. (CVS 5358) (user: drh, branch: trunk)
4.99 years tool/soak1.tcl
[1e3b8308] Change the TEMP_STORE preprocessor symbol to SQLITE_TEMP_STORE. (CVS 5312) (user: danielk1977, branch: trunk)
4.99 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)
5.00 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)
5.03 years tool/speedtest8inst1.c
[98bdc7b4] Update utility program speedtest8inst1.c. (CVS 5201) (user: danielk1977, branch: trunk)
5.05 years ext/rtree/README
[9ab87b7b] Fix another typo in the rtree README file. (CVS 5187) (user: drh, branch: trunk)
5.07 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)
5.07 years ext/rtree/rtree.h
[aa8eba33] Update the amalgamation builder to incorporate the RTREE extension. (CVS 5160) (user: drh, branch: trunk)
5.07 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)
5.13 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)
5.14 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)
5.16 years test/vtabB.test
[776e7024] Add test cases to prove that ticket #3082 has been fixed. (CVS 5048) (user: drh, branch: trunk)
5.18 years test/speed1p.explain
[d11f5daf] Add speed-test scripts that also show EXPLAIN output. (CVS 5017) (user: drh, branch: trunk)
5.19 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)
5.20 years test/update.test
[1aaed6a4] Enhancements to the change counter tests. Ticket #3013. (CVS 4986) (user: drh, branch: trunk)
5.20 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)
5.22 years test/malloc9.test
[9987a7b1] Fix the output labels on the tests in malloc9. (CVS 4966) (user: drh, branch: trunk)
5.26 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)
5.27 years test/busy.test
[5e4df441] Add tests to make sure the busy handler resets. (CVS 4865) (user: drh, branch: trunk)
5.34 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)
5.35 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)
5.39 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)
5.39 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)
5.41 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)
5.42 years test/exec.test
[720bc20a] Miscellaneous test coverage improvements. (CVS 4734) (user: drh, branch: trunk)
5.42 years test/ioerr3.test
[010f7b78] Additional test coverage improvements. Test coverage now stands at 98.73%. (CVS 4731) (user: drh, branch: trunk)
5.43 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.44 years test/select8.test
[a6dddebc] Continuing work toward converting the VM into a register machine. (CVS 4707) (user: drh, branch: trunk)
5.53 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.53 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.54 years test/where4.test
[0b34a186] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (user: danielk1977, branch: trunk)
5.60 years test/fts2g.test
[75cb46f8] Don't do anything when input doclists are both empty. Ticket #2774 (CVS 4546) (user: shess, branch: trunk)
5.77 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.78 years test/tkt2643.test
[2cfdbfe6] Fix incorrect index cost assumptions that occur after an ANALYZE. Ticket #2643. (CVS 4424) (user: drh, branch: trunk)
5.78 years test/badutf.test
[c8405b15] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (user: danielk1977, branch: trunk)
5.80 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.84 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.84 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.87 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.90 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.90 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.91 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.91 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.93 years mkextu.sh
[e269f6e9] Updates to build scripts. Added scripts for building FTS2 shared libraries. (CVS 4171) (user: drh, branch: trunk)
5.99 years ext/fts2/mkfts2amal.tcl
[bbdcf372] Remove the unused EXTSRC variable from the non-configure makefile. (CVS 4129) (user: danielk1977, branch: trunk)
6.00 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)
6.00 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)
6.00 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)
6.02 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)
6.04 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)
6.04 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)
6.07 years test/tkt2391.test
[f9a95e92] Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040) (user: danielk1977, branch: trunk)
6.09 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)
6.09 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)
6.14 years test/format4.test
[b94d39e4] Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918) (user: drh, branch: trunk)
6.16 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)
6.17 years test/misc6.test
[25c1c7aa] Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865) (user: drh, branch: trunk)
6.19 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)
6.19 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)
6.21 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)
6.31 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)
6.33 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)
6.33 years test/fts1f.test
[16cb00ad] Fix typos in test naming (was using 'e' instead of 'f'). (CVS 3655) (user: shess, branch: trunk)
6.36 years tool/fragck.tcl
[bd6bc3b8] Changes to support fragmentation analysis in sqlite3_analyzer. (CVS 3634) (user: drh, branch: trunk)
6.41 years test/fts2i.test
[310f6858] Do not run the fts2i.test unless the FTS2 module is available. (CVS 3601) (user: drh, branch: trunk)
6.41 years test/fts1i.test
[810c0176] Do not run test fts1i.test if FTS1 is not installed. (CVS 3600) (user: drh, branch: trunk)
6.46 years test/threadtest2.c
[06216d0d] Get threadtest2.c working again after being long neglected. (CVS 3562) (user: drh, branch: trunk)
6.56 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.68 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.68 years test/fts1e.test
[b01c4371] Add tests for delete and update in fts1. (CVS 3481) (user: shess, branch: trunk)
6.70 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.72 years test/fts1c.test
[6cf1fb9f] The snippet generator adds ellipsis between text from different columns. (CVS 3465) (user: drh, branch: trunk)
6.72 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.73 years ext/fts1/fts1_tokenizer.h
[936b06aa] Add a Porter stemmer option to the FTS1 module. (CVS 3452) (user: drh, branch: trunk)
6.73 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.76 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.78 years ext/fts1/fts1.h
[d4edb803] Earlier refactoring changed name in fts1.c but not fts1.h. (CVS 3413) (user: shess, branch: trunk)
6.81 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.81 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.82 years ext/fts1/fulltext.c
[58006e38] Make static some symbols which shouldn't have been exported. (CVS 3371) (user: shess, branch: trunk)
6.83 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.84 years ext/README.txt
[7f152f9f] Add the ext/fts1 subdirectory for holding the first full-text search extension. (CVS 3360) (user: drh, branch: trunk)
7.00 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)
7.01 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)
7.14 years test/aggerror.test
[8f820e43] Faster :memory: database COMMITs. Ticket #1790. (CVS 3178) (user: drh, branch: trunk)
7.31 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)
7.36 years test/tkt1644.test
[c468aa34] Minor test file modifications for builds compiled with OMIT options. (CVS 3077) (user: danielk1977, branch: trunk)
7.43 years test/between.test
[3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (user: danielk1977, branch: trunk)
7.44 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.51 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.58 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.61 years test/sort.test
[ce06c123] Create separate affinities for INTEGER and REAL. (CVS 2766) (user: drh, branch: trunk)
7.75 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.83 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)
8.14 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)
8.24 years test/join4.test
[c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (user: danielk1977, branch: trunk)
8.33 years sqlite3.1
[5c99bea5] Revised man page from Bill Bumgarner. (CVS 2360) (user: drh, branch: trunk)
8.42 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.42 years test/join3.test
[d8b2a7e0] Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (user: drh, branch: trunk)
8.65 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.88 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.98 years test/threadtest1.c
[ffd3312b] Bug-fixes to get the two threadtest C programs working again. (CVS 1756) (user: danielk1977, branch: trunk)
9.10 years test/varint.test
[61bdb53a] New varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395) (user: drh, branch: trunk)
9.37 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)
10.17 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.58 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.97 years tool/diffdb.c
[00f83c25] Prepare for the 2.5.5 release. (CVS 661) (user: drh, branch: trunk)
11.12 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)
11.30 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.74 years install-sh
[00575d16] Put in the new LIBTOOL build system. (CVS 271) (user: drh, branch: trunk)
13.07 years tool/opcodeDoc.awk
[6f3655f7] initial check-in of the new version (CVS 1) (user: drh, branch: trunk)