This Day In History For 2020-09-24
1 Year Ago (more context)
|
2019-09-24
| ||
| 20:20 | Bug fixes for window frames of the form (... RANGE BETWEEN b PRECEDING AND a PRECEDING) or (... RANGE a FOLLOWING AND b FOLLOWING) where (a > b). (check-in: 040e196a user: dan tags: trunk) | |
2 Years Ago (more context)
|
2018-09-24
| ||
| 21:07 | Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open() returns. Fix test script problem in lookaside.test. (check-in: 3bd94e43 user: drh tags: branch-3.25) | |
| 20:50 | Fix missing space in 'configure.ac' reported on the mailing list. (check-in: 4407e15a user: drh tags: branch-3.25) | |
| 20:48 | Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 behavior of ALTER TABLE that does not modify the bodies of triggers or views or the WHERE clause of a partial index. Enable the legacy behavior by default when running the xRename method of virtual tables. (check-in: 31dc8b19 user: drh tags: branch-3.25) | |
| 19:41 | Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. (check-in: 3139af99 user: drh tags: branch-3.25) | |
| 19:32 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. (check-in: 8694c3d5 user: drh tags: branch-3.25) | |
| 19:21 | Fix the "sqlite3" command in the TCL interface so that it correctly returns an error if invoked with no arguments. (check-in: 8a82fcf0 user: drh tags: branch-3.25) | |
| 18:29 | Fix a problem with views that use window functions as part of complex expressions. (check-in: 1c0ecbbd user: drh tags: branch-3.25) | |
| 15:39 | Slightly smaller and faster alternative to [507d892c3a40a0bacbd47] that fixes a problem with views that use window function as part of complex expressions. (check-in: d7c816ae user: drh tags: trunk) | |
| 14:51 | Fix a problem with views that use window functions as part of complex expressions. (check-in: 507d892c user: dan tags: trunk) | |
| 14:12 | • Edit [5a38d9281b4ad63b|5a38d928]: Edit check-in comment. (artifact: 7e8b3d0a user: drh) | |
| 14:11 | • Fixed ticket [f25d5cee]: INTEGER PRIMARY KEY WITHOUT ROWID virtual table crash plus 5 other changes (artifact: b01c7b39 user: drh) | |
| 14:10 | Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. (check-in: 5a38d928 user: drh tags: trunk) | |
| 14:10 | • New ticket [f25d5cee] INTEGER PRIMARY KEY WITHOUT ROWID virtual table crash. (artifact: 0f28c7fc user: drh) | |
| 12:37 | Use compile-time options SQLITE_QUERY_PLANNER_LIMIT and SQLITE_QUERY_PLANNER_LIMIT_INCR to control the value for WhereLoopBuilder.iPlanLimit, rather than embedding magic numbers in the code. (check-in: 903e5018 user: drh tags: trunk) | |
| 10:47 | Increase the initial value of WhereLoopBuilder.iPlanLimit to 20K. Issue a warning if the iPlanLimit reaches zero. (check-in: 3dd35f51 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2016-09-24
| ||
| 17:42 | Omit the LikeOp object from the parser. Change more sqlite3PExpr() calls into sqlite3ExprAlloc() calls. (check-in: 795454a3 user: drh tags: trunk) | |
| 01:41 | Add -DSQLITE_MAX_EXPR_DEPTH=0 to the --lean option on speed-check.sh. (check-in: a8cb1390 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-09-24
| ||
| 18:47 | Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. (check-in: 668fc1eb user: drh tags: trunk) | |
| 17:38 | Fix over-length source code lines in where.c. No logic changes. (check-in: 1c8c5380 user: drh tags: trunk) | |
| 15:17 | Merge all recent trunk enhancements and fixes into the begin-concurrent branch. (check-in: c63c1e15 user: drh tags: begin-concurrent) | |
| 15:06 | Merge trunk changes into the cursor-hints branch. (check-in: fbe63762 user: drh tags: cursor-hints) | |
| 14:43 | Merge recent trunk enhancements into the apple-osx branch. (check-in: 4dd06d8b user: drh tags: apple-osx) | |
| 14:26 | Merge all the latest trunk enhancements into the sessions branch. (check-in: c91065f8 user: drh tags: sessions) | |
| 12:40 | Strengthen the implementations of xShmMemoryBarrier on both the unix and windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used. (check-in: c6ab807b user: drh tags: trunk) | |
| 12:19 | Make sure joins work correctly when both sides of the join are connected using indexed expressions. (check-in: c2fcb032 user: drh tags: trunk) | |
| 11:26 | Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. (check-in: d9b716a6 user: drh tags: trunk) | |
| 11:06 | Fix a JSON1 test case so that it works on builds that omit virtual tables. (check-in: a4444c0f user: drh tags: trunk) | |
| 01:40 | Another (smaller) performance optimization for the JSON parser. (check-in: c43daa8c user: drh tags: trunk) | |
| 01:06 | Performance optimizations on the JSON parser. (check-in: 7dd4b07a user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-09-24
| ||
| 19:14 | Modify some evidence tags to match updated gifs. (check-in: f44de500 user: dan tags: trunk) | |
| 18:08 | Merge experimental branch back into trunk. (check-in: 83ecec5d user: dan tags: trunk) | |
| 18:05 | • Edit [c1ebcacd9b31239a|c1ebcacd]: Timestamp 2010-09-24 09:32:45. Add tag "experimental". (artifact: 8205e437 user: drh) | |
| 18:04 | • Edit [c1ebcacd9b31239a|c1ebcacd]: Timestamp 2010-09-24 09:32:45. Cancel tag "experimental". (artifact: d85a51d4 user: drh) | |
| 18:04 | Add new file e_vacuum.test. Move part of e_select.test into e_select2.test. (Closed-Leaf check-in: 30801892 user: dan) | |
| 13:27 | • Edit [c1ebcacd9b31239a|c1ebcacd]: Change branch background color to "#c0ffc0". Timestamp 2010-09-24 09:32:45. (artifact: cd66ffd1 user: drh) | |
| 09:32 | Add experimental branch disallowing VACUUM when there are one or more active SQL statements. (check-in: c1ebcacd user: dan tags: experimental) | |
| 08:00 | Modify testable statement ids in a few test files to account for recent docsrc changes. (check-in: 7893e525 user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-09-24
| ||
| 15:25 | Version 3.2.7 (CVS 2736) (check-in: bd141a7c user: drh tags: trunk) | |
| 15:10 | Perparations for version 3.2.7. (CVS 2735) (check-in: 70937d5c user: drh tags: trunk) | |
| 11:01 | Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) (check-in: 079c6348 user: drh tags: trunk) | |