This Day In History For 2019-05-28
1 Year Ago (more context)
|
2018-05-28
| ||
| 23:59 | The geopoly virtual table seems to be working. But only thinly tested so far. (check-in: 4288f1ad59 user: drh tags: rtree-geopoly) | |
| 18:30 | Further window frame tests and fixes. (check-in: e74c6e9185 user: dan tags: exp-window-functions) | |
| 18:29 | Do not require a statement journal in cases where REPLACE conflict handling is used to insert a single row, so long as the REPLACE operation cannot fire any triggers or foreign key actions. (check-in: 469a62ca33 user: dan tags: trunk) | |
| 18:25 | • Edit [90ba2b2e5ce2619e|90ba2b2e5c]: Mark "Closed". (artifact: ecc2efe606 user: drh) | |
| 18:25 | When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. (check-in: ce99c77244 user: drh tags: trunk) | |
| 17:43 | Fix the build so that it works with -DSQLITE_TEST_REALLOC_STRESS (Closed-Leaf check-in: 90ba2b2e5c user: drh tags: stmt-journal-testing) | |
| 17:42 | • Edit [5a4542dbcf17a9f7|5a4542dbcf]: Move to branch stmt-journal-testing. (artifact: 73a96d9dbb user: drh) | |
| 17:31 | When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. (check-in: 5a4542dbcf user: drh tags: stmt-journal-testing) | |
| 13:23 | Untested incremental check-in. Add the geopoly_xform() function. Complete basic logic for the geopoly virtual table. (check-in: ed06cc3256 user: drh tags: rtree-geopoly) | |
3 Years Ago (more context)
|
2016-05-28
| ||
| 18:53 | Experimental change to allow virtual tables to take advantage of LIKE, REGEXP and GLOB terms that are part of OR expressions within WHERE clauses. (Closed-Leaf check-in: 242507b4ff user: dan tags: vtab-experimental) | |
| 17:45 | Remove an unnecessary malloc from the vfsstat extension. (check-in: 24f258c239 user: drh tags: trunk) | |
| 17:23 | Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevent the extensions from unloading when the database connection closes. (Closed-Leaf check-in: d3f99a5e8d user: drh tags: load-permanently) | |
| 15:22 | Enhance "PRAGMA compile_options" so that it shows the version of the compiler used to generate the executable, for common compilers. (check-in: 6a0f200957 user: drh tags: trunk) | |
| 15:09 | Update the amalgamation-tarball configure script so that it can use header file "readline/readline.h" with library file "libedit". (check-in: cbf72b04bb user: dan tags: trunk) | |
| 15:03 | Enhance the sqlite3_load_extension() API so that the first parameter (the "db" parameter) can be NULL. An extension that is not associated with any database connection remains loaded for the life of the process. (Closed-Leaf check-in: 3a46104389 user: drh tags: persistent-extensions) | |
| 14:53 | Add the vfsstat.c loadable extension - a VFS shim that measures the amount of I/O, and an eponymous virtual table that is used to extract and view the measurements. (check-in: 0987487dd4 user: drh tags: trunk) | |
| 00:13 | Clang can define _MSC_VER in some circumstances; therefore, check for Clang first. (Closed-Leaf check-in: 3f710bc361 user: mistachkin tags: ctimeCompiler) | |
4 Years Ago (more context)
|
2015-05-28
| ||
| 19:57 | Optimizations for fts5 queries that match against a specific column. (check-in: b29ac50af0 user: dan tags: fts5) | |
| 15:14 | Added comments and testcase() macros to error cases in the btree search. (check-in: 7da7dc714b user: drh tags: trunk) | |
| 14:37 | Remove some dead code from fts5. Add auxiliary function api tests to the same. (check-in: 0f9df202cc user: dan tags: fts5) | |
| 11:23 | Earlier detection of incompatible sibling pages in balance_nonroot. (check-in: 60a09f17d8 user: drh tags: trunk) | |
| 03:45 | Add new test cases to the fuzzdata3.db set of database fuzz tests. (check-in: 467b13a401 user: drh tags: trunk) | |
| 03:28 | Add the btreeGetUnusedPage() routine to btree.c, and use it to detect content pages on the freelist and to cause that condition to trigger an SQLITE_CORRUPT. (check-in: fe15d1f703 user: drh tags: trunk) | |
| 00:54 | Do not attempt to take any write lock on a read-only database on Windows. (check-in: a47ff0cdab user: drh tags: trunk) | |
5 Years Ago (more context)
|
2014-05-28
| ||
| 20:22 | Add the ".shell" and the ".system" commands (aliases for the same thing) to the command-line shell. (check-in: d018a34a05 user: drh tags: trunk) | |
| 10:00 | Add an extra test to verify that the FTS notindexed option is working. (check-in: c461c0fe05 user: dan tags: trunk) | |
| 09:59 | • Edit [7d445e593a99665a|7d445e593a]: Move to branch mistake. Add propagating "hidden". Edit check-in comment. (artifact: 31197713ee user: dan) | |
| 09:56 | Moved to "mistake" because this commit contains a typo causing a test to fail. Was: Add an extra test to further verify that the FTS notindexed option is working properly. (Leaf check-in: 7d445e593a user: dan tags: mistake) | |
| 03:27 | Revise locking retry semantics in Win32 VFS to abort early if the file handle is reported as invalid. (check-in: d43e2e59b5 user: mistachkin tags: winLockHandle) | |
| 03:23 | Revise how OSTRACE reports logically boolean results in the Win32 VFS. (check-in: c405f971cf user: mistachkin tags: trunk) | |
10 Years Ago (more context)
|
2009-05-28
| ||
| 21:04 | Remove references to deleted function sqlite3ExprRegister(). Changes to the expr.c source module to promote better testing. (CVS 6686) (check-in: 6ae4ad6ebe user: drh tags: trunk) | |
| 14:34 | Fix a NULL pointer dereference following an OOM error in the column name resolver. (CVS 6685) (check-in: 3b46142532 user: drh tags: trunk) | |
| 12:49 | Make sure the column name resolver does not try to duplicate Expr.u.zToken when the Expr.u.iValue union member is the element being used. (CVS 6684) (check-in: 376ecf0d87 user: drh tags: trunk) | |
| 11:05 | Workaround the need for internal API sqlite3BtreeCursorDb(). It was only being used for an assert() statement, which can be done differently. (CVS 6683) (check-in: 5904af6e6d user: danielk1977 tags: trunk) | |
| 01:00 | Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) (check-in: 4ac2bdfbb4 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2004-05-28
| ||
| 16:00 | Factor common code for generating index keys into a procedure. Other speed improvements and bug fixes. (CVS 1487) (check-in: 6661bb5f9c user: drh tags: trunk) | |
| 13:13 | Fix a bug in the sqlite3_column_decltype() API. (CVS 1486) (check-in: c8a40218c2 user: danielk1977 tags: trunk) | |
| 12:33 | Allow CREATE and DROP VIEW on attached databases. (CVS 1485) (check-in: ad879a957d user: danielk1977 tags: trunk) | |
| 12:11 | Allow DROP TABLE and DROP INDEX on attached databases. (CVS 1484) (check-in: 2fb3708e10 user: danielk1977 tags: trunk) | |
| 11:37 | Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) (check-in: 4984a130cc user: danielk1977 tags: trunk) | |
| 08:21 | Tables and indices use the same record format. (CVS 1482) (check-in: 1b15b32bdb user: drh tags: trunk) | |
| 08:21 | Tables and indices use the same record format. (CVS 1481) (check-in: ebd564d10b user: drh tags: trunk) | |
| 01:39 | Remove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit version of sqlite3GetVarint for schema-level parameters. (CVS 1480) (check-in: 321f8c4635 user: drh tags: trunk) | |