SQLite

Today In History
Login

This Day In History For 2020-08-24

1 Year Ago (more context)

2019-08-24
21:02
Minor performance improvement for balance_nonroot(). (check-in: d7434cae3e user: dan tags: trunk)
21:01 Edit [c88d42a921edd00f|c88d42a921]: Move to branch mistake. Add propagating "hidden". Mark "Closed". (artifact: bca6da1457 user: dan)
20:59
Minor performance improvement to balance_nonroot(). (Closed-Leaf check-in: c88d42a921 user: dan tags: mistake)
17:11
Fix a potential buffer overrun in fts5 caused by corrupt database records. (check-in: 156d612800 user: dan tags: trunk)

2 Years Ago (more context)

2018-08-24
20:20
Fix a problem by renaming a column when the schema contains an trigger program featuring an UPSERT that uses an "excluded.*" reference to a different table. (check-in: 83d5f5abce user: dan tags: alter-table-rename-column)
20:10
Fix a problem with renaming a column that occurs as an "excluded.colname" construction in an UPSERT that is part of a trigger program. (check-in: bb2f723496 user: dan tags: alter-table-rename-column)
19:04
Set SQLITE_PTRSIZE to 4 when compiling with xlc on 32-bit AIX. (check-in: d158e5b12e user: mistachkin tags: trunk)
17:55
After modifying and reparsing the schema as part of an ALTER TABLE RENAME COLUMN, check that no new schema errors have been introduced (e.g. ambiguous column names in views) before committing the operation. (check-in: a0e06d2c5e user: dan tags: alter-table-rename-column)
16:04
Avoid incorrectly replacing tokens that refer to a column being renamed via an alias. For example, do not overwrite "xyz" when "a" is renamed in "CREATE VIEW v1 AS SELECT a AS xyz FROM tbl WHERE xyz=1" (check-in: ad072a835f user: dan tags: alter-table-rename-column)

3 Years Ago (more context)

2017-08-24
20:54
Fix an incorrect hyperlink in a comment. (check-in: 25292b9a4e user: drh tags: trunk)
16:21
Version 3.20.1 (Leaf check-in: 8d3a7ea6c5 user: drh tags: release, branch-3.20, version-3.20.1)
15:43
Fixes to documentation about SQLITE_OPEN_URI. (check-in: 7ec72314d6 user: drh tags: trunk)
14:25 Closed ticket [88af8923dc]: plus 5 other changes (artifact: a7d394dc86 user: drh)
14:08
Increase the version number to 3.20.1. (check-in: 70338c7cb1 user: drh tags: branch-3.20)
14:04
Make sure the sqlite3_result_pointer() interface does not leave a VM register in an inconsistent state. Fix for ticket [7486aa54b968e9b5]. Test cases are in TH3. (check-in: abc7adfda2 user: drh tags: branch-3.20)
13:55 Fixed ticket [7486aa54b9]: Assertion fault caused by sqlite3_result_pointer() plus 5 other changes (artifact: 9747bf4814 user: drh)
13:55
Make sure the sqlite3_result_pointer() interface does not leave a VM register in an inconsistent state. Fix for ticket [7486aa54b968e9b5]. Test cases are in TH3. (check-in: d2f9230c5c user: drh tags: trunk)
13:45 New ticket [7486aa54b9] Assertion fault caused by sqlite3_result_pointer(). (artifact: ace65a0c51 user: drh)
10:10
Test BEGIN CONCURRENT transactions that consist entirely of read-only statements. (check-in: c3fe1f4b7e user: dan tags: begin-concurrent)

4 Years Ago (more context)

2016-08-24
21:54
Simplified VDBE code for the vector NOT IN null-scanning loop. (check-in: 7ae504e62e user: drh tags: rowvalue)
21:24
Improved extended comments of comparison operators when the SQLITE_STOREP2 flags is set on P5. No changes to non-debug code. (check-in: bbc1b01616 user: drh tags: rowvalue)
19:58
Modularize all use of the calling convention macros based on the USE_STDCALL nmake macro. (check-in: e4a56197b0 user: mistachkin tags: callbackConv)
19:14
Add the sqlite3changebatch_db() API. (check-in: bee44ebc53 user: dan tags: changebatch)
18:51
In sqlite3FindInIndex(), improve internal comments and avoid an unreachable branch. (check-in: 55945fc12f user: drh tags: rowvalue)
18:50
Fix a bug in the fts5 snippet function causing it to return text containing zero phrase instances. (Closed-Leaf check-in: b174ed2bde user: dan tags: fts5-snippet-bias)
18:49
Merge updates from trunk. (check-in: 428fc38d95 user: mistachkin tags: callbackConv)
18:23 Edit [71ffa195f5a48280|71ffa195f5]: Remove the "Closed" mark. (artifact: 57d089e4b3 user: mistachkin)
18:21
Sync up the MSVC autoconf makefile. (check-in: 77f7c31a3a user: mistachkin tags: trunk)
17:49
Fix more unreachable branches. (check-in: 6099c180db user: drh tags: rowvalue)
15:37
Add a NEVER() on an unreachable branch in comparisonAffinity(). (check-in: 505a2f20ea user: drh tags: rowvalue)
12:22
Fix a buffer overrun in the code for handling IN(...) operators when the LHS of the operator contains indexed columns or expressions. (check-in: f41a0391b7 user: dan tags: rowvalue)
02:19 Edit [b0848925babde524|b0848925ba]: Add tag "cvs-to-fossil-cutover". (artifact: 7fa48b3872 user: drh)
00:51
The previous OOM fix was bad. Back it out and replace it with a better one. (check-in: 1e3bc3698a user: drh tags: rowvalue)
00:25
Avoid a potential null-pointer dereference following an OOM. (check-in: 25f6ed8de4 user: drh tags: rowvalue)

5 Years Ago (more context)

2015-08-24
22:06
Remove duplicated line of code. (check-in: 47280f2a2b user: mistachkin tags: begin-concurrent)
20:54
Remove some redundant code: Call sqlite3ResolveExprListNames() rather than calling sqlite3ResolveExprNames() in a loop - in two places. (check-in: bdaf66465b user: drh tags: trunk)
20:21
Enhances the parser so that it accepts arbitrary expressions for the arguments of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. (check-in: bed42116ad user: drh tags: trunk)
19:56
Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". (check-in: ba1ab858e2 user: dan tags: begin-concurrent)
19:08
Fix handling of attempts to modify the database schema, application_id or user_version within an UNLOCKED transaction. (check-in: 5b9f272113 user: dan tags: begin-concurrent)
17:42
Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. (check-in: d794b34da6 user: drh tags: trunk)
17:18
Enhancements to the batch build tool for MSVC. (check-in: a1ae20cd97 user: mistachkin tags: trunk)
16:00
Fix compilation without SQLITE_ENABLE_UNLOCKED. Also other code organization issues. (check-in: 0411355754 user: dan tags: begin-concurrent)
15:39
Disallow the use of COLLATE clauses and the ASC and DESC keywords within foreign key constraints and in the argument list to common table expressions. (check-in: 83cbc4d876 user: drh tags: trunk)
12:42
Improvements to JSON string dequoting. (check-in: 196d66d34d user: drh tags: trunk)
10:05
Consolidate two blocks of similar code in btreeFixUnlocked(). (check-in: 701302b4bd user: dan tags: begin-concurrent)
06:44
Merge trunk changes with this branch. (check-in: 876810c28b user: dan tags: begin-concurrent)
06:43
Fix another problem involving unlocked transactions and wal-file restarts. (check-in: 4460764ea8 user: dan tags: begin-concurrent)
02:32
Fix corner-case problems in the type and atom columns of json_each() and json_tree(). (check-in: f0aba0e120 user: drh tags: trunk)

10 Years Ago (more context)

2010-08-24
20:46
Replicate asserts on unixOpen() to winOpen() in os_win.c. (check-in: 40526d8390 user: shaneh tags: trunk)
18:35
Changes to support building with SQLITE_OMIT_WAL. (check-in: d1ed743b6e user: shaneh tags: trunk)
18:07
Change sqlite3_open_v2() to return SQLITE_MISUSE if the combination of bits in the flags parameter is invalid. The documentation says the behavior in this situation is undefined - the documentation is unaltered by this code change. (check-in: 5e8101c512 user: drh tags: trunk)
18:06
Comment enhancements and typo fixes in pcache1.c. (check-in: c2dc39c0c4 user: drh tags: trunk)
16:59
Fixes to allow fts3 tables to be renamed mid-transaction. (check-in: d1c875320a user: dan tags: trunk)
13:11
Add tests to e_expr.test. (check-in: 5c1c694ee1 user: dan tags: trunk)
12:05
Pull the incremental_vacuum bug fix ([255f1eefa373153942c67b18b]) and the R-tree segfault bug fix ([7f2f71cc9e3c39093f09231f44]) into the 3.6.23 branch. Increase the version number to 3.6.23.3. (check-in: bcbdecd854 user: drh tags: branch-3.6.23)
02:10
Cherrypick the R-tree invalid shadow-table big fix of [7f2f71cc9e3c39093f09231f44] into the apple-osx 3.6.23 branch. (check-in: 68103d91d4 user: drh tags: apple-osx-3623)
01:59
Cherrypick the incremental_vacuum bug fix ([255f1eefa373153942c67b18b]) into the apple-osx 3.6.23 branch. (check-in: 60f16838cc user: drh tags: apple-osx-3623)
01:51
Merge in the R-tree fix from the trunk. (check-in: 02ee0bd5a3 user: drh tags: apple-osx)
01:49
The R-tree module should not assume that its shadow tables are consistent. If a problem is found in a shadow table, return SQLITE_CORRUPT. (check-in: 7f2f71cc9e user: drh tags: trunk)
01:39 Edit [9883b406ce24eae9|9883b406ce]: Timestamp 2008-05-29 20:22:36. (artifact: 55f68fe6df user: drh)
01:38 Edit [6ed2d9f82e2c81d5|6ed2d9f82e]: Edit check-in comment. Timestamp 2008-01-22 16:35:36. (artifact: 953815cd71 user: drh)
01:38 Edit [2a2e8b64df3ff9ea|2a2e8b64df]: Timestamp 2008-03-06 04:14:17. (artifact: 3ccdd30689 user: drh)
01:38 Edit [b3a141b2b0c09bf3|b3a141b2b0]: Timestamp 2008-01-17 02:36:27. (artifact: 921f99cec6 user: drh)
01:37 Edit [f84550be0a0c9e58|f84550be0a]: Edit check-in comment. Timestamp 2007-08-28 23:28:07. (artifact: f6a7e81bb7 user: drh)
01:36 Edit [16041116aaaa2d52|16041116aa]: Edit check-in comment. Timestamp 2007-05-05 11:48:52. (artifact: 61b7b05973 user: drh)
01:36 Edit [7e0aa964129612e2|7e0aa96412]: Timestamp 2007-03-30 14:56:34. (artifact: 60b653f2c8 user: drh)
01:35 Edit [efa8fb32a596c723|efa8fb32a5]: Edit check-in comment. Timestamp 2006-09-18 20:24:02. (artifact: fe7cfedfe2 user: drh)
01:34 Edit [212de3ce66f74603|212de3ce66]: Edit check-in comment. Timestamp 2004-06-26 06:37:06. (artifact: 65754c424b user: drh)
01:33 Edit [d7551df8c32c4981|d7551df8c3]: Timestamp 2004-05-22 10:33:03. (artifact: 78c0a37cdc user: drh)
01:32 Edit [e80afe75b33d4eac|e80afe75b3]: Timestamp 2003-03-31 13:36:08. (artifact: 530a5b6b6d user: drh)
01:30 Edit [5ddeeb477148295b|5ddeeb4771]: Timestamp 2001-01-04 14:27:07. (artifact: d6d5c9e784 user: drh)
01:30 Edit [d49e10fb5e29318f|d49e10fb5e]: Timestamp 2001-01-04 14:20:17. (artifact: 7031b03620 user: drh)
01:29 Edit [ced90c3f93e5e0cf|ced90c3f93]: Timestamp 2000-12-10 18:23:49. (artifact: cfc0d37b77 user: drh)
01:28 Edit [af9673d1bff613b9|af9673d1bf]: Edit check-in comment. Timestamp 2000-12-10 18:23:50. (artifact: 9476fae243 user: drh)
01:08
Merge changes through release 3.7.2 into the apple-osx branch. (check-in: 415c448dc4 user: drh tags: apple-osx)
00:41 Edit [42537b60566f2881|42537b6056]: Change background color to "#d0c0ff". Edit check-in comment. Timestamp 2010-08-24 00:40:48. Add tag "release". (artifact: 9eb999380f user: drh)
00:40
Version 3.7.2 (check-in: 42537b6056 user: drh tags: trunk, release, version-3.7.2)

15 Years Ago (more context)

2005-08-24
18:04
Fix the --enable-threadsafe option to the configure script. Ticket #1378. (CVS 2623) (check-in: 76ec0b3d3a user: drh tags: trunk)
17:07
Additional defense against the rowid-fifo overflow problem. (CVS 2622) (check-in: 881dcf5fb1 user: drh tags: trunk)
16:54
Remove a stray C++ style comment causing problems for some compilers. (CVS 2621) (check-in: aa7dd3f2c7 user: drh tags: trunk)
16:13
Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620) (check-in: 7c599bae33 user: drh tags: trunk)
11:14
Version 3.2.4 (CVS 2619) (check-in: 8cef2c1ae7 user: drh tags: trunk)
11:07
Increase the version number and update the change log prior to release. (CVS 2618) (check-in: 139a28d231 user: drh tags: trunk)
03:52
After calling realloc() on an array to resize it, be sure not to use pointers into the old array. Ticket #1376. (CVS 2617) (check-in: 9f9a257123 user: drh tags: trunk)