File Ages
Not logged in

Files in [f7cc30d45b] ordered by check-in time

Times are relative to the checkin time for [f7cc30d45b] which is 2013-10-08 23:16:48.

current src/analyze.c
[f7cc30d45b] Move a conditional inside of an #ifdef in order to make all branches reachable regardless of compile-time options used. (user: drh, branch: row-size-est)
51.4 minutes test/pragma.test
[dd03be1065] Fix test cases for the new information in PRAGMA index_list. (user: drh, branch: row-size-est)
2.6 hours src/where.c
[65553ff34b] Rollback some of the previous changes in the branch such that the estimated row sizes are now only used as a tie-breaker for index scans. (user: drh, branch: row-size-est)
3.3 hours src/select.c
[3fd5e33217] Use #ifdefs to omit unused code in the columnType() routine depending on compile-time options. (user: drh, branch: row-size-est)
4.6 hours src/build.c
[18bd6ba96d] Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. (user: drh, branch: row-size-est)
1.5 days src/btree.c
[1d7b2dc0ea] Merge bug fixes from trunk. (user: drh, branch: row-size-est)
3.1 days src/test8.c
[029430c503] Fix an issue in the test8.c test module that arises because of the change to PRAGMA index_list(). Remove an unused local variable. (user: drh, branch: row-size-est)
3.2 days src/sqliteInt.h
[8b4aa0c7a2] Completely remove the iScanRatio field. The PRAGMA index_list(TABLE) command shows the estimated row size in the forth column. It also generates a row for the table with an index name of NULL. The query planner still does not take row size estimates into account - that is the next step. (user: drh, branch: row-size-est)
3.2 days tool/logest.c
[5252aeb619] Improvements to the LogEst command-line tool used to convert between ordinary numbers and the LogEst representation. (user: drh, branch: row-size-est)
3.2 days src/util.c
[66c4a251d6] Begin an experimental refactoring to estimate the average number of bytes in table and index rows and to use that information in query planner. Begin by renaming WhereCost to LogEst and making that type and its conversion routines available outside of where.c. (user: drh, branch: row-size-est)
4.1 days ext/fts3/fts3.c
[c6ac80ed8d] Merge trunk changes. (user: drh, branch: index-scan-rate)
4.3 days test/eqp.test
[2f394de88f] Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. (user: drh, branch: index-scan-rate)
4.3 days src/expr.c
[07462bb605] Improved estimates of the relative speed of index scans based on declared datatypes of columns in the table. Add "r" column to PRAGMA index_info, showing the estimated relative scan rate. (user: drh, branch: index-scan-rate)
4.9 days test/analyze6.test
[6c352edbba] Progress toward using the iScanRatio information on indices. Many tests are still failing. (user: drh, branch: index-scan-rate)
5.3 days src/attach.c
[500c5932fe] The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". (user: drh, branch: trunk)
5.4 days test/triggerE.test
[f35f6ae3da] Return an error if an attempt is made to create a trigger with an SQL variable embedded within it. If such a variable reference is found within a trigger definition loaded from the sqlite_master table, silently replace it with a NULL. (user: dan, branch: trunk)
5.5 days src/tclsqlite.c
[eec3187bc6] Remove unnecessary memset() calls from test code. (user: drh, branch: trunk)
6.1 days tool/lemon.c
[8d399a03de] In the lemon parser generator, change all hashes to unsigned to avoid potential problems with signed integer overflow. (user: drh, branch: trunk)
7.1 days src/btreeInt.h
[012d54d0d2] Bring some file format comments in btreeInt.h up to date. (user: drh, branch: trunk)
7.2 days tool/fast_vacuum.c
[e0db7b38e1] Fix comments in the fast_vacuum.c demonstration program. (user: drh, branch: trunk)
7.3 days src/shell.c
[473234632f] Change the ".dump" command in the command-line shell so that it COMMITs if there are database corruption errors but invokes ROLLBACK on any other kind of error. (user: drh, branch: trunk)
8.2 days test/amatch1.test
[ad71c72be5] Add some timing tests to the amatch test script. (user: drh, branch: trunk)
8.2 days test/fts3snippet.test
[fa0f2f0e3e] Fix a performance problem in the FTS4 auxiliary functions triggered by an OR clause in the full-text query. (user: dan, branch: trunk)
8.2 days ext/misc/amatch.c
[604134732e] Fix memory leaks in the amatch extension. Add a few simple test cases. (user: drh, branch: trunk)
8.5 days src/vacuum.c
[94c914e3fa] Update and modernize an obsolete comment associated with VACUUM. No changes to code. (user: drh, branch: trunk)
9.8 days ext/misc/nextchar.c
[0b7bd46825] Fix typo in comment. No changes to code. (user: mistachkin, branch: trunk)
10.3 days test/fts3defer3.test
[a6cd14effe] Add new test file fts3defer3.test. (user: dan, branch: trunk)
10.4 days test/spellfix.test
[59b9fa2236] In the nextchar.c extension, allow the second argument to the next_char() function to be a subquery. (user: drh, branch: trunk)
10.4 days tool/spaceanal.tcl
[3e5c7771fa] Updates to the sqlite3_analyzer utility: Change the names of some labels, especially change "Fragmentation" to "Non-sequential pages". Revise the computation of non-sequential pages so that it ignores itercalated non-leaf pages (overflow and index pages). (user: drh, branch: trunk)
12.3 days src/delete.c
[1f8f4fdf3f] Obtain the required shared-cache write-lock when executing "DELETE FROM tbl" statements. Fix for 1e1321ee98. (user: dan, branch: trunk)
12.5 days test/shared3.test
[1e1321ee98] Fix a faulty assert() in sqlite3BtreeBeginTrans() that may fail in shared-cache mode. (user: dan, branch: trunk)
20.5 days test/fts4unicode.test
[ed24051462] Test that the unicode61 tokenchars= and separators= options work with the fts3tokenize virtual table. (user: dan, branch: trunk)
21.0 days src/vdbeaux.c
[cebd6fc551] Clear the current time value on prepared statements when the prepared statement is reset. (user: drh, branch: trunk)
22.1 days src/sqlite3.rc
[e645906257] Readability improvements to the Win32 RC file. (user: mistachkin, branch: trunk)
22.4 days src/date.c
[daf6ba413c] The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). (user: drh, branch: trunk)
25.0 days src/os_win.c
[d5fc3f1dab] Fix Windows SDK compiler warning. (user: mistachkin, branch: trunk)
25.0 days test/bigfile2.test
[650b32825a] Fix test issues for Windows portability. (user: mistachkin, branch: trunk)
25.0 days Makefile.msc
[d56fac4031] VSIX tooling changes to support Visual Studio 2013. (user: mistachkin, branch: trunk)
25.1 days test/softheap1.test
[c326356f9a] Add the soft_heap_limit pragma. (user: drh, branch: trunk)
25.2 days src/func.c
[bc446449a1] Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms. (user: drh, branch: trunk)
25.3 days src/malloc.c
[870c030b4e] Change the PRAGMA parser to use a binary search for the pragma name. Also: Minor performance enhancement to sqlite3DbFree() and to the token dequoter. (user: drh, branch: trunk)
27.3 days test/tpch01.test
[eb5cef8351] Add test cases to cover TPC-H Q8. (user: drh, branch: trunk)
32.4 days src/callback.c
[97b10e66e9] Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single new FuncDef.funcFlags field. (user: drh, branch: trunk)
33.2 days src/fkey.c
[e940b5de49] When preparing an UPDATE statement, avoid generating VDBE code for those foreign key related actions and constraint checks that may be seen to be unnecessary by considering the subset of table columns potentially modified by the UPDATE. (user: dan, branch: trunk)
34.3 days test/analyzeB.test
[f929e9b41f] Add tests to improve coverage when SQLITE_ENABLE_STAT3 is defined. (user: dan, branch: trunk)
34.3 days src/vdbemem.c
[eb21663271] The sqlite3Stat4ProbeSetValue() routine should always return results using the database encoding. (user: drh, branch: trunk)
38.2 days src/mem2.c
[c94933f132] Cleanup of the windows VFS, including added support for Cygwin, fixes for compiler warnings under unusual configurations, and improved diagnostic error messages. (user: drh, branch: trunk)
38.3 days test/alter.test
[d9fadc8fa6] Reenable a test accidentally disabled when the stat4 branch was merged. (user: dan, branch: trunk)
39.2 days test/whereF.test
[79e458ef7a] If the cost of two whereLoop objects is the same in every way except that one has fewer expected output rows than the other, then choose the one with fewer output rows. (user: drh, branch: trunk)
40.5 days test/tkt-9f2eb3abac.test
[c1152bdcbb] Candidate fix for [9f2eb3abac]: Have the whereShortCut() planner ignore indexes with more than four columns. (user: dan, branch: trunk)
40.9 days test/tester.tcl
[9229aeb361] Small enhancements to unit testing infrastructure. (user: mistachkin, branch: trunk)
41.2 days test/wild001.test
[4f182ddc36] Re-enable test file wild001.test. (user: dan, branch: trunk)
41.2 days configure
[12d0a8859d] Add the win32-longpath VFS allowing windows filenames up to 32K characters in length. Remove unused code when -DSQLITE_MAX_MMAP_SIZE=0. Fix some compiler warnings on windows. (user: drh, branch: trunk)
41.4 days VERSION
[41c089e2a2] Increase the version number to 3.8.1 due to the addition of STAT4 support. (user: drh, branch: trunk)
42.3 days sqlite3.pc.in
[2460dfd882] Update sqlite3.pc.in to use @PACKAGE_VERSION@ instead of @RELEASE@. (user: dan, branch: trunk)
43.0 days src/alter.c
[a32af0abe5] Merge the STAT4 capability into trunk. (user: drh, branch: trunk)
46.3 days test/e_insert.test
[3ad1f998e5] Fix a requirements comment in a test case. No changes to the testcase itself nor to any code. (user: drh, branch: trunk)
46.5 days tool/mkautoconfamal.sh
[375b4e3db0] Modify script mkautoconfamal.sh to use the download.html naming convention for the tar.gz it creates. (user: dan, branch: trunk)
48.0 days src/backup.c
[617e23ec28] Simplify the btreeGetPage() routine so that it uses a single flag parameter in place of two boolean parameters. (user: drh, branch: trunk)
48.0 days src/random.c
[4144dffb57] Refactor the sqlite3_randomness() implementation for improved performance. (user: drh, branch: trunk)
48.1 days src/printf.c
[700dbbea86] Simplification to the StrAccum object and the sqlite3StrAccumAppend() method that also results in slightly better performance. (user: drh, branch: trunk)
48.1 days test/malloc5.test
[ef2a6a3736] Minor fixes for test cases. No code changes. (user: dan, branch: trunk)
48.1 days test/collate2.test
[f9859fe93b] Fix typo in test. (user: mistachkin, branch: trunk)
48.7 days test/malloc_common.tcl
[a95ae93b32] Fix a minor problem in progress.test. No code changes. (user: dan, branch: trunk)
49.1 days test/corruptG.test
[356c6c5931] Fix a couple of test scripts to work with DEFAULT_AUTOVACUUM and OMIT_VIRTUALTABLE. (user: dan, branch: trunk)
49.3 days test/indexedby.test
[ef192abb82] Fix an invalid assert() in where.c. Also a crash that can occur in the EXPLAIN QUERY PLAN code under obscure circumstances. (user: dan, branch: trunk)
49.3 days test/where3.test
[e476408e3c] Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. (user: drh, branch: trunk)
50.2 days test/pragma2.test
[6acf728100] Fix test script pragma2.test so that it works with ENABLE_MEMORY_MANAGEMENT. (user: dan, branch: trunk)
50.2 days ext/fts3/fts3_snippet.c
[1c63e9515b] Add some extra assert() statements to silence a few clang warnings. (user: dan, branch: trunk)
52.3 days src/btree.h
[65a85a156f] Add the cache_spill pragma. Change the fullfsync and checkpoint_fullfsync pragmas to apply to all attached databases. (user: drh, branch: trunk)
54.0 days test/resolver01.test
[f2d175f975] Make sure that GROUP BY terms select input column names in preference to output column names, in compliance with the SQL standard. Ticket [1c69be2dafc28]. (user: drh, branch: trunk)
54.1 days test/tkt2822.test
[c78b357c00] Bare identifiers in ORDER BY clauses bind more tightly to output column name, but identifiers in expressions bind more tightly to input column names. This is a compromise between SQL92 and SQL99 behavior and is what PostgreSQL and MS-SQL do. Ticket [f617ea3125e9c]. (user: drh, branch: trunk)
56.0 days src/mem5.c
[9e999081a5] Fix a few more minor comment typos. No changes to code. (user: mistachkin, branch: trunk)
62.4 days src/test_intarray.h
[0ad83ceb79] Add a guard #ifndef to test_intarray.h to prevent harm if it is #included more than once. Add a comment on the closing #endif of the guards on sqlite3.h and test_multiplex.h. (user: drh, branch: trunk)
63.2 days src/test_autoext.c
[89930ea3c3] Adjust #ifdefs in test_autoext.c so that it compiles with SQLITE_OMIT_LOAD_EXTENSION. Fix compiler warnings in two other test modules. No changes to the core. (user: drh, branch: trunk)
63.6 days mkopcodeh.awk
[924f7e4d7a] More than double the speed of the resolveP2Values() routine in vdbeaux.c by moving from an extended if-else on every opcode to a switch. Opcodes are reordered in mkopcodesh.awk to put the switched opcodes close together, for additional performance and to reduce code footprint. (user: drh, branch: trunk)
64.1 days ext/misc/vtshim.c
[240f7252c6] For the vtshim module, always zero out the xChildDestroy function pointer after calling it. (user: mistachkin, branch: trunk)
64.4 days src/test_rtree.c
[4b8b426f10] Add a missing '#include "tcl.h"' to test_rtree.c. (user: drh, branch: trunk)
67.0 days src/tokenize.c
[213020769f] Updates to requirements marks. No code changes. (user: drh, branch: trunk)
67.3 days src/vdbe.h
[478113f18b] Add support for partial indices. (user: drh, branch: trunk)
68.0 days test/index.test
[e3c8935f87] Fix the CREATE INDEX statement so that trying to create a TEMP index on a non-TEMP table throws an error rather than segfaulting. (user: drh, branch: trunk)
71.3 days src/test_vfs.c
[c0809b5e32] Comment and preprocessor macro cleanup. (user: drh, branch: trunk)
71.4 days main.mk
[a94a66d10f] In main.mk, always recompile vdbe.o and parse.o first, since changes to either parse.y or vdbe.c will cause all files to be recompiled and if there are syntax errors in vdbe.c or parse.y we want to hit them early in the compile process. (user: drh, branch: trunk)
81.0 days test/func.test
[f755b4b21c] Fixes to test numbering. (user: mistachkin, branch: trunk)
82.4 days ext/misc/regexp.c
[7acc8cd32d] Documentation changes to warn that sqlite3_set_auxdata() might call the destructor even before it returns. Also fix the regexp extension to deal with that case. Ticket [406d3b2ef91c]. (user: drh, branch: trunk)
83.1 days ext/misc/closure.c
[b1b0de29fd] Fix copy/paste errors in comments in the transitive_closure virtual table. No changes to code. (user: drh, branch: trunk)
84.0 days src/prepare.c
[20dba3a7fb] Make sure the sqlite3_prepare16 and sqlite3_prepare16_v2 interfaces do not read past a zero-terminator if the nBytes parameter is too large. (user: drh, branch: trunk)
84.1 days test/where8.test
[5e19d05410] Enhance the query planner so that it looks at multiple solutions to OR expressions in the WHERE clause. (user: drh, branch: trunk)
85.3 days src/loadext.c
[cdce87eb88] Add the sqlite3_cancel_auto_extension(X) interface which will undo a prior call to sqlite3_auto_extension(X). (user: drh, branch: trunk)
89.3 days test/fkey6.test
[6557c40798] Add the experimental "query_only" pragma. (user: drh, branch: trunk)
89.3 days src/status.c
[527121ac3c] Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS value for sqlite3_db_status(). This is a cherry-pick of a sequence of five checkins in the sessions branch between 1d44e5d3c2 and d39e65fe70. (user: drh, branch: trunk)
91.3 days ext/misc/spellfix.c
[f003bea9fe] Adjust the costs in the xBestIndex function of the spellfix1 virtual table to force the use of the MATCH term if it is available. (user: drh, branch: trunk)
91.4 days ext/fts1/fts1.c
[1e39f85077] Modify several extensions to use the new exported function naming. Fix some shared library compilation issues. (user: drh, branch: trunk)
91.8 days test/select9.test
[52a49cbc16] Make sure the schema is verified prior to processing a "WHERE 0" on the first term of a compound SELECT statement. Fix for ticket [490a4b723562429] (user: drh, branch: trunk)
92.1 days test/transitive1.test
[3b30b75b34] Fix an adverse interaction between the IS NOT NULL optimization (available only with SQLITE_ENABLE_STAT3) and the transitive constraint processing. Fix for ticket [d805526eae253] (user: drh, branch: trunk)
94.2 days test/memsubsys1.test
[cdb97d41ab] Fixes for test cases running in the "mmap" permutation. (user: dan, branch: trunk)
94.2 days test/mmapfault.test
[0ae7e75b21] Drop any existing mapping of the database file when exiting the pager "error state", as it may at this point be too large for the database file. Do not invoke file-control MMAP_SIZE if the database file handle does not support xFetch and xUnfetch (on the grounds that xUnfetch(0) calls to invalidate the mapping cannot be made). (user: dan, branch: trunk)
95.2 days test/autoindex1.test
[60cf7e4487] Fix two test script problems revealed by permutations.test. (user: dan, branch: trunk)
95.3 days test/mmap3.test
[ff8c3f7840] Replace an erroneous SQLITE_OMIT_VIRTUAL_TABLE in vdbeaux.c with SQLITE_OMIT_WAL. Also fix some test script problems. (user: dan, branch: trunk)
95.5 days ext/misc/percentile.c
[9676280a93] Make a couple of implicit casts explicit to fix compiler warnings. (user: dan, branch: trunk)
99.0 days ext/misc/ieee754.c
[1c3ed47b71] Fix harmless typos in comments of two extensions. (user: drh, branch: trunk)
99.2 days test/tkt-868145d012.test
[72919ec34f] Add a missing test that prevented double LEFT JOINs with transitive constraints from working correctly. Fix for ticket [868145d012]. (user: drh, branch: trunk)
102.1 days test/wal6.test
[f308c48517] Allow read transactions to be freely opened and closed by SQL statements run from within the implementation of user-functions if the user-function is called by a SELECT statement that does not access any database tables (e.g. "SELECT user_function();"). (user: dan, branch: trunk)
103.0 days src/vdbetrace.c
[14f7969634] Refactor names of fields in the sqlite3 object: "activeVdbeCnt" becomes "nVdbeActive". Related fields becomes "nVdbeRead", "nVdbeWrite", and "nVdbeExec". (user: drh, branch: trunk)
103.2 days test/capi3d.test
[1937fd8eec] Make sure that sqlite3_stmt_readonly reports false for PRAGMA journal_mode and PRAGMA wal_checkpoint. Ticket [a589ec069e3]. Also keep track of whether a prepared statement does no reading or writing. (user: drh, branch: trunk)
103.5 days src/wal.c
[361c22969a] Add extended error code SQLITE_BUSY_SNAPSHOT - returned in WAL mode when a read-transaction cannot be upgraded to a write-transaction because it is reading from a snapshot other than the most recently committed. (user: dan, branch: trunk)
104.3 days test/boundary3.tcl
[ebac5afa47] Update the boundary3.tcl script so that it can be run with tcl 8.5 or 8.6 to regenerate boundary3.test. (user: dan, branch: trunk)
104.5 days ext/misc/fuzzer.c
[0fe31f60ca] Cut over the next generation query planner. Increase the version number to 3.8.0. (user: drh, branch: trunk)
109.2 days test/fts4noti.test
[361084e1eb] Merge the fts4-notindexed branch with the trunk. (user: dan, branch: trunk)
119.4 days ext/fts3/fts3_expr.c
[24fc9d4438] Add the SQLITE_FTS3_MAX_EXPR_DEPTH compile time option. (user: dan, branch: trunk)
121.1 days test/collate1.test
[7e3820e5b9] Fix the memory leak in CREATE TABLE that occurs if there are two or more COLLATE clauses on the same column. (user: drh, branch: trunk)
125.3 days ext/fts3/fts3_unicode2.c
[6cfd9af525] 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)
132.4 days test/fts4merge4.test
[09e5a7ad85] Add tests for running FTS 'merge' and 'optimize' commands in shared cache mode. (user: dan, branch: trunk)
133.1 days Makefile.in
[a64d760d92] Add the percentile() SQL function as a loadable extension in the ext/misc directory. (user: drh, branch: trunk)
133.5 days src/vdbesort.c
[a0d5cc9315] Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. (user: drh, branch: trunk)
133.5 days autoconf/INSTALL
[a72f50ef76] Merge autoconf-package branch with trunk. (user: dan, branch: trunk)
134.5 days test/trace2.test
[3cd2da42e9] 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)
138.1 days magic.txt
[dab6a32847] Add OGC GeoPackage files to the magic.txt database. (user: drh, branch: trunk)
144.3 days src/test_syscall.c
[0f355bb17f] 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)
144.4 days mptest/multiwrite01.test
[d0c2288c72] Use sum() instead of total() in mptest/multiwrite01.test too. (user: drh, branch: trunk)
144.4 days mptest/crash01.test
[8ba0fc9811] Use sum() instead of total() in the mptest/crash01.test script. (user: drh, branch: trunk)
144.5 days test/mmap1.test
[cec0a06c17] Add extra "PRAGMA mmap_size = N" statements to mmap1.test and mmap2.test. (user: dan, branch: trunk)
146.2 days test/closure01.test
[00231fb012] Fixes to allow testfixture to be compiled with SQLITE_OMIT_VIRTUAL_TABLE defined. (user: dan, branch: trunk)
146.3 days test/sharedA.test
[5cc1cc55d2] Make sure an sqlite3_close() or a rollback on one shared-cache connection does not disrupt the operation of other connections using the same shared cache. Fix for ticket [e636a050b709]. (user: drh, branch: trunk)
146.3 days test/collate3.test
[b10b9e758b] Extra test for commit 6dae62c4e5. (user: dan, branch: trunk)
146.4 days ext/misc/rot13.c
[8f9bd8e7a8] Add the rot13.c loadable extension. (user: drh, branch: trunk)
152.9 days src/test2.c
[610425f190] Refine and reform all Windows OSTRACE macro usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. (user: mistachkin, branch: trunk)
153.3 days ext/fts3/fts3_tokenize_vtab.c
[1fa8c45739] Fix a couple of harmless compiler warnings in the fts3_tokenize virtual table. (user: drh, branch: trunk)
153.3 days test/selectA.test
[ce853a7506] Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Fix for ticket [6709574d2a8d8]. (user: drh, branch: trunk)
153.4 days ext/misc/wholenumber.c
[7227b61512] Fix the wholenumber virtual table so that it returns higher costs for unconstrained usage. Cherrypick from ceff8955020cd13. (user: drh, branch: trunk)
158.3 days tool/showdb.c
[b2efe4f225] Allocate meta(8) in the header as the "application ID" and add the "PRAGMA application_id" command to query and set it. (user: drh, branch: trunk)
159.2 days src/wal.h
[b81e87e72b] Minor fixes for compilation with SQLITE_OMIT_WAL defined. (user: dan, branch: trunk)
162.7 days test/fuzzerfault.test
[e81e9ca11d] 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)
166.2 days tool/build-shell.sh
[aabeea98f5] Fix the tool/build-shell.sh script to remove references to files that are now loadable extensions. (user: drh, branch: trunk)
166.3 days test/8_3_names.test
[bbe607c7d1] Merge the std-ext branch into trunk. This merge adds several new extensions to the ext/misc folder, including transitive_closure, ieee754, and amatch, and it converts some older src/test_*.c file into extensions in the ext/misc folder. (user: drh, branch: trunk)
166.9 days test/selectD.test
[39b4e6ff93] 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)
169.4 days src/test_sqllog.c
[206caf21f6] Enhanced documentation for the SQLITE_CONFIG_SQLLOG mechanism and the test_sqllog.c demonstration file. No changes to code. (user: drh, branch: trunk)
172.4 days test/loadext.test
[514adbbd8c] Add the "warning" command to the TCL test infrastructure. Fix problems with the loadext.test module. (user: drh, branch: trunk)
173.1 days mptest/mptest.c
[e94783f36a] Fix an incorrect comment (a copy/paste error) in the mptester. No code changes. (user: drh, branch: trunk)
175.3 days src/os.h
[16f7ba4afa] Remove the unused SQLITE_CURDIR macro. (user: drh, branch: trunk)
176.3 days mptest/config01.test
[ea1404a10a] 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)
179.3 days ext/fts3/fts3_aux.c
[546a187f13] 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)
181.5 days mptest/crash02.subtest
[f0d95afc73] Use symbolic names for tasks in mptester. (user: drh, branch: trunk)
181.8 days ext/rtree/rtree1.test
[0adf8a3a4f] Correct test numbering on several rtree tests. (user: mistachkin, branch: trunk)
185.2 days src/legacy.c
[c1d7304c80] 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)
185.5 days test/pager2.test
[07a0e4e982] Add tests to "permutations.test coverage-pager" to cover uncovered branches. (user: dan, branch: trunk)
186.1 days test/walfault.test
[b095e2cdb6] Improve the code coverage of "permutations.test coverage-pager". (user: dan, branch: trunk)
187.9 days src/pcache.h
[fff2be6077] Try to use mmap() to speed access to the database file on windows, linux, and mac. (user: drh, branch: trunk)
193.1 days Makefile.vxworks
[5687e5ee7b] For the clean target, tidy up a couple more generated (or copied) source files. (user: mistachkin, branch: trunk)
195.2 days test/orderby4.test
[2936f7466e] In order to optimize out the ORDER BY clause, outer loops must generate values for ORDER BY terms that are unique or else the inner loops must generate no more than a single row. Fix for ticket [a179fe7465]. (user: drh, branch: trunk)
195.8 days test/tkt-6bfb98dfc0.test
[322a5f086d] 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)
197.5 days test/fts3near.test
[5062db672c] Add a second test for [38b1ae018f]. (user: dan, branch: trunk)
201.1 days ext/fts1/ft_hash.h
[6f6e2d5094] Many spelling fixes in comments. No changes to code. (user: mistachkin, branch: trunk)
202.5 days test/numcast.test
[5b22053f91] 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)
203.3 days tool/mksqlite3h.tcl
[d1f41089ab] Bring makefiles and build scripts into alignment with the sessions branch. No changes to code. (user: drh, branch: trunk)
209.7 days test/tkt-4dd95f6943.test
[0b452734fa] Enhance tests for ticket [4dd95f6943]. (user: dan, branch: trunk)
210.0 days test/descidx3.test
[839aa91faf] Fix the ORDER BY with IN constraint logic so that it works with all combinations of DESC on the ORDER BY clause, on the RHS of the IN operator, and in the index used by ORDER BY and IN. Fix for ticket [4dd95f6943fbd18]. (user: drh, branch: trunk)
213.4 days test/triggerA.test
[e899b058a7] Add a test case for the problem fixed by the previous commit. (user: dan, branch: trunk)
215.6 days test/fts3ai.test
[e39391422e] Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16. (user: mistachkin, branch: trunk)
216.5 days test/incrvacuum_ioerr.test
[66576b450a] Fix a problem in incrvacuum_ioerr.test. Do not run ioerr6.test with an in-memory journal. (user: dan, branch: trunk)
216.9 days test/tkt-fc7bd6358f.test
[7097241c12] 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)
218.2 days test/view.test
[f40552ada5] Omit a test that uses the progress handler callback from view.test if OMIT_PROGRESS_HANDLER is defined. (user: dan, branch: trunk)
219.1 days test/index5.test
[b457c8870a] 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)
225.4 days test/tkt3762.test
[26e235b7a4] Merge the incr-vacuum-opt branch with the trunk. (user: dan, branch: trunk)
239.4 days test/capi2.test
[939d828274] Add extended error codes for all SQLITE_CONSTRAINT errors. (user: drh, branch: trunk)
251.9 days test/limit.test
[7d346250e8] Remove some debugging logic accidently left in the limit.test module. (user: drh, branch: trunk)
256.3 days tool/showwal.c
[93b159da5d] 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)
272.5 days test/orderby3.test
[7249bfc2ca] Fix the date on the new orderby3.test test case. (user: drh, branch: trunk)
277.0 days test/tkt3457.test
[e9ac533960] Remove superfluous text from a comment. (user: mistachkin, branch: trunk)
292.9 days test/fkey5.test
[e408dc9080] Add PRAGMA foreign_key_check. Name the child and parent tables as part of a "foreign key mismatch" error. (user: drh, branch: trunk)
293.3 days test/tkt-a7b7803e.test
[b3c9e8f812] Fix the segfault problem of ticket [a7b7803e8d1e869] which involved the use of "AS" named result columns as logical terms of the WHERE clause. (user: drh, branch: trunk)
294.3 days test/auth2.test
[9b67c633d9] Resolve names in FROM-clause subqueries prior to resolving names in the result set expressions of a SELECT statement. (user: drh, branch: trunk)
294.5 days src/journal.c
[8183d8d7ae] 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)
299.2 days test/minmax.test
[52e755943f] Generalize the min/max optimization so that if an appropriate index exists, the index it can be used by any aggregate query that contains only a single max() or min() and does not contain a GROUP BY clause. (user: drh, branch: trunk)
302.5 days test/releasetest.tcl
[75e545a9e2] 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)
304.1 days test/interrupt.test
[8542e6180d] Refactor collating-sequence handling as a fix for ticket [71e333e7d2e642]. The Expr.pColl field is removed from the Expr object. The COLLATE operator now becomes a separate instance of Expr in the expression tree. The code generator looks up the correct collating function as needed, rather than referring to Expr.pColl. (user: drh, branch: trunk)
305.2 days test/subquery2.test
[2d5f37c99a] 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)
305.6 days ext/async/README.txt
[930ba85262] Spelling and header fixes for the async extension. (user: mistachkin, branch: trunk)
306.0 days ext/async/sqlite3async.c
[c507ca4a8e] In the async VFS, treat the new error code SQLITE_IOERR_DELETE_NOENT as success for xDelete. (user: mistachkin, branch: trunk)
306.1 days test/triggerC.test
[79ef8e3c77] Merge the constant-refactoring-in-triggers branch with the trunk. (user: dan, branch: trunk)
306.2 days src/test_vfstrace.c
[1a63b1d5fa] 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)
307.3 days test/thread001.test
[51cbddd51d] Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. (user: dan, branch: trunk)
307.4 days test/shared_err.test
[40c143955e] 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)
307.6 days test/wal9.test
[04ab2dc691] Update a couple of test scripts so that they work in auto-vacuum mode. (user: dan, branch: trunk)
315.3 days test/fts3conf.test
[e38fb02d5e] Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly by REPLACE queries. (user: dan, branch: trunk)
337.4 days test/instr.test
[a4c181cbcf] Add the INSTR() SQL function. (user: drh, branch: trunk)
340.0 days test/aggnested.test
[4f7dfc32aa] Merge the fix for ticket [bfbf38e5e9956ac6] into trunk. (user: drh, branch: trunk)
343.2 days test/minmax2.test
[9dca18f5fe] Enable the use of coroutines as an alternative to manifesting views used in a FROM clause. (user: drh, branch: trunk)
354.9 days ext/fts2/fts2_icu.c
[aaa2d9b0db] Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. (user: drh, branch: trunk)
355.3 days src/hash.c
[5be96788a1] Merge Watcom compiler warning fixes into trunk. (user: drh, branch: trunk)
356.3 days test/crash7.test
[db9b1fa597] Add a test for the problem fixed by bf44d73d3e. (user: dan, branch: trunk)
364.2 days src/lempar.c
[7b1a6e6cb5] Attempt to suppress warnings generated by Coverity. (user: drh, branch: trunk)
1.01 years test/orderby2.test
[956e4d7f89] 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)
1.02 years test/tclsqlite.test
[c1f10a2643] 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)
1.03 years test/bigfile.test
[d869eddaf2] Disable the bigfile tests on Macs. (user: drh, branch: trunk)
1.03 years test/collate5.test
[1e874629d7] Query planner enhancements to be more agressive about optimizing out ORDER BY clauses - in particular the query planner now has the ability to omit ORDER BY clauses that span multiple tables in a join. (user: drh, branch: trunk)
1.03 years test/lock.test
[1a679a1ef3] Merge the "PRAGMA busy_timeout" change into trunk. (user: drh, branch: trunk)
1.05 years test/autovacuum.test
[ddd5d789e7] Merge the covering-index-scan optimization into trunk. (user: drh, branch: trunk)
1.06 years test/in5.test
[5ded9b6838] 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)
1.06 years tool/stack_usage.tcl
[030013ff0c] 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)
1.06 years tool/vdbe-compress.tcl
[e7db056a0d] 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)
1.07 years test/backcompat.test
[0ebe7cc574] Fix WAL capability checking in one of the test files. (user: mistachkin, branch: trunk)
1.07 years test/full.test
[c1a8557008] Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. (user: mistachkin, branch: trunk)
1.11 years test/select6.test
[200a81358c] 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)
1.12 years doc/lemon.html
[9b19b84753] Fix all known instances of 'repeated the' style typos in comments. No changes to code. (user: mistachkin, branch: trunk)
1.13 years test/fts3defer.test
[e799222f3b] Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (user: dan, branch: trunk)
1.14 years tool/checkSpacing.c
[be1faadebd] Change the checkSpacing utility program to ignore whitespace at end-of-line unless the --wseol option is used. (user: drh, branch: trunk)
1.14 years src/mem1.c
[7edd10a960] Remove tab characters from source code files. Replace them with spaces. (user: drh, branch: trunk)
1.17 years test/walthread.test
[a192a718d5] Fix a bug in walthread.test causing intermittent failures. (user: dan, branch: trunk)
1.23 years test/wal3.test
[e416359633] 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.30 years test/backup.test
[fb8893abee] Add the sqlite3_close_v2() interface (from the deferred-close branch) that allows close operations to happen out-of-order in bindings to garbage-collected langauges. (user: drh, branch: trunk)
1.30 years test/atof1.test
[4cebd60704] Merge changes to trunk that ensure that floating point values are exactly preserved on a round-trip through ".dump". (user: drh, branch: trunk)
1.30 years tool/mksqlite3c-noext.tcl
[eebd594d6b] Remove more references to OS/2. (user: mistachkin, branch: trunk)
1.30 years src/mutex.h
[ff828c67e5] Remove support for OS/2 from the source tree. (user: drh, branch: trunk)
1.34 years test/shared.test
[7caca1939c] Fix a problem preventing a shared in-memory database from being attached to a read-only connection. (user: dan, branch: trunk)
1.34 years test/capi3.test
[506008f000] Fix a malloc/free mismatch in pager.c (sqlite3_free() called on a buffer allocated by sqlite3DbMalloc()). (user: dan, branch: trunk)
1.34 years tool/warnings-clang.sh
[31fe1985ad] Fix harmless Clang warnings. (user: drh, branch: trunk)
1.34 years test/misc1.test
[61360ca6ca] Merge the changes need to compile on WinRT into trunk. (user: drh, branch: trunk)
1.34 years src/test_quota.h
[61669c9585] 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.37 years src/test_btree.c
[e72179f3a4] Merge into trunk the changes that permit :memory: databases to use shared cache. (user: drh, branch: trunk)
1.37 years ext/fts3/README.tokenizers
[25ba1f84f2] Merge fts4-unicode branch with trunk. (user: dan, branch: trunk)
1.38 years test/fuzz-oss1.test
[5519cc5ef4] Increase the version number to Minor changes to test scripts. (user: drh, branch: trunk)
1.41 years test/schema5.test
[e536ac0418] 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.41 years test/tkt-bdc6bbbb38.test
[f84d87bcc0] Before running each test script, make sure the FTS enhanced query syntax is disabled. (user: dan, branch: trunk)
1.41 years src/test_stat.c
[e68a3527de] Fix a harmless compiler warning inside an assert() statement within test code. (user: drh, branch: trunk)
1.46 years test/shell4.test
[9fb7da6904] Move the shell test scripts into the test/ subfolder so that they are run automatically by "make test". (user: drh, branch: trunk)
1.47 years ext/fts3/fts3_term.c
[3281972eaa] 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.47 years test/fts4merge3.test
[de3f7187eb] 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.48 years tool/mkkeywordhash.c
[6015200beb] Fix a harmless compiler warning in the mkkeywordhash.c utility program. (user: drh, branch: trunk)
1.52 years ext/rtree/rtree4.test
[02b7640f51] 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.52 years test/savepoint7.test
[d2bf0efa7d] Test cases for RELEASE and ROLLBACK TO of a nested savepoint while queries are pending. Ticket [27ca74af3c083] (user: drh, branch: trunk)
1.53 years test/in.test
[f9a7e179cb] Do more aggressive optimization of the AND operator where one side or the other is always false. (user: drh, branch: trunk)
1.53 years ext/fts3/tool/fts3view.c
[4d6de3e9be] Merge fts4-incr-merge with trunk. (user: dan, branch: trunk)
1.56 years test/ioerr2.test
[affaebde10] Modify a test in ioerr2.test to account for the new SQLITE_ABORT_ROLLBACK extended error code. (user: dan, branch: trunk)
1.57 years ext/fts3/fts3_porter.c
[74eadeec34] Fix harmless compiler warnings. (user: drh, branch: trunk)
1.59 years test/tkt-94c04eaadb.test
[82bcd7ec15] 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.60 years test/select4.test
[4f34d7077b] Add a test case for ticket [3557ad65a076c]. (user: drh, branch: trunk)
1.61 years test/multiplex3.test
[c267893a08] Fix a case where an error code was being overwritten in multiplexDelete(). (user: dan, branch: trunk)
1.65 years test/savepoint.test
[9c572d424a] Merge the non-blocking ROLLBACK changes into trunk. (user: drh, branch: trunk)
1.65 years test/journal3.test
[84b324606a] 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.65 years test/insert.test
[76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (user: dan, branch: trunk)
1.67 years config.h.in
[16a471129d] 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.69 years test/tkt3838.test
[0d78ebb8e4] 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.69 years src/test5.c
[c4cd38a0c7] Fix compiler warnings in the TCL test harness. (user: drh, branch: trunk)
1.74 years test/backup2.test
[227cfe11c4] Fix backup2.test so that it passes on OpenBSD (which produces a slightly different error message in one case). (user: dan, branch: trunk)
1.74 years test/shrink.test
[a298465c39] 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.75 years test/multiplex.test
[1238619756c] Make sure the multiplexor does not create unnecessary overflow files. (user: drh, branch: trunk)
1.76 years src/mutex.c
[e9d05cbb76] Fix typos and comments and make minor changes to a few function names, as suggested by readership. (user: drh, branch: trunk)
1.77 years src/pcache.c
[17c30634a7] 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.80 years test/incrvacuum2.test
[2370d70eb5] Merge the POWERSAFE_OVERWRITE features and the use of statvfs() from the statvfs branch into trunk. (user: drh, branch: trunk)
1.81 years test/walpersist.test
[49d21ce50f] Add code for a test that was failing before the persistent-wal related changes of 09ccc4a1be. (user: dan, branch: trunk)
1.82 years test/quota-glob.test
[322bd15f97] Add stdio support to the quota VFS. (user: drh, branch: trunk)
1.83 years test/multiplex2.test
[ee1e012256] Change the multiplexor VFS so that xTruncate is a no-op on database files. (user: dan, branch: trunk)
1.83 years test/selectB.test
[5061d85ff9] Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery. (user: drh, branch: trunk)
1.90 years test/attach.test
[93a947989b] Add the sqlite3_db_filename() interface. (user: drh, branch: trunk)
1.90 years src/test_pcache.c
[457513f21f] Merge the PCACHE2 changes into trunk. (user: drh, branch: trunk)
1.93 years test/insert4.test
[e3f368cd5e] 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.94 years ext/fts3/README.content
[13a9d085e1] Add new file ext/fts3/README.content, describing the experimental FTS4 content option. (user: dan, branch: trunk)
1.94 years test/fts3fault.test
[3f2d49c678] Update fts3fault.test to account for the sqlite3_errmsg() related changes in 8f88cc4e61 and dcb7879347. (user: dan, branch: trunk)
1.95 years test/fts3drop.test
[3565fcf898] Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a]. (user: dan, branch: trunk)
1.97 years test/fts3first.test
[8a4077057d] Merge the fts4-content branch with the trunk. (user: dan, branch: trunk)
1.98 years test/fts3d.test
[d65f63531c] 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.98 years test/nan.test
[4becc47eb4] Avoid 32-bit integer overflow when evaluating the exponent of a floating point value during ascii to binary conversion. (user: drh, branch: trunk)
1.99 years test/tkt3793.test
[39408702a9] 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.99 years test/fts-9fd058691.test
[7e24645be2] Handle updating the only row of an FTS table correctly. Fix for [9fd058691]. (user: dan, branch: trunk)
1.99 years test/tkt-fa7bf5ec.test
[e43da426e6] 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.99 years tool/symbols-mingw.sh
[c41d1d4652] Adjust the symbols.sh script for STAT3. Add the symbols-mingw.sh script for testing on windows with MinGW. (user: drh, branch: trunk)
2.00 years test/printf.test
[1f843fb383] 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)
2.00 years test/corrupt3.test
[2ab14a8467] Add the SQLITE_DIRECT_OVERFLOW_READ compile time option. (user: dan, branch: trunk)
2.02 years tool/warnings.sh
[774d0842bc] Merge the STAT3 changes into trunk. (user: drh, branch: trunk)
2.03 years test/vacuum.test
[9ddfe1e413] Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (user: dan, branch: trunk)
2.04 years test/misc3.test
[87946c627f] Fix misc3.test so that it works with OMIT_MERGE_SORT builds. (user: dan, branch: trunk)
2.04 years test/attach4.test
[a38668dcff] Fix some test files so that they work with SQLITE_OMIT_WAL builds. (user: dan, branch: trunk)
2.05 years test/ctime.test
[4eb4689834] Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. (user: dan, branch: trunk)
2.10 years test/index4.test
[4c43e8b2d2] Performance improvements to the external merge-sorter. Keep content on an in-memory linked lists rather than an ephemeral table prior to spilling to disk. Use the external merge-sorter to implement ORDER BY and GROUP BY in addition to CREATE INDEX. (user: drh, branch: trunk)
2.11 years src/os_common.h
[6489848590d] The server1.test script should only run if mutexes are functional. Fix to the #ifdef change of check-in 9e6a4c1473. (user: drh, branch: trunk)
2.11 years tool/tostr.awk
[df55006665] 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)
2.11 years test/thread002.test
[20ddfb4780] Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time option. (user: drh, branch: trunk)
2.11 years mkopcodec.awk
[f1bd5bbae5] 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)
2.13 years test/walbak.test
[35e6ac18e3] 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)
2.13 years test/tkt-b1d3a2e531.test
[3f3acee465] Fix for [b1d3a2e531]. (user: dan, branch: trunk)
2.16 years test/indexfault.test
[346a453d1f] Merge the experimental changes to use a merge-sort when creating an index into the trunk. (user: dan, branch: trunk)
2.17 years tool/extract.c
[dfa22ed438] Add command-line utilities "offsets.c" and "extract.c" for use in low-level analyzsis of database files. (user: drh, branch: trunk)
2.18 years test/alter2.test
[b90c28be38] Merge the winopen-retry-logic branch into trunk. The biggest change here is to test scripts, which should now use such as copy_file and delete_file from tester.tcl rather than the raw file commands of TCL. (user: drh, branch: trunk)
2.18 years test/tkt-d635236375.test
[a2135ad130] Update the OP_Move opcode to shift the pScopyFrom pointer of aliases when compiled with SQLITE_DEBUG. Ticket [d63523637517386191]. (user: drh, branch: trunk)
2.19 years test/vtabF.test
[a55f4ab999] Make sure IS NOT NULL constraints work on virtual tables. Fix for ticket [6c14288a473ceff]. (user: drh, branch: trunk)
2.26 years test/tkt-54844eea3f.test
[9f14fa56ba] Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries. (user: dan, branch: trunk)
2.26 years src/mem3.c
[a68b6580c7] 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)
2.27 years test/func3.test
[6c51bad0a3] Adjust a couple of test scripts so that they work with OMIT_UTF16 builds. (user: dan, branch: trunk)
2.28 years ext/fts3/fts3_hash.c
[29e69f389c] Changes to allow FTS to be compiled as a loadable module again. (user: dan, branch: trunk)
2.29 years test/exists.test
[d9f7993bfa] 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.29 years test/incrblob_err.test
[afbe9023a7] Fix a Windows line ending issue in a test case that was causing an incrblob test to fail. (user: shaneh, branch: trunk)
2.30 years test/tkt-91e2e8ba6f.test
[c271f7e88f] Add a test for ticket [91e2e8ba6f]. No changes to code. (user: dan, branch: trunk)
2.30 years test/types3.test
[6e1f4df51a] Change a test case in types3.test slightly so that it works with the latest versions of Tcl. (user: dan, branch: trunk)
2.30 years test/tkt-bd484a090c.test
[0e82175fd8] Change the error message returned when localtime_r() fails to "local time unavailable". Ticket [bd484a090c8077] (user: dan, branch: trunk)
2.32 years test/wal7.test
[177e2d72a8] Further tweaks to the wal7.test test case. (user: drh, branch: trunk)
2.32 years test/fts3rnd.test
[b1f9c1e0ac] Merge fts3-prefix-search branch with trunk. (user: dan, branch: trunk)
2.33 years test/fkey3.test
[2b3d9996a8] 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.35 years test/lock_common.tcl
[19084a6641] Merge the read-only shared memory branch into trunk. After this merge, an unprivileged process can open WAL-mode databases owned by another user as long as a database connection with write permission exists on the database file and if the readonly_shm=1 URI query parameter is supplied. (user: drh, branch: trunk)
2.43 years test/cast.test
[2e5c0ed724] Merge windows test case fixes. No changes to code. (user: dan, branch: trunk)
2.47 years tool/getlock.c
[0ab24b133e] Add the "getlock" utility for determining if a database file (on unix) is currently locked. (user: drh, branch: trunk)
2.50 years tool/rollback-test.c
[a65a7a59d1] Add a simple test program to aid in verifying that journals are cross-platform. (user: drh, branch: trunk)
2.51 years test/thread1.test
[532ae32ea0] Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined. (user: dan, branch: trunk)
2.51 years test/thread_common.tcl
[e4e99606fd] Do not run multi-threaded Tcl tests if the library was built with SQLITE_MUTEX_NOOP defined. (user: dan, branch: trunk)
2.51 years src/btmutex.c
[614de91a50] 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.51 years src/test_server.c
[2039ed952a] Changes to support building with various SQLITE_OMIT_XXX options defined. (user: dan, branch: trunk)
2.52 years tool/mkopts.tcl
[5d34e64d4d] 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.52 years install-sh
[8088031bc9] 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.55 years test/tableapi.test
[69fe0c873d] Fix problem with tableapi.test on Windows. (user: shaneh, branch: trunk)
2.56 years test/tkt-f7b4edec.test
[eedbcf0a0b] Add a test case to verify that ticket [f7b4edece25c994857] is fixed. (user: drh, branch: trunk)
2.59 years test/mem5.test
[d7dae06fb2] Fix issue with mem5 allocator when min request size is larger thatn 2^30. (user: shaneh, branch: trunk)
2.66 years test/tkt-752e1646fc.test
[559739998833643f] Skip flattening if subquery has LIMIT and outer query is DISTINCT. Fix for ticket [752e1646fc]. (user: shaneh, branch: trunk)
2.66 years test/tkt3824.test
[d78949fc93] 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.68 years test/fts3comp1.test
[3996f92a9a] Change fts4aux to (additionally) report on term frequency in individual columns of an fts table. (user: dan, branch: trunk)
2.68 years test/minmax3.test
[499edcbc8a] Merge the stat2 query planner enhancements into the trunk. (user: drh, branch: trunk)
2.68 years test/threadtest3.c
[bac7342c36] Merge in the blocking-checkpoint enhancement, including the new sqlite3_wal_checkpoint_v2() interface and the PRAGMA wal_checkpoint(full) statement. (user: drh, branch: trunk)
2.70 years test/mutex1.test
[c86e46f4fd] Update test file mutex1.test to account for e3b500fb5d. (user: dan, branch: trunk)
2.80 years test/lookaside.test
[b0888047bb] 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.84 years src/test_superlock.c
[fe441df9ba] Work around restriction in Windows file locking. (user: shaneh, branch: trunk)
2.86 years test/e_resolve.test
[6858df9c72] Add test file e_resolve.test. (user: dan, branch: trunk)
2.93 years art/sqlite370.ico
[1635d927cd] Merge the multiplexer VFS demo into the trunk. (user: drh, branch: trunk)
2.94 years test/fts3corrupt2.test
[b770290561] Test cases and minor changes to make fts3 more robust in the face of a corrupt database. (user: dan, branch: trunk)
2.95 years ext/fts3/fts3speed.tcl
[988164cf48] Merge experimental fts3/fts4 changes with trunk. (user: dan, branch: trunk)
3.01 years test/lock6.test
[759c954fee] Fix minor test suite problems causing errors on OSX. (user: dan, branch: trunk)
3.02 years tool/showjournal.c
[fa97d89546] Updates to the showjournal.c utility in order to bring it up to version 3. (user: drh, branch: trunk)
3.02 years test/tkt-3998683a16.test
[07ee080ec4] Merge experimental into trunk: Refactor the text-to-numeric conversion routines to work without zero-terminators and in UTF16 as well as UTF8. Avoid invalidating strings with doing affinity conversions. (user: drh, branch: trunk)
3.03 years test/schema4.test
[655991ec8a] Fix some problems that can occur if a trigger has the same name as another database object. (user: dan, branch: trunk)
3.03 years test/tkt-b351d95f9.test
[1f7ef0af8d] Merge fixes for ticket [b351d95f9cd5ef17e9d9dbae18f5ca8611190001] into the trunk. (user: drh, branch: trunk)
3.04 years test/misc4.test
[a7645d2938] 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)
3.04 years ext/rtree/rtreeA.test
[fab3b383bb] Add tests to e_delete.test. (user: dan, branch: trunk)
3.05 years test/stmt.test
[ba8ca9c9e2] Changes to test scripts to work with SQLITE_TEMP_STORE=2. (user: dan, branch: trunk)
3.05 years test/tkt-313723c356.test
[4ea134a84c] Add a test case to verify that bug [313723c356] has been fixed. (user: dan, branch: trunk)
3.09 years test/releasetest.mk
[e1d4a87e4e] Remove proprietary information from the releasetest.tcl script and add it to the public repository. (user: drh, branch: trunk)
3.11 years ext/rtree/rtree3.test
[b06f4695bd] Add tests (and associated fixes) to restore coverage of rtree.c. (user: dan, branch: trunk)
3.11 years test/types.test
[0900e35348] Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. (user: drh, branch: trunk)
3.12 years ext/rtree/rtree2.test
[1975a27cde] Fix a couple of memory leaks in r-tree that can occur following an OOM condition. (user: dan, branch: trunk)
3.13 years test/tkt-5e10420e8d.test
[255f1eefa3] Fix for ticket [5e10420e8d]. (user: dan, branch: trunk)
3.14 years test/ioerr5.test
[56cc883d3a] 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)
3.16 years test/pager3.test
[aa092ac928] Merge experimental changes into trunk. (user: dan, branch: trunk)
3.20 years test/icu.test
[451d965742] Add tests to check that the ICU regexp() function can only be called with exactly two arguments. (user: dan, branch: trunk)
3.20 years Makefile.arm-wince-mingw32ce-gcc
[8118de2af3] Update the makefiles to prefer TCL version 8.5 instead of 8.4. (user: drh, branch: trunk)
3.21 years src/notify.c
[008368b2bd] Add support for SQLITE_DBSTATUS_SCHEMA_USED and SQLITE_DBSTATUS_STMT_USED to the trunk. (user: drh, branch: trunk)
3.23 years test/fts3.test
[d692434b49] Re-introduce the prefix-search optimization of feef1b15d6, which was lost in a reorganization of FTS3 code. (user: dan, branch: trunk)
3.24 years test/tkt-80e031a00f.test
[6851c517ac] Additional test cases and evidence marks for the empty RHS bug on the IN operator - ticket [80e031a00f45dca877] (user: drh, branch: trunk)
3.24 years src/test_devsym.c
[2b68e50268] Remove the xShmOpen method from the VFS. Shared-memory is opened automatically by a call to xShmMap. Rename the xShmClose method to xShmUnmap. (user: drh, branch: trunk)
3.24 years test/lock2.test
[05ac254865] Fix problems with running the async.test script. (user: dan, branch: trunk)
3.26 years test/backup_malloc.test
[aef2643852] Fix test case numbering in backup_malloc.test and issue when running under Windows. (user: shaneh, branch: trunk)
3.26 years test/index3.test
[f553c8ed04] Changes to test scripts so that the "inmemory_journal" permutation works with ef126e775a. (user: dan, branch: trunk)
3.26 years test/mallocI.test
[dd59cea6c8] Fix issue in mallocI test script where db handle not released. (user: shaneh, branch: trunk)
3.28 years test/schema3.test
[a85ae33246] Remove debugging code from test script. (user: dan, branch: trunk)
3.30 years test/walhook.test
[8d0f8a7f70] 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.30 years test/async4.test
[85dd51a75c] Some changes to test scripts related to codec enabled versions of sqlite. (user: dan, branch: trunk)
3.31 years test/tkt-fc62af4523.test
[7c3a86b9c7] Fix the tkt-fc62af4523.test to work around non-randomness of the randomblob() function when in testing mode. (user: drh, branch: trunk)
3.32 years test/quick.test
[6e43eed931] Add test file pager1.test, containing tests of inter-process locking in non-wal mode. (user: dan, branch: trunk)
3.33 years art/sqlite370.eps
[af353bd89e] Adding original art for the new SQLite logo. (user: drh, branch: trunk)
3.34 years test/avtrans.test
[7c33eb5a5a] Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file. (user: dan, branch: trunk)
3.34 years test/capi3b.test
[c2edf8e17f] Refactor some of the global variables and commands used by tester.tcl. (user: dan, branch: trunk)
3.35 years test/rowhash.test
[28efe0a404] In the rowhash.test, make sure global variables are cleared prior to use. (user: drh, branch: trunk)
3.41 years doc/vfs-shm.txt
[bce21c1838] The refactored of VFS SHM primitives are now working so merge the wal-refactor branch back into the trunk. (user: drh, branch: trunk)
3.41 years test/tkt-26ff0c2d1e.test
[7838163d08] 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.44 years test/savepoint2.test
[de9ae443cc] Merge the write-ahead-logging changes into the trunk. (user: drh, branch: trunk)
3.49 years test/select2.test
[defaf0d99a] Further refinements to table order selection on join query planning. (user: drh, branch: trunk)
3.55 years test/fts3ac.test
[d37034f7fc] Fix for [9861b74ab9]. Correctly handle strings with zero tokens in the fts3 offsets() function. (user: dan, branch: trunk)
3.55 years test/init.test
[ad68fa65bb] Disable the "init.test" test script when compiled with SQLITE_THREADSAFE=0. (user: drh, branch: trunk)
3.57 years test/fts3ag.test
[bea9258643] 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.60 years test/select7.test
[8858042fa1] 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.62 years test/where6.test
[f0ae251abb] 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.62 years test/schema.test
[a8c984c1d6] 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.62 years test/vtabA.test
[ff61e0fd80] 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.63 years src/complete.c
[7c4cca6d1a] Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging output for CORRUPT, and CANTOPEN errors. (user: drh, branch: trunk)
3.63 years test/vacuum4.test
[86d50ce57f] 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.75 years tool/restore_jrnl.tcl
[08c545f030] Added option to restore_jrnl.tcl utility to hex dump journal pages. (user: shaneh, branch: trunk)
3.76 years test/fts3al.test
[8a208223a7] Change the fts3 snippet function to return (hopefully) more relevant snippets in less time. (user: dan, branch: trunk)
3.77 years test/fuzz2.test
[97f8a886b6] Minor changes to test scripts to support various SQLITE_OMIT options. (user: shaneh, branch: trunk)
3.81 years test/trace.test
[85e3c73497] Fixed some TCL test cases to work if SQLITE_OMIT_TRIGGER is defined. (user: shaneh, branch: trunk)
3.84 years test/fts3ad.test
[5030ba2e30] Add extra tests for parsing of whitespace in tokenizer declarations,. (user: dan, branch: trunk)
3.85 years test/fts3b.test
[ef5b745029] Modify a test in fts3b.test to reflect the fact that the docid field may now be updated. (user: dan, branch: trunk)
3.88 years src/test_tclvar.c
[83dc7d38c2] Make sure registers computed for the VFilter opcode are marked invalid after the VFilter opcode finishes. Ticket [16fbf14cb2]. (user: drh, branch: trunk)
3.89 years test/fts3ab.test
[551dbe30ea] Merge fts3-refactor into the main trunk. (user: dan, branch: trunk)
3.91 years test/func2.test
[d7b3801dc7] Update comment for substrFunc(). Added additional SUBSTR() test cases. (user: shaneh, branch: trunk)
3.91 years test/coalesce.test
[d0591258b6] Additional test cases for the coalesce() and ifnull() functions. (user: drh, branch: trunk)
3.91 years test/intarray.test
[0c8db5d88e] Additional intarray test cases and tweaks to comments. (user: drh, branch: trunk)
3.91 years ext/rtree/rtree_perf.tcl
[f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (user: drh, branch: trunk)
3.93 years tool/lempar.c
[27d8e684db] 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.97 years tool/fragck.tcl
[761396f8cb] For Windows VFS, modified xGetLastError() to call FormatMessage() with the FORMAT_MESSAGE_IGNORE_INSERTS option. Additionally updated to ensure strings are returned as UTF8. Ticket [39c85e8a4e]. (user: shane, branch: trunk)
3.97 years test/join.test
[6fe6371175] 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)
4.00 years tool/genfkey.test
[273ccbf18a] Fix a problem in the legacy genfkey code to do with column names that require quoting. (user: dan, branch: trunk)
4.03 years test/boundary4.tcl
[e4eb227b14] Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (user: dan, branch: trunk)
4.04 years test/tkt-4a03edc4c8.test
[f0c56fa90d] 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)
4.05 years addopcodes.awk
[98853f6104] 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)
4.05 years test/tkt3201.test
[fb6ceed388] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (user: dan, branch: trunk)
4.08 years README
[ba20091ae8] Update the README file to state that TCL is required in order to run the makefiles for SQLite. Ticket [7d96113ff]. (user: drh, branch: trunk)
4.10 years test/tkt-2ea2425d34.test
[f22e388727] 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)
4.10 years test/tkt3731.test
[e016cca363] Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (user: dan, branch: trunk)
4.10 years test/trigger8.test
[c1b388c30d] Merge in changes to support recursive invocation of triggers (disabled by default). (user: dan, branch: trunk)
4.13 years test/tkt4018.test
[aa6acfa8ca] Fix a problem in os_unix.c where a malloc failure could lead to a leaked file descriptor. (user: dan, branch: trunk)
4.16 years test/whereB.test
[06098505fc] Tweak to the new whereB.test file to make it more consistent. (user: drh, branch: trunk)
4.20 years test/tkt3997.test
[b2784cf5d8] 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)
4.22 years test/bind.test
[7f3fc7f20f] Changes to test code (only) to allow veryquick.test to run with OMIT_UTF16 builsd. Ticket #3985. (CVS 6919) (user: danielk1977, branch: trunk)
4.24 years test/zeroblob.test
[25dd342283] Make sure the IN operator works with zeroblobs. Ticket #3965. Other simplifications associated with structural testing. (CVS 6890) (user: drh, branch: trunk)
4.27 years test/tkt3935.test
[29b48972b6] 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)
4.28 years test/incrblob2.test
[f17ef37897] 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.31 years test/tkt3841.test
[3d7327fd6a] 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.33 years test/tkt3911.test
[bd341a103c] Make sure nested queries with USING clauses do not leak memory. Preliminary fix for ticket #3911. (CVS 6750) (user: drh, branch: trunk)
4.34 years test/savepoint4.test
[ed1d4f47ee] 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.35 years test/count.test
[1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (user: drh, branch: trunk)
4.35 years test/corrupt5.test
[453ff88f73] Minor updates to comments in test scripts. (CVS 6714) (user: shane, branch: trunk)
4.35 years test/colname.test
[2472f6db95] Add a test case for ticket #3893 and ticket #3894. (CVS 6705) (user: drh, branch: trunk)
4.37 years test/tkt3508.test
[4ac2bdfbb4] 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.37 years test/tkt1514.test
[7cb1c3ba07] 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.44 years test/auth3.test
[694662f786] Work toward cleaning up the authorizer interface. Work is on-going. This is an incremental check-in. (CVS 6598) (user: drh, branch: trunk)
4.45 years test/blob.test
[e855654283] 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.46 years test/insert3.test
[e71fb0fb8d] 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.46 years test/alias.test
[dd4d67a674] 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.47 years test/make-where7.tcl
[f61e4cd936] Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) (user: danielk1977, branch: trunk)
4.48 years test/bindxfer.test
[c29b37ea36] 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.50 years test/speed1.test
[0c41f7cff4] 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.51 years test/tkt3791.test
[8362d88324] Do not attempt to walk a TokenOnly or SpanOnly expression tree node. Ticket #3791. (CVS 6469) (user: drh, branch: trunk)
4.51 years test/tkt2767.test
[277dace43d] Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464) (user: danielk1977, branch: trunk)
4.52 years test/bitvec.test
[ca3aa3ba7d] Increase test coverage of bitvec.c slightly. Fix the line length on a comment in bitvec.c. (CVS 6432) (user: drh, branch: trunk)
4.53 years test/tkt3761.test
[8c1d0c6ad9] Make sure a ROLLBACK that follows an incremental vacuum works. Ticket #3761. (CVS 6416) (user: drh, branch: trunk)
4.54 years test/lock3.test
[767a7f7b55] 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.62 years tool/genfkey.README
[36d699660b] 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.64 years test/default.test
[d9f6ffbc5e] 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.66 years test/distinctagg.test
[e20bf38466] 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.68 years test/schema2.test
[f92405afb6] Simplify wording of backup API error message. Decapitalize some other error messages. (CVS 6256) (user: drh, branch: trunk)
4.68 years test/substr.test
[cd2e7f6c0f] 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.68 years test/tkt3630.test
[3b0a25548c] 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.69 years test/keyword1.test
[6041ca87a1] 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.70 years aclocal.m4
[813a3c9686] regenerate autotools (CVS 6211) (user: vapier, branch: trunk)
4.74 years test/tkt3581.test
[f5f5ef646b] Here is the test case to prove that ticket #3581 is fixed. (CVS 6174) (user: drh, branch: trunk)
4.75 years test/mallocJ.test
[6e171c0a64] More coverage improvements. (CVS 6148) (user: drh, branch: trunk)
4.75 years test/mallocK.test
[1e5725c517] Increased test coverage in where.c. (CVS 6146) (user: drh, branch: trunk)
4.76 years test/fuzz_common.tcl
[e02323b362] 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.76 years test/fuzz3.test
[77dc19cfab] Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110) (user: drh, branch: trunk)
4.77 years test/savepoint5.test
[3e9efb7638] 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.77 years test/boundary1.tcl
[b1a4a17f87] 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.77 years ext/fts3/README.syntax
[ac8258da6e] Fix the name in the documentation of the compile-time macro for enabling FTS3 parenthesis processing. (CVS 6089) (user: drh, branch: trunk)
4.82 years test/randexpr1.tcl
[4685ffccd3] Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029) (user: drh, branch: trunk)
4.82 years test/tkt3541.test
[ea9b747efb] Convert the "~" and "NOT" operators to be two-address instructions. Ticket #3541. (CVS 6028) (user: drh, branch: trunk)
4.83 years test/tkt3346.test
[4f10f19dd1] Additional test cases for nested subqueries in a WHERE clause. (CVS 5999) (user: drh, branch: trunk)
4.85 years test/tkt3522.test
[06d206ef7d] Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979) (user: drh, branch: trunk)
4.92 years test/utf16align.test
[3f657e8876] Prevent buffer overruns when converting malformed UTF16 to UTF8. Ticket #3482. (CVS 5869) (user: drh, branch: trunk)
4.93 years test/tkt3080.test
[51f04aaff2] 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.94 years test/altermalloc.test
[0996783b1b] Fix a crash that can follow a malloc failure in sqlite3ValueFromExpr(). Ticket #3468. (CVS 5851) (user: danielk1977, branch: trunk)
4.95 years test/laststmtchanges.test
[e68e4282ad] Make sqlite3_count_changes() and total_changes() work with "DELETE FROM ". (CVS 5844) (user: danielk1977, branch: trunk)
4.99 years test/eval.test
[b055bfc4e5] 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.99 years mkdll.sh
[66f57ecb16] Added -DSQLITE_ENABLE_RTREE=1 to the mkdll.sh script. Ticket #3427. (CVS 5810) (user: shane, branch: trunk)
5.00 years test/wherelimit.test
[282c6a46b2] 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)
5.00 years tool/speedtest8.c
[2d427746d5] New speed testing tools. (CVS 5786) (user: drh, branch: trunk)
5.01 years test/mutex2.test
[02a12eb1cf] 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)
5.01 years test/tkt3419.test
[c3cf54a1b6] Add a test script to verify that ticket #3419 stays fixed. (CVS 5771) (user: drh, branch: trunk)
5.03 years sqlite.pc.in
[efe095e0cb] fix #3077: use full version in pkg-config files (CVS 5746) (user: vapier, branch: trunk)
5.09 years ext/icu/sqliteicu.h
[79364b963b] 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)
5.12 years test/trans2.test
[39c34e2238] 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)
5.12 years test/tkt3334.test
[4995a1d1c9] 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)
5.12 years test/collate8.test
[0d61960afd] Additional coverage testing in the new name resolver module. (CVS 5608) (user: drh, branch: trunk)
5.13 years test/crash2.test
[16f612d61e] 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)
5.14 years test/select5.test
[6855711595b] 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)
5.16 years test/tkt3292.test
[055f173ab1] 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)
5.18 years mkso.sh
[ce5daa0359] Revise build scripts in set SQLITE_ENABLE_COLUMN_METADATA on DLLs. (CVS 5539) (user: drh, branch: trunk)
5.18 years test/cse.test
[9ca975c8fd] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (user: danielk1977, branch: trunk)
5.19 years test/mallocH.test
[2cd6bae809] Bring test coverage up to 99%. (CVS 5522) (user: drh, branch: trunk)
5.20 years test/fts2r.test
[02870ed21d] Backport http://www.sqlite.org/cvstrac/chngview?cn=5489 from fts3. Re-used prepared statement from fts2 cursor. (CVS 5499) (user: shess, branch: trunk)
5.20 years test/fts3e.test
[ae96d960e6] Add some simple tests to make sure that the different fulltextFilter query paths are being exercised. (CVS 5498) (user: shess, branch: trunk)
5.22 years test/fts2q.test
[c16900dc76] Implement optimize() function. Backports check-in (5417) from fts3. (CVS 5458) (user: shess, branch: trunk)
5.22 years test/fts2p.test
[4e47394be9] fts2 functions for testing scripts. Backports (5340) from fts3. (CVS 5456) (user: shess, branch: trunk)
5.24 years test/in2.test
[dcb160249f] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (user: drh, branch: trunk)
5.25 years test/collate9.test
[636cd72329] 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)
5.26 years test/delete2.test
[96df0a5fa4] 3 more coverage tests for btree.c. (CVS 5370) (user: danielk1977, branch: trunk)
5.26 years test/tokenize.test
[fe80aa58a4] Testing coverage enhancements. (CVS 5358) (user: drh, branch: trunk)
5.30 years spec.template
[66529ae3a2] Added ldconfig invocations for postinstall and postuninstall. Updated package URL and description to match the current website. (CVS 5287) (user: mihailim, branch: trunk)
5.33 years tool/speedtest8inst1.c
[98bdc7b44d] Update utility program speedtest8inst1.c. (CVS 5201) (user: danielk1977, branch: trunk)
5.35 years ext/rtree/README
[9ab87b7b0d] Fix another typo in the rtree README file. (CVS 5187) (user: drh, branch: trunk)
5.36 years tool/speedtest16.c
[9883b406ce] 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.37 years ext/rtree/rtree.h
[aa8eba3360] Update the amalgamation builder to incorporate the RTREE extension. (CVS 5160) (user: drh, branch: trunk)
5.37 years test/like2.test
[33548744369643c] 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.43 years config.guess
[2b1e455c46] Add AC_SYS_LARGEFILE to ensure large file support, update autotools-related files. Ticket #3094. (CVS 5087) (user: mlcreech, branch: trunk)
5.44 years test/tkt3093.test
[3dc334aa4a] 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.46 years test/vtabB.test
[776e702410] Add test cases to prove that ticket #3082 has been fixed. (CVS 5048) (user: drh, branch: trunk)
5.48 years test/speed1p.explain
[d11f5dafda] Add speed-test scripts that also show EXPLAIN output. (CVS 5017) (user: drh, branch: trunk)
5.49 years test/collateA.test
[c5435f71ef] 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.50 years test/update.test
[1aaed6a469] Enhancements to the change counter tests. Ticket #3013. (CVS 4986) (user: drh, branch: trunk)
5.50 years test/speed4p.test
[a2da7f9ac2] 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.52 years test/malloc9.test
[9987a7b193] Fix the output labels on the tests in malloc9. (CVS 4966) (user: drh, branch: trunk)
5.57 years test/busy.test
[5e4df44181] Add tests to make sure the busy handler resets. (CVS 4865) (user: drh, branch: trunk)
5.64 years test/malloc4.test
[63da5d9754] 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.65 years test/tkt2942.test
[6d33cbd99c] 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.69 years test/tkt2920.test
[b3259e8721] 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.69 years ext/fts3/mkfts3amal.tcl
[72411043e6] 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.71 years test/colmeta.test
[9f95d79dae] Improvements to test coverage in the lemon-generated parser and in the sqlite3_get_table() interface. (CVS 4745) (user: drh, branch: trunk)
5.72 years test/exec.test
[720bc20a11] Miscellaneous test coverage improvements. (CVS 4734) (user: drh, branch: trunk)
5.72 years test/ioerr3.test
[010f7b780c] Additional test coverage improvements. Test coverage now stands at 98.73%. (CVS 4731) (user: drh, branch: trunk)
5.73 years test/insert2.test
[3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (user: danielk1977, branch: trunk)
5.74 years test/select8.test
[a6dddebcc5] Continuing work toward converting the VM into a register machine. (CVS 4707) (user: drh, branch: trunk)
5.82 years ext/fts2/README.tokenizers
[4e91a267fe] 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.83 years test/null.test
[2f88b9b3e3] 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.83 years test/where4.test
[0b34a18651] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (user: danielk1977, branch: trunk)
5.90 years test/fts2g.test
[75cb46f82a] Don't do anything when input doclists are both empty. Ticket #2774 (CVS 4546) (user: shess, branch: trunk)
6.07 years test/shortread1.test
[995c63b561] Add tests to prevent a regression of the short read problem discovered in version 3.2.2. (CVS 4428) (user: drh, branch: trunk)
6.07 years test/tkt2643.test
[2cfdbfe654] Fix incorrect index cost assumptions that occur after an ANALYZE. Ticket #2643. (CVS 4424) (user: drh, branch: trunk)
6.08 years test/badutf.test
[c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (user: danielk1977, branch: trunk)
6.10 years test/vtab_err.test
[d66e08fd4f] 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)
6.14 years test/fts3af.test
[24739f148e] 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)
6.14 years ext/fts3/README.txt
[216c91d2fc] Copy fts2 to fts3, renaming, and replacing references to fts2 with fts3, including capitalization variants. (CVS 4249) (user: shess, branch: trunk)
6.17 years test/fts2k.test
[16730cb137] 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)
6.20 years ext/fts1/fts1_porter.c
[3f9a666143] 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)
6.20 years test/collate6.test
[7b69968618] 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)
6.21 years test/fts1n.test
[f9020cffda] 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)
6.21 years test/fts1m.test
[c2ba3cc0f7] 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)
6.23 years mkextu.sh
[e269f6e9f6] Updates to build scripts. Added scripts for building FTS2 shared libraries. (CVS 4171) (user: drh, branch: trunk)
6.29 years ext/fts2/mkfts2amal.tcl
[bbdcf372c6] Remove the unused EXTSRC variable from the non-configure makefile. (CVS 4129) (user: danielk1977, branch: trunk)
6.29 years ext/fts2/fts2.h
[c795e6fd8f] 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.29 years test/fts2token.test
[fbcf2d75cd] Add a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118) (user: danielk1977, branch: trunk)
6.30 years test/tkt2450.test
[d5b7224f37] When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111) (user: danielk1977, branch: trunk)
6.34 years test/where5.test
[72612a0373] Additional test cases for comparisons against NULL in the WHERE clause and elsewhere in a SELECT. (CVS 4051) (user: drh, branch: trunk)
6.34 years test/join5.test
[46fdd19548] 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.37 years test/tkt2391.test
[f9a95e92df] Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040) (user: danielk1977, branch: trunk)
6.38 years test/enc.test
[0595319cd7] Add some code to MemTranslate() to prevent the READ_UTF8() macro from overreading a buffer. (CVS 4033) (user: danielk1977, branch: trunk)
6.39 years test/fts2a.test
[ed3a131f1d] 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.44 years test/format4.test
[b94d39e4d9] Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918) (user: drh, branch: trunk)
6.46 years test/quote.test
[0935cdf82a] Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869) (user: drh, branch: trunk)
6.47 years test/misc6.test
[25c1c7aaa8] Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865) (user: drh, branch: trunk)
6.49 years test/vtab9.test
[8d6c3bfc4d] Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845) (user: danielk1977, branch: trunk)
6.49 years test/speed2.test
[e44995debf] 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.50 years test/fts1l.test
[81be7290a4] 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.61 years test/vtab8.test
[52885ed8b7] 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.63 years test/types2.test
[da81725ca1] 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.63 years test/fts1f.test
[16cb00adeb] Fix typos in test naming (was using 'e' instead of 'f'). (CVS 3655) (user: shess, branch: trunk)
6.71 years test/fts2i.test
[310f685851] Do not run the fts2i.test unless the FTS2 module is available. (CVS 3601) (user: drh, branch: trunk)
6.71 years test/fts1i.test
[810c0176f8] Do not run test fts1i.test if FTS1 is not installed. (CVS 3600) (user: drh, branch: trunk)
6.76 years test/threadtest2.c
[06216d0d3b] Get threadtest2.c working again after being long neglected. (CVS 3562) (user: drh, branch: trunk)
6.86 years test/fts2h.test
[66581162da] 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.98 years test/fts2b.test
[2806c34158] 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.98 years test/fts1e.test
[b01c4371d8] Add tests for delete and update in fts1. (CVS 3481) (user: shess, branch: trunk)
7.00 years ext/fts2/README.txt
[d0d1e7cdcc] 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)
7.02 years test/fts1c.test
[6cf1fb9f80] The snippet generator adds ellipsis between text from different columns. (CVS 3465) (user: drh, branch: trunk)
7.02 years test/fts1porter.test
[df1a4b4834] 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)
7.03 years ext/fts1/fts1_tokenizer.h
[936b06aaa8] Add a Porter stemmer option to the FTS1 module. (CVS 3452) (user: drh, branch: trunk)
7.03 years test/fts1a.test
[8cdf1d6ae0] 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)
7.06 years test/fts1b.test
[5e35dc1ffa] 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)
7.07 years ext/fts1/fts1.h
[d4edb8035c] Earlier refactoring changed name in fts1.c but not fts1.h. (CVS 3413) (user: shess, branch: trunk)
7.11 years ext/fts1/fts1_hash.c
[e1891f0dc5] 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)
7.11 years ext/fts1/simple_tokenizer.c
[6c77c2d5e1] 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)
7.13 years ext/fts1/ft_hash.c
[b0d8e0d314] A first implementation of a full-text search module for SQLite. (CVS 3363) (user: adamd, branch: trunk)
7.14 years ext/README.txt
[7f152f9f3a] Add the ext/fts1 subdirectory for holding the first full-text search extension. (CVS 3360) (user: drh, branch: trunk)
7.30 years test/tkt1444.test
[0534f6e15b] 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.30 years test/lastinsert.test
[d50c37975d] Make the last_insert_rowid method in the TCL interface work with 64-bit rowids. (CVS 3283) (user: drh, branch: trunk)
7.44 years test/aggerror.test
[8f820e4352] Faster :memory: database COMMITs. Ticket #1790. (CVS 3178) (user: drh, branch: trunk)
7.61 years test/index2.test
[cdca3383c5] 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.66 years test/tkt1644.test
[c468aa349d] Minor test file modifications for builds compiled with OMIT options. (CVS 3077) (user: danielk1977, branch: trunk)
7.73 years test/tkt1435.test
[3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (user: danielk1977, branch: trunk)
7.74 years test/tkt1537.test
[8e79a0c24a] 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.81 years test/tkt1567.test
[e6106cc133] 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.88 years test/tkt1536.test
[a2e55a3828] Fix incorrect type conversions when copying from a table into itself. Ticket #1536. (CVS 2773) (user: drh, branch: trunk)
7.90 years test/sort.test
[ce06c123d0] Create separate affinities for INTEGER and REAL. (CVS 2766) (user: drh, branch: trunk)
8.05 years contrib/sqlitecon.tcl
[079c6348f9] Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) (user: drh, branch: trunk)
8.13 years test/delete3.test
[7c599bae33] 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.43 years test/trigger6.test
[c2af7d2c94] Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454) (user: drh, branch: trunk)
8.54 years test/join4.test
[c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (user: danielk1977, branch: trunk)
8.63 years sqlite3.1
[5c99bea5a4] Revised man page from Bill Bumgarner. (CVS 2360) (user: drh, branch: trunk)
8.72 years test/join2.test
[bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (user: danielk1977, branch: trunk)
8.72 years test/join3.test
[d8b2a7e091] Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (user: drh, branch: trunk)
8.94 years test/trigger5.test
[be661acfa8] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (user: drh, branch: trunk)
9.18 years test/bigrow.test
[d33771a303] 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)
9.28 years test/threadtest1.c
[ffd3312b66] Bug-fixes to get the two threadtest C programs working again. (CVS 1756) (user: danielk1977, branch: trunk)
9.40 years test/varint.test
[61bdb53a36] New varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395) (user: drh, branch: trunk)
9.67 years test/crashtest1.c
[597a59a72d] 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)
11.27 years tool/diffdb.c
[00f83c2576] Prepare for the 2.5.5 release. (CVS 661) (user: drh, branch: trunk)
13.37 years tool/opcodeDoc.awk
[6f3655f79f] initial check-in of the new version (CVS 1) (user: drh, branch: trunk)