SQLite
Timeline
Not logged in

50 most recent timeline items

2016-06-29
06:19
[ba1b441b] Leaf: Add the ability to have a table-valued function on the RHS of an IN operator. (user: drh, tags: prototype-int-array)
05:08
[06e1fab7] Another test case for the intarray($PTR,$N) virtual table. (user: drh, tags: prototype-int-array)
05:00
[233b3338] Add a prototype intarray($PTR,$N) table valued function. (user: drh, tags: prototype-int-array)
2016-06-28
22:27
[a33d2356] Leaf: Proposed fix for a problem in the query planner. (user: drh, tags: planner-fix)
2016-06-26
04:06
[f8105085] Leaf: Prevent the WhereLoop.rSetup cost estimate from going negative on complex queries. (user: drh, tags: trunk)
2016-06-25
11:43
[507014e4] Fix the handling of OP_Eq opcodes that compare a register against itself and that require an affinity change. (user: drh, tags: trunk)
2016-06-24
06:23
[77e4f7a3] Fix the ctime.test script so that it works with clang. (user: drh, tags: trunk)
02:50
[67c39e16] Fix the Makefile.in to avoid unnecessary recompiles of sqlite3.c. (user: drh, tags: trunk)
02:21
[a2778ae4] Leaf: Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. (user: drh, tags: temp-page-size)
2016-06-23
16:48
[b8671e94] Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (user: dan, tags: trunk)
12:35
[91113142] Fix the build for -DSQLITE_OMIT_VIRTUALTABLE (user: drh, tags: trunk)
2016-06-21
10:34
[5d0a9d4c] Closed-Leaf: Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (user: dan, tags: sqldiff-vtab-support)
2016-06-20
17:25
[913e5956] For a table on the rhs of a LEFT JOIN operator, do not include terms like "IS NULL" from the WHERE clause in the cursor-hint. These may be false for rows that the cursor would otherwise visit, but true for a row of all NULL values generated by the LEFT JOIN. (user: dan, tags: trunk)
17:22
[7455d932] Closed-Leaf: Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. (user: dan, tags: cursor-hints)
2016-06-17
19:27
[998095ab] Include WHERE terms in the cursor-hint passed to a cursor opened for the rhs of a LEFT JOIN iff we can be sure that those terms will not evaluate to true if the LEFT JOIN generates a row of NULLs. (user: dan, tags: cursor-hints)
14:59
[fcd12b69] Fix a duplicate test name in cursorhint2.test. (user: dan, tags: cursor-hints)
14:47
[c1a5a57c] Fix a typo in the cursorhint2.test script. (user: dan, tags: cursor-hints)
14:33
[2a2346b0] If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. (user: dan, tags: cursor-hints)
13:01
[2c3714ae] Leaf: Add the json_quote() function to the JSON1 extension. (user: drh, tags: json_quote)
2016-06-16
17:14
[0b1579ca] Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (user: dan, tags: trunk)
11:16
[48b555c4] Fix a typo in a comment on the SrcList object. (user: drh, tags: trunk)
2016-06-15
10:21
[0f707d15] Leaf: Merge changes from trunk. (user: drh, tags: apple-osx)
2016-06-13
19:58
[0230ca17] Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". (user: drh, tags: trunk)
15:59
[a1e1cdc5] Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. (user: drh, tags: trunk)
12:51
[fcf6114b] Fix an incorrect assert() in the btree logic. (user: drh, tags: trunk)
12:34
[d362ba15] Fix the "onecolumn" and "exists" methods of the TCL interface so that they work in combination with the "profile" callback. (user: drh, tags: trunk)
2016-06-10
22:49
[53a1e5d5] Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (user: drh, tags: trunk)
2016-06-08
18:07
[fe187432] Prefer to use partial indexes for full table scans when that is possible. (user: drh, tags: trunk)
14:04
[f48a4ad3] Add the "dbhash.exe" utility program that computes a SHA1 hash over the invariant content of an SQLite database file. Free space in the file, the page size, auto_vacuum status, text encoding, and so forth do not change the hash. Only the content matters. (user: drh, tags: trunk)
13:59
[fb276815] Closed-Leaf: Fix an undersized buffer in the SHA1 implementation. (user: drh, tags: dbhash)
13:49
[44f157e0] Fix the dbhash utility so that it ignores the root page number when hashing the sqlite_master table. Add new command-line options. Add the ability to hash multiple databases with a single command. (user: drh, tags: dbhash)
01:03
[2247649c] An initial attempt at a "dbhash" command-line utility. (user: drh, tags: dbhash)
2016-06-07
20:25
[2091a4c9] Fix the walcrash4.test test module so that it works on windows. (user: drh, tags: trunk)
2016-06-06
20:36
[e404ad70] In winFullPathname, translate '/X:' to 'X:' before doing anything else. (user: mistachkin, tags: trunk)
20:27
[f8470ffc] Translate filenames of the form "/c:/*" into just "c:/*" on WinRT and Cygwin. (SQLite has long done this for Win32/WinNT.) (user: drh, tags: trunk)
18:17
[3665a2f5] Fix lempar.c so that the shift-reduce optimization works for error processing. This is a Lemon issue only and has no impact on SQLite. (user: drh, tags: trunk)
13:24
[45531654] Initialize the yyerrcnt variable in the lemon parser template. This has no effect on SQLite itself. (user: drh, tags: trunk)
01:54
[e106a77d] Small performance boost and size decrease in sqlite3BtreeMovetoUnpacked(). (user: drh, tags: trunk)
01:48
[5fb0c354] Small performance improvement in the LIKE function. (user: drh, tags: trunk)
01:14
[2d831074] Btree interface refactoring: (1) The sqlite3BtreeKeySize() interface is renamed to sqlite3BtreeIntegerKey() and modified to work only for table btrees with a rowid. (2) The sqlite3BtreeDataSize() interface is renamed to sqlite3BtreePayloadSize() and modified to work with any btree. (3) The sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() routines are combined into a single sqlite3BtreePayloadFetch() routine. The result of these changes is a smaller binary and fewer CPU cycles needed to run queries. (user: drh, tags: trunk)
2016-06-04
21:05
[5e269c2d] Closed-Leaf: Improved comment on cursorOwnsBtShared(). No changes to code. (user: drh, tags: btree-refactor)
20:58
[aa53a36e] Fix a C99-ism and a compiler warning for MSVC. (user: drh, tags: btree-refactor)
20:37
[bef35e18] Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. (user: drh, tags: btree-refactor)
17:12
[b411107a] Allocate KeyInfo objects from lookaside if possible. (user: drh, tags: trunk)
16:33
[9583c0fb] Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). (user: drh, tags: trunk)
13:57
[313e990c] Remove an unreachable branch in the UNIQUE constraint parsing. (user: drh, tags: trunk)
2016-06-03
18:59
[fa3a89fc] The OR optimization is usable on virtual tables with LIKE, REGEXP and/or GLOB terms in the WHERE clause. (user: drh, tags: trunk)
18:44
[aa7e9d0c] Add support for virtual tables using a WITHOUT ROWID schema. This merge also includes enhancements to the CSV extension, which is used for testing of the new WITHOUT ROWID virtual table mechanism. (user: drh, tags: trunk)
18:21
[31b83a7d] Closed-Leaf: Fix a memory leak when a WITHOUT ROWID eponymous virtual table is used. (user: drh, tags: without-rowid-vtab)
17:27
[d31c2597] Disallow access to the rowid column on WITHOUT ROWID virtual tables. (user: drh, tags: without-rowid-vtab)