SQLite

Today In History
Login

This Day In History For 2020-03-11

1 Year Ago (more context)

2019-03-11
19:50
Remove "cache mode" from the window frame code generator. Handle the same cases by editing the window frame specification itself. (check-in: 0812635383 user: dan tags: window-functions)
18:17
Simplify the windows frame code some. Add a comment explaining some of the VM code generated by sqlite3WindowCodeStep(). (check-in: 6bd1a07949 user: dan tags: window-functions)
11:12
Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: e7bced731a user: dan tags: window-functions)

3 Years 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)

4 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)

5 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)

15 Years Ago (more context)

2005-03-11
18:06
Version 3.1.5 (CVS 2382) (check-in: b1792ae516 user: drh tags: trunk)
18:06
Disable GNU readline in the build of the command-line shell for linux since some systems (ex: SuSE) do not support it. (CVS 2381) (check-in: baddb06450 user: drh tags: trunk)
17:55
Updates to the homepage prior to 3.1.5. (CVS 2380) (check-in: c78611f620 user: drh tags: trunk)
17:52
Fix bugs discovered in 3.1.4. F_FULLFSYNC not F_FULLSYNC. And a bug in "make doc". Also typos in the documentation. (CVS 2379) (check-in: 3c57a4571f user: drh tags: trunk)
04:53
Version 3.1.4 (CVS 2378) (check-in: 3d070a9b4d user: drh tags: trunk)
04:41
Fixes so that the FULLSYNC changes will build on windows. They do not have any effect, but neither do they cause errors. (CVS 2377) (check-in: ace3e30de1 user: drh tags: trunk)
04:40
Increase the version number to 3.1.4. (CVS 2376) (check-in: e438b65cf9 user: drh tags: trunk)
04:39
Documentation updates for version 3.1.4. (CVS 2375) (check-in: a7261f1590 user: drh tags: trunk)