SQLite

All files named ”test/select1.test”
Login

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

History for test/select1.test

2023-06-09
13:08
[1f3f154481] 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: 32246)
2022-04-22
17:36
[692e84cfa2] part of check-in [a2d3ee9242] Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by distinguishing between "subquery" and "join" and using consistent names across EQP and bytecode. (check-in: [a2d3ee9242] user: drh branch: trunk, size: 31973)
2021-02-13
18:14
[3d23f66bf9] part of check-in [179c79ea0d] Fix incorrect test name labels in the select1.test script. (check-in: [179c79ea0d] user: drh branch: trunk, size: 31981)
2020-10-02
12:42
[0ed9367407] part of check-in [80ecdb3da4] Fix a faulty assert() statement. Add new test cases. (check-in: [80ecdb3da4] user: drh branch: trunk, size: 31975)
2020-01-03
14:16
[009a6d8eac] part of check-in [b36126c188] Fix the OP_Copy-coalesce optimization so that if the previous row happens to end with OP_Copy but is not a candidate for the optimization due to jumps, then the optimization is correctly bypassed. (check-in: [b36126c188] user: drh branch: trunk, size: 31611)
2020-01-01
21:14
[0aaefed5e7] part of check-in [4edddcc0bc] When generating code for a subquery, make a copy of the Select object and generate the code out of the copy, in case the code generator makes modifications to expression and the Select object needs to be reused. (check-in: [4edddcc0bc] user: drh branch: trunk, size: 31513)
2019-12-18
01:31
[b887331202] part of check-in [9bdd57cb9a] Remove an assert() in the code generator that can fail due to an invalid INSERT statement. The same assert() appears again in the VDBE and will fire there if the problem persists in an SQL statement that does not contain errors. Gramfuzz find. (check-in: [9bdd57cb9a] user: drh branch: trunk, size: 31204)
2019-07-24
23:15
[703154cbf6] part of check-in [01cdc590f7] Fix faulty asserts in the code generator. Ticket [c52b09c7f38903b1] (check-in: [01cdc590f7] user: drh branch: trunk, size: 30677)
2019-01-16
19:26
[7d41f35499] part of check-in [49fcde2f1f] Fix a problem in the code generator for sorting results with SRT_EphemTab and a LIMIT clause. (check-in: [49fcde2f1f] user: drh branch: trunk, size: 28363)
2018-01-10
00:40
[2e760bab8f] part of check-in [36b89d728f] Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing. (check-in: [36b89d728f] user: drh branch: trunk, size: 27710)
2017-09-29
12:12
[460a5824df] part of check-in [04ef40a8fe] Better names for subqueries in EXPLAIN comments. (check-in: [04ef40a8fe] user: drh branch: trunk, size: 27717)
2016-04-14
19:29
[e80459748c] part of check-in [129083bd5e] Work toward improving analysis and code generation for DISTINCT and aggregate queries. (check-in: [129083bd5e] user: drh branch: better-distinct-agg, size: 27717)
2015-04-17
15:16
[be62204d2b] part of check-in [620d19c3b4] Fix a faulty assert() in sqlite3SelectNew(). (check-in: [620d19c3b4] user: drh branch: trunk, size: 27725)
2015-04-16
07:19
[53c3a5228b] part of check-in [b51028ed2f] Ensure the sqlite3Select() routine always returns non-zero if an error has occurred. (check-in: [b51028ed2f] user: dan branch: trunk, size: 27588)
2013-10-08
20:42
[fc2a61f226] part of check-in [65553ff34b] Rollback some of the previous changes in the branch such that the estimated row sizes are now only used as a tie-breaker for index scans. (check-in: [65553ff34b] user: drh branch: row-size-est, size: 27459)
2012-02-23
17:35
[deba017eed] part of check-in [c8c7846fb9] Fix an obscure bug that causes a crash when parsing certain invalid SQL statements. (check-in: [c8c7846fb9] user: drh branch: trunk, size: 27465)
2009-05-28
01:00
[f67ca2dfc0] part of check-in [4ac2bdfbb4] Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) (check-in: [4ac2bdfbb4] user: drh branch: trunk, size: 27318)
2009-05-27
10:31
[313078d5fc] part of check-in [7cb1c3ba07] Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) (check-in: [7cb1c3ba07] user: drh branch: trunk, size: 27318)
2009-04-23
14:58
[041fe01f2a] part of check-in [e71fb0fb8d] Move the asynchronous IO code from src/test_async.c to ext/async/. Refactor it to be a standalone module and to support windows. (CVS 6539) (check-in: [e71fb0fb8d] user: danielk1977 branch: trunk, size: 27328)
2009-04-10
15:38
[7de2cabb41] part of check-in [88cefbb4a1] Disable the select1-15 tests when locking_mode is EXCLUSIVE. Ticket #3771. (CVS 6484) (check-in: [88cefbb4a1] user: drh branch: trunk, size: 27238)
2009-04-02
17:23
[fff3396617] part of check-in [058a2f2093] Ensure the required VerifyCookie/Transaction/TableLock opcodes are added for "x IN (SELECT c FROM t)" expressions. Ticket #3771. (CVS 6439) (check-in: [058a2f2093] user: danielk1977 branch: trunk, size: 27074)
2008-08-04
03:51
[d0a4cad954] part of check-in [9ca975c8fd] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (check-in: [9ca975c8fd] user: danielk1977 branch: trunk, size: 26673)
2008-07-15
00:27
[e66c18df88] part of check-in [7cf91e08c0] Increased test coverage. (CVS 5414) (check-in: [7cf91e08c0] user: drh branch: trunk, size: 26655)
2008-07-10
00:32
[0c7ed6dbe1] part of check-in [636cd72329] Remove unused code. Test coverage enhancements. Modify the algorithm used to select column names for VIEWs of joins so that the constructed column names omits the underlying table names. (CVS 5386) (check-in: [636cd72329] user: drh branch: trunk, size: 25466)
2008-07-09
01:39
[6cea013e12] part of check-in [c6cf08477c] Additional test coverage in select.c and expr.c. (CVS 5381) (check-in: [c6cf08477c] user: drh branch: trunk, size: 24808)
2008-06-24
12:46
[9f9d90c40b] part of check-in [95037e6dbf] Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2. Other bug fixes in compound-merge. The compound-merge is still disabled in this check-in using "#if 0" due to additional bugs. (CVS 5295) (check-in: [95037e6dbf] user: drh branch: trunk, size: 24139)
12:28
[a976b3b21a] part of check-in [3117238ce9] Remove a surplus "breakpoint" from select4.test. (CVS 5294) (check-in: [3117238ce9] user: drh branch: trunk, size: 24140)
00:32
[64f6231c75] part of check-in [e2ba324cbc] The compound-select merge optimization is mostly working with this check-in. But there are still a few problems and so the optimization is disabled by and "#if 0". This check-in is to synchronize with the other changes happening in parallel. (CVS 5291) (check-in: [e2ba324cbc] user: drh branch: trunk, size: 24150)
2008-06-23
18:49
[2f011e7aa0] part of check-in [f8238770bf] Fix a bug in handling queries on the sqlite_master table with an empty (0 bytes in size) database file. (CVS 5286) (check-in: [f8238770bf] user: danielk1977 branch: trunk, size: 24148)
2007-12-13
07:58
[871df931cb] part of check-in [2f88b9b3e3] Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) (check-in: [2f88b9b3e3] user: danielk1977 branch: trunk, size: 23672)
2007-12-10
05:03
[79784038f0] part of check-in [0b34a18651] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (check-in: [0b34a18651] user: danielk1977 branch: trunk, size: 23687)
2007-12-08
21:10
[d091e1c8ad] part of check-in [62a78d212c] Better resolution of ORDER BY terms in compound queries. Candidate solution for ticket #2822. Needs more testing and documentation before going final. (CVS 4602) (check-in: [62a78d212c] user: drh branch: trunk, size: 23656)
2007-07-23
22:51
[7603a4d406] part of check-in [de000280c6] Detect nested aggregate functions even if the inner aggregate function is aliased using an AS clause. Ticket #2526. (CVS 4179) (check-in: [de000280c6] user: drh branch: trunk, size: 23656)
2007-04-13
16:06
[1a35bf8201] part of check-in [cfc6f933dc] Match ORDER BY terms to columns using names in compound queries. Make sure this works for subqueries, especially in the right-hand side of an IN operator. Ticket #2296. (CVS 3842) (check-in: [cfc6f933dc] user: drh branch: trunk, size: 23022)
2007-04-06
15:02
[1287b040f9] part of check-in [479b3d965b] Binary file I/O infrastructure added and used to increase test coverage for detection of corrupt database files. (CVS 3822) (check-in: [479b3d965b] user: drh branch: trunk, size: 22025)
2006-04-11
14:16
[fa4e941da0] part of check-in [d83e0230c0] Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS 3173) (check-in: [d83e0230c0] user: drh branch: trunk, size: 21892)
2006-03-26
01:21
[cf2553f611] part of check-in [80cda9f7ce] 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) (check-in: [80cda9f7ce] user: drh branch: trunk, size: 21583)
2006-03-14
13:10
[db53c25755] part of check-in [4d70013a6a] Set and clear the full_column_name flag using direct invocation rather than the execsql tcl command so that the select1 test works with the serialized statement extension. (CVS 3136) (check-in: [4d70013a6a] user: drh branch: trunk, size: 21607)
2006-02-09
22:13
[9991b12eb6] part of check-in [9e04f8fdf1] SUM never gives an error. An integer result is returned for exact results and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) (check-in: [9e04f8fdf1] user: drh branch: trunk, size: 21607)
2006-01-14
08:02
[f4ab4b66e7] part of check-in [8e79a0c24a] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: [8e79a0c24a] user: danielk1977 branch: trunk, size: 21614)
2006-01-13
13:01
[ed95ce4c27] part of check-in [caa7da807d] Fix a vdbe stack overflow problem that could occur with a correlated sub-query. (CVS 2938) (check-in: [caa7da807d] user: danielk1977 branch: trunk, size: 21549)
2005-12-15
10:11
[386cc42da2] part of check-in [c1ed79f594] Add the sqlite3_os_routine_set()/get() functions. (CVS 2818) (check-in: [c1ed79f594] user: danielk1977 branch: trunk, size: 20952)
2005-12-09
14:25
[20275797ef] part of check-in [601c335463] Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) (check-in: [601c335463] user: danielk1977 branch: trunk, size: 20950)
2005-09-08
10:37
[480233d4f5] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 20943)
2005-01-21
04:25
[ad700a2a1c] part of check-in [d4e19efcef] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efcef] user: danielk1977 branch: trunk, size: 20959)
03:12
[bb62bfcd4f] 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: 20917)
2005-01-18
17:20
[6d4a42c2fb] part of check-in [b1d4c42d2b] CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) (check-in: [b1d4c42d2b] user: drh branch: trunk, size: 20770)
16:02
[0b4d3883a9] part of check-in [9295050af1] Column names coming back from a SELECT are now just the name of the source column without the "table." prefix. In other words, "PRAGMA short_column_names=ON" is now the default. This makes the names of columns behave more like other SQL engines. The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231) (check-in: [9295050af1] user: drh branch: trunk, size: 20794)
2005-01-15
01:52
[2b08187aff] part of check-in [92f9d2b2f4] Test coverage improvements. (CVS 2215) (check-in: [92f9d2b2f4] user: drh branch: trunk, size: 20736)
2004-11-22
13:35
[524d4323f3] 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: 20048)
2004-08-20
18:34
[0e459a8066] 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: 19811)
2004-07-20
01:45
[1eab1f8aa8] part of check-in [9937ffb08e] Handle quotes on table names in TABLE.* terms in SELECT. Ticket #680. (CVS 1834) (check-in: [9937ffb08e] user: drh branch: version_2, size: 19540)
01:45
[3ada65f990] part of check-in [826b6797a9] Handle quotes on the table name in TABLE.* terms in SELECT statements. Ticket #680. (CVS 1833) (check-in: [826b6797a9] user: drh branch: trunk, size: 19803)
2004-07-18
21:14
[ccace97d8f] part of check-in [223521c04e] Min() and max() ignore NULL values. Ticket #800. (CVS 1803) (check-in: [223521c04e] user: drh branch: version_2, size: 19450)
20:52
[84b0d95f8b] part of check-in [166234a2b6] min() ignores NULL values. Ticket #800. (CVS 1802) (check-in: [166234a2b6] user: drh branch: trunk, size: 19713)
2004-06-24
00:20
[813a270ac7] part of check-in [0a26b91580] Apply (1679) to version 3. Ticket #777. (CVS 1680) (check-in: [0a26b91580] user: danielk1977 branch: trunk, size: 19724)
2004-06-23
21:16
[e40a88c85f] part of check-in [78ced6e309] The MIN() aggregate function returns NULL if any element in the result was NULL. This makes MIN() consistent with ORDER BY which sorts NULL first. Ticket #777. (CVS 1679) (check-in: [78ced6e309] user: drh branch: version_2, size: 19453)
2004-05-28
11:37
[2f161f9cdf] part of check-in [4984a130cc] Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) (check-in: [4984a130cc] user: danielk1977 branch: trunk, size: 19721)
2004-05-12
11:24
[3bfcccd2ea] part of check-in [2f16c9ef3c] Add some more code to support manifest typing in indices. Not activated yet. (CVS 1362) (check-in: [2f16c9ef3c] user: danielk1977 branch: trunk, size: 19659)
2002-06-02
16:09
[0d708cec56] part of check-in [7acbf84b49] Enhance the ORDER BY clause so that an integer term means to sort by the corresponding column. (CVS 602) (check-in: [7acbf84b49] user: drh branch: trunk, size: 19446)
2002-05-29
23:22
[a19a8026b5] part of check-in [19ae12bef2] Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) (check-in: [19ae12bef2] user: drh branch: trunk, size: 18433)
2002-05-27
03:25
[1842aa108d] part of check-in [f562d54230] Fix the "alias.*" bug found by Bernie Cosell and reported on the newsgroup. (CVS 593) (check-in: [f562d54230] user: drh branch: trunk, size: 18438)
01:04
[4e1ac9cc3c] part of check-in [0e268d0c0f] Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) (check-in: [0e268d0c0f] user: drh branch: trunk, size: 18344)
2002-05-24
20:31
[6ba20b52d5] part of check-in [99bd1f5b9a] Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) (check-in: [99bd1f5b9a] user: drh branch: trunk, size: 18280)
2002-05-08
21:46
[c19617be69] part of check-in [1b0ee944c9] Fix for ticket #35: Ignore any ORDER BY clause on a subquery in a FROM clause. (CVS 557) (check-in: [1b0ee944c9] user: drh branch: trunk, size: 18266)
2002-04-06
13:57
[734b9f45a8] part of check-in [28ce42f787] Make the FROM clause on a SELECT optional. If omitted, the result of the SELECT is a single row consisting of the values in the expression list. (CVS 520) (check-in: [28ce42f787] user: drh branch: trunk, size: 17916)
2002-04-04
02:10
[114d4545c1] part of check-in [c2320eabfe] Fix for bug #2: Add support for TABLE.* in SELECT statements. (CVS 518) (check-in: [c2320eabfe] user: drh branch: trunk, size: 17174)
2002-03-02
17:04
[572d53f7b2] part of check-in [d5d3e79cc5] Subquery flattening is implemented and passes all regression tests. We still need to add addition tests to the suite to further exercise the flattener, however. (CVS 408) (check-in: [d5d3e79cc5] user: drh branch: trunk, size: 15432)
2002-02-28
03:14
[ec4c205145] part of check-in [7d86749d4a] Change the IFNULL and NVL functions to COALESCE. Change MIN and MAX so that they require at least one argument. (CVS 404) (check-in: [7d86749d4a] user: drh branch: trunk, size: 14311)
03:04
[72328eb569] part of check-in [b00cf110b1] The new function code passes regression tests. (CVS 403) (check-in: [b00cf110b1] user: drh branch: trunk, size: 14235)
2002-02-23
23:45
[7d5ae792d6] part of check-in [c490a1ff95] Added support for user-defined normal functions. Support for user-defined aggregates is pending. (CVS 390) (check-in: [c490a1ff95] user: drh branch: trunk, size: 14263)
2002-01-22
14:11
[fd2936aa90] part of check-in [035984a5b0] Constant ORDER BY or GROUP BY expressions are an error. (CVS 352) (check-in: [035984a5b0] user: drh branch: trunk, size: 14252)
03:13
[391a1e1a05] part of check-in [3684beab0f] The right-hand side of an AS in a SELECT can be used within expressions of the WHERE, ORDER BY, GROUP BY, and/or HAVING clauses. (CVS 350) (check-in: [3684beab0f] user: drh branch: trunk, size: 14122)
2001-12-16
20:05
[7423a9dbb8] part of check-in [ffbdd43f5d] Added the ability to say things like "SELECT rowid, * FROM table1;" (CVS 332) (check-in: [ffbdd43f5d] user: drh branch: trunk, size: 13452)
2001-11-06
14:10
[13aa0a5545] part of check-in [177012249a] Added support for LIMIT. (CVS 302) (check-in: [177012249a] user: drh branch: trunk, size: 12974)
2001-10-19
16:44
[75af194669] part of check-in [8467d84fc6] Version 2.0.6 (CVS 291) (check-in: [8467d84fc6] user: drh branch: trunk, size: 12802)
2001-10-18
12:34
[129c018856] part of check-in [22948fc685] Support for UTF-8 and ISO8859 characters in identifiers. Bug fix in the column name generator for selects (was coreing). (CVS 290) (check-in: [22948fc685] user: drh branch: trunk, size: 12117)
2001-10-15
00:44
[5f47445fa3] part of check-in [747bf1b30b] Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) (check-in: [747bf1b30b] user: drh branch: trunk, size: 11833)
2001-10-06
16:33
[b59e8c7132] part of check-in [b63b3f3684] Adding table column query capability to support ODBC. (CVS 278) (check-in: [b63b3f3684] user: drh branch: trunk, size: 11449)
2001-09-16
00:13
[e0c3ff05f4] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 10975)
2001-04-12
23:21
[223507655c] part of check-in [3bde128418] More testing (CVS 209) (check-in: [3bde128418] user: drh branch: trunk, size: 11517)
2001-04-04
11:48
[824d9d5007] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 9592)
2000-07-29
13:06
[68ff778c24] part of check-in [3bf434d93a] better column labels in select results (CVS 110) (check-in: [3bf434d93a] user: drh branch: trunk, size: 9075)
2000-06-21
13:59
[4e57b0b5ea] part of check-in [e1bf96a467] :-) (CVS 104) (check-in: [e1bf96a467] user: drh branch: trunk, size: 9083)
2000-06-07
15:11
[64703852af] part of check-in [d3baa046c9] :-) (CVS 70) (check-in: [d3baa046c9] user: drh branch: trunk, size: 9078)
14:42
[55af6d31c7] part of check-in [5d773b5d4e] :-) (CVS 1697) (check-in: [5d773b5d4e] user: drh branch: trunk, size: 8903)
2000-06-06
17:27
[2311bddd40] part of check-in [db88a0c2d4] GROUP BY and HAVING installed (CVS 58) (check-in: [db88a0c2d4] user: drh branch: trunk, size: 8899)
2000-05-31
18:20
[a0b00df77e] part of check-in [35a8f523e8] :-) (CVS 25) (check-in: [35a8f523e8] user: drh branch: trunk, size: 8922)
17:59
Added: [b994637d78] part of check-in [4cd98ebaea] :-) (CVS 24) (check-in: [4cd98ebaea] user: drh branch: trunk, size: 8179)