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