SQLite

Today In History
Login

This Day In History For 2018-03-11

1 Year Ago (more context)

2017-03-11
13:02
Make sure the translateColumnToCopy() routine in the query planner does not try to access an array that failed to be fully allocated due to a prior OOM. This fixes an issue discovered by OSSFuzz. (check-in: 3299a26160 user: drh tags: trunk)
01:56
The output of the ".dump" command in the CLI quotes newline and carriage-return characters using "char(10)" and "char(13)". (Closed-Leaf check-in: 8b2954dd83 user: drh tags: string-quoting-dump)
00:46
Increase the number of significant digits in floating point literals on ".dump" output from the shell. (check-in: 7359fcacaa user: drh tags: trunk)

2 Years Ago (more context)

2016-03-11
23:07
Do not allow the use of WAL mode with nolock=1 because it does not work. (check-in: 74f5d3b07f user: drh tags: trunk)
15:25
Tweak the amalgamation autoconf files so that the --disable-static-shell option works again. (check-in: 83efcdebfa user: dan tags: trunk)
14:30
Update spellfix1_scriptcode() to output 215 (latin) for pure numeric text. (check-in: df44308b86 user: drh tags: trunk)

3 Years Ago (more context)

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: ff868e22ca 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: b7f1fc26d2 user: dan tags: stat4-function)
14:51
Add an optimization to the fts5 unicode tokenizer code. (check-in: f5db489250 user: dan tags: fts5)
14:34
Expand the multi-process test cases to repeat each case 20 times and to repeat tests using different journal modes. (check-in: a2715b049a user: drh tags: trunk)

4 Years Ago (more context)

2014-03-11
23:44
Remove a stray C99-style comment. (check-in: f500e87d6e user: drh tags: overflow-pgno-cache)
23:40
Combine the various boolean fields of the BtCursor object into a single bit-vector. This allows setting or clearing more than one boolean at a time and makes the overflow-pgno-cache branch faster than trunk on speedtest1. (check-in: 968fec44d7 user: drh tags: overflow-pgno-cache)
20:34 Edit [da59198505990a4f|da59198505]: Edit check-in comment. (artifact: d21fe9a665 user: dan)
20:33
Enable the b-tree cursor object's overflow page-number cache, which is normally enabled only for incr-blob cursors, for all cursors. (check-in: da59198505 user: dan tags: overflow-pgno-cache)
15:27
Version 3.8.4.1 (check-in: 018d317b12 user: drh tags: trunk, release, version-3.8.4.1)
15:26 Edit [04caffcef33ab0d2|04caffcef3]: Mark "Closed". (artifact: 217ffb9730 user: drh)
15:25
Update version number to 3.8.4.1 (check-in: 33f5694fa4 user: drh tags: trunk)
15:22 Edit [04caffcef33ab0d2|04caffcef3]: Move to branch mistake. Edit check-in comment. Cancel background color. (artifact: d9e3bbf340 user: drh)
14:44
Forgot to change the VERSION file. (Closed-Leaf check-in: 04caffcef3 user: drh tags: mistake)
13:20 Closed ticket [0841d0f524]: Exclusive transactions do not work if same database multiply attached plus 4 other changes (artifact: e4ce6e4579 user: drh)
13:20 Closed ticket [13137dccf3]: FTS3 and last_insert_rowid() plus 3 other changes (artifact: 81c931a1cb user: drh)
13:20 Closed ticket [084941461f]: Some minor asyncvfs issues plus 2 other changes (artifact: 0895c6994a user: drh)
13:19 Closed ticket [25e09aa2ab]: Lint mode plus 3 other changes (artifact: c165b8c802 user: drh)
13:18 Fixed ticket [5ac9b497de]: Some issues with aliases, fully qualified identifiers, and * plus 3 other changes (artifact: 571628716f user: drh)
13:18 Closed ticket [030632f55b]: make sqlite2 detect sqlite3 plus 3 other changes (artifact: dc3fdfa018 user: drh)
13:18 Closed ticket [72b01a982a]: Per page/region checksums plus 4 other changes (artifact: 1b2cd92493 user: drh)
13:17 Closed ticket [3671265894]: No error reporting on file open failure plus 3 other changes (artifact: a8c0cf879d user: drh)
13:17 Closed ticket [af3450b763]: Recursive virtual tables plus 3 other changes (artifact: 46e25d4bfe user: drh)
13:17 Fixed ticket [c25aab7e7e]: The ".import" command does not parse CSV correctly. plus 3 other changes (artifact: 5733c490a9 user: drh)
13:16 Closed ticket [f817a45752]: CantOpen doesn't include name of file that can't be opened plus 4 other changes (artifact: 0309965386 user: drh)
13:15 Fixed ticket [775b39dd3c]: Poor query planning with virtual tables, joins and ORDER BY. plus 2 other changes (artifact: f9f600d939 user: drh)
13:15 Closed ticket [2e047cbefa]: select DISTINCT performance could be better plus 4 other changes (artifact: 397b2b896b user: drh)
13:14 Fixed ticket [23b2128201]: Uninformative error message on check constraint failure plus 3 other changes (artifact: 56d0f0144e user: drh)
13:14 Closed ticket [61d35ac210]: A way to tell if a journal should exist plus 3 other changes (artifact: 8cfcaee08e user: drh)
13:13 Closed ticket [33fdaab1a0]: Need to cancel an integrity check in progress with sqlite3_interrupt plus 3 other changes (artifact: 6cf22fecb5 user: drh)
13:12 Closed ticket [293860ac26]: Allow triggers to reference other databases plus 3 other changes (artifact: 72175e60e1 user: drh)
13:12 Closed ticket [65a1fd4bab]: Shell should call rl_readline_name plus 4 other changes (artifact: 1553d73723 user: drh)
13:11 Fixed ticket [bcff482dd6]: Explicit extended error code for deadlock with sqlite_busy plus 4 other changes (artifact: 17a60b18fe user: drh)
13:11 Closed ticket [5896edbe46]: List available SQL functions plus 4 other changes (artifact: 902c82604b user: drh)
13:10 Closed ticket [c276ee2e4e]: null should not be allowed in primary key plus 5 other changes (artifact: 9e0a2c0b1f user: drh)
13:09 Fixed ticket [f711d5a937]: Windows DLL should have versioninfo resource plus 4 other changes (artifact: 3a0f905847 user: drh)
13:08 Closed ticket [4d5c039d12]: Truncated database not detected well plus 3 other changes (artifact: af4312204a user: drh)
13:07 Fixed ticket [de3ae967a0]: Insert multiple rows at once plus 3 other changes (artifact: 23340708ed user: drh)
13:06 Closed ticket [c060923a54]: VFS filename truncation issues plus 3 other changes (artifact: fc3c4605e0 user: drh)
13:06 Fixed ticket [f6ee7c1986]: Negative widths should right justify plus 4 other changes (artifact: 96dd07a820 user: drh)
13:05 Fixed ticket [ba7fdb568d]: Page size should auto default to file system block size plus 3 other changes (artifact: 14d4023191 user: drh)
13:05 Closed ticket [08595ca456]: INTERSECT operator should have higher precedence plus 5 other changes (artifact: 376a460dee user: drh)
13:04 Closed ticket [ed2ff2f4ef]: Call progress callback while doing pragma integrity_check plus 4 other changes (artifact: 760956842d user: drh)
13:04 Closed ticket [ebde3f66fc]: Shared cache has different busy behaviour than non-shared plus 3 other changes (artifact: 5d117cb602 user: drh)
13:03 Closed ticket [d8fe6cef65]: Error return from VFS xUnlock ignored plus 4 other changes (artifact: 149285a538 user: drh)
13:02 Closed ticket [1c67bd6ce9]: Shell Control-C (break) handling could be better plus 4 other changes (artifact: d49cecf221 user: drh)
13:00 Closed ticket [1a1790ca1a]: No way to signal an error in collation callback plus 4 other changes (artifact: 1d03e3694a user: drh)
13:00 Closed ticket [62359d6511]: xGetLastError should be dumped plus 4 other changes (artifact: b2d8d1119e user: drh)
12:59 Closed ticket [efeeb90f2a]: error messages should be per-thread not global plus 4 other changes (artifact: 0fa3cc5d4a user: drh)
12:59 Closed ticket [15e11a2c87]: IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings plus 3 other changes (artifact: 1952615092 user: drh)
12:58 Closed ticket [eaa105fe74]: (...) WHERE col IN (val1) not reflected in xBestIndex plus 3 other changes (artifact: d685d603f5 user: drh)
12:58 Closed ticket [b803a45d50]: Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...) plus 4 other changes (artifact: 2882bfb8c8 user: drh)
12:57 Ticket [084941461f] Some minor asyncvfs issues status still Open with 4 other changes (artifact: 1f0b55dd12 user: drh)
12:56 Closed ticket [e33452c90f]: Query plan doesn't use existing index plus 3 other changes (artifact: 78867f00a3 user: drh)
12:56 Closed ticket [89f7b55854]: RFE - Documentation in PDF format? plus 4 other changes (artifact: 44da06a86c user: drh)
12:56 Closed ticket [2c5661c26a]: Thread safety: does SQLite handle pthread_cancel cleanly? plus 4 other changes (artifact: 766bc52d43 user: drh)
12:54 Closed ticket [1248e6cda8]: Insufficient precision of sqlite3_column_text16() for floating point values plus 4 other changes (artifact: 467b6acba3 user: drh)
12:50 Closed ticket [36769f697d]: termDataCmp in FTS3 should be __cdecl on Windows plus 4 other changes (artifact: b4aecdbd0e user: drh)
12:49 Closed ticket [8f81455baf]: fts3GetVarint32 sets random number on error plus 3 other changes (artifact: 13cba602b0 user: drh)
12:48 Ticket [13137dccf3] FTS3 and last_insert_rowid() status still Open with 3 other changes (artifact: c36c80902c user: drh)
12:47 Ticket [5e0423b058] xAccess behaviour is not documented, changed in Windows 3.7.0 status still Open with 3 other changes (artifact: f57fde4855 user: drh)
12:47 Fixed ticket [edb497982c]: FTS n-character prefix query returns incorrect results when using an n+1 character prefix index. plus 4 other changes (artifact: eb2d23d22d user: drh)
12:46 Closed ticket [f48b7da35c]: Loadable extensions documentation bitrot plus 4 other changes (artifact: 662e23067f user: drh)
12:45 Closed ticket [01b785eefa]: sqlite3.exe - wrong parameter charset plus 5 other changes (artifact: 481bb647cf user: drh)
12:44 Ticket [6c266900a2] shell: The column mode (and width option) does not manage correctly UTF-8 status still Open with 3 other changes (artifact: ca97a463fe user: drh)
12:44 Fixed ticket [beba9cae63]: Assertion fault on a valid query plus 5 other changes (artifact: f40290c295 user: drh)
12:41 Fixed ticket [4eb3a0bd32]: Performance regression in Skrooge plus 5 other changes (artifact: bf79277f1c user: drh)
09:19
Add a test to see what happens if an rtree constructor encounters an SQLITE_BUSY error. No changes to code. (check-in: 5527e23636 user: dan tags: trunk)
01:48
Version 3.8.4 for sessions (plus two minor fixes). (check-in: 917c410808 user: drh tags: sessions)

5 Years Ago (more context)

2013-03-11
13:37
Define _BSD_SOURCE when building on OpenBSD. This is required for fchmod(). (check-in: f9027cb47b user: dan tags: trunk)
11:57
Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. (check-in: 1da15adba8 user: dan tags: trunk)
11:49
Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. (Closed-Leaf check-in: 938b91e855 user: dan tags: omit-fixes)
06:24
Add more tests. (check-in: f9468e334d user: mistachkin tags: toTypeFuncs)
01:23
Add experimental tointeger() and todouble() SQL functions. (check-in: 465fd853d3 user: mistachkin tags: toTypeFuncs)

10 Years Ago (more context)

2008-03-11
18:03
If tclsh is not found, don't default to building the amalgamation (CVS 4853) (check-in: cbc0167556 user: mlcreech tags: trunk)
15:41
Increase the version number to 3.5.7 in anticipation of the next release. (CVS 4852) (check-in: c85e97e4f0 user: drh tags: trunk)