This Day In History For 2019-07-23
1 Year Ago (more context)
2018-07-23
| ||
22:55 | Return an SQLITE_NOMEM error if the locking mutex fails to allocate. (Closed-Leaf check-in: 1c94834879 user: drh tags: separate-lock-mutex) | |
21:10 | First attempt at reducing mutex contention in the unix VFS by providing a separate mutex for each unixInodeInfo object. (check-in: f69afaf00a user: drh tags: separate-lock-mutex) | |
18:53 | Fix typo of 'SQLITE_OMIT_WINDOWFUNC'. (check-in: 8607b84a5c user: mistachkin tags: trunk) | |
18:32 | Attempt to improve the documentation for snapshots. No changes to code. (check-in: 46dd076af5 user: drh tags: trunk) | |
10:57 | Fix the macros used to generate the output of "PRAGMA compile_options" so that they handle valid values for the SQLITE_DEFAULT_LOOKASIDE macro (which contain a "," character). (check-in: 1cc72845f9 user: dan tags: trunk) | |
3 Years Ago (more context)
2016-07-23
| ||
20:27 | Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. (check-in: c8e0539b97 user: drh tags: trunk) | |
20:24 | Allow vector IN(SELECT ...) expressions to use an index if either all the indexed columns are declared NOT NULL or if there is no difference between the expression evaluating to 0 and NULL (as in a WHERE clause). (check-in: e2fd6f49b1 user: dan tags: rowvalue) | |
19:34 | Add the json_quote() function to the JSON1 extension. (check-in: 269892abf6 user: drh tags: trunk) | |
19:20 | • Edit [549abe3f89b55b05|549abe3f89]: Mark "Closed". (artifact: 625c5e2f44 user: drh) | |
19:18 | Small tweak to the btree balancer for improved tree balance. (check-in: 8817dedb75 user: drh tags: trunk) | |
14:50 | Fix recently added tests so that they work in all configurations. (check-in: d0bcaf0cd9 user: drh tags: trunk) | |
05:22 | Add the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces. (check-in: 99a6c51887 user: drh tags: trunk) | |
04:58 | Improvements to sqlite3_trace_v2() documentation. Fix the sqlite3VdbeExpandSql() routine to respond better to OOM conditions. (Closed-Leaf check-in: 0400f642d5 user: drh tags: sqlite3_trace_v2) | |
02:07 | Add requirements marks to the sqlite3_trace_v2() interface documentation. (check-in: ebd388e94d user: drh tags: sqlite3_trace_v2) | |
00:43 | Fix sqlite3VdbeExpandSql() so that it handles OOMs by always returning NULL. (check-in: 5a027fe412 user: drh tags: sqlite3_trace_v2) | |
4 Years Ago (more context)
2015-07-23
| ||
21:59 | Merge all changes in the latest 3.8.11 beta into the sessions branch. Changes include the rename of OTA to RBU, the WITHOUT-ROWID-OR-Skipscan fix, and improvements to pcache1. (check-in: 7f0ee77062 user: drh tags: sessions) | |
20:44 | Change the name of the OTA extension to RBU: Resumable Bulk Update. (check-in: 017c5019e1 user: drh tags: trunk) | |
17:16 | When SQLITE_OMIT_LOOKASIDE is set, do not allocate any lookaside memory since it will never be used. (check-in: 0ffd499f23 user: drh tags: trunk) | |
16:41 | • Fixed ticket [8fd39115d8]: assertion fault on WITHOUT ROWID query using the OR optimization plus 7 other changes (artifact: 4bd51eb98f user: drh) | |
16:39 | The sqlite3ExprCodeGetColumn() is not guaranteed to put the result in the register requested. Fix the skip-scan code generator for WITHOUT ROWID tables so that it always checks the register and copies the result if it lands in the wrong register. Fix for ticket [8fd39115d8f46ece70e7d4b3]. (check-in: 793e206f90 user: drh tags: trunk) | |
14:27 | • New ticket [8fd39115d8] assertion fault on WITHOUT ROWID query using the OR optimization. (artifact: d63541a512 user: drh) | |
5 Years Ago (more context)
2014-07-23
| ||
23:57 | Add experimental "costmult" logic. Only enabled when compiled with -DSQLITE_ENABLE_COSTMULT. (check-in: 729ece4088 user: drh tags: trunk) | |
19:37 | Ugh. Consecutive UNIQUE index entries are only distinct if the index is on NOT NULL columns. So the previous version was not quite right. This check-in fixes the problem. (check-in: 30033f9650 user: drh tags: faster-analyze) | |
19:31 | Add a snippet() function to fts5. (check-in: bdc58fd28a user: dan tags: fts5) | |
19:04 | Enhancements to the hex literal tests. (Closed-Leaf check-in: a3cc027fa7 user: mistachkin tags: hex-literal) | |
18:41 | • Edit [3e1e79e1335f7ad3|3e1e79e133]: Move to branch faster-analyze. (artifact: 27fe394045 user: drh) | |
18:36 | Improve the performance of the ANALYZE command by taking advantage of the fact that every row of a UNIQUE index is distinct. (check-in: 3e1e79e133 user: drh tags: faster-analyze) | |
15:51 | Updated documentation on sqlite3_temp_directory. No changes to code. (check-in: e6225a7bf7 user: drh tags: trunk) | |
14:52 | Remove a surplus function prototype. #ifdef code that is not used when hex integers are omitted at compile time. (check-in: a5b383e077 user: drh tags: hex-literal) | |
13:40 | Change the hex literal processing so that only the SQL parser understands hex literals. Casting and coercing string literals into numeric values does not understand hexadecimal integers. This preserves backwards compatibility. Also: Throw an error on any hex literal that is too big to fit into 64 bits. (check-in: 6c6f0de59b user: drh tags: hex-literal) | |
02:07 | Casting hex literals directly from string to float always results in a positive number. (check-in: 4b86ccdf4f user: drh tags: hex-literal) | |
01:59 | Reformatting a few test cases for clarity. (check-in: 7e1bbacb11 user: drh tags: hex-literal) | |
01:56 | Test cases for hex literals. (check-in: 19054339c4 user: drh tags: hex-literal) | |
01:26 | Add support for parsing C-style hexadecimal literals. (check-in: 34a1f38b7a user: drh tags: hex-literal) | |
10 Years Ago (more context)
2009-07-23
| ||
01:44 | Simplifications and comment enhancements on btree.c. (CVS 6925) (check-in: 5ba880dde8 user: drh tags: trunk) | |
15 Years Ago (more context)
2004-07-23
| ||
01:10 | More fixes to the publish.sh script. (CVS 1863) (check-in: 022e3f56ac user: drh tags: version_2) | |
00:01 | First cut at a analysis tool for version 3.0 databases. (CVS 1862) (check-in: 7c7f698b2e user: drh tags: trunk) | |