/ 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/select1.test

2019-07-24
23:15
Fix faulty asserts in the code generator. Ticket [c52b09c7f38903b1] file: [703154cb] check-in: [01cdc590] user: drh branch: trunk, size: 30677
2019-01-16
19:26
Fix a problem in the code generator for sorting results with SRT_EphemTab and a LIMIT clause. file: [7d41f354] check-in: [49fcde2f] user: drh branch: trunk, size: 28363
2018-01-10
00:40
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. file: [2e760bab] check-in: [36b89d72] user: drh branch: trunk, size: 27710
2017-09-29
12:12
Better names for subqueries in EXPLAIN comments. file: [460a5824] check-in: [04ef40a8] user: drh branch: trunk, size: 27717
2016-04-14
19:29
Work toward improving analysis and code generation for DISTINCT and aggregate queries. file: [e8045974] check-in: [129083bd] user: drh branch: better-distinct-agg, size: 27717
2015-04-17
15:16
Fix a faulty assert() in sqlite3SelectNew(). file: [be62204d] check-in: [620d19c3] user: drh branch: trunk, size: 27725
2015-04-16
07:19
Ensure the sqlite3Select() routine always returns non-zero if an error has occurred. file: [53c3a522] check-in: [b51028ed] user: dan branch: trunk, size: 27588
2013-10-08
20:42
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. file: [fc2a61f2] check-in: [65553ff3] user: drh branch: row-size-est, size: 27459
2012-02-23
17:35
Fix an obscure bug that causes a crash when parsing certain invalid SQL statements. file: [deba017e] check-in: [c8c7846f] user: drh branch: trunk, size: 27465
2009-05-28
01:00
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) file: [f67ca2df] check-in: [4ac2bdfb] user: drh branch: trunk, size: 27318
2009-05-27
10:31
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) file: [313078d5] check-in: [7cb1c3ba] user: drh branch: trunk, size: 27318
2009-04-23
14:58
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) file: [041fe01f] check-in: [e71fb0fb] user: danielk1977 branch: trunk, size: 27328
2009-04-10
15:38
Disable the select1-15 tests when locking_mode is EXCLUSIVE. Ticket #3771. (CVS 6484) file: [7de2cabb] check-in: [88cefbb4] user: drh branch: trunk, size: 27238
2009-04-02
17:23
Ensure the required VerifyCookie/Transaction/TableLock opcodes are added for "x IN (SELECT c FROM t)" expressions. Ticket #3771. (CVS 6439) file: [fff33966] check-in: [058a2f20] user: danielk1977 branch: trunk, size: 27074
2008-08-04
03:51
Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) file: [d0a4cad9] check-in: [9ca975c8] user: danielk1977 branch: trunk, size: 26673
2008-07-15
00:27
Increased test coverage. (CVS 5414) file: [e66c18df] check-in: [7cf91e08] user: drh branch: trunk, size: 26655
2008-07-10
00:32
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) file: [0c7ed6db] check-in: [636cd723] user: drh branch: trunk, size: 25466
2008-07-09
01:39
Additional test coverage in select.c and expr.c. (CVS 5381) file: [6cea013e] check-in: [c6cf0847] user: drh branch: trunk, size: 24808
2008-06-24
12:46
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) file: [9f9d90c4] check-in: [95037e6d] user: drh branch: trunk, size: 24139
12:28
Remove a surplus "breakpoint" from select4.test. (CVS 5294) file: [a976b3b2] check-in: [3117238c] user: drh branch: trunk, size: 24140
00:32
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) file: [64f6231c] check-in: [e2ba324c] user: drh branch: trunk, size: 24150
2008-06-23
18:49
Fix a bug in handling queries on the sqlite_master table with an empty (0 bytes in size) database file. (CVS 5286) file: [2f011e7a] check-in: [f8238770] user: danielk1977 branch: trunk, size: 24148
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: [871df931] check-in: [2f88b9b3] user: danielk1977 branch: trunk, size: 23672
2007-12-10
05:03
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) file: [79784038] check-in: [0b34a186] user: danielk1977 branch: trunk, size: 23687
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: [d091e1c8] check-in: [62a78d21] user: drh branch: trunk, size: 23656
2007-07-23
22:51
Detect nested aggregate functions even if the inner aggregate function is aliased using an AS clause. Ticket #2526. (CVS 4179) file: [7603a4d4] check-in: [de000280] user: drh branch: trunk, size: 23656
2007-04-13
16:06
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) file: [1a35bf82] check-in: [cfc6f933] user: drh branch: trunk, size: 23022
2007-04-06
15:02
Binary file I/O infrastructure added and used to increase test coverage for detection of corrupt database files. (CVS 3822) file: [1287b040] check-in: [479b3d96] user: drh branch: trunk, size: 22025
2006-04-11
14:16
Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS 3173) file: [fa4e941d] check-in: [d83e0230] user: drh branch: trunk, size: 21892
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: [cf2553f6] check-in: [80cda9f7] user: drh branch: trunk, size: 21583
2006-03-14
13:10
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) file: [db53c257] check-in: [4d70013a] user: drh branch: trunk, size: 21607
2006-02-09
22:13
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) file: [9991b12e] check-in: [9e04f8fd] user: drh branch: trunk, size: 21607
2006-01-14
08:02
Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) file: [f4ab4b66] check-in: [8e79a0c2] user: danielk1977 branch: trunk, size: 21614
2006-01-13
13:01
Fix a vdbe stack overflow problem that could occur with a correlated sub-query. (CVS 2938) file: [ed95ce4c] check-in: [caa7da80] user: danielk1977 branch: trunk, size: 21549
2005-12-15
10:11
Add the sqlite3_os_routine_set()/get() functions. (CVS 2818) file: [386cc42d] check-in: [c1ed79f5] user: danielk1977 branch: trunk, size: 20952
2005-12-09
14:25
Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) file: [20275797] check-in: [601c3354] user: danielk1977 branch: trunk, size: 20950
2005-09-08
10:37
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) file: [480233d4] check-in: [21adf4bd] user: drh branch: trunk, size: 20943
2005-01-21
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [ad700a2a] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 20959
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [bb62bfcd] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 20917
2005-01-18
17:20
CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) file: [6d4a42c2] check-in: [b1d4c42d] user: drh branch: trunk, size: 20770
16:02
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) file: [0b4d3883] check-in: [9295050a] user: drh branch: trunk, size: 20794
2005-01-15
01:52
Test coverage improvements. (CVS 2215) file: [2b08187a] check-in: [92f9d2b2] user: drh branch: trunk, size: 20736
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [524d4323] check-in: [007be591] user: danielk1977 branch: trunk, size: 20048
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [0e459a80] check-in: [e97c3313] user: drh branch: trunk, size: 19811
2004-07-20
01:45
Handle quotes on table names in TABLE.* terms in SELECT. Ticket #680. (CVS 1834) file: [1eab1f8a] check-in: [9937ffb0] user: drh branch: version_2, size: 19540
01:45
Handle quotes on the table name in TABLE.* terms in SELECT statements. Ticket #680. (CVS 1833) file: [3ada65f9] check-in: [826b6797] user: drh branch: trunk, size: 19803
2004-07-18
21:14
Min() and max() ignore NULL values. Ticket #800. (CVS 1803) file: [ccace97d] check-in: [223521c0] user: drh branch: version_2, size: 19450
20:52
min() ignores NULL values. Ticket #800. (CVS 1802) file: [84b0d95f] check-in: [166234a2] user: drh branch: trunk, size: 19713
2004-06-24
00:20
Apply (1679) to version 3. Ticket #777. (CVS 1680) file: [813a270a] check-in: [0a26b915] user: danielk1977 branch: trunk, size: 19724
2004-06-23
21:16
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) file: [e40a88c8] check-in: [78ced6e3] user: drh branch: version_2, size: 19453
2004-05-28
11:37
Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) file: [2f161f9c] check-in: [4984a130] user: danielk1977 branch: trunk, size: 19721
2004-05-12
11:24
Add some more code to support manifest typing in indices. Not activated yet. (CVS 1362) file: [3bfcccd2] check-in: [2f16c9ef] user: danielk1977 branch: trunk, size: 19659
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: [0d708cec] check-in: [7acbf84b] user: drh branch: trunk, size: 19446
2002-05-29
23:22
Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) file: [a19a8026] check-in: [19ae12be] user: drh branch: trunk, size: 18433
2002-05-27
03:25
Fix the "alias.*" bug found by Bernie Cosell and reported on the newsgroup. (CVS 593) file: [1842aa10] check-in: [f562d542] user: drh branch: trunk, size: 18438
01:04
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) file: [4e1ac9cc] check-in: [0e268d0c] user: drh branch: trunk, size: 18344
2002-05-24
20:31
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) file: [6ba20b52] check-in: [99bd1f5b] user: drh branch: trunk, size: 18280
2002-05-08
21:46
Fix for ticket #35: Ignore any ORDER BY clause on a subquery in a FROM clause. (CVS 557) file: [c19617be] check-in: [1b0ee944] user: drh branch: trunk, size: 18266
2002-04-06
13:57
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) file: [734b9f45] check-in: [28ce42f7] user: drh branch: trunk, size: 17916
2002-04-04
02:10
Fix for bug #2: Add support for TABLE.* in SELECT statements. (CVS 518) file: [114d4545] check-in: [c2320eab] user: drh branch: trunk, size: 17174
2002-03-02
17:04
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) file: [572d53f7] check-in: [d5d3e79c] user: drh branch: trunk, size: 15432
2002-02-28
03:14
Change the IFNULL and NVL functions to COALESCE. Change MIN and MAX so that they require at least one argument. (CVS 404) file: [ec4c2051] check-in: [7d86749d] user: drh branch: trunk, size: 14311
03:04
The new function code passes regression tests. (CVS 403) file: [72328eb5] check-in: [b00cf110] user: drh branch: trunk, size: 14235
2002-02-23
23:45
Added support for user-defined normal functions. Support for user-defined aggregates is pending. (CVS 390) file: [7d5ae792] check-in: [c490a1ff] user: drh branch: trunk, size: 14263
2002-01-22
14:11
Constant ORDER BY or GROUP BY expressions are an error. (CVS 352) file: [fd2936aa] check-in: [035984a5] user: drh branch: trunk, size: 14252
03:13
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) file: [391a1e1a] check-in: [3684beab] user: drh branch: trunk, size: 14122
2001-12-16
20:05
Added the ability to say things like "SELECT rowid, * FROM table1;" (CVS 332) file: [7423a9db] check-in: [ffbdd43f] user: drh branch: trunk, size: 13452
2001-11-06
14:10
Added support for LIMIT. (CVS 302) file: [13aa0a55] check-in: [17701224] user: drh branch: trunk, size: 12974
2001-10-19
16:44
Version 2.0.6 (CVS 291) file: [75af1946] check-in: [8467d84f] user: drh branch: trunk, size: 12802
2001-10-18
12:34
Support for UTF-8 and ISO8859 characters in identifiers. Bug fix in the column name generator for selects (was coreing). (CVS 290) file: [129c0188] check-in: [22948fc6] user: drh branch: trunk, size: 12117
2001-10-15
00:44
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) file: [5f47445f] check-in: [747bf1b3] user: drh branch: trunk, size: 11833
2001-10-06
16:33
Adding table column query capability to support ODBC. (CVS 278) file: [b59e8c71] check-in: [b63b3f36] user: drh branch: trunk, size: 11449
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [e0c3ff05] check-in: [4e926efe] user: drh branch: trunk, size: 10975
2001-04-12
23:21
More testing (CVS 209) file: [22350765] check-in: [3bde1284] user: drh branch: trunk, size: 11517
2001-04-04
11:48
Added transaction support (CVS 196) file: [824d9d50] check-in: [35a8feed] user: drh branch: trunk, size: 9592
2000-07-29
13:06
better column labels in select results (CVS 110) file: [68ff778c] check-in: [3bf434d9] user: drh branch: trunk, size: 9075
2000-06-21
13:59
:-) (CVS 104) file: [4e57b0b5] check-in: [e1bf96a4] user: drh branch: trunk, size: 9083
2000-06-07
15:11
:-) (CVS 70) file: [64703852] check-in: [d3baa046] user: drh branch: trunk, size: 9078
14:42
:-) (CVS 1697) file: [55af6d31] check-in: [5d773b5d] user: drh branch: trunk, size: 8903
2000-06-06
17:27
GROUP BY and HAVING installed (CVS 58) file: [2311bddd] check-in: [db88a0c2] user: drh branch: trunk, size: 8899
2000-05-31
18:20
:-) (CVS 25) file: [a0b00df7] check-in: [35a8f523] user: drh branch: trunk, size: 8922
17:59
:-) (CVS 24) file: [b994637d] check-in: [4cd98eba] user: drh branch: trunk, size: 8179 Added