SQLite

Today In History
Login

This Day In History For 2024-11-06

1 Year Ago (more context)

2023-11-06
21:57
Add -DSQLITE_ENABLE_COLUMN_METADATA to the JNI build, as per forum post 9205518c0568fdf0. Add tests for the functions that flag enables so that the build will fail if that flag is missing. (check-in: 7a63b5b65a user: stephan tags: trunk)
19:16
Merge latest trunk into this branch. (check-in: 3a869cf1f8 user: dan tags: fts5-token-data)
19:08
Update the srctree-check.tcl script and child script so that they can be run on a read-only source tree and so that if any inconsistencies are found, the script returns a non-zero exit code and thus halts the build. (check-in: a0cc7e8117 user: drh tags: branch-3.44)
19:01
Fix an fts5 problem where a transaction consisting of (a) a DELETE on rowid X, (b) a prefix query, and (c) an INSERT on rowid X, could corrupt the index. (check-in: 34af510a56 user: drh tags: branch-3.44)
18:40
Fix an fts5 problem where a transaction consisting of (a) a DELETE on rowid X, (b) a prefix query, and (c) an INSERT on rowid X, could corrupt the index. (check-in: c2058a045b user: dan tags: trunk)
16:32
Merge trunk changes into this branch. (check-in: ac5570614e user: dan tags: fts5-token-data)
15:31
Move console_io lib to its own subdirectory, etc/consio . (check-in: 1d0583f2eb user: larrybr tags: console-io-lib)
15:15
Some renaming, warnings cured, and more coding convention conformance. (check-in: 58815f0ad2 user: larrybr tags: console-io-lib)
13:24
Add an fputs() equivalent to console I/O lib, and use in CLI. (check-in: d661f90724 user: larrybr tags: console-io-lib)
03:09
Cause CLI to use console_io library. (check-in: bf66a7c1d3 user: larrybr tags: console-io-lib)
00:15
Make MSVC accept it, too. (Cannot use static const int as part of a constant expression?) (check-in: bb278d2496 user: larrybr tags: console-io-lib)

2 Years Ago (more context)

2022-11-06
17:19
The recoverAssertMutexHeld() function is for testing and verification only and should be a harmless no-op for production builds. [forum/forumpost/b4f2c7d402|Forum post b4f2c7d402]. (check-in: d75504710c user: drh tags: trunk)
13:12
shell.c.in: on non-Windows platforms, check for $XDG_CONFIG_HOME/sqlite3/sqliterc before ~/.sqliterc, per request in forum post 7a16582b1e403c81. (Closed-Leaf check-in: 49c6e438a8 user: stephan tags: sqliterc-xdg-config)

3 Years Ago (more context)

2021-11-06
20:25
Add ALWAYS() to a branch made unreachable by the previous check-in. (check-in: 0dc963f63a user: drh tags: trunk)
18:22
Return an error if an attempt is made to drop an eponymous virtual table. (check-in: 889dea52de user: dan tags: trunk)
16:46
Merge further changes from trunk into this branch. (check-in: 700876b79c user: dan tags: wal2)
16:36
Merge change [6979efbf07d93e7a] from trunk to this branch. (check-in: 2bb2448d60 user: dan tags: wal2)
16:10
Merge changes from trunk into this branch. (check-in: 52667bce48 user: dan tags: wal2)
11:58
Add the rbu_exclusive_checkpoint query parameter to RBU. (Leaf check-in: c15806a45a user: drh tags: reuse-schema-3.36)
10:59
Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: a024764cef user: drh tags: trunk)
10:51 Edit [ca09148e13d33a74|ca09148e13]: Move to branch reuse-schema. (artifact: 59a23ff6f0 user: drh)
07:08
Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: b1fc3de81e user: dan tags: reuse-schema)

4 Years Ago (more context)

2020-11-06
16:48
Add ALWAYS() to conditionals associated with SHM locking that are always true. (check-in: b599e89076 user: drh tags: trunk)

5 Years Ago (more context)

2019-11-06
23:10 New ticket [299b50ba81] UPDATE on table with two generated columns and CHECK clause results in segfault. (artifact: 627b555460 user: mrigger)
22:20 Fixed ticket [4fc08501f4]: Segfault when inserting into table with generated columns plus 6 other changes (artifact: 635c203d34 user: drh)
22:19
Change the way generated columns are computed so that no column is computed inside branch code that might not be taken. Ticket [4fc08501f4e56692] (check-in: 9e07b48934 user: drh tags: trunk)
19:25
Minor simplification to the changes from check-in [36c11ad51f]. (check-in: 7bc8205dd9 user: mistachkin tags: trunk)
17:31 Fixed ticket [ce22a07731]: NULL WHERE condition unexpectedly results in row being fetched plus 6 other changes (artifact: d70a33c49d user: drh)
17:31
Fix the OP_DeferredSeek index-to-table column map in P4 so that it works with generated columns. Ticket [ce22a07731530118] (check-in: 36c11ad51f user: drh tags: trunk)
15:41 New ticket [4fc08501f4] Segfault when inserting into table with generated columns. (artifact: 73daa54fdf user: mrigger)
15:16 New ticket [ce22a07731] NULL WHERE condition unexpectedly results in row being fetched. (artifact: b13b7dce76 user: mrigger)
14:50 Fixed ticket [2399f59861]: REPLACE on table with generated NOT NULL column results in segfault plus 6 other changes (artifact: 990c736a41 user: drh)
14:49
Fix the handling of NOT NULL constraint violations for generated columns in a REPLACE statement. Ticket [2399f5986134f79c] (check-in: 77b1c90add user: drh tags: trunk)

10 Years Ago (more context)

2014-11-06
14:43
Added SQLITE_SCANSTAT_SELECTID. Change the value returned by SQLITE_SCANSTAT_EST from sqlite3_int64 to double. Enhanced the formatting and display of scan statistics using the ".scanstats on" command in the shell. (check-in: 20c7614add user: drh tags: trunk)
12:46
Further improvements to the ".scanstats on" display in the shell. Be sure to show the results of all subqueries even if there are gaps in the SELECTID values. Add ".scanstats" to the ".help" output. (Closed-Leaf check-in: ee922682bb user: drh tags: scanstatus)
12:17
On the ".scanstats on" output in the shell, initialize the estimated count for the first loop of each subquery to the actual loop count. (check-in: d1c51c8455 user: drh tags: scanstatus)
12:08
Changes the formatting of ".scanstats on" in the shell so that the stats for subqueries are grouped together and occur after the main query. (check-in: eacbbd8849 user: drh tags: scanstatus)
04:42
Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the ".stmtscan on" output in the shell. (check-in: 64ad5761a8 user: drh tags: scanstatus)
03:55
Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for the estimated number of output rows per loop, rather than a 64-bit integer. Revise the output format for the ".scanstats on" in the shell to make use of this new capability. (check-in: f968400066 user: drh tags: scanstatus)

15 Years Ago (more context)

2009-11-06
17:22 Fixed ticket [f12a9eeedc]: Shell command argument parsing is lax plus 2 other changes (artifact: 84f729d1a8 user: shane)
17:20
Improved shell "dot" command argument handling. Ticket [f12a9eeedc]. (check-in: 9fb6991933 user: shaneh tags: trunk)
04:42 Ticket [33fdaab1a0] Need to cancel an integrity check in progress with sqlite3_interrupt status still Open with 3 other changes (artifact: 5b925ecaf4 user: rogerb)
04:41 New ticket [33fdaab1a0]. (artifact: c1ba384681 user: rogerb)
04:15 Fixed ticket [0bf974bdf9]: backup api asserts with zero length source file plus 5 other changes (artifact: daf649bb31 user: drh)
04:13
Fix the backup API so that a backup from an empty database to a non-empty database works. Ticket [0bf974bdf9]. The only changes are in assert() statements. (check-in: ddb71cd9ed user: drh tags: trunk)
03:33
Merged accidental fork. (check-in: d410cd4e42 user: shaneh tags: trunk)
03:22
Add some very basic tests for the commands available from the CLI. (check-in: 6bf4333804 user: shaneh tags: trunk)
03:04 New ticket [0bf974bdf9] backup api asserts with zero length source file. (artifact: fcecca71f3 user: shane)
03:00 Edit [eb7a544fe49d1626|eb7a544fe4]: Timestamp 2009-11-04 13:30:02. Add tag "release". (artifact: e52df9968f user: drh)

20 Years Ago (more context)

2004-11-06
12:26
Auto-vacuum: Ensure pages to be removed by database truncation are in the journal file. Also fix an sqlite3pager_movepage() bug. (CVS 2074) (check-in: 081676e491 user: danielk1977 tags: trunk)
00:02
Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073) (check-in: 89b9026a53 user: drh tags: trunk)