SQLite

Today In History
Login

This Day In History For 2018-03-06

1 Year Ago (more context)

2017-03-06
23:51
Make the default MASK argument for "PRAGMA optimize" be 0xfffe, to allow for future expansion of up to 14 new default-on optimizations. (check-in: 73019a8bba user: drh tags: trunk)
20:44
Fix a typo in a comment. No changes to code. (check-in: ec529bf11b user: drh tags: trunk)
20:00
Merge all pending 3.18 enhancements from trunk. (check-in: 1650c3f468 user: drh tags: apple-osx)
17:33
Add an initial implementation of the "PRAGMA optimize" command. (check-in: 137aeb2b16 user: drh tags: trunk)
11:39
Merge updates from trunk. (Closed-Leaf check-in: 5f7fc79aa0 user: drh tags: auto-analyze)

3 Years Ago (more context)

2015-03-06
20:49
Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: 6b993bd540 user: drh tags: like-opt-fix)
19:47
Fix the LIKE optimization even when comparing mixed-case BLOBs. (check-in: a58aafdb4e user: drh tags: like-opt-fix)
16:45
The LIKE optimization must be applied twice, once for strings and a second time for BLOBs. Ticket [05f43be8fdda9f]. This check-in is a proof-of-concept of how that might be done. (check-in: 5757e803cb user: drh tags: like-opt-fix)
13:14 New ticket [05f43be8fd] Incorrect use of index with LIKE operators when the LHS is a blob. (artifact: 9a374a0d2d user: drh)
04:37
Clearification of some documentation text. Added requirements marks. (check-in: 8c1e85aab9 user: drh tags: trunk)
03:31
Clarification of documentation on sqlite3_backup. (check-in: 31d5e9b42e user: drh tags: trunk)

4 Years Ago (more context)

2014-03-06
18:16
Do not run corruptH.test in mmap mode. (check-in: c0d54b4e41 user: dan tags: trunk)
15:01
Fix a harmless compiler warning in the sessions test harness. (check-in: d389e20ab0 user: drh tags: sessions)
14:53
Enhance the test harness for the sessions interface so that it does not use SQLite operations that can encounter an OOM error in places where it is unable to report an OOM error back up to the test script. (check-in: bc0e661033 user: drh tags: sessions)
13:48
Merge the latest 3.8.4 tweaks from trunk. (check-in: 1ed463d918 user: drh tags: sessions)
13:38
Improved EXPLAIN indentation of a loop in the ANALYZE logic for STAT4. Mark the not-found jump of a seek operation in that loop as never taken. (check-in: 0a4200f95c user: drh tags: trunk)
12:36
Remove a branch that is never taken from where.c. (check-in: 4a4997221f user: dan tags: trunk)
02:15
Cosmetic change to the shell in-memory database warning to skip coloring the trailing period. (check-in: c87d8e07ec user: mistachkin tags: trunk)
01:56
Fix some incorrect comments and typos in comments. Add testcase() macros to some of the new record comparison code. (check-in: b83cfe899d user: drh tags: trunk)
00:31 Edit [057c16ee9786efca|057c16ee97]: Mark "Closed". (artifact: 08cb57cc6d user: mistachkin)
00:30 Edit [854d410ad3a2bb3a|854d410ad3]: Mark "Closed". (artifact: bc561b0b33 user: mistachkin)
00:30
Better loadable extension handling in the Win32 VFS when compiled for Cygwin. (check-in: 29b0a4f158 user: mistachkin tags: trunk)
00:28
Better support for MinGW 4.x. (check-in: 170e058520 user: mistachkin tags: trunk)

5 Years Ago (more context)

2013-03-06
11:44
Fix a problem in incrvacuum_ioerr.test. Do not run ioerr6.test with an in-memory journal. (check-in: 66576b450a user: dan tags: trunk)
11:32 Edit [8398f77c5a689c79|8398f77c5a]: Mark "Closed". (artifact: 030887cf57 user: drh)
11:32 Edit [209b21085b9767f1|209b21085b]: Mark "Closed". (artifact: a9ab1def82 user: drh)
11:32 Edit [7280e14cd8f55896|7280e14cd8]: Mark "Closed". (artifact: 54c07dceed user: drh)
11:31 Edit [bf57534188e044fb|bf57534188]: Mark "Closed". (artifact: 9c847c9cdb user: drh)
11:31 Edit [4f5f3aebe81c3cbe|4f5f3aebe8]: Mark "Closed". (artifact: 937d350506 user: drh)
02:12
Merge all the latest trunk changes into the sessions branch. (check-in: d69d21903b user: drh tags: sessions)
01:55 Fixed ticket [fc7bd6358f]: Incorrect query result in a 3-way join due to affinity issues plus 4 other changes (artifact: 921b0574dc user: drh)
01:55
Fix a bug (ticket [fc7bd6358f59]) that caused incorrect query results in three way queries that involved comparing INTEGER and TEXT columns for equality. (check-in: 7097241c12 user: drh tags: trunk)
01:48
Add the SQLITE_READONLY_ROLLBACK extended error code. Do not try to set the permissions on journal or wal files except if the filesize is initially zero (indicating that it is a new file.) (check-in: ce4ac66a4b user: drh tags: trunk)
01:41
Fix an operator precedence problem on the [1d8086902e] check-in. (Closed-Leaf check-in: 4f5f3aebe8 user: drh tags: ex-robust-open)
01:40 Edit [4e6e07a60e543d5d|4e6e07a60e]: Move to branch ex-robust-open. Edit check-in comment. (artifact: 534015bd2e user: drh)

10 Years Ago (more context)

2008-03-06
16:28
Clean up recent autoconf-related additions, add config.h to the amalgamation (CVS 4833) (check-in: 8044623062 user: mlcreech tags: trunk)
09:58
Handle non-autoconf build correctly with new changes (CVS 4832) (check-in: e2a9f5f105 user: mlcreech tags: trunk)
09:19
Typo in amalgamation non-x86 builds (CVS 4831) (check-in: a8424e0606 user: mlcreech tags: trunk)
09:16
Don't try and include common.h on stand-alone amalgamation builds (CVS 4830) (check-in: 9898320be0 user: mlcreech tags: trunk)
09:03
Remove amalgamation on "make clean" (fixes #2559) (CVS 4829) (check-in: e03802f362 user: mlcreech tags: trunk)
08:54
Miscellaneous autoconf cleanups - get rid of TARGET_CFLAGS, fix header list (CVS 4828) (check-in: a674f76db9 user: mlcreech tags: trunk)
08:09
Respect user's configured bindir/libdir/includedir if present (fixes #558) (CVS 4827) (check-in: 48c9fa97b9 user: mlcreech tags: trunk)
07:51
Actually use TARGET_CFLAGS on autoconf-driven builds (CVS 4826) (check-in: dda3d65899 user: mlcreech tags: trunk)
07:36
Add headers for use with autoconf (missing from previous checkin) (CVS 4825) (check-in: 4513a5f493 user: mlcreech tags: trunk)
07:35
Use intptr_t definition to silence warnings about ptr-int casts (CVS 4824) (check-in: 54839a84e6 user: mlcreech tags: trunk)
07:19
Include inttypes.h when available, add support for intptr_t (CVS 4823) (check-in: 88698fbdd5 user: mlcreech tags: trunk)
04:14
Make extension loading more easily configurable. Fixes #2977 (CVS 4822) (check-in: fc401ad9d1 user: mlcreech tags: trunk)
04:14
Make extension loading more easily configurable. Fixes #2977 (CVS 4821) (check-in: 2a2e8b64df user: mlcreech tags: trunk)