Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
66 events for the month beginning 2019-07-01 by user drh
Following month ↑|
2019-07-31
| ||
| 15:16 | New test cases in test/fuzzdata8.db. (check-in: 6e92d71c user: drh tags: trunk) | |
| 12:13 | Do not allow the json_set() function to overwrite the same element more than once. (check-in: f237f60e user: drh tags: trunk) | |
|
2019-07-30
| ||
| 21:00 | Fix the build for when -DSQLITE_SMALL_STACK is used. (check-in: b9eda224 user: drh tags: trunk) | |
| 14:22 | Improved fix for ticket [ced41c7c7d6b4d36] that keeps skip-scan enabled, but avoids identifying a skip-scan as order-distinct (because it is not) and thus forces a separate b-tree to implement the DISTINCT clause of a query. This undoes check-in [a871d69c6de65038] and substitutes a new fix. (check-in: 89bf0399 user: drh tags: trunk) | |
| 01:17 | • Fixed ticket [ced41c7c]: Query with DISTINCT does not fetch all distinct rows plus 6 other changes (artifact: 8f62d6df user: drh) | |
| 01:17 | Disable the skip-scan optimization for DISTINCT queries. Fix for ticket [ced41c7c7d6b4d36] (check-in: a871d69c user: drh tags: trunk) | |
|
2019-07-29
| ||
| 17:18 | Convert an assert() in R-Tree into a database corruption detection case. (check-in: 48b518eb user: drh tags: trunk) | |
| 06:07 | • Fixed ticket [ba2f4585]: Query with ORDER BY results in "database disk image is malformed" error plus 6 other changes (artifact: 468ed184 user: drh) | |
| 06:06 | Fix the OP_Affinity operator so that when applying REAL affinity, it only sets MEM_IntReal if the integer value will fit in 6 bytes or less. Fix for ticket [ba2f4585cf495231] (check-in: 2b221bb1 user: drh tags: trunk) | |
| 06:05 | • Closed ticket [18ab5da2]: Issue with DISTINCT and COLLATE plus 7 other changes (artifact: 739f46ad user: drh) | |
| 05:23 | Fix a minor typo in a comment. (check-in: cea8a892 user: drh tags: trunk) | |
|
2019-07-24
| ||
| 23:15 | • Fixed ticket [c52b09c7]: Assertion fault in the query planner on a deeply nested query plus 4 other changes (artifact: f92124ec user: drh) | |
| 23:15 | Fix faulty asserts in the code generator. Ticket [c52b09c7f38903b1] (check-in: 01cdc590 user: drh tags: trunk) | |
| 22:44 | • Ticket [c52b09c7] Assertion fault in the query planner on a deeply nested query status still Open with 7 other changes (artifact: 7a3aa0ef user: drh) ... 1 similar event omitted. | |
|
2019-07-22
| ||
| 23:30 | Do not use the insert-overwrite optimization if the cell might overwrite the page header. (Leaf check-in: 9991626b user: drh tags: branch-3.29) | |
| 23:24 | Do not use the insert-overwrite optimization if the cell might overwrite the page header. (check-in: f60a8306 user: drh tags: trunk) | |
| 19:01 | Consolidate the removal of Window objects from the Select.pWin list into a single subroutine. (check-in: e46b2afc user: drh tags: trunk) | |
| 16:57 | New test cases added to test/fuzzdata8.db (check-in: 25fec62a user: drh tags: trunk) | |
|
2019-07-20
| ||
| 21:12 | Make sure any window definitions in an ORDER BY clause are removed from the SELECT statement if the ORDER BY clause gets optimized out. (check-in: 23b11967 user: drh tags: winfunc-in-orderby) | |
| 18:00 | Early detection of a corrupt R-Tree in the R-Tree search algorithm. (check-in: 2bf5a4c1 user: drh tags: trunk) | |
| 17:43 | Performance optimizations in the rtreeStepToLeaf() routine of RTree. (check-in: 4e34e361 user: drh tags: trunk) | |
|
2019-07-19
| ||
| 15:03 | New test cases added to test/fuzzdata8.db. (check-in: 39be3c61 user: drh tags: trunk) | |
| 15:00 | Refinement to check-in [348e7f193a963390] that avoids unreachable branches. (check-in: bbfb2908 user: drh tags: trunk) | |
| 01:25 | Fix a new problem in the BETWEEN operator when applied to a window function. The problem was introduced yesterday by check-in [7ef7b23cbb1b9ace]. This cherry-pick also needed to remove an assert from sqliteExprDelete(). (check-in: ce6bf395 user: drh tags: branch-3.29) | |
| 01:11 | Fix a new problem in the BETWEEN operator when applied to a window function. The problem was introduced yesterday by check-in [7ef7b23cbb1b9ace]. (check-in: 47e23064 user: drh tags: trunk) | |
|
2019-07-18
| ||
| 19:50 | Add a ctime.c entry for SQLITE_ENABLE_SHARED_SCHEMA. (check-in: 892ac945 user: drh tags: reuse-schema) | |
|
2019-07-17
| ||
| 19:57 | Always use the stdlib.h intptr_t type for pointer-integer conversions, when it is available. (check-in: c0d93244 user: drh tags: trunk) | |
| 18:19 | When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9]. (check-in: bc6b0d73 user: drh tags: branch-3.29) | |
| 18:11 | Fix problems with duplicate fields in the PRIMARY KEYs of WITHOUT ROWID tables. (check-in: bda25883 user: drh tags: branch-3.29) | |
| 16:18 | Fix an incorrect assert() in balance_nonroot(). (check-in: 59c9e73f user: drh tags: trunk) | |
| 15:47 | • Fixed ticket [1be72aab]: CHECK constraint using COLLATE with CASE or BETWEEN plus 3 other changes (artifact: fd3c95a4 user: drh) | |
| 15:05 | Improvement to the hexdb interpreter built into the CLI and into the TCL test harness: Round the "size" up to the next multiple of the "pagesize". (check-in: 9ec92939 user: drh tags: trunk) | |
| 14:28 | • Ticket [1be72aab] CHECK constraint using COLLATE with CASE or BETWEEN status still Open with 3 other changes (artifact: 551d972b user: drh) ... 2 similar events omitted. | |
| 13:10 | • Fixed ticket [fd3aec0c]: Valgrind warning if PK has more columns than the table. plus 5 other changes (artifact: c294e6d9 user: drh) | |
| 12:49 | Fix the WITHOUT ROWID table logic so that it generates a correct KeyInfo object for tables that have a PRIMARY KEY containing the same column used more than once with different collating sequences. Enhance the index_xinfo pragma to assist in testing the above. Fix for ticket [fd3aec0c7e3e2998]. (check-in: 84a51a75 user: drh tags: trunk) | |
| 12:42 | New test cases for PRAGMA index_xinfo on a WITHOUT ROWID table. And new testcases using index_xinfo to verify that WITHOUT ROWID tables are constructed correctly. (Closed-Leaf check-in: 340378c1 user: drh tags: wor-pk-dups) | |
| 11:01 | Enhance the "PRAGMA index_info()" and "PRAGMA index_xinfo()" statements so that they allow a WITHOUT ROWID table as their argument, and in that case show the structure of the underlying index used to implement the WITHOUT ROWID table. (check-in: 62274ff6 user: drh tags: wor-pk-dups) | |
| 01:27 | • New ticket [fd3aec0c] Valgrind warning if PK has more columns than the table.. (artifact: 6e4769b4 user: drh) | |
|
2019-07-16
| ||
| 19:44 | Add new assert() statements in an attempt to help static analyzers avoid false-positives. (check-in: 9e664585 user: drh tags: trunk) | |
| 18:27 | Add assert()s in os_win.c in an effort to silence false-positives from static analyzers. (check-in: 22a7c15b user: drh tags: trunk) | |
|
2019-07-14
| ||
| 00:15 | Mark an unreachable branch using ALWAYS(). (check-in: 0fff105a user: drh tags: trunk) | |
|
2019-07-13
| ||
| 17:21 | Fix a double-quoted string literal used in the ".schema" command of the CLI. (check-in: fcd937d9 user: drh tags: trunk) | |
| 16:15 | Remove unreachable "break" statements to silence harmless compiler warnings from ICC. (check-in: 0d7287e1 user: drh tags: trunk) | |
|
2019-07-11
| ||
| 19:50 | Improved comments and extra testcase() macros on the serial-type computation logic in the OP_MakeRecord opcode. (check-in: 18bfb217 user: drh tags: trunk) | |
| 19:27 | Increase the version number to 3.30.0 for the next release cycle. (check-in: 2578e3c6 user: drh tags: trunk) | |
| 19:22 | Move the sqlite3VdbeSerialType() routine in-line in the OP_MakeRecord opcode. Optimizing compilers were doing this already. By doing it manually, we can omit some redundant tests and make the whole thing run a million cycles faster and use about 80 bytes less code space. (check-in: d837ab0d user: drh tags: trunk) | |
|
2019-07-10
| ||
| 18:45 | Merge the version 3.29.0 release enhancements into the reuse-schema branch. (check-in: 9819ead0 user: drh tags: reuse-schema) | |
| 18:40 | Merge the 3.29.0 updates into the begin-concurrent-pnu-wal2 branch. (check-in: 627b428f user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:30 | Merge the 3.29.0 release into the wal2 branch. (check-in: 8baa4022 user: drh tags: wal2) | |
| 18:21 | Merge the 3.29.0 changes into the begin-concurrent-pnu branch. (check-in: c89949cc user: drh tags: begin-concurrent-pnu) | |
| 18:11 | Merge the 3.29.0 release into the begin-concurrent branch. (check-in: 983733ae user: drh tags: begin-concurrent) | |
| 17:58 | Merge the 3.29.0 release into the apple-osx branch. (check-in: 87aa1d70 user: drh tags: apple-osx) | |
| 17:32 | Version 3.29.0 (check-in: fc82b73e user: drh tags: trunk, release, version-3.29.0) | |
|
2019-07-09
| ||
| 23:35 | Add the "LL" suffix on a pair of larger integer literals, for compatibility with older C compilers. (check-in: 6f328c35 user: drh tags: trunk) | |
|
2019-07-08
| ||
| 21:32 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: fae92fee user: drh tags: reuse-schema) | |
| 21:25 | Merge enhancments from wal2, which also merges trunk enhancements. (check-in: 08dcb459 user: drh tags: begin-concurrent-pnu-wal2) | |
| 21:19 | Merge all enhancements from trunk into the wal2 branch. (check-in: dcbcbc2a user: drh tags: wal2) | |
| 21:12 | Merge enhancements from trunk into the begin-concurrent-pnu branch. (check-in: 05aa93af user: drh tags: begin-concurrent-pnu) | |
| 21:06 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 7fff0803 user: drh tags: begin-concurrent) | |
| 20:59 | Merge recent enhancements from trunk into apple-osx. (check-in: de88ed86 user: drh tags: apple-osx) | |
| 18:35 | Fix dbfuzz2 so that it will compile on systems that do not support getrlimit(). (check-in: 36295dce user: drh tags: trunk) | |
| 12:44 | Comment improvements. No changes to code. (Leaf check-in: b0629132 user: drh tags: tkt9b78184b-alt) | |
|
2019-07-02
| ||
| 12:23 | Restore the legacy behavior of enabling double-quoted string literals in all contexts. But also provide a new compile-time option (SQLITE_DQS) to change the default to something more restrictive. (check-in: 97a94446 user: drh tags: trunk) | |