/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 check-ins occurring around ebc9433fddf78ef7.

2010-02-25
16:09
Fixed numbering of a few tests; minor tweaks on others; added a couple new tests to stress previous simplifications to compile-time option reporting functions. check-in: 9b18dfd1 user: shaneh tags: trunk
15:28
Minor simplifications to the compile-time option reporting functions and pragmas to facilitate coverage testing. check-in: 633d8747 user: drh tags: trunk
14:56
Expire pragma statements when reset, even if they were not run to completion. check-in: b8fbf427 user: drh tags: branch-3.6.22
14:47
Expire pragma statements when reset, even if they were not run to completion. check-in: 78351d28 user: drh tags: trunk
14:44
Add some technically unnecessary variable initializations to silence compiler warnings. check-in: a2550597 user: dan tags: branch-3.6.1
04:15
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] check-in: f0ae251a user: drh tags: trunk
02:32
Merge in all of the logging enhancements. This is a cherrypick merge of the following check-ins: [103321e37a], [a8076aede3], [6d910245ad], [7c4cca6d1a], [edea3bb740], [1a6d4bb130], [a8c984c1d6], [69a493182f], and [1168763d2c]. check-in: 46f406b2 user: drh tags: branch-3.6.22
02:11
Fix a segfault that is possible for an OOM fault in ATTACH when in shared-cache mode. This is a cherrypick merge of check-in [e37137376a]. check-in: f73cc0e9 user: drh tags: branch-3.6.22
02:04
Enhance integrity_check to detect out-of-order rowids. This is a cherrypick merge of check-in [cae47c5b09]. check-in: ecd22ef3 user: drh tags: branch-3.6.22
01:54
Merge in the fix for VACUUM on auto_vacuumed databases with large schemas. Check-in [86d50ce57f]. Ticket [da1151f97df]. check-in: ce624e39 user: drh tags: branch-3.6.22
01:47
Start a new branch for release 3.6.22 plus limited enhancements and fixes. This first check-in includes the performance enhancements of check-ins [26cb1df735], [61a2c8d4d6], and [27dc5b1c52] check-in: 95882598 user: drh tags: branch-3.6.22
2010-02-24
21:44
Add testcase() macros beside each sqlite3_log() call to make sure it is tested with both logging enable and disabled. check-in: 1168763d user: drh tags: trunk
19:36
Changes to compile time option diags to report values for some defines. Added test cases to TCL test suite (ctime.test). check-in: dd480f62 user: shaneh tags: trunk
19:23
Add a sqlite3_log() call on anonymous constraint failures. Fix the output of test cases having to do with improved reprepare reporting. Fix the VACUUM command to report more helpful error messages when things go wrong. check-in: 69a49318 user: drh tags: trunk
18:40
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. check-in: a8c984c1 user: drh tags: trunk
18:25
Remove an unused variable from rtree. check-in: 8e60d399 user: drh tags: trunk
17:15
Enhancements to the way errors are reported up when an automatic statement reprepare fails. check-in: 1a6d4bb1 user: drh tags: trunk
15:10
Fix an assertion fault that occurs when two different virtual tables are used in a single UPDATE statement. Ticket [d2f02d37f52b]. check-in: ff61e0fd user: drh tags: trunk
2010-02-23
21:08
Fix the stmt.test test script so that it works with SQLITE_TEMP_STORE=3. check-in: 8bf710ce user: drh tags: trunk
20:32
Merge the compile-time option introspection interfaces into the trunk. check-in: 9f429434 user: drh tags: trunk
20:11
Continuing improvements to error reporting and the sqlite3_log() routine. check-in: edea3bb7 user: drh tags: trunk
20:08
Refactored compile time option diagnostic support to use strings identifiers instead of bitmask. Closed-Leaf check-in: 76a0294a user: shaneh tags: compile_opts
18:05
Fix a segfault that can occur if a malloc fails in ATTACH in shared-cache mode. check-in: e3713737 user: dan tags: trunk
17:36
Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging output for CORRUPT, and CANTOPEN errors. check-in: 7c4cca6d user: drh tags: trunk
10:56
Fix a segfault that can occur if a malloc fails in ATTACH in shared-cache mode. check-in: 875f8fa3 user: dan tags: compile_opts
10:50
Fix a segfault that can occur if a malloc fails in ATTACH in shared-cache mode. check-in: d6343d03 user: dan tags: branch-3.6.1
05:17
Removed checking of some compile options from the sqlite3_compileopts() API. check-in: 833da702 user: shaneh tags: compile_opts
04:19
Test new api to report which options (defines) were used to compile SQLite. check-in: 84c97569 user: shaneh tags: compile_opts
01:47
Add the ".log" command to the shell. This shows that some errors are logged multiple times and other errors are never logged at all. check-in: 6d910245 user: drh tags: trunk
01:01
Remove the ".genfkey" command from the shell. We've had foreign-key support in the core since 3.6.19. Anyone who still needs the simulated foreign-key triggers can always generate them with an older version of the shell. check-in: c4401fc9 user: drh tags: trunk
2010-02-22
23:17
Fix an assertion-fault/segfault problem that comes up when trying to VACUUM an auto-vacuumed database with a large schema. Ticket [da1151f97df244]. check-in: 86d50ce5 user: drh tags: trunk
19:37
Merge in the massive clean-up and ANSI-fication of Lemon carried out by Ryan Gordon. There are no functional changes to SQLite itself - Lemon still generates exactly the same parsing automaton from exactly the same grammar. check-in: 1e8b8420 user: drh tags: trunk
19:32
Log all error messages if logging is enabled. check-in: a8076aed user: drh tags: trunk
2010-02-19
04:28
Changes to pragma integrity_check to check rowid order. Tests of same in corruptE.test. check-in: cae47c5b user: shaneh tags: trunk
2010-02-18
18:45
Add a new, experimental logging interface designed to aid in debugging of deeply embedded projects that use SQLite. check-in: 103321e3 user: drh tags: trunk
08:19
Allow statements like "REPLACE INTO tbl(rowid) VALUES(...)" to run without a statement journal as long as there are no triggers, foreign keys or indexes. check-in: 0e422580 user: dan tags: trunk
2010-02-17
20:31
Report error if the grammar has multiple %type lines for the same nonterminal. check-in: 721f33e7 user: icculus tags: lemon-update-2010
20:22
Fixed % formatting in some printf-style strings. check-in: f96add89 user: icculus tags: lemon-update-2010
20:19
Corrected error message (cut-and-paste bug). check-in: b3839f2a user: icculus tags: lemon-update-2010
19:34
Merge latest changes from the trunk into the apple-osx branch. check-in: 4b72e39b user: drh tags: apple-osx
17:48
Consistent use of #ifdef for SQLITE_HAS_CODEC to avoid confusion. check-in: 34a3413a user: shaneh tags: trunk
05:40
Removed unused variables. check-in: ca570a02 user: icculus tags: lemon-update-2010
04:19
Avoid using the internal printf routine for round(x,y) in the common case where y==0. check-in: d76ad8b3 user: shaneh tags: trunk
03:57
More rounding tests. check-in: 3863638b user: shaneh tags: trunk
2010-02-16
22:06
Remove duplicated assignment in realloc. check-in: c419955d user: shaneh tags: trunk
22:00
Added additional rounding tests. check-in: b8ee76bc user: shaneh tags: trunk
16:09
Removed %expect directive, on drh's advice. check-in: b43ac330 user: icculus tags: lemon-update-2010
16:07
Patched to compile. Accidentally removed va_list declaration. check-in: 673d470c user: icculus tags: lemon-update-2010
12:18
Change a C++ style comment in os_unix.c to use normal C style commenting. check-in: 7a193309 user: dan tags: trunk
10:59
Fix for [e9a9fde1f4]. When opening an existing rtree, determine the node size by inspecting the root node of the r-tree structure (instead of assuming it is a function of the page-size). check-in: ebc9433f user: dan tags: trunk
2010-02-15
18:03
Fix the ALTER TABLE RENAME command so that it converts FOREIGN KEY constraints in ATTACH-ed and in TEMP tables as well as in the main database. Ticket [13336e9c3c8c3f]. check-in: ab197d0a user: drh tags: trunk
16:54
When creating a trigger on a main database table when there is a TEMP table with the same name, make sure the trigger is bound to the main table. Ticket [985771e11612]. check-in: ec914af3 user: drh tags: trunk
15:47
Fix a compiler warning in shell.c. Updates to comments in trigger.c. check-in: c727601e user: drh tags: trunk
15:17
Fix a typo in the documentation for the OP_OpenPseudo opcode. check-in: 9acfb069 user: drh tags: trunk
00:01
Removed the 80-char line formatting for ErrorMsg(), on dhr's suggestion. check-in: 132ea4e5 user: icculus tags: lemon-update-2010
2010-02-14
17:14
Make Lemon able to compile as C++ code. check-in: 75a1060b user: icculus tags: lemon-update-2010
05:42
Added option to not clip error output.    This is useful for IDEs and other tools that benefit from full path information, so they can jump directly to the error line in the source code. check-in: 90602030 user: icculus tags: lemon-update-2010
05:34
Delete output files if this is a failed run.    Otherwise, the fail will stop a Makefile from progressing, but if you immediately run the build again, Make will think the output files are up to date, since they are newer (albeit incomplete/incorrect). check-in: e38c08d9 user: icculus tags: lemon-update-2010
05:19
Added %expect directive, to consider a certain number of conflicts "correct."    This has the side effect of changing the process exit code to never overflow. check-in: d8bab8cf user: icculus tags: lemon-update-2010
00:48
Added -T option, to specify a template filename on the command line.    The default is still "lempar.c", though. check-in: e6cbe1e5 user: icculus tags: lemon-update-2010
2010-02-13
02:31
Merged tracing and initialization changes from mutex_unix.c into mutex_w32.c. check-in: 942aa1f6 user: shaneh tags: trunk
2010-02-12
22:43
Added experimental mutex implementation using interlocked ops and spin locks. Closed-Leaf check-in: f3676b24 user: shaneh tags: experimental
19:46
Enhancements to the secure_delete pragma to make it easier to use. check-in: 2bb38bb9 user: drh tags: trunk
18:18
Allow the secure-delete setting to be changed at run-time using a pragma. The SQLITE_SECURE_DELETE compile-time option determines the default setting. check-in: f72f8a87 user: drh tags: trunk
2010-02-10
05:33
Fix a segfault in fts3 that may occur if the snippet, offsets or matchinfo functions are used in a query that does not contain a MATCH clause. check-in: 14ab536a user: dan tags: trunk
2010-02-05
18:00
Make sure file descriptors are closed before unlinking in VxWorks. check-in: f64b81f1 user: drh tags: trunk
16:28
Avoid truncating non-in-memory sub-journals when releasing a savepoint for a small performance improvement. check-in: 27dc5b1c user: shaneh tags: trunk
14:12
Remove the use of 64-bit math in the offset computations of the OP_Column opcode for a small performance improvement. check-in: 61a2c8d4 user: drh tags: trunk
2010-02-04
17:38
Fix a performance glitch that appears for large transactions. check-in: 26cb1df7 user: drh tags: trunk
2010-02-03
19:55
Add a new full-text search variant that tracks the total number of documents and document sizes, to make ranking search results easier. Currently called FTS4. check-in: 1b6e6094 user: drh tags: trunk
2010-02-01
15:47
Add log.c. Closed-Leaf check-in: 7b31373f user: dan tags: wal
15:47
Create new branch named "wal" check-in: 784b718e user: dan tags: wal
2010-01-31
15:14
Fix a C++-ism that snuck into sqlite3_finalize(). check-in: fb96f2a2 user: drh tags: trunk
14:18
If an OOM occurs while setting the page size for the TEMP database, be sure that error gets reported back out to the interface layer. check-in: 6487e70a user: drh tags: trunk
2010-01-30
23:08
The iInUseDB and iInUseMM variables do not need to be volatile. Leaf check-in: bb18f578 user: drh tags: branch-3.5.9
22:28
Always hold the MEM2 mutex when initially marking a pager as in use by its database connection. check-in: 622c1717 user: drh tags: branch-3.5.9
19:17
Avoid a race condition in the sqlite3_release_memory() logic within pager.c. check-in: a718e663 user: drh tags: branch-3.5.9
19:00
Remove all cache pages from the LRU list prior to removing the pager from the pager list when closing a pager. check-in: 9d13acc4 user: drh tags: branch-3.5.9
18:22
Add additional pagerMutexHeld() macros to better verify the correct operation of pager.c. check-in: c50e972f user: drh tags: branch-3.5.9
2010-01-29
21:23
Fix a missing mutex on page cache truncation during vacuum and auto-vacuum when SQLITE_ENABLE_MEMORY_MANAGEMENT is engaged. check-in: ea3b941a user: drh tags: branch-3.5.9
19:50
Additional changes suggested by Rob Stoddard. Closed-Leaf check-in: 228b8ad9 user: drh tags: branch-3.5.9
19:46
Changes to 3.5.9 proposed by Rob Stoddard. check-in: 5ed168c4 user: drh tags: branch-3.5.9
2010-01-28
19:56
Tweaks for consistency to the SEE and CEROD API declarations in sqlite3.h. check-in: 299f7456 user: shaneh tags: trunk
2010-01-26
01:25
Make the TEMP file tables use the page size set for the main database. Ticket [b80eeab588c4]. Also copy over the changes from apple-osx check-in [7c3bede3f2]. check-in: 5dcfb0c9 user: drh tags: trunk
01:14
Updated open mask to include SQLITE_OPEN_AUTOPROXY check-in: 7c3bede3 user: adam tags: apple-osx
2010-01-22
15:48
Fix two similar problems in fts3 that meant that an OOM error could cause a memory leak. check-in: 701ef64b user: dan tags: trunk
2010-01-21
23:11
Fix a segfault that can occur when the LHS of a LIKE operator has an undefined collating sequence. Ticket [1258875e07553]. check-in: a82e6b45 user: drh tags: trunk
01:53
Redesign the string to numeric value caster so that it is more likely to work on unusual floating point hardware. check-in: 8bb1104c user: drh tags: trunk
2010-01-20
14:25
Fix a problem with handling OOM errors in fts3. check-in: f9c54e95 user: dan tags: trunk
13:20
Align the os_unix.c source file with the version found on trunk. check-in: fa0f6c14 user: drh tags: apple-osx
13:07
Move the Apple OS-X VFS changes into the trunk. check-in: 571594bf user: drh tags: trunk
01:26
Update the Apple OS-X branch to include all of the latest changes in trunk. check-in: 96499b1d user: drh tags: apple-osx
01:20
Manually copy over the rebustness fixes from the apple-osx branch. check-in: 095c74ea user: drh tags: trunk
2010-01-19
23:50
robustness fixes for preventing a finalized statement from being reused check-in: a7a0c8d6 user: adam tags: apple-osx
2010-01-18
18:17
Fix a problem with the CLI where not all SQL commands were being echoed. Added tests of same to tools/shell2.test. Ticket [eb620916be]. check-in: 7080ae3b user: shaneh tags: trunk
2010-01-15
17:33
Fix test numbering in fts3snippet.test. check-in: 34f68546 user: dan tags: trunk
17:25
Add coverage tests for fts3_snippet.c. Also fixes related to the same. check-in: 5e9d8cca user: dan tags: trunk
2010-01-14
11:45
Add a test to e_fts3.test for the matchinfo example in fts3.html. check-in: e5336edc user: dan tags: trunk
11:17
Fix some matchinfo related test problems in fts3rnd.test. check-in: da7abe05 user: dan tags: trunk
00:39
Comment cleanup in sqliteInt.h. check-in: 67c3aea5 user: drh tags: trunk