Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/select1.test
|
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 | |