/ 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 c50e972f1bea2e35.

2010-02-23
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
2010-01-13
17:39
Make the sqlite3IsNaN() function a macro that evaluates to FALSE when compiled with SQLITE_OMIT_FLOATING_POINT. check-in: 56f232d5 user: drh tags: trunk
16:43
When SQLITE_OMIT_FLOATING_POINT is defined, the floating-point formats in the sqlite3_*printf() functions should pull an int64 off of the parameter list and ignore it. check-in: 3fd6f9ad user: drh tags: trunk
16:25
When SQLITE_OMIT_FLOATING_POINT is defined, make sure the result of a mathematical operation is always tagged as an integer. check-in: e12da0d3 user: drh tags: trunk
15:15
Make the doubleToInt64() routine a pass-through when using OMIT_FLOATING_POINT. check-in: 41716718 user: drh tags: trunk
14:08
Add tests to backup.test to verify that SQLite behaves as expected when the source database is modified mid-backup. check-in: 985d3bec user: dan tags: trunk
04:22
Comment out unused code when SQLITE_OMIT_FLOATING_POINT is selected. Added testcase() macros to boundary conditions in util.c routines. check-in: dfc6595d user: drh tags: trunk
00:04
Make the sqlite3_result_double() interface work the same as sqlite3_result_int64() when SQLITE_OMIT_FLOATING_POINT is defined. check-in: 61df5986 user: drh tags: trunk
2010-01-12
23:54
Make sure internal queries are well ordered, even when the reverse_unordered_selects pragma is in effect. Ticket [eb942c64a157]. check-in: 0209f171 user: drh tags: trunk
19:28
Fix the implementation of CURRENT_TIMESTAME and CURRENT_DATE when SQLITE_OMIT_DATETIME_FUNCS is defined. check-in: eb98265b user: drh tags: trunk
17:57
Update comments in fts3_snippet.c. check-in: dd9689b7 user: dan tags: trunk
17:04
Use #ifdefs to disable unused code when SQLITE_OMIT_FLOATING_POINT is defined. check-in: 66bab856 user: drh tags: trunk
2010-01-11
18:26
Add a few documentation evidence comments to the built-in function implementations. check-in: 8bd0f814 user: drh tags: trunk
12:00
Modify snippets code to run more efficiently. And to avoid a bug relating to snippets based on full-text queries that contain duplicate terms. check-in: a2b1183d user: dan tags: trunk
2010-01-09
07:33
Fix handling of an OOM error in the fts3 offsets() function. Fix a couple of snippet related test cases in e_fts3.test. check-in: 14dc46a7 user: dan tags: trunk
2010-01-08
23:01
Update comments in fts3.c to more accurately describe the doclist format. check-in: e424a030 user: drh tags: trunk
04:50
Added option to restore_jrnl.tcl utility to hex dump journal pages. check-in: 08c545f0 user: shaneh tags: trunk
2010-01-07
22:02
Minor tweaks to restore_jrnl.tcl utility script. check-in: b97aca12 user: shaneh tags: trunk
21:49
Small tool that attempts to repair a journal header. check-in: 05b18b5f user: shaneh tags: trunk
15:17
Fix the expression comparison logic to take the COLLATE operator into account. Ticket [360c6073e197] check-in: 44bb1bfe user: drh tags: trunk
11:27
Changes to test code so that testfixture compiles when OMIT_SHARED_CACHE and OMIT_UTF16 are defined. check-in: d6ee5ff6 user: dan tags: trunk
10:54
Fixes to problems in FTS3 snippet() function found by th3 tests. check-in: 3b5ccd26 user: dan tags: trunk
03:53
Another attempt at fixing the table generator in lemon. Again, this does not effect the SQLite grammar. check-in: e22c090f user: drh tags: trunk
2010-01-06
18:36
Fix a segfault that can occur following an OOM in the FTS3 snippet() function check-in: c7e5966e user: dan tags: trunk
17:19
Change the fts3 snippet function to return (hopefully) more relevant snippets in less time. check-in: 8a208223 user: dan tags: trunk
13:12
Update the OS-X branch to include all trunk changes through version 3.6.22. check-in: 541e2b48 user: drh tags: apple-osx
13:07
Fix an issue with lemon generating incorrect grammars. This issue does not effect SQLite. check-in: 077a6bee user: drh tags: trunk
00:00
Version 3.6.22 check-in: 28d0d771 user: drh tags: trunk, release
2010-01-05
18:11
Apply fix [9b8acf8319] to the 3.6.1 branch. check-in: 62b4891b user: dan tags: branch-3.6.1