Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around aff209804722ac90.
|
2019-09-01
| ||
| 18:44 | • New ticket [2841e99d] Different rounding when converting TEXT to REAL. (artifact: 08df019d user: mrigger) | |
| 16:02 | • New ticket [57af00b6] Expression computed on row yields incorrect result. (artifact: ece608d0 user: mrigger) | |
|
2019-08-31
| ||
| 20:29 | Fix a harmless compiler warning. (check-in: 63c67a54 user: drh tags: trunk) | |
| 20:26 | Mark new VDBE branches never taken. (check-in: 83c2adff user: drh tags: trunk) | |
| 20:13 | Improvements to the algorithm that determines which SELECT in a sequence of nested SELECT statements that an aggregate function belongs to. This resolves an issue identified by dbsqlfuzz. (check-in: d7680074 user: drh tags: trunk) | |
| 17:15 | • Closed ticket [d6a0fbc1]: REINDEX causes "UNIQUE constraint failed" error when using TRIGGER plus 6 other changes (artifact: 9c168f35 user: dan) | |
| 17:14 | If a DELETE trigger fired by an UPDATE OR REPLACE statement deletes the row being updated, do not attempt to proceed with the original UPDATE operation. Fix for [d6a0fbc1]. (check-in: 4145b3e0 user: dan tags: trunk) | |
| 06:17 | • New ticket [d6a0fbc1] REINDEX causes "UNIQUE constraint failed" error when using TRIGGER. (artifact: 32d2e31d user: mrigger) | |
| 01:33 | Remove some affinity tests that became unreachable due to the prior change. (check-in: e2db1123 user: drh tags: trunk) | |
|
2019-08-30
| ||
| 23:56 | • Fixed ticket [40812aea]: Incorrect result for comparison of large number plus 6 other changes (artifact: 0dea4a6a user: drh) | |
| 23:56 | When the affinity of a table column is INT or REAL, make the affinity of corresponding index columns NUMERIC. This increases the precision of index lookups for large numbers so that it matches the precision of ordinary comparison operators. Ticket [40812aea1fde9594] (check-in: e0d909c7 user: drh tags: trunk) | |
| 23:15 | • Fixed ticket [5a3dba81]: REINDEX causes "UNIQUE constraint failed" error plus 6 other changes (artifact: fedacb2d user: drh) | |
| 23:15 | Make sure OP_RealAffinity has been applied to all columns of type REAL in the excluded.* pseudo-table of an UPSERT. Ticket [5a3dba8104421320] (check-in: 67381dad user: drh tags: trunk) | |
| 21:52 | Improvements to VDBE tracing. No changes to code in normal deliverables. (check-in: 54553bf1 user: drh tags: trunk) | |
| 20:28 | • New ticket [40812aea] Incorrect result for comparison of large number. (artifact: 8188b7b4 user: mrigger) | |
| 19:45 | Add test case to window8.test. Also fix an error in a comment in window.c. (check-in: 2925bfa5 user: dan tags: trunk) | |
| 19:41 | • New ticket [5a3dba81] REINDEX causes "UNIQUE constraint failed" error. (artifact: a6172ac6 user: mrigger) | |
| 18:02 | Back out the change at [47cd634c98b502d4] which was incorrect. Add a test case so that we don't accidently back out that change again. (check-in: 596ac2a4 user: drh tags: trunk) | |
| 17:28 | Add further comments to window.c. (check-in: 90046456 user: dan tags: trunk) | |
| 16:46 | New test cases for window functions with RANGE BETWEEN and DESC NULLS FIRST. (check-in: f7002f86 user: drh tags: trunk) | |
| 16:14 | Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause. (check-in: 39b4cad4 user: dan tags: trunk) | |
| 16:01 | • Fixed ticket [f8f472cb]: Partial index and BETWEEN issue plus 6 other changes (artifact: 03079b14 user: drh) | |
| 16:00 | The expression "(X IS FALSE) IN (FALSE)" does not imply that X is NOT NULL. Ticket [f8f472cbc77ba9c9] (check-in: dd661348 user: drh tags: trunk) | |
| 15:43 | • New ticket [f8f472cb] Partial index and BETWEEN issue. (artifact: bac71624 user: mrigger) | |
| 15:11 | • Fixed ticket [fba33c8b]: Partial index causes row to not be fetched in BETWEEN expression plus 6 other changes (artifact: 9f4bc62d user: drh) | |
| 15:11 | The expression "(X IS FALSE) BETWEEN FALSE AND TRUE" does not implie that X is not NULL. Ticket [fba33c8b1df6a915] (check-in: 057fb8b1 user: drh tags: trunk) | |
| 14:33 | • New ticket [fba33c8b] Partial index causes row to not be fetched in BETWEEN expression. (artifact: aa648476 user: mrigger) | |
| 13:07 | • Fixed ticket [a6408d42]: Partial index causes row to not be fetched plus 6 other changes (artifact: 8b2e986d user: drh) | |
| 13:07 | The expression "(x IS FALSE) IS FALSE" does not imply that X is not NULL. Ticket [a6408d42b9f44462] (check-in: 45ff2b1f user: drh tags: trunk) | |
| 11:33 | • New ticket [a6408d42] Partial index causes row to not be fetched. (artifact: ba5257e3 user: mrigger) | |
|
2019-08-29
| ||
| 23:24 | Remove a faulty testcase() macro. (check-in: 80124ae5 user: drh tags: trunk) | |
| 21:16 | Improve vdbe branch coverage of NULLS LAST code. (check-in: e8e9f77d user: dan tags: trunk) | |
| 19:34 | Fix other problems similar to ticket [c0390363]. (check-in: 96ff2ba9 user: dan tags: trunk) | |
| 16:48 | Add a missing VdbeCoverage() macro. (check-in: 33da6092 user: drh tags: trunk) | |
| 16:17 | Remove an unreachable branch in the NULLS LAST logic of RANGE window functions. (check-in: 47cd634c user: drh tags: trunk) | |
| 15:50 | Fix another case where SQLite assumes that if "~(? AND FALSE)" is true, "?" must be non-null. (check-in: 616f5663 user: dan tags: trunk) | |
| 15:48 | • Edit [84ae41fd2f50cb7c|84ae41fd]: Edit check-in comment. (artifact: 1ab67b0d user: dan) | |
| 15:07 | • Closed ticket [c0390363]: Indexes causes row to not be fetched plus 6 other changes (artifact: f038f6f7 user: dan) | |
| 15:06 | Avoid assuming that for "~ (? AND FALSE)" to be true, "?" must not be NULL, just as we do for "NOT (? AND FALSE)". Fix for ticket [c0390363]. (check-in: 84ae41fd user: dan tags: trunk) | |
| 14:25 | Fix a potential buffer overrun in fts5 caused by corrupted database records. (check-in: c465d0eb user: dan tags: trunk) | |
| 13:46 | • New ticket [c0390363] Indexes causes row to not be fetched. (artifact: c8904367 user: mrigger) | |
| 12:54 | • Closed ticket [51f5b6e4]: Short-circuit evaluation issue plus 8 other changes (artifact: 5e239be7 user: drh) | |
| 00:27 | Improve Lemon so that it enlarges some of its tables slightly in order to avoid having to index range checks on table lookups for a performance increase. (check-in: 4be6a23a user: drh tags: trunk) | |
|
2019-08-28
| ||
| 21:11 | • New ticket [51f5b6e4] Short-circuit evaluation issue. (artifact: 4fa98dbf user: mrigger) | |
| 11:49 | Fix an unreachable branch in sqlite3ParserFallback() (Closed-Leaf check-in: e059178b user: drh tags: lemon-optimization) | |
| 11:31 | Further improvements to parser speed by enlarging lookup tables to eliminate the need to do range checking on the index prior to lookup. (check-in: 47d3e091 user: drh tags: lemon-optimization) | |
| 02:09 | Increase the size of the yy_lookahead table so that it is never necessary to down bounds checking on the index. (check-in: bafd8723 user: drh tags: lemon-optimization) | |
|
2019-08-27
| ||
| 20:00 | • Closed ticket [f8a7060e]: Incorrect result for query that uses MIN() and a CAST on rowid plus 4 other changes (artifact: 400f3bdf user: dan) | |
| 19:59 | Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. (check-in: 94085fb3 user: dan tags: trunk) | |
| 17:59 | The ALWAYS() added by the previous check-in was incorrect. Take it back out. (check-in: 336235db user: drh tags: trunk) | |
| 17:28 | Add ALWAYS() to an always true conditional that results from the previous check-in. Add a test case for ticket [dbaf8a6820be1ece] to supplement those already checked into TH3. (check-in: aff20980 user: drh tags: trunk) | |
| 17:01 | • Fixed ticket [dbaf8a68]: Unexpected affinity conversion is performed for the IN operator plus 6 other changes (artifact: afafc304 user: drh) | |
| 17:01 | Omit the "x IN (y)" to "x==y" optimization of check-in [e68b427afbc82e20] (and ticket [e39d032577df6942]) as it causes difficult affinity problems as demonstrated by ticket [dbaf8a6820be1ece] and the original assertion fault is no longer a factor due to countless other changes of the previous 5 years. (check-in: 7f5168a7 user: drh tags: trunk) | |
| 15:14 | • New ticket [dbaf8a68] Unexpected affinity conversion is performed for the IN operator. (artifact: 8542c61f user: mrigger) | |
| 10:09 | • Fixed ticket [ac8dd4a3]: Segfault when dropping a temp trigger on a database that has already been detached plus 5 other changes (artifact: 8eb244c9 user: drh) | |
| 10:08 | • Edit [069c2f4c61f06211|069c2f4c]: Edit check-in comment. (artifact: 6718e124 user: drh) | |
| 10:05 | If a TEMP TRIGGER references an auxiliary schema, and that auxiliary schema is detached, move the trigger to reference the TEMP schema before completing the detach, so that the trigger does not hold a dangling schema pointer. Ticket [ac8dd4a32ba4322f] (check-in: 069c2f4c user: drh tags: trunk) | |
| 09:42 | • New ticket [ac8dd4a3] Segfault when dropping a temp trigger on a database that has already been detached. (artifact: 719304a8 user: dan) | |
|
2019-08-26
| ||
| 20:41 | Merge in recent fixes from trunk. (Closed-Leaf check-in: ad816d01 user: drh tags: nulls-last) | |
| 14:57 | Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. (check-in: 279ac7fd user: dan tags: trunk) | |
| 14:19 | • Ticket [78acc9d4] Assertion fault in row-value UPDATE status still Fixed with 3 other changes (artifact: dad97470 user: drh) ... 1 similar event omitted. | |
| 14:18 | Improved detection of number of column mismatch for vector assignment in UPDATE statements. Ticket [78acc9d40f0786e8] (check-in: bd4bda73 user: drh tags: trunk) | |
| 13:45 | Fix typo in a comment. No code changes. (check-in: d0cc06d8 user: drh tags: trunk) | |
| 13:24 | • New ticket [78acc9d4] Assertion fault in row-value UPDATE. (artifact: a4def077 user: drh) | |
| 12:50 | Enforce 80-character line discipline in the CLI. Minor improvements to the CLI built-in help. (check-in: 9690013a user: drh tags: trunk) | |
|
2019-08-24
| ||
| 21:02 | Minor performance improvement for balance_nonroot(). (check-in: d7434cae user: dan tags: trunk) | |
| 21:01 | • Edit [c88d42a921edd00f|c88d42a9]: Move to branch mistake. Add propagating "hidden". Mark "Closed". (artifact: bca6da14 user: dan) | |
| 17:11 | Fix a potential buffer overrun in fts5 caused by corrupt database records. (check-in: 156d6128 user: dan tags: trunk) | |
|
2019-08-23
| ||
| 23:05 | Fix the built-in edit() SQL function in the CLI so that it works with zero-length blobs. (check-in: e3249012 user: drh tags: trunk) | |
| 21:11 | • Edit [bad4d7a0d93f4d8f|bad4d7a0]: Mark "Closed". (artifact: ca328fec user: drh) | |
| 21:11 | Attempt to parse the NULLS LAST clause more efficiently. A few cycles were saved, but at the expense of more code. And there is a bug was introduced somewhere. Not worth continuing down this line. (Closed-Leaf check-in: 12d2cf88 user: drh tags: dead-end) | |
| 20:33 | Move some things in parse.y so that TK_COLUMN and TK_AGG_COLUMN are assigned the same values as they are on trunk for a very small speedup. (check-in: d26fdfa3 user: dan tags: nulls-last) | |
| 17:09 | Revise the VDBE comments for NULL-scan so that they also work make sense when reading a NULLS FIRST plan. (check-in: bfe79378 user: drh tags: nulls-last) | |
| 17:00 | Additional simplifications of the WHERE loop code generator logic for NULLS LAST. (check-in: 1383680d user: drh tags: nulls-last) | |
| 16:12 | Simplification of the WHERE loop code generator for NULLS LAST saves a few CPU cycles and about a hundred bytes of code space. (check-in: e3ed2f49 user: drh tags: nulls-last) | |
| 13:32 | Invert the meaning of the regBignull flag so that it is 1 when doing the normal scan and 1 when scanning nulls. This enables the re-do jump at the bottom of the loop to be coded with a single OP_IfNotZero opcode, rather than a sequence of OP_If, OP_Integer, OP_Goto. (check-in: bf875e1a user: drh tags: nulls-last) | |
| 13:08 | Extra VDBE comments in the NULLS LAST logic provide landmarks to help understand the EXPLAIN output. (check-in: 649b08ea user: drh tags: nulls-last) | |
|
2019-08-22
| ||
| 21:16 | • Edit [d3531f5be7d37696|d3531f5b]: Edit check-in comment. (artifact: e809bbe8 user: drh) | |
| 21:13 | Add additional VDBE coverage macros. (check-in: d3531f5b user: drh tags: nulls-last) | |
| 19:35 | Merge fixes from trunk. Also fix a reference to the KeyInfo.aSortOrder field, which should now be KeyInfo.aSortFlags (check-in: 63e625c8 user: drh tags: nulls-last) | |
| 16:39 | • Fixed ticket [7e07a3db]: LIKELY() seems to cause unexpected affinity conversion for rowid plus 6 other changes (artifact: 8584b3e4 user: drh) | |
| 16:38 | Fix the likely(), unlikely(), and likelihood() functions so that they have no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] (check-in: 44578865 user: drh tags: trunk) | |
| 14:34 | • New ticket [7e07a3db] LIKELY() seems to cause unexpected affinity conversion for rowid. (artifact: ea40e09c user: mrigger) | |
| 11:14 | • Fixed ticket [ac184eb5]: Row with comparison on TEXT UNIQUE column is not fetched plus 7 other changes (artifact: 924b1a42 user: drh) | |
| 11:11 | Fix a false-positive in sqlite3ExprNeedsNoAffinityChange(). Ticket [ac184eb571d5e6e0] (check-in: e62eddbb user: drh tags: trunk) | |
| 09:44 | • New ticket [ac184eb5] Row with comparison on TEXT UNIQUE column is not fetched. (artifact: d99f1ffe user: mrigger) | |
| 00:55 | • Fixed ticket [d9f584e9]: Row is not fetched in table with INTEGER PRIMARY KEY plus 7 other changes (artifact: 815dccdd user: drh) | |
| 00:53 | Fix the OP_SeekGE, OP_SeekGT, OP_SeekLE, and OP_SeekLT opcodes so that they preserve the datatype of the value in the register used as the key. Ticket [d9f584e936c7a8d0] (check-in: 81b9f0f5 user: drh tags: trunk) | |
|
2019-08-21
| ||
| 21:34 | • New ticket [d9f584e9] Row is not fetched in table with INTEGER PRIMARY KEY. (artifact: d7eaf033 user: mrigger) | |
| 19:58 | Add missing VdbeCoverage() macros to new code. (check-in: b1cbcdc6 user: dan tags: nulls-last) | |
| 17:46 | Disable broken test case in expert1.test. (check-in: 73e30c2e user: dan tags: nulls-last) | |
| 15:41 | Update this branch with latest trunk changes. (check-in: 6153bcf4 user: dan tags: nulls-last) | |
| 14:55 | • Closed ticket [b8689402]: DISTINCT malfunctions for IS NULL plus 6 other changes (artifact: e33394d3 user: dan) | |
| 14:54 | Avoid assuming that "column IS ?", where column is declared UNIQUE, matches only a single row (as "?" might be NULL). Fix for [b8689402]. (check-in: d02490a2 user: dan tags: trunk) | |
| 11:50 | • New ticket [b8689402] DISTINCT malfunctions for IS NULL. (artifact: c70c47e7 user: mrigger) | |
| 11:31 | Fix a broken assert() in the fts3 snippet code that was failing for queries containging more than 64 phrases. (check-in: 4c01e017 user: dan tags: trunk) | |
|
2019-08-20
| ||
| 20:09 | Further tests for the special null-handling on this branch. (check-in: 0dbbb51f user: dan tags: nulls-last) | |
| 19:11 | Fix a problem with fts5 "ORDER BY rank" queries when the fts5 table name requires quoting. (check-in: 00e9a8f2 user: dan tags: trunk) | |
| 17:51 | Add tests for sort-by-index cases that use IN() and non-default NULL handling. (check-in: 09d660ec user: dan tags: nulls-last) | |