SQLite

All files named ”test/selectB.test”
Login

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

History for test/selectB.test

2011-12-10
23:18
[954e4e49cf] part of check-in [5061d85ff9] Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery. (check-in: [5061d85ff9] user: drh branch: trunk, size: 10821)
2011-06-30
20:17
[0d072c5846] part of check-in [f7ba0219ef] Experimental changes to improve optimization of DISTINCT queries. (check-in: [f7ba0219ef] user: dan branch: experimental, size: 9618)
2009-04-02
16:59
[f305cc6660] part of check-in [23f90d5073] Disable the query flattening optimization when the subquery is a compound query with an ORDER BY clause. Ticket #3773 shows why that combination does not work. (CVS 6437) (check-in: [23f90d5073] user: drh branch: trunk, size: 9618)
2008-08-04
03:51
[31e81ac9af] 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: 9490)
2008-07-12
14:52
[59c1caf267] part of check-in [dcb160249f] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (check-in: [dcb160249f] user: drh branch: trunk, size: 9434)
2008-07-10
17:59
[4bc893e4cb] part of check-in [9c8b97ef59] Fix a crash in flattenSubquery(). (CVS 5388) (check-in: [9c8b97ef59] user: danielk1977 branch: trunk, size: 9443)
2008-07-08
17:43
[09ae87083e] part of check-in [6c2adade34] Prevent the flattening optimization from transforming a to a query with an illegal ORDER BY clause. (CVS 5372) (check-in: [6c2adade34] user: danielk1977 branch: trunk, size: 9305)
2008-07-01
18:26
[811a852ad6] part of check-in [8f9d1abb31] Fix errors in in.test. Also add a few tests to selectB.test. (CVS 5337) (check-in: [8f9d1abb31] user: danielk1977 branch: trunk, size: 9125)
17:39
[afc43b5bbc] part of check-in [56109b9a1f] Fix another memory leak related to UNION ALL and sub-selects. (CVS 5336) (check-in: [56109b9a1f] user: danielk1977 branch: trunk, size: 7367)
16:05
[effd81c295] part of check-in [6ee71f4ddb] Fix a memory leak to do with the recent UNION ALL sub-select optimization. (CVS 5333) (check-in: [6ee71f4ddb] user: danielk1977 branch: trunk, size: 4961)
14:39
[37d21b6f18] part of check-in [a79786a961] Fix a problem with LIMIT and OFFSET clauses on the parent query when optimizing a UNION ALL sub-select. (CVS 5332) (check-in: [a79786a961] user: danielk1977 branch: trunk, size: 2763)
14:09
Added: [ade563cde5] part of check-in [3ef468e704] Optimize sub-selects and views that use UNION ALL. This optimization isn't very well tested yet. (CVS 5331) (check-in: [3ef468e704] user: danielk1977 branch: trunk, size: 2364)