/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/select4.test

2017-07-17
19:25
When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. file: [ddcaffe1] check-in: [adc082c1] user: drh branch: push-down-backport, size: 22240
2016-04-25
02:20
When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. file: [5389d989] check-in: [ec215f94] user: drh branch: trunk, size: 25483
2016-03-15
17:52
Implement FROM-clause subqueries as co-routines whenever they are guaranteed to be the outer-most loop of the join. file: [d926792a] check-in: [c7bae50b] user: drh branch: trunk, size: 24331
2016-02-09
02:12
Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. file: [45363115] check-in: [ca72be86] user: drh branch: trunk, size: 23353
2015-05-20
00:15
Fix handling of queries with VALUES on the left and UNION ALL SELECT on the right and a LIMIT clause. file: [6d5bc6d1] check-in: [c403502c] user: drh branch: trunk, size: 22710
2015-05-07
00:09
Remove a faulty assert() statement. file: [824342f3] check-in: [5f2539da] user: drh branch: trunk, size: 22517
2015-05-04
16:09
Fix a faulty assert() in the SELECT code generator and add a test case to prevent regression. file: [ac1cd552] check-in: [1421c8ff] user: drh branch: trunk, size: 22429
2015-04-21
02:17
Test case for the previous check-in. file: [48e14766] check-in: [a526f58b] user: drh branch: trunk, size: 22220
2015-04-17
18:52
Always resolve symbols in all ORDER BY clauses of a compound-SELECT, even illegal ORDER BY clauses. file: [a3201fa9] check-in: [6c39ef73] user: drh branch: trunk, size: 22109
2015-04-16
16:22
Fix a faulty assert() in the compound-SELECT code generator. file: [4b2df481] check-in: [10715b05] user: drh branch: trunk, size: 21928
14:13
Improvements to the way VALUES clauses are parsed. file: [d4330ee0] check-in: [ec5a493a] user: drh branch: trunk, size: 21716
2015-04-15
07:10
Change the multiSelectOrderBy() routine to return non-zero if there has been any prior error. file: [16fa1caf] check-in: [14784c31] user: drh branch: trunk, size: 21490
05:20
When adding the implied "LIMIT 1" to the end of a scalar subquery, make sure that subquery is not a VALUES-only query as such queries cannot deal with LIMIT clauses. file: [af938bb5] check-in: [7c27310b] user: drh branch: trunk, size: 21274
2015-03-05
01:29
New requirements marks on compound SELECT statements. file: [e20e8ce4] check-in: [e7991bc5] user: drh branch: trunk, size: 21087
2014-02-19
01:31
Make sure a multi-row VALUES clause works correctly in a compound SELECT. file: [8c5a60d4] check-in: [85b355cf] user: drh branch: trunk, size: 20950
2012-03-03
01:44
Add a test case for ticket [3557ad65a076c]. file: [00179be4] check-in: [4f34d707] user: drh branch: trunk, size: 19757
2009-04-16
00:24
In a 3-fold compound SELECT make sure early code generation of the SELECTs to the right do not dereference non-existant columns in SELECTs on the left. (CVS 6511) file: [44aa6e71] check-in: [414f3408] user: drh branch: trunk, size: 19282
2008-08-04
03:51
Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) file: [b64d5d24] check-in: [9ca975c8] user: danielk1977 branch: trunk, size: 18870
2008-06-25
08:02
Fixed typo to close #1731. (CVS 5302) file: [0618c937] check-in: [9902be8d] user: mihailim branch: trunk, size: 18867
2008-03-26
12:46
Make sure an imbalance in the number of columns on a compound SELECT is detected and reported as an error before it can cause an assertion fault or array-bounds overflow in the code generator. Oops: part of the fix for ticket #3015 got included with this check-in by mistake. (CVS 4917) file: [7cc135c8] check-in: [50de87dc] user: drh branch: trunk, size: 18862
2008-01-16
18:20
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [ba1c276c] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 15019
2008-01-12
12:48
Continuing work toward converting the VM into a register machine. (CVS 4707) file: [491193f5] check-in: [a6dddebc] user: drh branch: trunk, size: 15013
2007-12-13
07:58
Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) file: [69015a6c] check-in: [2f88b9b3] user: danielk1977 branch: trunk, size: 13952
03:45
ORDER BY in a compound SELECT will first match against the left-most SELECT. If there is no match there, it begins working its way to the right. (CVS 4621) file: [566b4ca1] check-in: [56063ec8] user: drh branch: trunk, size: 13956
2007-12-10
18:51
Further modifications to do with ORDER BY and compound SELECT queries. Related to ticket #2822. (CVS 4606) file: [2dd28cfe] check-in: [0d9b0e6e] user: danielk1977 branch: trunk, size: 13952
2007-12-08
21:10
Better resolution of ORDER BY terms in compound queries. Candidate solution for ticket #2822. Needs more testing and documentation before going final. (CVS 4602) file: [4192e6c7] check-in: [62a78d21] user: drh branch: trunk, size: 13911
2006-06-20
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [305ba0a6] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 13919
2006-03-26
01:21
SQLite now always chooses the column names for compound selects using the left-most select. This makes SQLite work like other SQL database, but it also is a change from historical behavior and may break some scripts. Ticket #1721. (CVS 3153) file: [d0280e3b] check-in: [80cda9f7] user: drh branch: trunk, size: 13767
2005-01-21
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [c239f516] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 11784
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [1ae6f2bd] check-in: [007be591] user: danielk1977 branch: trunk, size: 11482
2004-05-27
17:22
Remove the COPY command. (CVS 1477) file: [86e72fc3] check-in: [287f8673] user: drh branch: trunk, size: 11275
2004-05-14
11:00
Implement type affinity for table and index records (CVS 1375) file: [d2443e55] check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 11316
2004-05-13
05:16
Manifest types in indices. At the moment indices use manifest typing, but some other parts of the SQL engine do not, which can lead to some strange results. (CVS 1368) file: [804b48d6] check-in: [9f2b6d9d] user: danielk1977 branch: trunk, size: 11644
2003-02-02
12:41
Make the GROUP BY clause work even if there are no aggregate functions. (CVS 859) file: [e7e9a32f] check-in: [b6879231] user: drh branch: trunk, size: 11309
2002-06-22
02:33
An optimization: avoid the use of an intermediate table on UNION ALL if there is no ORDER BY clause. (CVS 637) file: [10ba54f2] check-in: [8aa73ce6] user: drh branch: trunk, size: 10698
2002-06-20
03:38
Fix for ticket #73: The ORDER BY clause is significant for subqueries. This passes all regression tests, but more testing is needed to exercise all paths through the new code. (CVS 631) file: [13618c11] check-in: [43c5aff5] user: drh branch: trunk, size: 10345
2002-06-02
16:09
Enhance the ORDER BY clause so that an integer term means to sort by the corresponding column. (CVS 602) file: [9b5c87b7] check-in: [7acbf84b] user: drh branch: trunk, size: 8754
2002-05-31
15:51
Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison is considered false, not NULL. With these changes, NULLs in SQLite now work the same as in PostgreSQL and in Oracle. (CVS 600) file: [32018b97] check-in: [da61aa1d] user: drh branch: trunk, size: 7655
2002-05-27
01:04
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) file: [2ea8c7b7] check-in: [0e268d0c] user: drh branch: trunk, size: 7634
2002-05-26
20:54
NULL values are distinct. A comparison involving a NULL is always false. Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) file: [0bc00651] check-in: [90511737] user: drh branch: trunk, size: 7508
2002-05-24
16:14
Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) file: [c2313f8c] check-in: [e238643e] user: drh branch: trunk, size: 6694
2002-04-23
17:10
Fix for ticket #22: In the code generator for compound SELECT statements, take care not to generate column name headers if the output is an intermediate table. Otherwise the column headers are not generated correctly if a compound SELECT statement appears as an expression in part of the WHERE clause. (CVS 543) file: [a8f1d97f] check-in: [a06d9acd] user: drh branch: trunk, size: 6691
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [29a2ffb1] check-in: [4e926efe] user: drh branch: trunk, size: 5890
2000-06-08
15:10
:-) (CVS 81) file: [cb5374d7] check-in: [61c381e7] user: drh branch: trunk, size: 6433
01:55
:-) (CVS 77) file: [5d6aa52f] check-in: [b3fb15cc] user: drh branch: trunk, size: 6048
00:28
:-) (CVS 76) file: [c9b4b4ab] check-in: [19029233] user: drh branch: trunk, size: 3169 Added