SQLite

All files named ”test/selectA.test”
Login

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

History for test/selectA.test

2024-03-20
16:27
[1da8ce3884] part of check-in [cd547c5004] Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY". (check-in: [cd547c5004] user: dan branch: eqp-orderby, size: 46043)
2022-10-26
21:14
[6aef8b2136] part of check-in [346a3b12b8] Disable the push-down optimization for sub-queries that are INTERSECT, UNION or EXCEPT compounds. dbsqlfuzz a34f455c91ad75a0cf8cd9476841903f42930a7a. This corrects an issue that was introduce 12 days earlier by [ed14863dd72e35fa]. (check-in: [346a3b12b8] user: dan branch: trunk, size: 46045)
2021-04-12
12:02
[985df11dfc] part of check-in [a4e3f13329] Avoid an assert() failure when a compound scalar sub-select is, due to a "WHERE (sub-select) AND (... OR ...)" clause, coded twice by the code generator. (check-in: [a4e3f13329] user: dan branch: trunk, size: 45538)
2021-03-20
15:11
[5a9ef0f36c] 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: 45173)
2020-06-15
13:51
[68de52409e] part of check-in [10fa79d00f] Fix a defect in the query-flattener optimization identified by ticket [8f157e8010b22af0]. (check-in: [10fa79d00f] user: drh branch: trunk, size: 45185)
2018-05-02
18:00
[b8a590f649] 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: 44343)
2016-06-25
11:43
[101e722370] part of check-in [507014e4c7] Fix the handling of OP_Eq opcodes that compare a register against itself and that require an affinity change. (check-in: [507014e4c7] user: drh branch: trunk, size: 44328)
2015-04-04
16:43
[e452bdb975] part of check-in [427b50fba7] Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. (check-in: [427b50fba7] user: dan branch: compound-order-by-fix, size: 44078)
2014-05-01
20:26
[64b88a8027] part of check-in [427409ae10] Fix an obscure problem to do with temp register allocation that could occur if more than one simple SELECT within a compound SELECT uses a partial sort. (check-in: [427409ae10] user: dan branch: trunk, size: 42291)
2014-02-10
21:07
[77adaffe97] part of check-in [9367632dd7] Fix a pointless conditional. Add a test case. (check-in: [9367632dd7] user: drh branch: trunk, size: 40865)
2013-05-07
17:49
[99cf21df03] part of check-in [fc3630cdef] Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Candidate fix for ticket [6709574d2a8d8]. (check-in: [fc3630cdef] user: drh branch: tkt-6709574, size: 40347)
2008-08-21
14:24
[06d1032fa9] part of check-in [b46267ff07] Add test cases to verify that ticket #3314 has been fixed. (CVS 5579) (check-in: [b46267ff07] user: drh branch: trunk, size: 40347)
2008-08-04
03:51
[9335851a42] part of check-in [9ca975c8fd] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (check-in: [9ca975c8fd] user: danielk1977 branch: trunk, size: 39659)
2008-07-15
00:27
[09c6b889f2] part of check-in [7cf91e08c0] Increased test coverage. (CVS 5414) (check-in: [7cf91e08c0] user: drh branch: trunk, size: 39603)
2008-06-25
14:31
[e4501789a1] part of check-in [edf7f51836] Test enhancements, especially to the new compound-SELECT merge logic. (CVS 5305) (check-in: [edf7f51836] user: drh branch: trunk, size: 38288)
02:47
[45263e0936] part of check-in [e53403b6d7] If a unique index covers any prefix of the ORDER BY clause then let it satisfy the ORDER BY clause. (CVS 5301) (check-in: [e53403b6d7] user: drh branch: trunk, size: 25880)
02:22
Added: [8d7e8787fd] part of check-in [a193b1612e] Add new test script for compound select statements. (CVS 5300) (check-in: [a193b1612e] user: drh branch: trunk, size: 25880)