Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/select6.test
|
2019-05-29
| ||
| 17:22 | Fix the query flattener optimization so that it preserve the "SF_Compound" bit when flattening a compound subquery into a non-compound outer query. Failure to preserve that bit could allow subsequent flattenings which are not valid. Fix for ticket [c41afac34f15781fe09cd]. file: [319d45e4] check-in: [523b4237] user: drh branch: trunk, size: 16982 | |
|
2015-02-09
| ||
| 16:34 | Add test cases for the query flattener fix for ticket [2f7170d73bf9abf8]. file: [39eac4a5] check-in: [dd8f7f75] user: drh branch: tkt-2f7170d7, size: 16604 | |
|
2012-08-28
| ||
| 14:45 | Fix a case where SQLite was failing to detect a syntax error in queries like "SELECT ... FROM (<select-1> UNION ALL <select-2>)" when <select-1> and <select-2> return different numbers of result columns. file: [e76bd10a] check-in: [200a8135] user: dan branch: trunk, size: 14822 | |
|
2010-09-25
| ||
| 22:32 | Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. file: [cc25a865] check-in: [a7645d29] user: drh branch: trunk, size: 13611 | |
|
2009-01-09
| ||
| 01:12 | Increased test coverage. (CVS 6147) file: [2b5e8500] check-in: [45bb5703] user: drh branch: trunk, size: 13592 | |
|
2008-08-20
| ||
| 16:35 | Refactor the name resolution procedures in the code generator. (CVS 5569) file: [faad87c6] check-in: [daf730d1] user: drh branch: trunk, size: 13324 | |
|
2008-07-12
| ||
| 14:52 | Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) file: [1131113e] check-in: [dcb16024] user: drh branch: trunk, size: 13324 | |
|
2006-11-30
| ||
| 13:06 | Improvements to the new performance tests. (CVS 3526) file: [399f14b9] check-in: [27f56c20] user: drh branch: trunk, size: 13341 | |
|
2006-11-23
| ||
| 09:39 | Add performance tests to the test suite. (CVS 3516) file: [3607be76] check-in: [270c745d] user: drh branch: trunk, size: 13347 | |
|
2006-06-11
| ||
| 23:41 | Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [a4e97b71] check-in: [898ec36b] user: drh branch: trunk, size: 13341 | |
|
2006-01-23
| ||
| 07:52 | Fixes for OMIT_UTF16 and OMIT_COMPOUND (CVS 2993) file: [d8ea108b] check-in: [f58bbdc0] user: danielk1977 branch: trunk, size: 13347 | |
|
2006-01-22
| ||
| 00:14 | Tests for the subquery flattening fix of check-in (2987). (CVS 2988) file: [22f4b0c5] check-in: [72a067f0] user: drh branch: trunk, size: 13269 | |
|
2005-11-14
| ||
| 22:29 | Create separate affinities for INTEGER and REAL. (CVS 2766) file: [f459a19b] check-in: [ce06c123] user: drh branch: trunk, size: 12320 | |
|
2005-11-01
| ||
| 15:48 | Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) file: [98a98b55] check-in: [e0d6f61c] user: drh branch: trunk, size: 12310 | |
|
2005-09-07
| ||
| 22:48 | More bug fixes. But there are still tests that fail. (CVS 2664) file: [21b72c56] check-in: [7e85a162] user: drh branch: trunk, size: 12320 | |
|
2005-07-08
| ||
| 17:13 | Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) file: [6559d16a] check-in: [3bb9ce5f] user: drh branch: trunk, size: 12303 | |
|
2005-01-29
| ||
| 08:32 | Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) file: [6e5a1a70] check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 12308 | |
|
2005-01-21
| ||
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [ba1b4dd1] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 12304 | |
|
2004-11-22
| ||
| 15:05 | Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) file: [c00d300d] check-in: [894c142d] user: danielk1977 branch: trunk, size: 12183 | |
| 13:35 | Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [fe1c2bfb] check-in: [007be591] user: danielk1977 branch: trunk, size: 11974 | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) file: [4ce9fa56] check-in: [b11fc9b3] user: drh branch: trunk, size: 11921 | |
|
2004-08-20
| ||
| 18:34 | Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [7a4c572a] check-in: [e97c3313] user: drh branch: trunk, size: 11740 | |
|
2004-01-24
| ||
| 20:18 | Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) file: [a9e31906] check-in: [3626f6d4] user: drh branch: trunk, size: 11714 | |
|
2003-05-02
| ||
| 16:44 | Additional tests of the new flattener added. Ticket #272. (CVS 949) file: [670026a0] check-in: [8d9ee45a] user: drh branch: trunk, size: 11718 | |
|
2002-04-30
| ||
| 19:20 | Fix for ticket #31: Do not attempt the flattening optimization if the subselect does not contain a FROM clause. Handle the special case where a WHERE clause is constant. (CVS 548) file: [efb8d0c0] check-in: [24e4cf73] user: drh branch: trunk, size: 9510 | |
|
2002-03-23
| ||
| 00:31 | Fix a bug in subquery generation when the subquery is a compound select. Also added new tests to cover this case. (CVS 435) file: [5b9b52e8] check-in: [aaf7fd4c] user: drh branch: trunk, size: 9015 | |
|
2002-03-13
| ||
| 18:54 | Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) file: [cc9e2efe] check-in: [c0e3f1c5] user: drh branch: trunk, size: 8091 | |
|
2002-03-03
| ||
| 03:42 | Fix a memory leak in expression processing. (CVS 414) file: [ae124c15] check-in: [dfe431c9] user: drh branch: trunk, size: 7888 | |
| 03:11 | Additional tests of flattening (CVS 413) file: [4eeb20b2] check-in: [e1d93c59] user: drh branch: trunk, size: 7889 | |
| 03:03 | Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) file: [522b4865] check-in: [000441c8] user: drh branch: trunk, size: 7672 | |
| 02:49 | Bug fixes and additional tests for the subquery flattener. (CVS 411) file: [8ccbcd3b] check-in: [2c05389e] user: drh branch: trunk, size: 7436 | |
|
2002-02-18
| ||
| 13:35 | Additional tests for the sub-query feature. (CVS 375) file: [d9fb417d] check-in: [a0019fce] user: drh branch: trunk, size: 5047 | |
| 03:21 | Test and documentation updates for sub-queries. (CVS 373) file: [510377ac] check-in: [607c0c49] user: drh branch: trunk, size: 1512 Added | |