/ 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
[954e4e49] part of check-in [5061d85f] Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery. (check-in: [5061d85f] user: drh branch: trunk, size: 10821)
2011-06-30
20:17
[0d072c58] part of check-in [f7ba0219] Experimental changes to improve optimization of DISTINCT queries. (check-in: [f7ba0219] user: dan branch: experimental, size: 9618)
2009-04-02
16:59
[f305cc66] part of check-in [23f90d50] 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: [23f90d50] user: drh branch: trunk, size: 9618)
2008-08-04
03:51
[31e81ac9] part of check-in [9ca975c8] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (check-in: [9ca975c8] user: danielk1977 branch: trunk, size: 9490)
2008-07-12
14:52
[59c1caf2] part of check-in [dcb16024] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (check-in: [dcb16024] user: drh branch: trunk, size: 9434)
2008-07-10
17:59
[4bc893e4] part of check-in [9c8b97ef] Fix a crash in flattenSubquery(). (CVS 5388) (check-in: [9c8b97ef] user: danielk1977 branch: trunk, size: 9443)
2008-07-08
17:43
[09ae8708] part of check-in [6c2adade] Prevent the flattening optimization from transforming a to a query with an illegal ORDER BY clause. (CVS 5372) (check-in: [6c2adade] user: danielk1977 branch: trunk, size: 9305)
2008-07-01
18:26
[811a852a] part of check-in [8f9d1abb] Fix errors in in.test. Also add a few tests to selectB.test. (CVS 5337) (check-in: [8f9d1abb] user: danielk1977 branch: trunk, size: 9125)
17:39
[afc43b5b] part of check-in [56109b9a] Fix another memory leak related to UNION ALL and sub-selects. (CVS 5336) (check-in: [56109b9a] user: danielk1977 branch: trunk, size: 7367)
16:05
[effd81c2] part of check-in [6ee71f4d] Fix a memory leak to do with the recent UNION ALL sub-select optimization. (CVS 5333) (check-in: [6ee71f4d] user: danielk1977 branch: trunk, size: 4961)
14:39
[37d21b6f] part of check-in [a79786a9] Fix a problem with LIMIT and OFFSET clauses on the parent query when optimizing a UNION ALL sub-select. (CVS 5332) (check-in: [a79786a9] user: danielk1977 branch: trunk, size: 2763)
14:09
Added: [ade563cd] part of check-in [3ef468e7] Optimize sub-selects and views that use UNION ALL. This optimization isn't very well tested yet. (CVS 5331) (check-in: [3ef468e7] user: danielk1977 branch: trunk, size: 2364)