/ File History
Login

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

History of test/with3.test

2019-11-09
14:38
Make sure the WITH stack in the Parse object is disabled following an error. file: [7de8dff2] check-in: [de6e6d68] user: drh branch: trunk, size: 4566
2019-05-03
18:50
Fix a memory-leak/segfault caused by using OP_OpenDup and OP_OpenEphemeral on the same VM cursor. file: [b5f13720] check-in: [a9b90aa1] user: dan branch: trunk, size: 4353
2019-02-19
18:00
Improve error messages caused by corrupt database schemas in OPEN_SHARED_SCHEMA mode. file: [e6b1730a] check-in: [8ac75b8a] user: dan branch: reuse-schema, size: 3280
2018-12-24
20:21
Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. file: [8d26920c] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 3279
2018-10-05
20:09
When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] file: [7bc36fd9] check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 3272
2018-05-03
01:37
Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. file: [5e8ce2c5] check-in: [c75eee69] user: drh branch: rework-EQP, size: 3272
2018-05-02
18:00
Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. file: [2829c3de] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 3181
2016-12-16
15:05
Fix a problem causing the planner to generate sub-optimal plans for some queries that use recursive WITH sub-queries with LIMIT clauses. file: [e71604a0] check-in: [053a149c] user: dan branch: trunk, size: 3074
2015-11-07
17:48
Proposed fix for an infinite loop bug in the WITH clause semantic analysis logic. file: [511bacdb] check-in: [028475cb] user: drh branch: infinite-with-loop-bug, size: 1417 Added
2014-01-21
00:19
Add support for the LEVEL pseudo-column in the recursive part of a common table expression. LEVEL has the value of 1 on the first iteration and successively larger integer values of subsequent iterations. It cannot have a table qualifier. Actual columns named "level" can still be accessed by including the table name qualifier. file: [e302761b] check-in: [cc1cb321] user: drh branch: level-pseudocolumn, size: 2932 Added