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) | |