Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/select6.test
2025-04-10
| ||
10:18 | [da91e61d26] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 17753) | |
2024-12-09
| ||
11:12 | [d455cc36cb] part of check-in [289daf6cee] Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum thread 5c8a069d23. (check-in: [289daf6cee] user: dan branch: forum-5c8a069d23-fix, size: 17757) | |
2023-06-09
| ||
13:08 | [b3ec3ae543] part of check-in [f587891134] Experimental change to add a per-connection option that raises an error if a bare column appears in an aggregate query. (check-in: [f587891134] user: drh branch: newbie-safe-aggregates, size: 17326) | |
2022-01-16
| ||
19:11 | [9b2fb4ffed] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 16963) | |
2019-05-29
| ||
17:22 | [319d45e414] part of check-in [523b423711] 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]. (check-in: [523b423711] user: drh branch: trunk, size: 16982) | |
2015-02-09
| ||
16:34 | [39eac4a5c0] part of check-in [dd8f7f7511] Add test cases for the query flattener fix for ticket [2f7170d73bf9abf8]. (check-in: [dd8f7f7511] user: drh branch: tkt-2f7170d7, size: 16604) | |
2012-08-28
| ||
14:45 | [e76bd10a56] part of check-in [200a81358c] 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. (check-in: [200a81358c] user: dan branch: trunk, size: 14822) | |
2010-09-25
| ||
22:32 | [cc25a8650c] part of check-in [a7645d2938] Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. (check-in: [a7645d2938] user: drh branch: trunk, size: 13611) | |
2009-01-09
| ||
01:12 | [2b5e8500d8] part of check-in [45bb5703d7] Increased test coverage. (CVS 6147) (check-in: [45bb5703d7] user: drh branch: trunk, size: 13592) | |
2008-08-20
| ||
16:35 | [faad87c6e6] part of check-in [daf730d1de] Refactor the name resolution procedures in the code generator. (CVS 5569) (check-in: [daf730d1de] user: drh branch: trunk, size: 13324) | |
2008-07-12
| ||
14:52 | [1131113eb6] 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: 13324) | |
2006-11-30
| ||
13:06 | [399f14b9ba] part of check-in [27f56c2051] Improvements to the new performance tests. (CVS 3526) (check-in: [27f56c2051] user: drh branch: trunk, size: 13341) | |
2006-11-23
| ||
09:39 | [3607be760b] part of check-in [270c745dff] Add performance tests to the test suite. (CVS 3516) (check-in: [270c745dff] user: drh branch: trunk, size: 13347) | |
2006-06-11
| ||
23:41 | [a4e97b713b] part of check-in [898ec36b41] Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) (check-in: [898ec36b41] user: drh branch: trunk, size: 13341) | |
2006-01-23
| ||
07:52 | [d8ea108b65] part of check-in [f58bbdc0ac] Fixes for OMIT_UTF16 and OMIT_COMPOUND (CVS 2993) (check-in: [f58bbdc0ac] user: danielk1977 branch: trunk, size: 13347) | |
2006-01-22
| ||
00:14 | [22f4b0c591] part of check-in [72a067f0df] Tests for the subquery flattening fix of check-in (2987). (CVS 2988) (check-in: [72a067f0df] user: drh branch: trunk, size: 13269) | |
2005-11-14
| ||
22:29 | [f459a19bda] part of check-in [ce06c123d0] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123d0] user: drh branch: trunk, size: 12320) | |
2005-11-01
| ||
15:48 | [98a98b5596] part of check-in [e0d6f61c7d] 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) (check-in: [e0d6f61c7d] user: drh branch: trunk, size: 12310) | |
2005-09-07
| ||
22:48 | [21b72c56e7] part of check-in [7e85a162d0] More bug fixes. But there are still tests that fail. (CVS 2664) (check-in: [7e85a162d0] user: drh branch: trunk, size: 12320) | |
2005-07-08
| ||
17:13 | [6559d16ad1] part of check-in [3bb9ce5f20] Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) (check-in: [3bb9ce5f20] user: drh branch: trunk, size: 12303) | |
2005-01-29
| ||
08:32 | [6e5a1a70a7] part of check-in [b1b50f3158] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f3158] user: danielk1977 branch: trunk, size: 12308) | |
2005-01-21
| ||
03:12 | [ba1b4dd18a] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 12304) | |
2004-11-22
| ||
15:05 | [c00d300d90] part of check-in [894c142d11] Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) (check-in: [894c142d11] user: danielk1977 branch: trunk, size: 12183) | |
13:35 | [fe1c2bfb69] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 11974) | |
2004-11-03
| ||
16:27 | [4ce9fa5636] part of check-in [b11fc9b3f3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3f3] user: drh branch: trunk, size: 11921) | |
2004-08-20
| ||
18:34 | [7a4c572ada] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 11740) | |
2004-01-24
| ||
20:18 | [a9e31906e7] part of check-in [3626f6d4a1] Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) (check-in: [3626f6d4a1] user: drh branch: trunk, size: 11714) | |
2003-05-02
| ||
16:44 | [670026a06c] part of check-in [8d9ee45ab4] Additional tests of the new flattener added. Ticket #272. (CVS 949) (check-in: [8d9ee45ab4] user: drh branch: trunk, size: 11718) | |
2002-04-30
| ||
19:20 | [efb8d0c07a] part of check-in [24e4cf73d2] 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) (check-in: [24e4cf73d2] user: drh branch: trunk, size: 9510) | |
2002-03-23
| ||
00:31 | [5b9b52e84c] part of check-in [aaf7fd4cef] Fix a bug in subquery generation when the subquery is a compound select. Also added new tests to cover this case. (CVS 435) (check-in: [aaf7fd4cef] user: drh branch: trunk, size: 9015) | |
2002-03-13
| ||
18:54 | [cc9e2efeef] part of check-in [c0e3f1c592] Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) (check-in: [c0e3f1c592] user: drh branch: trunk, size: 8091) | |
2002-03-03
| ||
03:42 | [ae124c15db] part of check-in [dfe431c9b7] Fix a memory leak in expression processing. (CVS 414) (check-in: [dfe431c9b7] user: drh branch: trunk, size: 7888) | |
03:11 | [4eeb20b272] part of check-in [e1d93c5923] Additional tests of flattening (CVS 413) (check-in: [e1d93c5923] user: drh branch: trunk, size: 7889) | |
03:03 | [522b4865bf] part of check-in [000441c8fe] Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) (check-in: [000441c8fe] user: drh branch: trunk, size: 7672) | |
02:49 | [8ccbcd3b53] part of check-in [2c05389eda] Bug fixes and additional tests for the subquery flattener. (CVS 411) (check-in: [2c05389eda] user: drh branch: trunk, size: 7436) | |
2002-02-18
| ||
13:35 | [d9fb417d6c] part of check-in [a0019fce70] Additional tests for the sub-query feature. (CVS 375) (check-in: [a0019fce70] user: drh branch: trunk, size: 5047) | |
03:21 | Added: [510377ac09] part of check-in [607c0c49b2] Test and documentation updates for sub-queries. (CVS 373) (check-in: [607c0c49b2] user: drh branch: trunk, size: 1512) | |