SQLite

Today In History
Login

This Day In History For 2020-05-30

1 Year Ago (more context)

2019-05-30
13:47
Optimization to the round() SQL function for large input values without a fractional part. (check-in: e95138f5 user: drh tags: trunk)
00:46
Smaller and faster sqlite3IsNaN() implementation makes deserialization of floating point values much faster. (check-in: ea748ede user: drh tags: trunk)

2 Years Ago (more context)

2018-05-30
20:44
Allow min() and max() to be used as window functions. (check-in: c16125a8 user: dan tags: exp-window-functions)
14:17
Add the Makefile.fallback makefile to the amalgamation tarball. (check-in: ce3d0456 user: drh tags: trunk)
07:36
Do not use the codec on the resetdb.test script. (check-in: fe55cea0 user: drh tags: trunk)
07:24
Fix a typo in an error message in the CLI. (check-in: 80883980 user: drh tags: trunk)
01:14
Fix the parser so that it builds with -DSQLITE_OMIT_CTE. (check-in: 86ee267e user: drh tags: trunk)
00:59
Fix a harmless compiler warning. (check-in: 8d02c7a6 user: drh tags: trunk)
00:54
Demonstration code on a possible technique for optimizing the use of IN operator on columns to the right of multicolumn indexes. If the OP_Noop generated where were really a new opcode that checked to see if there existed any entries in the index with a matching prefix, it might prevent unnecessary iterations of the IN operator. (check-in: 92f0fe15 user: drh tags: multikey-opt-idea)

3 Years Ago (more context)

2017-05-30
18:34
Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. (check-in: e972a386 user: drh tags: trunk)
18:14
Omit a test of codepoint 0x202F (non-break narrow space) from the fts3 ICU tests. Different versions of ICU apparently handle this obscure codepoint slightly differently. (check-in: 69ae6889 user: dan tags: trunk)

4 Years Ago (more context)

2016-05-30
08:28
Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. (check-in: 64ca1a83 user: dan tags: trunk)
05:45
Minor tweaks to the bc_test1 test program. (check-in: d0d0bab4 user: dan tags: begin-concurrent)

5 Years Ago (more context)

2015-05-30
22:57
Updates to configure.ac to help it find where the TCL libraries hidden on Ubuntu 14.04. (check-in: c864ff91 user: drh tags: trunk)
22:05
Fix minor typo in comment. No changes to code. (check-in: 73fc058b user: mistachkin tags: trunk)
11:49
Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: e008c3c8 user: dan tags: fts5)

10 Years Ago (more context)

2010-05-30
19:55
Initial code for incremental checkpoint in WAL mode. This check-in compiles on unix and runs as long as you do not engage WAL mode. WAL mode crashes and burns. Consider this check-in a baseline implementation for getting the new capability up and running. (check-in: ef3ba7a1 user: drh tags: wal-incr-ckpt)

20 Years Ago (more context)

2000-05-30
20:17
:-) (CVS 19) (check-in: 03725ce5 user: drh tags: trunk)
19:22
:-) (CVS 18) (check-in: 2d41caec user: drh tags: trunk)
18:45
loads the complete ACD database! (CVS 17) (check-in: 97a0fb78 user: drh tags: trunk)
17:30
:-) (CVS 16) (check-in: b56d1b9c user: drh tags: trunk)
16:27
:-) (CVS 15) (check-in: 8d66c735 user: drh tags: trunk)
13:44
:-) (CVS 14) (check-in: 1bb8ee8d user: drh tags: trunk)
03:28
:-) (CVS 13) (check-in: 191a7f48 user: drh tags: trunk)
03:12
:-) (CVS 12) (check-in: 20f2811f user: drh tags: trunk)
00:51
:-) (CVS 11) (check-in: 9818723e user: drh tags: trunk)
00:05
:-) (CVS 10) (check-in: 1c1d9c0d user: drh tags: trunk)