Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
126 events for the month beginning 2019-08-01 by user drh
Following month ↑|
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) | |
| 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) | |
| 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) | |
| 16:46 | New test cases for window functions with RANGE BETWEEN and DESC NULLS FIRST. (check-in: f7002f86 user: drh 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: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) | |
| 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) | |
|
2019-08-29
| ||
| 23:24 | Remove a faulty testcase() macro. (check-in: 80124ae5 user: drh 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) | |
| 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
| ||
| 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
| ||
| 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) | |
| 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) | |
|
2019-08-26
| ||
| 20:41 | Merge in recent fixes from trunk. (Closed-Leaf check-in: ad816d01 user: drh tags: nulls-last) | |
| 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-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) | |
| 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) | |
| 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) | |
| 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-20
| ||
| 17:14 | Bring the hard-heap-limit branch up-to-date with trunk. (check-in: 9b14eb77 user: drh tags: hard-heap-limit) | |
| 13:49 | Add the new sqlite3_drop_modules() interface to the loadable extension mechanism. (check-in: 658bd516 user: drh tags: trunk) | |
|
2019-08-19
| ||
| 20:44 | Add the sqlite3_drop_modules() interface. (check-in: e2c6fed8 user: drh tags: trunk) | |
| 20:35 | Omit the "_except" term from the name of the new interface. (Closed-Leaf check-in: e5ba47c2 user: drh tags: sqlite3_drop_modules_except) | |
|
2019-08-17
| ||
| 19:55 | Fix to the query planner for the LSM1 extension. (check-in: 7496e872 user: drh tags: trunk) | |
| 19:45 | The experimental sqlite3_drop_modules_except() interface. (check-in: 0851db4d user: drh tags: sqlite3_drop_modules_except) | |
| 19:31 | Fix the new ability to unregister virtual table modules so that it works for the automatic PRAGMA virtual tables. (check-in: 5d6f4dfe user: drh tags: trunk) | |
| 17:11 | • Fixed ticket [6710d2f7]: LEFT JOIN fails to fetch row plus 7 other changes (artifact: 12e735c0 user: drh) | |
| 17:07 | Ensure the functions that appear to be constant are not factored out of expression that originate on the right-hand side of a LEFT JOIN. Ticket [6710d2f7a13a2997] (check-in: 500c9152 user: drh tags: trunk) | |
| 15:27 | Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. (check-in: 9c4bca64 user: drh tags: trunk) | |
| 00:53 | The SQLITE_DIRECTONLY flag, when added to sqlite3_create_function() prevents the function from being used inside a trigger or view. (check-in: de767376 user: drh tags: trunk) | |
|
2019-08-16
| ||
| 22:58 | Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. (check-in: 31e34fa3 user: drh tags: trunk) | |
|
2019-08-15
| ||
| 23:11 | Fix harmless compiler warnings in the TCL interface. (check-in: f17e7229 user: drh tags: trunk) | |
| 21:27 | Add the SQLITE_DBCONFIG_ENABLE_VIEW option, together with a "db config" command in the TCL interface that can access that option as well as all the other sqlite3_db_config() boolean options. (check-in: 61b4bccd user: drh tags: trunk) | |
| 20:04 | Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. (Closed-Leaf check-in: fc745845 user: drh tags: directonly) | |
| 14:36 | • Fixed ticket [256741a1]: null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) plus 3 other changes (artifact: cf72f220 user: drh) | |
| 14:35 | • Fixed ticket [e4598ecb]: Division by zero in the query planner. plus 5 other changes (artifact: b83367a9 user: drh) | |
| 14:35 | Ensure that the optional "sz=N" parameter that can be manually added to the end of an sqlite_stat1 entry does not have an N value that is too small. Ticket [e4598ecbdd18bd82] (check-in: 98357d8c user: drh tags: trunk) | |
| 14:28 | • New ticket [e4598ecb] Division by zero in the query planner.. (artifact: d93508fc user: drh) | |
| 13:46 | Avoid downgrading SQLITE_CORRUPT errors detected by the schema parser into SQLITE_NOMEM or SQLITE_ERROR errors. (check-in: b2e79f8f user: drh tags: trunk) | |
| 13:17 | Ensure that the cell overwrite optimization does not overwrite the header of the b-tree page. (check-in: 4cc5694c user: drh tags: trunk) | |
| 00:04 | Early detection out-of-bounds page numbers on the direct-overflow-read optimization gives consistent error messages regardless of whether or not the optimization is enabled. (check-in: b517a52f user: drh tags: trunk) | |
|
2019-08-14
| ||
| 15:17 | Always check for reads past the end of the file on the in-memory journal driver. This used to be an assert(). (check-in: 4d41ca7d user: drh tags: trunk) | |
|
2019-08-12
| ||
| 18:26 | • Fixed ticket [3cf9bb22]: Database corruption caused by REPLACE plus 5 other changes (artifact: 927499fa user: drh) | |
| 18:26 | Make sure the btree cursor overflow cache is cleared when overwriting a cell in sqlite3BtreeInsert(). Ticket [3cf9bb227e9a5d32] (check-in: 7dae7b96 user: drh tags: trunk) | |
| 18:25 | • New ticket [3cf9bb22] Database corruption caused by REPLACE. (artifact: 4c0dd574 user: drh) | |
| 16:25 | For the ".testctrl prng_seed" command in the CLI, if the argument is "random" then select a random integer seed and print the seed value on stdout. (check-in: 636ca447 user: drh tags: trunk) | |
| 15:37 | Fix the build for compilation using separate files rather than the amalgamation. (Leaf check-in: 1e0f4869 user: drh tags: sha3) | |
| 15:19 | Make the sha3 extension part of the amalgamation, enabled using SQLITE_ENABLE_SHA3. (check-in: a48a7b78 user: drh tags: sha3) | |
| 14:17 | Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. (check-in: 48d9b48a user: drh tags: trunk) | |
| 00:08 | Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: 724f4df9 user: drh tags: trunk) | |
|
2019-08-10
| ||
| 15:07 | • Edit [da01ba4fa47c6508|da01ba4f]: Edit check-in comment. (artifact: d9c628b3 user: drh) | |
| 15:06 | • Fixed ticket [9080b622]: Constant expression in partial index results in row not being fetched plus 6 other changes (artifact: 53eb33a8 user: drh) | |
| 15:06 | Fix the sqliteExprImpliesExpr() routine so that it recognizes that "(NULL IS FALSE) IS FALSE" doe not imply "NULL NOT NULL". Ticket [9080b6227fabb466] (check-in: da01ba4f user: drh tags: trunk) | |
| 14:16 | Remove two incorrect assert() statements from the logic used to derive column names and types from subqueries. (check-in: 712e4771 user: drh tags: trunk) | |
|
2019-08-09
| ||
| 20:26 | Allow the RHS of a row-value IN operator to use a compound query with an ORDER BY clause. (check-in: eaf15d9b user: drh tags: trunk) | |
| 01:11 | Fix more compiler warnings. (check-in: 1b85442b user: drh tags: trunk) | |
|
2019-08-08
| ||
| 19:40 | Fix harmless compiler warnings. (check-in: 1eef4dde user: drh tags: trunk) | |
| 19:19 | Remove support for SQLITE_ENABLE_STAT3. The sqlite_stat3 table is now ignored, if it exists. Run ANALYZE using STAT4 to get the equivalent functionality, which presumably everybody has been doing for a long time now. (check-in: f1cd234c user: drh tags: trunk) | |
| 18:49 | Fix a case of the Expr.affinity to Expr.affExpr refactor that was missed in the [a29f2a7d07beff64] check-in. (check-in: 83450d10 user: drh tags: trunk) | |
| 16:23 | More legacy STAT3 code removed. (Closed-Leaf check-in: 845d2f17 user: drh tags: omit-stat3) | |
| 15:24 | Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: 1e17ea2f user: drh tags: omit-stat3) | |
| 01:39 | Remove a NEVER() that is reachable from a corrupt database. (check-in: 30e6ee27 user: drh tags: trunk) | |
|
2019-08-07
| ||
| 21:30 | • Ticket [f8a7060e] Incorrect result for query that uses MIN() and a CAST on rowid status still Open with 7 other changes (artifact: 3bee902b user: drh) | |
| 13:25 | Do not make SQLITE_READ authorizer calls for tables without names, as all such tables will be internal-use-only tables for subqueries and whatnot. (check-in: 193c87fc user: drh tags: trunk) | |
|
2019-08-06
| ||
| 23:28 | • Fixed ticket [0a5e2c1d]: Unexpected affinity conversion for view column in IN operator plus 6 other changes (artifact: d65bc0de user: drh) | |
| 20:55 | Improved reuse of file descriptors for which close() is delayed to prevent clearing of posix advisory locks. (check-in: 509c1ba2 user: drh tags: trunk) | |
| 20:26 | Enhance the ".recover" output in the shell to use double-quotes around table and column identifiers. (check-in: 846d2d2d user: drh tags: trunk) | |
| 17:05 | • Fixed ticket [9f66f887]: EXPLAIN PRAGMA executes PRAGMA plus 8 other changes (artifact: f8525f61 user: drh) | |
| 15:33 | • Fixed ticket [61c85385]: Row is not fetched in SELECT from VIEW plus 6 other changes (artifact: 505de8a7 user: drh) | |
| 15:32 | Ensure that columns of views and sub-queries that are expressions with no affinity are comparied without any type conversions, as required in the documentation. Tickets [61c853857f40da49] and [d52a29a9e6bc55c5]. (check-in: 9c8c1092 user: drh tags: trunk) | |
| 15:18 | Performance optimization to the new affinity handling logic. (Closed-Leaf check-in: c9724e76 user: drh tags: pending) | |
| 14:37 | Use 0x40 (ASCII '@') instead of 0x00 to mean "no affinity" so that columns with no affinity can appear in a zero-terminated string. Use the new SQLITE_AFF_NONE macro for this new magic number. (check-in: e8234f69 user: drh tags: pending) | |
|
2019-08-05
| ||
| 23:31 | • Edit [e15a0977ddfad3d0|e15a0977]: Move to branch pending. Edit check-in comment. (artifact: 37715ac2 user: drh) | |
| 21:04 | • Edit [470ac8d50ce2f7cc|470ac8d5]: Mark "Closed". (artifact: 8029b648 user: drh) | |
| 20:41 | • Ticket [d52a29a9] Unexpected affinity conversion in view status still Fixed with 4 other changes (artifact: 7c070101 user: drh) | |
| 19:34 | The second option for [61c853857f40da49]: In this mode, columns of VIEWs and subqueries that are formed by expressions have affinity BLOB rather than affinity none, as has usually been the case for a while. But this mode fixes a couple of corner cases involving query flattening and the push-down optimization where that rule was violated. (Closed-Leaf check-in: 470ac8d5 user: drh tags: tkt-61c853-B) | |
| 19:32 | One of two options on how to address ticket [61c853857f40da49]. In this mode, we back out the documentation change of [07b7749da88d54e5] and change the core to work as it has been documented to work since 2017, rather than how it has actually worked since 2009. (check-in: 09cd0c0c user: drh tags: tkt-61c853-A) | |
| 18:01 | Refactor field Expr.affinity into Expr.affExpr to avoid confusion with other fields and variables named "affinity" and display affExpr it in sqlite3TreeViewExpr() output. (check-in: a29f2a7d user: drh tags: trunk) | |
| 16:22 | Improved detection of corruption on the freeblock list of a btree page. (check-in: 4b00799b user: drh tags: trunk) | |
| 13:06 | • Fixed ticket [d52a29a9]: Unexpected affinity conversion in view plus 8 other changes (artifact: ac513e2e user: drh) | |
|
2019-08-04
| ||
| 09:26 | • Edit [1bd4b97d6405c9b0|1bd4b97d]: Edit check-in comment. (artifact: aba6b05a user: drh) | |
|
2019-08-03
| ||
| 19:06 | Strengthen an assert() in the WHERE clause code generator for the min/max optimization. (check-in: 1bd4b97d user: drh tags: trunk) | |
| 16:17 | In the ".wheretrace 0x100" debugging mode, show the structure of the main parameters to sqlite3WhereBegin() calls. (check-in: fd598e47 user: drh tags: trunk) | |
| 14:30 | • Ticket [71e183ca] MIN() malfunctions for a query with ISNULL condition status still Open with 4 other changes (artifact: afd8a0b2 user: drh) | |
| 01:40 | Add the SQLITE_TESTCTRL_PRNG_SEED which can control the PRNG seed either directly or through the schema cookie of a supplied database connection. (check-in: 2660e929 user: drh tags: trunk) | |
| 01:39 | Give the SQLITE_TESTCTRL_PRNG_SEED two arguments. The second argument if not NULL is a pointer to a database connection which seeds the connection from its schema cookie. In this way, fuzzers can control the PRNG seed. (Closed-Leaf check-in: 49aa3448 user: drh tags: prng-seed-test-control) | |
|
2019-08-02
| ||
| 21:03 | Fixes to the PRNG_SEED pragma idea. (check-in: c7109840 user: drh tags: prng-seed-test-control) | |
| 20:45 | Add the SQLITE_TESTCTRL_PRNG_SEED test control. (check-in: 3ac57231 user: drh tags: prng-seed-test-control) | |
|
2019-08-01
| ||
| 22:48 | The sqlite3_set_authorizer() interface should only expire prepared statements when it is setting a new authorizer, not when clearing the authorizer. And statements that are running when sqlite3_set_authorizer() is invoked should be allowed to continue running to completion. (check-in: 961e2f08 user: drh tags: trunk) | |