/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

2019-12-12
00:20
Fix goofy string formatting in lemon.c that dates from the K&R-C days. Leaf check-in: 48ba5e5a22 user: drh tags: trunk
2019-12-11
18:53
Improved tracing output from the LEMON-generated parser. check-in: 4d6d2fc046 user: drh tags: trunk
16:22
Strengthen check-in [83da4d4104ee1870] by ignoring *all* WHERE-clause constraints for a virtual table that is the right table of a LEFT JOIN, as such constraints are never useful. This fixes an issue discovered by Manuel Rigger. check-in: 840de36df1 user: drh tags: trunk
15:07
When trying to drop a virtual table that has no xDestroy method, invoke the xDisconnect method rather than doing nothing, to avoid a memory leak. check-in: 1fa29a5f2a user: drh tags: trunk
14:25
The xDestroy method of a module might be NULL if the schema is corrupt. check-in: 0457e7d196 user: drh tags: trunk
2019-12-10
20:41
Enhance LEMON to provide the ability to mark a rules as one that will never reduce due to intervention of actions. Use this new capability to designate the EXPLAIN rule as NEVER-REDUCES. check-in: 136cdefb2f user: drh tags: trunk
18:10
Use a statement journal on a CREATE VIRTUAL TABLE statement in case the VCreate opcode fails. check-in: aa3b0eb8c3 user: drh tags: trunk
15:05
Fix parser bugs: require a semicolon after an EXPLAIN command. check-in: 707a058a22 user: drh tags: trunk
03:40
Avoid a buffer overread in fts5 that could occur when parsing corrupt configuration records. check-in: 355afd77df user: dan tags: trunk
02:48
Set the affinity of regular columns prior to computing the values of generated columns. Ticket [d7c3f125c925c522] check-in: d47d66e3d3 user: drh tags: trunk
2019-12-09
19:44
Rename a local variable to avoid masking a function parameter and thus causing a harmless compiler warning. check-in: f065cf003b user: drh tags: trunk
19:29
Add a NEVER() to the ALTER TABLE fix in check-in [1d2e53a39b87e364] check-in: c7309ed3c7 user: drh tags: trunk
18:22
The previous check-in was not quite correct, and introduced a new problem with the USING clause. Use this version instead. check-in: ed28aaa485 user: drh tags: trunk
17:14
Ensure that the SrcList_item.colUsed field is set correctly (set to have a 1 for all columns of the table) when a generated column appears in the USING clause of a join. check-in: 1923efb283 user: drh tags: trunk
15:52
Fix the NOT NULL verification logic in PRAGMA integrity_check so that it works for generated columns whose value is the result of a comparison operator. Ticket [bd8c280671ba44a7] check-in: f3b39c71b8 user: drh tags: trunk
14:34
Fix a gramfuzz find. If a partial index that does not reference any column of its table is used by an UPDATE statement in one-pass mode, then avoid the use of OP_DeferredSeek since the seek might not be resolved prior to the OP_Delete and OP_Insert that implement the UPDATE. check-in: e3398c5ffb user: drh tags: trunk
08:13
Avoid infinite recursion in the ALTER TABLE code when a view contains an unused CTE that references, directly or indirectly, the view itself. check-in: 1d2e53a39b user: dan tags: trunk
02:20
Fix possible null pointer dereferences in the fts5_expr() scalar function. check-in: c5d4414359 user: dan tags: trunk
2019-12-08
00:06
Fix incorrect column-usage accounting associated with generated columns and added by check-in [6601da58032d18ae]. Fix for ticket [b92e5e8ec2cdbaa1]. check-in: 9d75e1ccc7 user: drh tags: trunk
2019-12-07
13:42
Correctly deal with multi-row VALUES clauses that contain window functions. check-in: 26d991f214 user: drh tags: trunk
12:13
Ignore type affinity for auxiliary columns in RTREE as it is too error-prone to try to parse out the type from other constraints. Ticket [8bf76328ac940d52] check-in: 7fa664ea0e user: drh tags: trunk
00:22
Fix a problem with foreign keys and generated columns discovered by Manuel Rigger. check-in: 27c0fdab1b user: drh tags: trunk
2019-12-06
19:07
Early detection and reporting of too few columns in an rtree CREATE VIRTUAL TABLE statement. check-in: ef73107f47 user: drh tags: trunk
13:10
In the rtree extension, actively suppress extra tokens on the column names, and be pedantic about column affinities. Ticket [367a86e28859f1ff] check-in: 97fb5a72f9 user: drh tags: trunk
11:48
The check-in [b7810062ec2489e1] was not quite right in that it allowed an oversized shift operation (which is UB in C) on some obscure inputs. OSSFuzz found the problem for us overnight. check-in: 62f2235adf user: drh tags: trunk
01:38
Further enhancements to RTREE, following up to check-in [f898d04cf272ef01] so that constraints are allowed to be compared to strings that look like numbers. Ticket [aa573a787b8f1fdf] check-in: 32772dfd50 user: drh tags: trunk
01:23
Do not allow UPSERT of a view. check-in: ebf897e861 user: drh tags: trunk
2019-12-05
21:46
Fix to the rowvalue logic that avoids disabling rowvalue inequality contraints on a virtual table when the virtual table sets the omit flag. The logic has been incorrect since row-values were added. However, this does not come up often as very few virtual tables implement inequality constraints using the omit flag. Ticket [f096d191b6641daa] check-in: b7810062ec user: drh tags: trunk
18:29
Documentation update: Clarify that the sqlite3_index_info.aConstraintUsage.omit flag is a hint only and that the code generator is not obligated to follow the hint. check-in: 7d3e3f6e7e user: drh tags: trunk
17:31
Additional debugging information printed with the ".wheretrace 0x100" option. No changes to normally delivered code. check-in: fc72ec52c9 user: drh tags: trunk
14:42
Make sure the rowid of an RTREE virtual table has integer affinity. Ticket [9fe487ba3c064b4e] check-in: 7ae8c0d52f user: drh tags: trunk
14:31
Fix a problem in ALTER TABLE that could occur if an index, view or trigger in the schema features an expression of the form ((SELECT ...) IN ()) where the SELECT statement uses a CTE. check-in: 7e5ad8e0ab user: dan tags: trunk
13:34
Be strict about type enforcement on rowid look-ups in the RTREE extension. Ticket [30e2c183b6b356e4] check-in: d43e0efb96 user: drh tags: trunk
00:44
Enhance the RTREE extension so that it give correct query results even if the query uses non-numeric constraints. Ticket [a55ab6d97d01ecbc] check-in: f898d04cf2 user: drh tags: trunk
2019-12-04
19:45
Window functions are never constant. check-in: 35f0b5a8c7 user: drh tags: trunk
15:08
Ensure that an ALWAYS() in the rename logic really is always true, even for faulty inputs. check-in: 54410f0e77 user: drh tags: trunk
14:26
Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE. check-in: 75b04a4b0d user: dan tags: trunk
03:46
Fix a buffer overread that could occur in fts3 with corrupt %_stat records. check-in: e01fdbf9f7 user: dan tags: trunk
03:31
Fix an incorrect NEVER() macro. check-in: 96b6a76da0 user: drh tags: trunk
01:42
Fix a double-free that could occur when a component of a compound SELECT with an ORDER BY clause uses named window definitions. check-in: 92893b7980 user: dan tags: trunk
2019-12-03
03:34
Avoid a crash that could occur when a database containing a table with a temp trigger that has the same name as a temp table is detached. check-in: c4cb9708d4 user: dan tags: trunk
03:31
Avoid a harmless zero offset of a null pointer in FTS3, so as to not provoke unnecessary warnings from run-time checkers. check-in: 85d95abec4 user: drh tags: trunk
02:51
Avoid computing a zero offset of a null pointer, which though this is technically harmless, is upsetting to pedantic run-time checkers. check-in: 3ce804e99b user: drh tags: trunk
2019-11-30
19:29
Do not allow a term in the WHERE clause of the query to qualify a partial index on the right table of a LEFT JOIN. Ticket [7f39060a24b47353] check-in: 4066a34da7 user: drh tags: trunk
2019-11-29
13:01
Add comments in the parse.sql file to help demonstrate how rules are encoded. check-in: 2c4f714892 user: drh tags: trunk
12:51
Fix the parse.sql output file so that it is readable into a database where foreign keys are enforced. check-in: 3a82c554c3 user: drh tags: trunk
2019-11-27
20:40
More details on the comment justifying the aleged data race in the WAL-mode checkpoint logic. check-in: 0fab65c79f user: drh tags: trunk
2019-11-26
14:24
Fix various documentation typos suggested by Mark Benningfield. No changes to code. check-in: 08f09dc4f9 user: drh tags: trunk
11:10
Fix to check-in [5d9a369301a65f32] so that it compiles without SQLITE_DEBUG. check-in: fefe2d0467 user: drh tags: trunk
02:22
Add the new -S option to the lemon parser generator to cause it to output SQL that describes the input grammar. check-in: 4dbd398d64 user: drh tags: trunk