SQLite

All files named ”test/with3.test”
Login

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

History for test/with3.test

2025-06-13
11:08
[4fca9df31c] part of check-in [40a83da503] Further improvements to the EQP text for flex-search. (check-in: [40a83da503] user: drh branch: flex-search, size: 6316)
00:50
[e0e9d2a866] part of check-in [680e278c3e] Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: [680e278c3e] user: drh branch: flex-search, size: 6312)
2025-06-12
19:02
[a39c0003d6] part of check-in [521948c64f] Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: [521948c64f] user: drh branch: flex-search, size: 6309)
2023-09-15
14:06
[e30369ea27] part of check-in [d9625a9eaf] The view-scan optimization was added to enhance the performance of one specific query, but it causes performance regressions on a host of others. Disable it (at least temporarily) in order to try to find an alternative way of fixing the one specific query that it was created to fix - an alternative way that does not cause performance problems for other unrelated queries. (check-in: [d9625a9eaf] user: drh branch: rethink-viewscan, size: 6304)
2023-02-28
13:46
[fe15975c0b] part of check-in [d7b2ac1c1a] When an automatic index creates a Bloom filter, show that in the EXPLAIN QUERY PLAN output. (check-in: [d7b2ac1c1a] user: drh branch: trunk, size: 6304)
2022-12-08
16:47
[e7bf809bf7] part of check-in [9243e850ae] Improved comments on the new co-routine logic. Fix a C++-ism in the code. Update test cases to accommodate the more aggressive use of co-routines. (check-in: [9243e850ae] user: drh branch: coroutines-exp2, size: 6271)
2022-09-01
10:41
[e76a354523] part of check-in [e3754cc188] In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: [e3754cc188] user: drh branch: branch-3.28, size: 3279)
10:29
[1e2e8d5e7b] part of check-in [609fbb94b8] In the query planner, add a heuristic that will reduce the estimated cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: [609fbb94b8] user: drh branch: trunk, size: 6274)
2021-03-20
15:46
[ad32d13ad5] part of check-in [1b83e232c4] Use the canonical name, not the AS name, when showing the MATERIALIZE or CO-ROUTINE lines for a CTE. (check-in: [1b83e232c4] user: drh branch: eqp-improvements, size: 6274)
15:11
[e223b72a34] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 6275)
2021-03-18
18:25
[2f1e05aef7] part of check-in [9981223618] Fix a problem causing spurious "<cte>: circular reference" errors to be reported when there is actually a different error in the SQL statement. (check-in: [9981223618] user: dan branch: trunk, size: 6464)
2021-02-13
16:39
[85e059bf4c] part of check-in [9692f51080] Avoid manifesting a CTE (or other view) multiple times when it is possible to reuse the first manifestation. (check-in: [9692f51080] user: drh branch: trunk, size: 5913)
2020-10-19
01:23
[a261f0ea22] part of check-in [5481fa8c79] 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: [5481fa8c79] user: drh branch: cte-enhancement, size: 5104)
2020-01-18
13:53
[13b3336739] part of check-in [a1be6ee018] 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: [a1be6ee018] user: drh branch: trunk, size: 5105)
2019-11-09
14:38
[7de8dff289] part of check-in [de6e6d6846] Make sure the WITH stack in the Parse object is disabled following an error. (check-in: [de6e6d6846] user: drh branch: trunk, size: 4566)
2019-05-03
18:50
[b5f1372097] part of check-in [a9b90aa12e] Fix a memory-leak/segfault caused by using OP_OpenDup and OP_OpenEphemeral on the same VM cursor. (check-in: [a9b90aa12e] user: dan branch: trunk, size: 4353)
2019-02-19
18:00
[e6b1730a4a] part of check-in [8ac75b8a88] Improve error messages caused by corrupt database schemas in OPEN_SHARED_SCHEMA mode. (check-in: [8ac75b8a88] user: dan branch: reuse-schema, size: 3280)
2018-12-24
20:21
[8d26920c88] part of check-in [7153552bac] 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: [7153552bac] user: drh branch: reuse-subqueries, size: 3279)
2018-10-05
20:09
[7bc36fd978] part of check-in [5c243eec7b] 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: [5c243eec7b] user: drh branch: unique-constraint-weights, size: 3272)
2018-05-03
01:37
[5e8ce2c585] part of check-in [c75eee69fa] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69fa] user: drh branch: rework-EQP, size: 3272)
2018-05-02
18:00
[2829c3de40] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 3181)
2016-12-16
15:05
[e71604a0e5] part of check-in [053a149cc8] 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: [053a149cc8] user: dan branch: trunk, size: 3074)
2015-11-07
17:48
Added: [511bacdbe4] part of check-in [028475cb17] Proposed fix for an infinite loop bug in the WITH clause semantic analysis logic. (check-in: [028475cb17] user: drh branch: infinite-with-loop-bug, size: 1417)
2014-01-21
00:19
Added: [e302761b7b] part of check-in [cc1cb32178] 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: [cc1cb32178] user: drh branch: level-pseudocolumn, size: 2932)