/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 descendants and 100 ancestors of [45acf6a8]

2015-04-16
11:56
Use a heap instead of a bitmap for cell overlap and coverage testing of btree pages in PRAGMA integrity_check. Closed-Leaf check-in: 5619c959 user: drh tags: integrity-check-heap
10:55
Avoid attempting to rename the *-oal file while it is still open. check-in: 658c3b0c user: dan tags: ota-update
08:54
Fix a problem in test file e_reindex.test. check-in: 5b3de939 user: dan tags: trunk
07:19
Ensure the sqlite3Select() routine always returns non-zero if an error has occurred. check-in: b51028ed user: dan tags: trunk
04:20
Merge updates from trunk. Closed-Leaf check-in: 22827542 user: mistachkin tags: expShell
03:56
Move OSTRACE defines so they are visible to all source files that need them. check-in: 72485c97 user: mistachkin tags: winTest
03:37
Make sure the sqlite3DebugPrintf() function is defined for OSTRACE as well. check-in: ae5af704 user: mistachkin tags: winTest
03:24
Merge updates from trunk. Make OSTRACE changes work on Linux. check-in: cd154266 user: mistachkin tags: winTest
00:26
When parsing the schema, ignore any SQL that does not begin with "CREATE". check-in: d3c00d61 user: drh tags: trunk
2015-04-15
19:25
Fix a potential one-byte buffer overread in the command-line shell. check-in: e018f4bf user: drh tags: trunk
19:13
Add the BtCursor.pPage field which is the current page to which the cursor points, for a very small performance gain. Leaf check-in: a200e1ea user: drh tags: btree-current-page-cache
17:26
Prevent the fetchPayload() routine from reporting a cell size that extends off the end of the page on a pathologically corrupted database file. check-in: f71053cf user: drh tags: trunk
15:29
Enhance the showdb utility program so that it can read the last partial page of a truncated database file. check-in: 61d72e17 user: drh tags: trunk
14:52
Add the --msvc command-line option to the releasetest.tcl script. This is only a partial merge from the winTest branch as the OS_TRACE changes are omitted. check-in: b8768f12 user: drh tags: trunk
14:26
Merge all recent trunk enhancements and fixes into the ota-update branch. check-in: 9bd3e445 user: drh tags: ota-update
14:14
Merge all recent trunk fixes and enhancements into the sessions branch. check-in: e65e65f9 user: drh tags: sessions
13:51
Merge recent trunk fixes and enhancements into the apple-osx branch. check-in: bfc7142a user: drh tags: apple-osx
09:16
Remove an incorrect assert() statement from sqlite3Fts3Dequote(). check-in: bd06eeb8 user: dan tags: trunk
08:37
Remove a branch that became unreachable due to one of the earlier check-ins today. check-in: fa0956ed user: drh tags: trunk
08:20
Fix a problem causing an assert() to fail if a snippet containing 0 tokens was requested from fts3. check-in: eafd0a1e user: dan tags: trunk
07:57
Fix the error message generator for illegal token errors so that it does not leak memory if it immediately follows another erroneous SQL statement. check-in: 3576973f user: drh tags: trunk
07:34
Remove an incorrect ALWAYS() from the automatic index generator. check-in: eeb4bd06 user: drh tags: trunk
07:19
Remove an incorrect ALWAYS() from the table_info pragma. check-in: 0e087c01 user: drh tags: trunk
07:10
Change the multiSelectOrderBy() routine to return non-zero if there has been any prior error. check-in: 14784c31 user: drh tags: trunk
06:45
Fix a faulty assert() statement in the name resolver associated with the optimization that converts compound selects with ORDER BY COLLATE into subqueries. check-in: c72324ef user: drh tags: trunk
05:57
Correctly handle COLLATE operators applied to COLLATE operators in an ORDER BY clause. check-in: 9e1f837b user: drh tags: trunk
05:38
Fix a faulty assert() in the sqlite3StrAccumAppend() routine. check-in: 998cfdb8 user: drh tags: trunk
05:31
Correctly deal with an unknown collating sequence on an indexed DISTINCT query. check-in: a0b6e2fe user: drh tags: trunk
05:20
When adding the implied "LIMIT 1" to the end of a scalar subquery, make sure that subquery is not a VALUES-only query as such queries cannot deal with LIMIT clauses. check-in: 7c27310b user: drh tags: trunk
04:51
When doing the (dubious) conversion of double-quoted identifier into string literal for MySQL compatibility, be sure to also clear the iTable value from the Expr entry to avoid an assert. check-in: d7211b68 user: drh tags: trunk
04:20
Add a test case for what was formerly thought to be an unreachable condition: when the LHS of an OR operator contains an error and the RHS contains an IN operator. check-in: 38727425 user: drh tags: trunk
04:10
An oversize hex literal can cause a parsing error while generating code for constants that are factored out of the main body of the VDBE program. So allow for that case. check-in: a084690b user: drh tags: trunk
2015-04-14
19:01
Add the --summary option to the sqldiff command-line tool. check-in: 88b22761 user: drh tags: trunk
15:14
Update API documentation to identify many functions as methods on objects. No changes to code. check-in: b549cbce user: drh tags: trunk
2015-04-13
23:11
Merge all recent trunk enhances into the apple-osx branch. check-in: e709d3b4 user: drh tags: apple-osx
23:05
Add #ifdef magic for HAVE_GETHOSTUUID so that the build will hopefully now work on more verions of MacOS with SQLITE_ENABLE_LOCKING_STYLE turned on. check-in: 211411d0 user: drh tags: trunk
22:26
On a DETACH statement, keep all schemas intact except fo the one that is being detached, and thus avoid unnecessary schema reparsing. check-in: 661db19b user: drh tags: trunk
21:39
Omit the "pc" or "program counter" variable from the VDBE loop for 0.6% performance increase. check-in: d2f10c41 user: drh tags: trunk
19:14
Remove the out2-prerelease VDBE opcode property and its associated code, for a 0.5% performance improvement. check-in: e29c7f2c user: drh tags: trunk
17:43
Add a comment to wal.c to explain why a race condition is safe. check-in: bc33af86 user: dan tags: trunk
14:44
Remove a faulty assert() from the btree balancing logic. check-in: d06669d9 user: drh tags: trunk
14:08
Test that if the definition of a collation sequence is changed and VACUUM run, the new database contains records sorted in the (new) correct order. check-in: ce6eaac1 user: dan tags: trunk
14:03
Remove an unreachable branch from the VACUUM logic. check-in: 65ace4b0 user: drh tags: trunk
12:45
Remove an unreachable branch from the vdbeSorterCompareInt() routine. check-in: f666ef06 user: drh tags: trunk
2015-04-12
21:28
Update the version number to 3.8.10 because of the new sort optimizations from check-in [79326d6eec]. check-in: bd2cfa1d user: drh tags: trunk
17:35
Fix a problem with a stale Select.pWith pointer when a CTE is used together with a compound query and an ORDER BY clause. check-in: 9a453f52 user: drh tags: trunk
01:33
Merge all recent trunk enhancements into the sessions branch. check-in: 5f14f34f user: drh tags: sessions
01:22
Avoid problems when a query has a GROUP BY and an ORDER BY but no FROM clause. check-in: e527d96a user: drh tags: trunk
2015-04-11
20:44
Optimizations for VACUUM, CREATE INDEX and some cases of ORDER BY. check-in: 79326d6e user: dan tags: trunk
20:20
Fix a problem with sorting large amounts of partially ordered data. check-in: acca97ef user: dan tags: trunk
18:45
Merge latest trunk changes with this branch. Closed-Leaf check-in: cf7590f6 user: dan tags: sorter-opt
17:09
Merge the sessions-diff branch with this one. check-in: 805baa57 user: dan tags: sessions
13:49
Add the --changeset option to the sqldiff utility program, for generating a sessions changeset file instead of an SQL diff. check-in: f9a3a839 user: drh tags: trunk
13:48
The --changeset option now appears to be working. Closed-Leaf check-in: 1a2e2803 user: drh tags: sqldiff-changeset
12:07
First complete attempt to generate a working changeset. Still contains bugs. check-in: 5611fa9b user: drh tags: sqldiff-changeset
11:53
Update tests in whereD.test to account for the change in the previous commit. check-in: da49700c user: dan tags: trunk
11:44
Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c]. check-in: e3b1f625 user: dan tags: trunk
02:08
Detect and report oversized records constructed from multiple zeroblobs. check-in: 9e139afd user: drh tags: trunk
2015-04-10
21:16
Minor build enhancements for MSVC. check-in: 40c417a7 user: mistachkin tags: trunk
19:41
Work toward adding the --changeset option to the sqldiff utility program. Changes are incomplete. This is an incremental check-in. check-in: 463e38d7 user: drh tags: sqldiff-changeset
16:05
In sqlite3_declare_vtab(), avoid accessing the database structure until after the "api-armour" safety-check has completed and the db mutex has been obtained. check-in: 860e4f8a user: dan tags: trunk
12:04
Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY KEY and the parent table contains other columns named "rowid", "_rowid_", and "oid". check-in: ed3cbaab user: drh tags: trunk
08:28
Update this branch with the latest changes from sorter-opt. Leaf check-in: 08c0b19b user: dan tags: insert-select-opt
08:20
Update this branch with latest trunk changes. check-in: 60be9c1c user: dan tags: sorter-opt
07:55
Do not allow virtual table constructors to be called recursively. check-in: 0a72726d user: dan tags: trunk
2015-04-09
19:39
Fix incorrect column names in UPDATE statements generated by the sqldiff utility. check-in: ee53b460 user: drh tags: trunk
19:19
Updates to comments describing the changeset and patchset formats. check-in: 5342f721 user: dan tags: sessions
18:14
Add the --primarykey option to the sqldiff tool, which causes it to use the schema-defined PRIMARY KEY. check-in: 5063f907 user: drh tags: trunk
16:30
Remove two pointless assert() statements. This should silence harmless compiler warnings reported at https://bugzilla.mozilla.org/show_bug.cgi?id=1152845 check-in: 83b342a4 user: drh tags: trunk
13:40
Fix comment typos in the sqldiff.c utility program. check-in: 32ab2bb9 user: drh tags: trunk
13:34
Add the "sqldiff" utility program. check-in: 88da5bf5 user: drh tags: trunk
11:24
Remove a variable initializion to silence a harmless compiler warning. check-in: 79861adb user: drh tags: trunk
2015-04-08
16:43
Fix problems in the sessions module causing it to produce spurious SQLITE_NOMEM errors when handling SQL text or blob values zero bytes in size. check-in: b9459d59 user: dan tags: sessions
16:01
Add experimental API sqlite3session_diff(). Closed-Leaf check-in: c4340b2e user: dan tags: sessions-diff
14:01
Merge all changes for version 3.8.9 into the ota-update branch. check-in: ec9d907a user: drh tags: ota-update
12:47
Merge in all version 3.8.9 changes from trunk. check-in: 30121870 user: drh tags: apple-osx
12:16
Version 3.8.9 check-in: 8a8ffc86 user: drh tags: trunk, release, version-3.8.9
2015-04-07
23:10
Merge printf() width and precision overflow fixes from trunk. check-in: aeca95ac user: drh tags: sessions
21:18
Merge updates from trunk. check-in: c458db41 user: mistachkin tags: expShell
15:39
Avoid signed integer overflow when converting oversized in-line integer widths and precisions in printf(). check-in: 8e4ac2ce user: drh tags: trunk
14:38
Another change to avoid a problem caused by integer overflow in the printf() code. check-in: 95625ef3 user: dan tags: trunk
13:28
Further changes to guard against integer overflow in the width and precision of printf() arguments. check-in: 5ce4e7d7 user: drh tags: trunk
12:41
Guard against excessive width and precision in floating-point conversions in the printf routines. check-in: c494171f user: drh tags: trunk
2015-04-06
12:08
Merge obscure problem fixes from trunk. check-in: 271c110b user: drh tags: sessions
11:04
Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. check-in: 3ad829e5 user: dan tags: trunk
09:05
Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. Closed-Leaf check-in: 0cdf5028 user: dan tags: fts3-prefix-query-fix
2015-04-04
16:49
Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. check-in: edc1de2a user: dan tags: trunk
16:43
Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. Closed-Leaf check-in: 427b50fb user: dan tags: compound-order-by-fix
00:02
Enhance the 'releasetest.tcl' tool to support MSVC. check-in: f664bfdc user: mistachkin tags: winTest
2015-04-03
20:33
Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and is not yet ready for release. check-in: 4ae9a3ac user: drh tags: trunk
18:33
Add source code to the "showlocks" utility program in the tool/ subdirectory. check-in: 6868cc66 user: drh tags: trunk
2015-04-02
17:46
Fix build with OSTRACE enabled on Windows when building using separate source files. check-in: 5f6e3580 user: mistachkin tags: winTest
15:24
Disable e_walauto.test on OpenBSD, as it requires a coherent cache. check-in: 90701227 user: dan tags: trunk
09:06
Fix a problem in vdbesort.c to do with caching unpacked records. check-in: 80a00539 user: dan tags: sorter-opt
2015-04-01
18:22
Merge latest trunk changes with this branch. check-in: 4621b2ee user: dan tags: sorter-opt
16:39
Merge recent enhancements from trunk. check-in: aea439bd user: drh tags: sessions
16:13
Merge all recent trunk fixes and enhancements into the apple-osx branch. check-in: 71b6f507 user: drh tags: apple-osx
13:21
Improved detection and suppression of endless loops in clearDatabasePage(). check-in: 30011ad2 user: drh tags: trunk
01:26
The build is still broken. Multiple definitions of sqlite3OSTrace when compiled using separate source files. check-in: 5c965a71 user: drh tags: winTest
2015-03-31
19:40
On windows, flush the mapping view when syncing content to disk. check-in: a828e73d user: drh tags: trunk
2015-03-27
18:22
Merge updates from trunk. Closed-Leaf check-in: 45acf6a8 user: mistachkin tags: winViewFlush
18:20
Enhancements to OSTRACE usage in the Win32 VFS. check-in: ab580029 user: mistachkin tags: trunk
02:27
Fix the ".testctrl imposter" command in the command-line shell to be consistent in error reporting and results with the other .testctrl commands. check-in: 0ec08ba8 user: drh tags: trunk
00:21
Using MSVC, get the sqlite3IoTrace variable working with the USE_STDCALL and/or DYNAMIC_SHELL options. check-in: fe976c91 user: mistachkin tags: trunk
00:19
In the MSVC Makefile, make the DYNAMIC_SHELL option work without USE_STDCALL. check-in: 25b46a9c user: mistachkin tags: trunk
2015-03-26
23:36
When syncing a memory mapped file on Windows, flush the mapped view as well. check-in: df204049 user: mistachkin tags: winViewFlush
18:24
Revise Win32 locking test to account for recent log message changes. check-in: 1bc76339 user: mistachkin tags: trunk
17:04
Avoid leaving the malloc subsystem in a partially initialized state if the low-level initialization callback fails. check-in: 3e872011 user: drh tags: trunk
15:27
Provide source code line numbers for errors in the Windows VFS generated by the winLogIoerr() routine. check-in: b5da0d93 user: drh tags: trunk
14:29
Fix a harmless compiler warning in FTS3. check-in: 1688f60c user: drh tags: trunk
2015-03-25
18:29
Change an unreachable branch into an assert(). check-in: fb076b28 user: drh tags: trunk
17:35
Fix the saveCursorPosition() routine in btree.c so that it works correctly for a eState=CURSOR_SKIPNEXT cursor. check-in: 37866b4d user: drh tags: trunk
13:06
Reactivate an older assert() (adding an "|| CORRUPT_DB" term) and add a new assert() in btree.c. check-in: 1e96520a user: drh tags: trunk
12:05
Add two new assert()s to the sqlite3BtreeDataSize() method. check-in: 42d1793d user: drh tags: trunk
2015-03-24
22:00
Add SQLITE_STDCALL and SQLITE_CDECL macros on public function definitions. check-in: cae3239a user: mistachkin tags: trunk
21:54
Further simplifications to the amalgamation builder. Closed-Leaf check-in: e826cd7d user: drh tags: stdcall
21:52
Update the 'mksqlite3c-noext' tool as well. check-in: a5322566 user: mistachkin tags: stdcall
21:34
Fix a couple comment typos in a tool script. No changes to code. check-in: 83421af6 user: mistachkin tags: trunk
21:27
Add SQLITE_STDCALL and SQLITE_CDECL macros on public function definitions. check-in: 242f09d4 user: mistachkin tags: stdcall
18:19
Suppress a compiler warning that was appearing with SQLITE_THREADSAFE=0. check-in: 436314b5 user: drh tags: trunk
16:43
Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. check-in: cbeb9a1a user: drh tags: trunk
14:57
Add tests to check that attempting to DROP a virtual table while it is use does not cause problems. Closed-Leaf check-in: 5ee625b1 user: dan tags: nVDestroy
14:57
Simplify the EXPLAIN output of virtual table P4 parameters to only show the pointer to the sqlite3_vtab object and omit the sqlite3_module object. Closed-Leaf check-in: 85610bbb user: drh tags: nVDestroy
14:05
More defenses against virtual table being deleted out from under a running statement. check-in: 116c9982 user: drh tags: nVDestroy
13:32
Prevent a virtual table from being destroyed while it is in use. check-in: fba674c0 user: drh tags: nVDestroy
12:51
Replace the Vdbe.inVtabMethod field with the sqlite3.nVDestroy counter. check-in: 9faefb96 user: drh tags: nVDestroy
2015-03-23
21:32
Disable loadable extensions in the command-line shell on VxWorks user-space. check-in: 0ee2d38d user: drh tags: trunk
19:55
Track total memory usage using a 64-bit integer on 64-bit systems. Add the sqlite3_status64() interface. Make the sqlite3_status() and sqlite3_status64() interfaces atomic using mutexes and verify correct mutex operation using assert() statements. check-in: 6fc4e79a user: drh tags: trunk
19:16
Fix a non-C89 variable declaration that causes problems for MSVC. Closed-Leaf check-in: 3de085ea user: drh tags: status64
19:03
Fix datetype size asserts in btree.c. check-in: ff4812d0 user: drh tags: trunk
18:52
Add the SQLITE_PTRSIZE macro. Use it to help sqlite3_status() run faster on 32-bit systems. check-in: c742bd60 user: drh tags: status64
17:25
Add the sqlite3_status64() interface. Make the new interface and the legacy sqlite3_status() both atomic and threadsafe. Check threadsafety using assert()s. check-in: 1ce8e8fa user: drh tags: status64
2015-03-22
10:23
Fix a potential NULL pointer dereference following a syntax error. check-in: 8d27e3e1 user: drh tags: trunk
2015-03-21
23:38
Fix harmless compiler warnings with MSVC when assert() and SQLITE_MEMDEBUG are both enabled. check-in: 9513dbd4 user: mistachkin tags: trunk
22:23
Add more comments to the MSVC batch build tool. check-in: 03522da3 user: mistachkin tags: trunk
22:13
Increase the debugging level for the debug configuration in the MSVC batch build tool. check-in: 041484ff user: mistachkin tags: trunk
20:59
Do not invoke a C preprocessor macro with an empty argument, as (reportedly) some versions of GCC are unable to deal with that. check-in: de9da317 user: drh tags: trunk
20:50
Add a missing "int" on a constant declaration. check-in: 235157de user: drh tags: trunk
19:35
Avoid a segfault if NULL is passed as the first argument to SQL scalar function fts3_tokenizer(). check-in: 6d098969 user: dan tags: trunk
16:40
Change walblock.test to block an external process for 10 seconds, not 5. 5 seconds is not long enough to tell the difference between a blocking lock and a series of retries. check-in: 717335fc user: dan tags: trunk
16:36
Fix the blocking WAL lock so that it works and so that it compiles on a Mac. check-in: 67d69d21 user: drh tags: trunk
12:25
Remove an unreachable branch from the OP_VCreate opcode (merge accidental fork in trunk). check-in: 2fbfec62 user: dan tags: trunk
12:22
Avoid an integer overflow in fts3 causing gcc 4.7.1 with -O2 to behave counter-intuitively (perhaps because the behaviour is undefined). Add an "ifcapable trace" to a test in shell4.test. check-in: e3e23464 user: dan tags: trunk
12:22
Remove an unreachable branch from the OP_VCreate opcode. check-in: 5fca41a3 user: drh tags: trunk
10:53
Add a missing "ifcapable fts3" to a test case in vtab2.test. check-in: d845b0f6 user: dan tags: trunk
03:18
Correctly detect the error of having a "*" wildcard on a SELECT without a FROM clause on the left-hand side of a recursive CTE. check-in: b11d1793 user: drh tags: trunk
02:58
If a column is both UNIQUE and a PRIMARY KEY, make sure the PRIMARY KEY designation takes precedence. check-in: d871a792 user: drh tags: trunk
02:25
Remove superfluous define from the MSVC makefile. check-in: 880d2513 user: mistachkin tags: trunk
02:22
Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. check-in: 737630b8 user: mistachkin tags: trunk
2015-03-20
16:54
Provide the BTREE_SEEK_EQ hint to the b-tree layer. check-in: 3c367004 user: drh tags: trunk
16:34
Fix to get SQLITE_SMALL_STACK working correctly again after the previous change. Closed-Leaf check-in: 78df0ce1 user: drh tags: seek-eq
14:57
Provide the BTREE_SEEK_EQ hint to the b-tree layer. check-in: e750830f user: drh tags: seek-eq
08:43
Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. check-in: eddc05e7 user: dan tags: trunk
2015-03-19
20:09
If a virtual table is created with a malformed UTF8 name in a UTF16 database, make sure that does not cause problems. check-in: b74cb0a9 user: drh tags: trunk
19:59
Fix a crash that can occur following an OOM condition within a CREATE VIRTUAL TABLE statement on a utf-16 database. Closed-Leaf check-in: 9453e7da user: dan tags: malformed-vtab-name
18:56
Fix a problem with creating virtual table with names specified using malformed utf-8 within utf-16 databases. check-in: 9969cff2 user: dan tags: malformed-vtab-name
16:25
Fix an FTS3/4 problem with handling empty tokenizer declarations (e.g. "CREATE VIRTUAL TABLE t(tokenize=);"). check-in: 26d2def8 user: dan tags: trunk
15:52
Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. check-in: ad4b19d2 user: dan tags: trunk
15:04
Add an assert() to check that the database mutex is held in sqlite3BtreeLeave(). check-in: 31f54d7b user: dan tags: trunk
14:48
Fix typo in shell error message. check-in: 775a02d5 user: mistachkin tags: trunk
13:30
Fix a bug in error handling in the ".trace" command of the command-line shell. check-in: 6a48b5d7 user: drh tags: trunk
2015-03-18
16:00
Add another sqlite3FaultSim() to the multi-threaded sorter logic to improve testability. check-in: 49ea2cde user: drh tags: trunk
2015-03-17
20:39
Clarify the documentation on sqlite3_errcode(). No changes to code. check-in: 2c0e0d87 user: drh tags: trunk
17:08
Also merge the WAL blocking lock tests that were somehow missed on the previous check-in. check-in: 7214dab7 user: drh tags: trunk
16:59
Transient locks in WAL mode can now block in order to resolve priority inversions. check-in: ec2f46de user: drh tags: trunk
16:01
Add a test for the change on this branch. Closed-Leaf check-in: e22dde18 user: dan tags: wal-blocking-lock
2015-03-16
20:40
Make SQLite slightly more likely to use an auto-index within a sub-query. check-in: ab832336 user: dan tags: trunk
18:08
Fix typo of test prefix in the new WHERE test file. check-in: 34779c52 user: mistachkin tags: trunk
17:48
When the WHERE clause contains two OR-connected terms with identical operands but different operators, try to combine them into a single term. Example: (X=A OR X>A) becomes (X>=A). check-in: 8bdda827 user: drh tags: trunk
17:07
Modify the fts3query.test script so that it works even when testfixture is built using a version of TCL that is unable to sort the integer -9223372036854775808 check-in: f61fd24b user: drh tags: trunk
16:44
When deleting the master journal to commit a multi-database transaction, do not sync the directory if PRAGMA synchronous=OFF for all participating database files. check-in: 018d7671 user: drh tags: trunk
16:28
When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. This generates more accurate estimates. check-in: 3e0590de user: dan tags: trunk
13:48
Use #ifdef to omit code that is only used for STAT3 and STAT4. check-in: f2c9c5b5 user: drh tags: trunk
13:12
Improved comments. No code changes. Closed-Leaf check-in: 23f71a26 user: drh tags: combine-disjuncts
12:13
When a WHERE clause contains disjuncts with the same operands, try to combine them into a single operator. Example: (x=A OR x>A) becomes (x>=A). check-in: 7a309768 user: drh tags: combine-disjuncts
09:21
Another test case for the planner change on this branch. Closed-Leaf check-in: f2207a06 user: dan tags: stat4-change
2015-03-14
18:59
When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. check-in: e1caf93c user: dan tags: stat4-change
2015-03-13
15:44
Add tests to ensure "PRAGMA incremental_vacuum" and "PRAGMA auto_vacuum = incremental" handle corrupt databases correctly. check-in: 1c2166cb user: dan tags: trunk
08:31
Extra tests for commit [0f250957]. check-in: 5aa522dc user: dan tags: trunk
00:11
Remove debugging logic accidently included in the previous check-in. check-in: 2887fb38 user: drh tags: trunk
2015-03-12
23:48
Fix the "now" option for date-time functions for cases when STAT4 is disabled. check-in: 3ac1f6a3 user: drh tags: trunk
21:22
When STAT4 is enabled, allow probes of the STAT4 table using the value of constant functions computed at compile-time. check-in: 0f250957 user: drh tags: trunk
21:02
Always disallow functions as the DEFAULT of a column. Add assert()s and Closed-Leaf check-in: a991bb1a user: drh tags: stat4-function
19:12
Disable multiplexing of master-journal files in the test_multiplex.c module. check-in: b8684df3 user: dan tags: trunk
18:38
If an error occurs in the compile-time evaluation of an application-defined function, then propagate back out the exact error code, not just the generic SQLITE_ERROR. check-in: 93f42586 user: drh tags: stat4-function
06:46
The valueFromFunction() routine is better able to handle OOM errors. Omit unreachable branches. check-in: 8fb6bd9b user: drh tags: stat4-function
05:08
Improve the text on one of the opcode documentation comments in vdbe.c. check-in: 08958f57 user: drh tags: trunk
2015-03-11
20:59
Allow the default value for columns added using ALTER TABLE ADD COLUMN to be a function in existing schemas loaded from disk. But prevent this version of SQLite from being used to create such a column. check-in: ff868e22 user: dan tags: stat4-function
20:06
Allow the query planner to evaluate deterministic scalar SQL functions used in WHERE constraints if all arguments are SQL literals in order to compare the results with sqlite_stat4 sample data. check-in: b7f1fc26 user: dan tags: stat4-function
14:34
Expand the multi-process test cases to repeat each case 20 times and to repeat tests using different journal modes. check-in: a2715b04 user: drh tags: trunk
2015-03-10
20:22
Arrange for some of the transient locks in WAL mode to block, as a single to the OS to fix priority inversions. check-in: c6e6d5f4 user: drh tags: wal-blocking-lock
15:34
Fix an incrblob2 test case so that it works on 32-bit systems. check-in: 8d0b11c9 user: drh tags: trunk
13:50
Revise test cases in malloc5.test to accommodate varying allocation sizes returned by some system malloc() implementations. check-in: fbae6baf user: drh tags: trunk
2015-03-09
13:01
Fix the LIKE optimization so that it works even if there are additional range contraints on the column that is subject to the LIKE or GLOB. check-in: 984c3fd5 user: drh tags: trunk
12:11
Always use LIKE optimization range constraints in pairs. Closed-Leaf check-in: 0e02dc94 user: drh tags: like-opt-fix
10:40
Increase the version number to 3.8.9 check-in: e5da5e7d user: drh tags: trunk
2015-03-07
20:32
Fix another problem with the LIKE optimization. check-in: 465bfc72 user: drh tags: like-opt-fix
13:56
Fix the LIKE optimization so that it finds BLOB entries in addition to text entries. Ticket [05f43be8fdda9f]. check-in: 74cb0b03 user: drh tags: trunk
12:58
New test cases for LIKE and GLOB with BLOB left-hand side values. Closed-Leaf check-in: 50fa3c5f user: drh tags: like-opt-fix
03:02
Remove some code that is commented out. check-in: 55ff4291 user: drh tags: like-opt-fix
02:51
Fix problems with reverse order sorting and indexes in the LIKE optimization. check-in: 564b8fe7 user: drh tags: like-opt-fix