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: e95138f5f4 user: drh tags: trunk)
00:46
Smaller and faster sqlite3IsNaN() implementation makes deserialization of floating point values much faster. (check-in: ea748edecb 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: c16125a884 user: dan tags: exp-window-functions)
14:17
Add the Makefile.fallback makefile to the amalgamation tarball. (check-in: ce3d045633 user: drh tags: trunk)
07:36
Do not use the codec on the resetdb.test script. (check-in: fe55cea0c8 user: drh tags: trunk)
07:24
Fix a typo in an error message in the CLI. (check-in: 8088398081 user: drh tags: trunk)
01:14
Fix the parser so that it builds with -DSQLITE_OMIT_CTE. (check-in: 86ee267ee8 user: drh tags: trunk)
00:59
Fix a harmless compiler warning. (check-in: 8d02c7a6a0 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: 92f0fe155d 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: e972a38608 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: 69ae688982 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: 64ca1a835a user: dan tags: trunk)
05:45
Minor tweaks to the bc_test1 test program. (check-in: d0d0bab4e9 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: c864ff912d user: drh tags: trunk)
22:05
Fix minor typo in comment. No changes to code. (check-in: 73fc058b3a user: mistachkin tags: trunk)
11:49
Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: e008c3c8e2 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: ef3ba7a17f user: drh tags: wal-incr-ckpt)

20 Years Ago (more context)

2000-05-30
20:17
:-) (CVS 19) (check-in: 03725ce5ae user: drh tags: trunk)
19:22
:-) (CVS 18) (check-in: 2d41caec80 user: drh tags: trunk)
18:45
loads the complete ACD database! (CVS 17) (check-in: 97a0fb780e user: drh tags: trunk)
17:30
:-) (CVS 16) (check-in: b56d1b9c0f user: drh tags: trunk)
16:27
:-) (CVS 15) (check-in: 8d66c7355d user: drh tags: trunk)
13:44
:-) (CVS 14) (check-in: 1bb8ee8d9f user: drh tags: trunk)
03:28
:-) (CVS 13) (check-in: 191a7f484e user: drh tags: trunk)
03:12
:-) (CVS 12) (check-in: 20f2811fc1 user: drh tags: trunk)
00:51
:-) (CVS 11) (check-in: 9818723ee1 user: drh tags: trunk)
00:05
:-) (CVS 10) (check-in: 1c1d9c0d4a user: drh tags: trunk)