SQLite
Timeline
Not logged in

100 check-ins occurring around fc49f556e4.

2016-05-27
01:07
Fix the Lemon-generated parser so that it compiles with -DYYSTACKDEPTH=0. It does compile now, but there are subtle issues still. check-in: 28d439f8 user: drh tags: trunk
2016-05-26
20:56
Add a new OP_SeekRowid opcode, that combines the functions of OP_MustBeInt and OP_NotExists. This makes the code slightly smaller and faster. check-in: ffe80a1b user: drh tags: trunk
20:52
Add further instrumentation to the bc_test1.c test app. check-in: 5528de4a user: dan tags: begin-concurrent
2016-05-25
18:53
Add the libvers.c tool in the tool/ subdirectory. check-in: 2a41f098 user: drh tags: trunk
2016-05-24
18:55
Enhance Lemon and the parser template so that it can once again build parsers that have no unreachable branches. check-in: 41fd46e2 user: drh tags: trunk
18:50
Minor change to the walcrash4.test module so that it works when SQLITE_DEFAULT_WAL_SYNCHRONOUS is set to something other than 2. check-in: 61e239bc user: drh tags: trunk
16:20
Fix an obscure problem with transactions written in "PRAGMA synchronous=full" mode on systems that do not support POWERSAFE_OVERWRITE causing an xSync() call to be omitted if the last frame written by a transaction is aligned to a sector boundary. This means that if a power failure or OS crash occurs very soon after such a transaction is committed, it may be lost following system recovery. check-in: 37de3eab user: dan tags: trunk
00:40
Improvements to the initialization of the push-down automoton for the Lemon-generated parser. Smaller and faster. check-in: 3b28b68e user: drh tags: trunk
2016-05-23
21:56
Use a pointer to the top of the stack rather than an index into the stack in the Lemon-generated parser template, for about 6.6% parser performance gain. check-in: 3c2a7705 user: drh tags: trunk
19:02
Avoid a minor error message when running RTREE without an sqlite_stat1 table. check-in: 276e92f5 user: drh tags: trunk
18:27
Fix the rtreeG.test test case. Closed-Leaf check-in: 9589e937 user: drh tags: tree-stat1-fix
18:12
Fix RTREE so that it does not run queries against the sqlite_stat1 if that table does not exist. check-in: 48526a2f user: drh tags: tree-stat1-fix
18:06
Remove an extra "finish_test" from the end of rtreeC.test. check-in: bfbb6dd8 user: drh tags: tree-stat1-fix
16:16
Improve the error messages generated by the rtree module when a constraint fails. check-in: 3ad2531e user: dan tags: trunk
16:15
Lemon enhancement: avoid unnecessary reduce actions that convert one non-terminal into another but have no side effects. check-in: a86e782a user: drh tags: trunk
14:24
Fix comment typos and improve clarity of presention in Lemon. The output should be identical. check-in: b91a5b82 user: drh tags: trunk
02:57
Merge changes from trunk. check-in: 815cc2bb user: drh tags: apple-osx
00:10
Update the configure script with additional hints on the location of tclConfig.sh, hints needed by the latest versions of Xcode. check-in: 90411a28 user: drh tags: trunk
2016-05-21
23:25
More tweaks to improve the performance of the insert logic, slightly. check-in: dec13075 user: drh tags: trunk
20:03
Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. check-in: 55f348cd user: drh tags: trunk
19:10
Remove some unused legacy code from the btree insert logic. check-in: 2ce11667 user: drh tags: trunk
18:50
Use pthreads mutexes and conditions to synchronize threads in bc_test1. check-in: f33aa76f user: dan tags: begin-concurrent
12:29
Yet another minor size reduction and performance increase in the b-tree insert logic. check-in: 1dbaf7a1 user: drh tags: trunk
11:23
Small size reduction and performance increase in the sqlite3BtreeInsert() logic. check-in: 656aa1ec user: drh tags: trunk
00:45
Add the shell-script used for routine performance testing. check-in: 8e366f18 user: drh tags: trunk
2016-05-20
23:51
Add a simple TCL script for summing cachegrind information for each VDBE opcode. check-in: 96cf821b user: drh tags: trunk
21:40
Another optimization on the OP_Column opcode. check-in: 1765672c user: drh tags: trunk
20:58
Fix typo in comment. check-in: 9db8f214 user: mistachkin tags: trunk
19:51
Slight performance improvement in the OP_Column opcode. check-in: 5c157474 user: drh tags: trunk
18:09
Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. check-in: f250166b user: drh tags: trunk
15:53
Performance optimization and size reduction on the freeP4() routine. check-in: 4dc56e86 user: drh tags: trunk
15:24
Increase the version number to 3.14.0 since we are already making significant code changes. check-in: 1a0d0576 user: drh tags: trunk
15:15
Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. check-in: 3d55d24d user: drh tags: trunk
14:54
Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. check-in: 9033afbb user: drh tags: trunk
14:11
For queries with both ORDER BY and LIMIT, if the rows of the inner loop are emitted in ORDER BY order and the LIMIT has been reached, then optimize by exiting the inner loop and continuing with the next cycle of the first outer loop. check-in: 559733b0 user: drh tags: trunk
13:44
Set the NULLEQ flag on the sequence counter comparison in the ORDER BY LIMIT optimization, to avoid coverage complaints about not testing the NULL case. Closed-Leaf check-in: ed1b30dc user: drh tags: orderby-limit
12:22
Autoconf configure.ac adjustment to try to get it to look for both editline and readline automatically. check-in: 645bd696 user: drh tags: trunk
00:21
A few simple test cases for the ORDER BY LIMIT optimization. check-in: 08849eab user: drh tags: orderby-limit
2016-05-19
22:40
Appears to work now. Needs test cases, more comments, and code optimization. check-in: 990fe50c user: drh tags: orderby-limit
22:13
In a query with both ORDER BY and LIMIT, if the inner loop satisfies the ORDER BY then try to cut short each invocation of the inner loop once the LIMIT has been satisfied. This check-in is a partial implementation only. check-in: 852d1eda user: drh tags: orderby-limit
19:31
Fixup comments on wctrlFlags value definitions. check-in: 58b516e8 user: drh tags: trunk
18:56
Clean up the WHERE_* macros used for the wctrlFlags parameter on the sqlite3WhereBegin() interface, freeing up some bits to be used for other things. check-in: d0130584 user: drh tags: trunk
17:51
Optimization marks in vdbe.c. No logic changes. check-in: cf273741 user: drh tags: trunk
16:58
Performance improvement in the OP_Column opcode. check-in: 4737cadc user: drh tags: trunk
16:21
Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. check-in: 1f577e1f user: dan tags: trunk
11:12
Small size reduction and performance improvement in the OP_Column opcode. check-in: 0d773061 user: drh tags: trunk
2016-05-18
21:03
Add the "scrub" utility program that simultaneously backs-up a live database and erases all deleted content. check-in: c981ab2a user: drh tags: trunk
21:01
Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. check-in: 915416d1 user: drh tags: trunk
20:53
Merge the 3.13.0 release changes. check-in: e2e9b985 user: drh tags: apple-osx
10:57
Version 3.13.0 check-in: fc49f556 user: drh tags: trunk, release, version-3.13.0
2016-05-17
21:17
Enhance the scrub utility program so that it does a FULL checkpoint prior to starting the backup, to ensure that the database file content matches what needs to be backed up without having to look at the WAL file. Closed-Leaf check-in: ab1c5ce5 user: drh tags: scrub-backup
17:11
Merge the latest changes from trunk. check-in: 5021dfe1 user: drh tags: scrub-backup
2016-05-16
14:35
Do not run snapshot_fault.test as part of the inmemory_journal permutation. check-in: 995c084b user: dan tags: trunk
13:37
Merge recent fixes from trunk. check-in: 0d9b82af user: drh tags: apple-osx
11:55
Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. check-in: 386bcbba user: drh tags: trunk
2016-05-13
17:22
Improvements to a comment in the pcache.c file. No changes to code. check-in: b369980f user: drh tags: trunk
15:22
Remove the unused PGHDR_NEED_READ flag. Add invariant checking (during SQLITE_DEBUG builds only) for the PgHdr object. check-in: 771c5411 user: drh tags: trunk
12:12
Clarification of the pagerFlushOnCommit() logic. check-in: 3401d9dc user: drh tags: trunk
11:50
Fix pager_end_transaction() to ensure that a ROLLBACK does not clobber unwritten pages in a TEMP file pcache. check-in: 9495d338 user: drh tags: trunk
04:24
Additional debugging and tracing logic for pcache.c, turned off by default using an "#if 0". check-in: 32a62e3b user: drh tags: trunk
2016-05-12
19:17
Disable ALWAYS and NEVER when compiled with SQLITE_MUTATION_TEST. check-in: 24d9fbc1 user: drh tags: trunk
19:05
Simplification of the sqlite3FaultSim() call inside of sqlite3PagerCommitPhaseOne(). check-in: 1b0f4cc3 user: drh tags: trunk
18:38
Add an assert in pager.c to confirm that pPager->tempFile is always true for in-memory databases. check-in: 3fd71092 user: drh tags: trunk
17:06
Add extra OPTIMIZATION-IF-FALSE comments where required to pcache.c. check-in: 9d55b8f5 user: dan tags: trunk
12:08
For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". check-in: 06c1e27c user: drh tags: trunk
12:01
Remove an unnecessary call to sqlite3PcacheMakeClean() inside of the ROLLBACK logic. check-in: 0dc50d99 user: drh tags: trunk
09:48
Add a missing OPTIMIZATION-IF-FALSE comment to pcache.c. check-in: bc202e5b user: dan tags: trunk
2016-05-11
23:54
For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". Closed-Leaf check-in: ad601c79 user: drh tags: pager-dev
20:03
Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. check-in: 3bfd2621 user: dan tags: trunk
18:20
Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. Closed-Leaf check-in: 4533ed35 user: dan tags: mistake
15:41
Remove some a small amount of redundant code related to PCache.pSynced from pcache.c. check-in: 9cc8cad7 user: dan tags: trunk
12:47
Do not reset the page cache when a rollback journal truncate fails, as doing so can cause loss of information for an in-memory TEMP file. check-in: 345ce1c9 user: drh tags: trunk
11:04
Always truncate, rather than persist, the rollback journal of a TEMP database. check-in: 42fb6f1e user: drh tags: trunk
10:57
Add pcache tracing macros. Off by default. Requires changing an "#if 0" and recompiling to enable. check-in: d9313d19 user: drh tags: trunk
2016-05-10
20:16
Add another test case to temptable3.test. check-in: 22364024 user: dan tags: trunk
20:03
Fix a problem in sqlite3PagerMovepage() when working on a temp table for which pages have been spilled. check-in: 20cf8811 user: drh tags: trunk
2016-05-09
23:11
Fixes to requirements marks. No changes to code. check-in: 79ecd0ef user: drh tags: trunk
22:35
Enhancements to test/sort5.test so that it works with SEE. check-in: 8a39c8ee user: drh tags: trunk
22:32
Remove some forgotten debugging lines from test/sort5.test. check-in: f5875489 user: drh tags: trunk
19:58
Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. Closed-Leaf check-in: da94a6e0 user: drh tags: dev
19:03
Update a comment in fts5.h. No changes to code. check-in: 14e53d0e user: dan tags: trunk
18:05
Fix the FTS5 xQueryPhrase() API function so that it recognizes column filters. check-in: 48505cde user: dan tags: trunk
2016-05-07
18:02
Add options to bc_test1.c to make it more flexible. check-in: ec6ef5f2 user: dan tags: begin-concurrent
12:15
Make the sqlite3DeleteTable() routine smaller and faster. check-in: d75140b8 user: drh tags: trunk
12:15
Fix typo in the intpkey-17.2 test. check-in: a45fda65 user: drh tags: trunk
2016-05-06
21:04
Add test/bc_test1.c, for testing the degree of concurrency provided by this branch under various conditions. check-in: 128c7eae user: dan tags: begin-concurrent
20:23
Simplification to the logic used to decide between OP_Seek and OP_NotExists. Use OP_NotExists for both DELETE and UPDATE. check-in: 3a695263 user: drh tags: trunk
18:47
Corrections to comments on the whereScanInit() interface. check-in: ab7ab415 user: drh tags: trunk
16:49
For DELETE operations, make sure that seeks on the main table are not deferred, since if they are and none of the indexes reference columns of the table, the seek might never occur until the OP_Delete opcode, which is too late. Fix for ticket [16c9801ceba49]. check-in: 93a2bace user: drh tags: trunk
16:30
Fix an error in main.mk causing testfixture to use individual fts5 source code files instead of fts5.c. check-in: 933a1c81 user: dan tags: trunk
16:06
In the WHERE generator, when building code for a DELETE operation, make sure that seeks to the main table are not deferred. This is a better fix for the [16c9801ceba49] bug than the previous. Closed-Leaf check-in: 150dd09e user: drh tags: ticket-16c9801ce
15:16
Fix a bug in sqlite_analyzer causing it report (slightly) incorrect values for the number of entries in indexes or WITHOUT ROWID tables. check-in: dc37750d user: dan tags: trunk
11:31
Do not scan indexes that have the integer primary key as their left-most column. This fixes the crash of ticket [16c9801ceba] but it seems like the wrong fix. More investigation needed. check-in: 50312273 user: drh tags: ticket-16c9801ce
2016-05-05
23:59
Additional error reporting. Open the source database read/write so that it can delete the WAL file when done. check-in: d2efd3c1 user: drh tags: scrub-backup
23:39
Working when run against sqlite.fossil. check-in: b0bd9dd6 user: drh tags: scrub-backup
23:09
Finished implementation compiles, but untested. check-in: aeb88bdf user: drh tags: scrub-backup
17:15
Initial check-in of the "scrub.exe" utility program prototype. Not yet fully functional. In particular, no scrubbing is done. check-in: bdf2ec77 user: drh tags: scrub-backup
11:53
Renumber internal constants in the printf() implemention for a small performance improvement. check-in: 69d11447 user: drh tags: trunk
2016-05-04
21:06
Disable the session extension API if SQLITE_ENABLE_SESSION is not defined. check-in: 71af9ac1 user: drh tags: trunk
19:04
Fix typo in comment. No changes to code. check-in: 6c43ba1c user: mistachkin tags: trunk