/ All files named "test/with3.test"
Login

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

History for test/with3.test

2020-10-19
01:23
[a261f0ea] part of check-in [5481fa8c] Allow multiple recursive terms in the compound SELECT of a recursive CTE. This facilitates writing a query to find find the connected components of an undirected graph. (check-in: [5481fa8c] user: drh branch: cte-enhancement, size: 5104)
2020-01-18
13:53
[13b33367] part of check-in [a1be6ee0] Fix the VDBE so that it correctly handles the sequence of operations OP_OpenEphemeral, OP_OpenDup, OP_OpenEphemeral, and OP_OpenDup in that order on the same cursor. (check-in: [a1be6ee0] user: drh branch: trunk, size: 5105)
2019-11-09
14:38
[7de8dff2] part of check-in [de6e6d68] Make sure the WITH stack in the Parse object is disabled following an error. (check-in: [de6e6d68] user: drh branch: trunk, size: 4566)
2019-05-03
18:50
[b5f13720] part of check-in [a9b90aa1] Fix a memory-leak/segfault caused by using OP_OpenDup and OP_OpenEphemeral on the same VM cursor. (check-in: [a9b90aa1] user: dan branch: trunk, size: 4353)
2019-02-19
18:00
[e6b1730a] part of check-in [8ac75b8a] Improve error messages caused by corrupt database schemas in OPEN_SHARED_SCHEMA mode. (check-in: [8ac75b8a] user: dan branch: reuse-schema, size: 3280)
2018-12-24
20:21
[8d26920c] part of check-in [7153552b] 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. (check-in: [7153552b] user: drh branch: reuse-subqueries, size: 3279)
2018-10-05
20:09
[7bc36fd9] part of check-in [5c243eec] 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] (check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 3272)
2018-05-03
01:37
[5e8ce2c5] part of check-in [c75eee69] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69] user: drh branch: rework-EQP, size: 3272)
2018-05-02
18:00
[2829c3de] part of check-in [5f0e803e] 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. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 3181)
2016-12-16
15:05
[e71604a0] part of check-in [053a149c] Fix a problem causing the planner to generate sub-optimal plans for some queries that use recursive WITH sub-queries with LIMIT clauses. (check-in: [053a149c] user: dan branch: trunk, size: 3074)
2015-11-07
17:48
Added: [511bacdb] part of check-in [028475cb] Proposed fix for an infinite loop bug in the WITH clause semantic analysis logic. (check-in: [028475cb] user: drh branch: infinite-with-loop-bug, size: 1417)
2014-01-21
00:19
Added: [e302761b] part of check-in [cc1cb321] 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. (check-in: [cc1cb321] user: drh branch: level-pseudocolumn, size: 2932)