sqllogictest

Timeline
Login

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

168 check-ins using file test/select5.test version 5063a1dec5

2024-11-15
00:01
Enhanced to verify that the correct number of rows is returned from each query. See SQLite Forum post 115a6fedd9. Leaf check-in: c5ec0e8e41 user: drh tags: trunk
2024-10-18
16:23
Update the built-in SQLite to the latest 3.47.0 beta. check-in: 7dda571435 user: drh tags: trunk
2024-05-21
22:03
Update the built-in SQLite to the 3.46.0 release candidate. check-in: 38790915ca user: drh tags: trunk
2024-01-12
20:22
Update the built-in SQLite to the latest 3.45.0 beta. check-in: 40cd78f7e8 user: drh tags: trunk
2023-10-30
19:21
Update the built-in SQLite to the latest 3.44.0 release candidate. check-in: 1236e2ddf4 user: drh tags: trunk
2023-10-25
12:59
Update the built-in SQLite to the latest 3.44.0 beta. check-in: 2dbcd3895a user: drh tags: trunk
2023-05-12
19:51
Update the built-in SQLite to the latest 3.42.0 beta. check-in: 756a41c25b user: drh tags: trunk
2023-02-19
20:28
Update the built-in SQLite to the latest beta. check-in: a22803965e user: drh tags: trunk
2023-02-06
17:27
Update the built-in SQLite to the latest 3.41.0 alpha version. check-in: df6e45280f user: drh tags: trunk
2022-11-14
16:25
Update SQLite to the 3.40.0 rc1 version. check-in: 6698644b2e user: drh tags: trunk
2022-11-07
16:13
Update the built-in SQLite to the latest 3.40.0 beta. check-in: ec19b41c79 user: drh tags: trunk
12:19
Update requirements marks to match typo corrections in the documentation. check-in: e6b18bef1a user: drh tags: trunk
2022-06-24
00:40
Update the built-in SQLite to the 3.39.0 beta. check-in: 2d3ce36eda user: drh tags: trunk
2022-02-19
14:07
Update the built-in SQLite to the latest 3.38.0 beta. check-in: 88723bbfd3 user: drh tags: trunk
2022-01-21
19:25
Update requirements marks due to typo fixes in the documentation. check-in: 0932e86618 user: drh tags: trunk
2021-11-22
23:08
Update the built-in SQLite to the 3.37.0 beta. check-in: 276631a489 user: drh tags: trunk
2021-06-17
14:41
Update to the latest 3.36.0 beta. check-in: f2c74c0f78 user: drh tags: trunk
2021-06-15
19:54
Update the built-in SQLite to a 3.36.0 beta. check-in: d0fafffa9d user: drh tags: trunk
2021-03-11
00:20
Update the built-in SQLite to 3.35.0 beta 3. check-in: d2ce33a5a0 user: drh tags: trunk
2021-01-14
20:00
Update the run-all.tcl script to disable more optimizations. Add the latest SQLite source code. check-in: c2bed6479c user: drh tags: trunk
2020-11-24
16:07
Update the built-in SQLite to the first 3.34.0 beta. check-in: 6a36801010 user: drh tags: trunk
2020-08-11
19:09
Update the built-in SQLite to the 3.33.0 beta 2. check-in: e09cd5dd1f user: drh tags: trunk
2020-05-18
20:32
Update the built-in SQLite to the latest 3.32.0 beta. check-in: c25acac6f8 user: drh tags: trunk
2020-05-15
16:06
Adjustment to evidence mark. No code changes. check-in: cd9a67b547 user: drh tags: trunk
2020-01-18
16:31
Update the built-in SQLite to 3.31.0 beta. check-in: 3d90c32e55 user: drh tags: trunk
2019-09-28
19:29
Update the built-in SQLite to the first 3.30.0 beta. check-in: 0b85555747 user: drh tags: trunk
2019-07-08
20:51
Update the built-in SQLite to the first 3.29.0 beta. check-in: bf409a4f2c user: drh tags: trunk
2019-04-15
14:24
Update the built-in SQLite to the 3.28.0 beta. check-in: 865a75877d user: drh tags: trunk
2019-02-06
16:28
Update the built-in SQLite to the latest 3.27.0 beta. check-in: 40b4bc94f8 user: drh tags: trunk
2018-11-27
22:13
Update the built-in SQLite to the latest 3.26.0 beta. check-in: 7ecd9f43d7 user: drh tags: trunk
2018-09-12
14:31
Update the built-in SQLite to the first 3.25.0 release candidate. check-in: 0756e950c1 user: drh tags: trunk
2018-05-30
01:40
Update the built-in SQLite to the first 3.24.0 beta. check-in: f50f35585d user: drh tags: trunk
2018-03-28
20:02
Update the built-in SQLite to the first 3.23.0 beta. check-in: 573f24b86a user: drh tags: trunk
2018-01-15
22:41
Update the built-in SQLite to the first 3.22.0 beta check-in: 6996cda303 user: drh tags: trunk
2017-10-21
19:14
Update the built-in SQLite to the second 3.21.0 beta. check-in: 2282cb63b7 user: drh tags: trunk
2017-07-25
18:42
Update the built-in SQLite to the second release candidate for 3.20.0. check-in: 0dfbb06ddb user: drh tags: trunk
2017-07-15
14:42
Update the built-in SQLite to the 3.20.0 release candidate. check-in: 1b31f96adf user: drh tags: trunk
2017-07-14
00:22
Update the built-in SQLite to the first 3.20.0 beta. check-in: 7ff30b6479 user: drh tags: trunk
2017-05-13
20:31
Update the built-in SQLite to the first 3.19.0 beta. Add -DSQLITE_DEBUG to the Makefile.no-odbc. Fix a compiler warning in sqllogictest.c. check-in: 2e07d66b27 user: drh tags: trunk
2017-03-27
15:15
Update the built-in SQLite to the 3rd 3.18.0 beta. check-in: db74fbad74 user: drh tags: trunk
2017-02-08
18:31
Adjust two requirement marks due to clarification of wording. check-in: 2f02c1ea3e user: drh tags: trunk
18:06
Update the built-in SQLite to the second 3.17.0 beta. check-in: 3a2664ec08 user: drh tags: trunk
2016-12-30
20:22
Update the built-in SQLite to the latest 3.16.0 beta. check-in: 32c0710fcb user: drh tags: trunk
2016-11-22
19:15
Updates to requirement marks. No code changes. check-in: 484d0e58e0 user: drh tags: trunk
2016-10-05
19:09
Update the built-in SQLite to the 3.15.0 beta. check-in: ef3b86baac user: drh tags: trunk
2016-08-01
17:55
Update the built-in SQLite to the 3.14 first beta. check-in: 4c1e2803a4 user: drh tags: trunk
2016-05-09
22:42
Update the built-in SQLite to the first 3.13.0 beta. check-in: 4a395f191d user: drh tags: trunk
2016-03-23
11:52
Update the built-in SQLite to the second 3.12.0 beta. check-in: 2422daf88f user: drh tags: trunk
2016-02-15
17:37
Version 3.11.0 check-in: ff12ab8446 user: drh tags: trunk, release, version-3.11.0
2016-02-13
02:07
Update SQLite to a 3.11.0 release candidate. check-in: f23cc7bd57 user: drh tags: trunk
2016-02-09
22:14
Update the built-in SQLite to the latest 3.11.0 beta. check-in: 5acb229d1c user: drh tags: trunk
2016-01-04
21:04
Bring in the latest SQLite 3.10.0 beta. check-in: 08c712f2f6 user: drh tags: trunk
2015-10-10
22:39
Add Makefile for MSVC, making #ifdef adjustments as necessary. check-in: 7a6b266590 user: mistachkin tags: trunk
18:53
Another SQLite 3.9.0 beta. check-in: 7f101da5c9 user: drh tags: trunk
13:45
Update the built-in SQLite to the first 3.9.0 beta. check-in: f0b45ac9a5 user: drh tags: trunk
2015-10-07
20:51
Update the built-in SQLite to the first 3.8.12 beta. check-in: be219301cd user: drh tags: trunk
2015-09-28
14:58
Update the built-in SQLite to the 3.8.12 alpha version that includes the ONEPASS bug fix. check-in: c70107362d user: drh tags: trunk
12:06
Add command-line options --halt and --trace. Add the "integrity_check" parameter to the SQLite3 engine that runs integrity_check after each statement. Enhance the SQLite3 engine to report memory leaks. check-in: 8828b124a6 user: drh tags: trunk
11:00
Update built-in SQLite to 3.8.12 alpha. Allow two prefix dashes on command-line options. Omit run-all.sh and rely on run-all.tcl for testing. Use all optimizer bits for the optimizer off tests in run-all.tcl. check-in: fcd2cc6991 user: drh tags: trunk
2015-09-11
20:54
Fix evidence marks due to wording changes. check-in: 62245fe6d0 user: drh tags: trunk
2015-07-24
00:37
Add the "run-all.tcl" script that runs all --verify tests and summarizes the output, and that works on both unix and windows. check-in: a9ccd7d797 user: drh tags: trunk
00:03
Update the built-in SQLite to the second 3.8.11 beta. check-in: ac688c398e user: drh tags: trunk
2015-05-06
01:28
Check in the second 3.8.10 beta. check-in: 3f320d5068 user: drh tags: trunk
2015-04-06
20:40
Update the built-in SQLite to the third 3.8.9 beta. check-in: 21890161c0 user: drh tags: trunk
2015-01-15
19:43
Update SQLite to the latest 3.8.8 release candidate. check-in: 22f3649555 user: drh tags: trunk
2015-01-06
16:11
Update the built-in SQLite code to version 3.8.8 alpha. check-in: f7c7ebfb61 user: drh tags: trunk
2014-11-18
16:07
Update the built-in SQLite to the 3.8.7.2 beta. check-in: c3054e4bf8 user: drh tags: trunk
2014-10-29
11:28
Update SQLite to the 3.8.7.1 beta. check-in: 4a7de5c09b user: drh tags: trunk
2014-10-15
18:28
Update the built-in SQLite to the 2014-10-15 beta of 3.8.7. check-in: 23d10a6b2c user: drh tags: trunk
2014-10-09
12:51
Update the built-in SQLite to 3.8.7 beta. check-in: 06e0b89fc2 user: drh tags: trunk
2014-08-14
00:08
Add the SQLite amalgamation for 3.8.6 beta. check-in: fc61d411c0 user: drh tags: trunk
2014-06-03
15:26
Incorporate the latest SQLite 3.8.5-beta changes. check-in: b26d5e2abc user: drh tags: trunk
11:45
Update to the 3.8.5 beta under test. check-in: 6950594f20 user: drh tags: trunk
2014-03-06
20:18
Update to the latest 3.8.4 beta from upstream. check-in: 8e0f0b0fc2 user: drh tags: trunk
2014-03-05
19:27
Update the built-in SQLite to 3.8.4 beta. check-in: ba3a2680e0 user: drh tags: trunk
2014-02-11
07:54
Skip MSSQL for several tests that are incompatible with it. check-in: bf3dafd972 user: mistachkin tags: trunk
07:40
Use standard engine naming for PostgreSQL as the tests already rely on it. check-in: b5e970313f user: mistachkin tags: trunk
07:21
Enhance support for recent versions of PostgreSQL. check-in: 1694a55bf7 user: mistachkin tags: trunk
2014-01-28
18:11
Update the built-in SQLite to the latest 3.8.3 beta. Fix a compiler warning in the md5.c module. check-in: 13832ba988 user: drh tags: trunk
2013-12-04
14:57
Update the built-in SQLite to the third 3.8.2 release candidate. check-in: 63f9fb8e47 user: drh tags: trunk
2013-11-26
20:34
Import latest SQLite from upstream. check-in: 50ffe6bef8 user: drh tags: trunk
2013-10-14
13:44
Update to the SQLite 3.8.1 beta. check-in: d206057b31 user: drh tags: trunk
2013-08-31
20:22
Rename the PostgreSQL DSN in the test batch file for consistency. check-in: ca64580860 user: mistachkin tags: trunk
20:19
Add batch files for testing purposes. check-in: f47d6cdfda user: mistachkin tags: trunk
2013-08-22
12:48
Update SQLite to the 3.8.0 beta with performance optimizations and deferred automatic indices. check-in: 7c52fd2246 user: drh tags: trunk
2013-08-20
23:18
Update to the SQLite 3.8.0 beta. check-in: c81107f210 user: drh tags: trunk
2013-05-16
01:04
Update to the SQLite version that fixes HAVING clause name resolution. check-in: 75cc8dafb2 user: drh tags: trunk
2013-05-15
23:47
Update SQLite to the 3.7.17 beta. check-in: 534b8ec9f0 user: drh tags: trunk
2013-03-13
01:51
Update the built-in SQLite to include the fixes to ORDER BY and IN that where discovered by the previous import. check-in: 9d717e74e7 user: drh tags: trunk
2013-03-12
16:31
Import the latest 3.7.16 beta from upstream. check-in: a026475c38 user: drh tags: trunk
2012-12-11
00:58
Update the SQLite core from upstream. This update includes the COLLATE expression refactor and other minor fixes. check-in: 99340f5906 user: drh tags: trunk
2012-12-05
15:03
Pull in an SQLite amalgamation 3.7.15 beta. check-in: 13409d2824 user: drh tags: trunk
15:02
Fix aggregate function evidence tests to work with the scan-by-index optimization. check-in: fb12af96c2 user: drh tags: trunk
04:43
Improve the ability to compile and test on Windows using MinGW. check-in: b5fbadd16e user: mistachkin tags: trunk
2012-08-30
13:58
Update the built-in SQLite amalgamation to a 3.7.14 beta. check-in: 3a6f90e718 user: drh tags: trunk
2012-06-10
01:14
Update SQLite to the 3.7.13 beta. check-in: cca587b0a4 user: drh tags: trunk
2012-05-14
01:48
Update to SQLite version 3.7.12 check-in: e41449241c user: drh tags: trunk
2012-05-12
02:44
Update the built-in SQLite to the latest 3.7.12 beta. check-in: f003563216 user: drh tags: trunk
2012-03-19
15:24
Update to SQLite version 3.7.11-beta check-in: 9e7d09c07c user: drh tags: trunk
2012-01-11
18:07
Update the built-in SQLite to the 3.7.10 beta. check-in: 9351002d37 user: drh tags: trunk
2011-10-29
18:39
Check in the 3.7.9 release candidate SQLite amalgamation. check-in: 9a5a8acdb7 user: drh tags: trunk
2011-09-17
18:03
Update the built-in SQLite amalgamation to the latest 3.7.8 beta. check-in: b568f2d8e4 user: drh tags: trunk
2011-09-14
15:48
Update the built-in SQLite to the latest 3.7.8 beta. check-in: 446fec4ebe user: drh tags: trunk
2011-08-26
13:29
Update the built-in SQLite to the latest trunk build. check-in: c70e29bd81 user: drh tags: trunk
2011-06-23
18:46
Update the SQLite sources to the version 3.7.7 release candidate. check-in: a0ab881592 user: drh tags: trunk
17:33
Fixes to evidence marks. check-in: b1158b0aff user: drh tags: trunk
2011-05-26
01:15
Updates makefiles to work with a standard amalgamation. Update the built-in SQLite to be the latest 3.7.7 alpha. check-in: 5a2901cd3d user: drh tags: trunk
2011-04-11
20:51
Add Windows equiv or run-all.sh. check-in: 4a969aec8c user: shaneh tags: trunk
2011-01-25
20:41
Update to the SQLite 3.7.5 beta. check-in: d3e28e8083 user: drh tags: trunk
2010-12-07
03:38
More changes in support of evidence testing. check-in: fb75130b8f user: drh tags: trunk
03:33
Update makefiles to build SQLite with the necessary options. Update SQLite to the latest version. Change run-all.sh so that it runs tests in sorted order. check-in: ab656a0873 user: drh tags: trunk
02:30
Add the --parameters command-line option. If the argument is optimizer=N with N a number, then on the SQLite engine, invoke sqlite3_test_control() to disable the optimizations identified by bitmask N. Update the run-all.sh script so that all tests are run three times with different optimizer settings - to verify that the same answers are generated regardless. check-in: 3a0c7f7549 user: drh tags: trunk
2010-12-06
21:13
Update the built-in SQLite amalgamation to a version 3.7.4 release candidate. check-in: d8af10c23b user: drh tags: trunk
2010-11-30
09:50
Update some evidence marks in slt_lang_dropview.test to account for updated documentation text. check-in: 18a6b7f09c user: dan tags: trunk
2010-09-25
04:03
Evidence tests for aggregate functions. check-in: 1ab2242b4f user: shaneh tags: trunk
2010-09-24
18:59
Update to SLT evidence marks. check-in: 04ea7ef2df user: shaneh tags: trunk
2010-09-01
18:52
Basic evidence tests for REPLACE. check-in: 9b2ad097cb user: shaneh tags: trunk
2010-08-10
04:29
Some evidence testing for views; check-in: eaf2c620e1 user: shaneh tags: trunk
04:23
Added evidence testing for triggers; check-in: 15543e896a user: shaneh tags: trunk
03:33
Evidence testing of SQLite SQL language. check-in: 99714e1f5b user: shaneh tags: trunk
2010-08-02
19:07
Better support for the Oracle ODBC interface; Added option to xStatement to suppress printing of errors. check-in: 81505d3c5f user: shaneh tags: trunk
2010-07-21
14:44
Some more tests of the in-op that work on MS SQL Server, Oracle, and MySQL. check-in: cf9bd258b0 user: shaneh tags: trunk
2010-07-20
06:43
First pass at adding evidence marks for the IN op. check-in: cf59d2c530 user: shaneh tags: trunk
2010-07-09
20:22
Update the SQLite amalgamation to version 3.7.0rc1. check-in: f85e976988 user: drh tags: trunk
2010-07-02
20:00
Update the SQLite amalgamation to the latest trunk check-in. check-in: 1d627f5850 user: drh tags: trunk
2010-03-09
16:52
Update SQLite to pre-3.6.23. check-in: 10318b880c user: drh tags: trunk
2010-01-05
15:58
Update the SQLite amalgamation to version 3.6.22 RC2. check-in: b23e3b6dbe user: drh tags: trunk
2009-11-02
17:53
Update the SQLite implementation to the 3.6.20 release candidate. check-in: 2c7d3524b6 user: drh tags: trunk
2009-10-14
11:16
Update SQLite to version 3.6.19. check-in: 4dc66b8b89 user: drh tags: trunk
2009-09-11
14:48
Add the logo image. check-in: 4997b20c29 user: drh tags: trunk
14:37
Get the new SQLite build working with SQLITE_OMIT_ANALYZE. check-in: e7138a41d3 user: drh tags: trunk
13:57
Update to the latest version of SQLite. check-in: 6912f911d5 user: drh tags: trunk
2009-08-10
13:27
Update the SQLite build to version 3.6.17. check-in: 1ed1dab9f0 user: drh tags: trunk
2009-06-23
14:56
Update to the latest version of SQLite. check-in: 62082e8586 user: drh tags: trunk
2009-05-06
16:58
Update the SQLite build to version 3.6.14. check-in: e6cd5e74a2 user: drh tags: trunk
2009-03-31
13:02
Update the SQLite core to version 3.6.12. check-in: c3a3dfe2cb user: drh tags: trunk
2009-03-23
15:27
Update the SQLite amalgamation to the latest code from CVS. check-in: 73f66663ec user: drh tags: trunk
2009-03-20
02:27
Test cases for views. check-in: d7cce3fca8 user: shaneh tags: trunk
2009-02-17
20:38
Update SQLite to version 3.6.11 (prerelease - CVS check-in 6298) check-in: efe8c1791f user: drh tags: trunk
2009-02-03
18:21
Update the SQLite library to include the new backup interface. check-in: 06f78f44e7 user: drh tags: trunk
18:18
Add the "run-all.sh" script. Add the SQLITE_NO_SYNC option to the Makefile. Add the no-ODBC makefile. check-in: ec2223d775 user: drh tags: trunk
16:35
Update the SQLite amalgamation to the latest from CVS. check-in: e2565741f0 user: drh tags: trunk
2009-01-23
23:53
Added more 'commute' test cases. Added simple tests for DELETE. check-in: 6b97c59722 user: shaneh tags: trunk
21:44
Fixed issue with MD5 hash possibly not being reset in a labeled query returning no results. check-in: 4a57829454 user: shaneh tags: trunk
21:37
Fixed issue with responses from ODBC3 drivers. check-in: 01ecc32bef user: shaneh tags: trunk
2009-01-16
16:15
Adjust the Makefile to omit unused features of SQLite. This makes coverage testing easier. check-in: 8a016b9169 user: drh tags: trunk
14:11
Update SQLite to version 3.6.10. check-in: 28ed264df2 user: drh tags: trunk
2009-01-14
01:14
Check-in [6173]. Version 3.6.8+. check-in: 47cf08460b user: shaneh tags: trunk
2009-01-13
21:07
More ORDER BY tests using the SLT "nosort" option on result sets. check-in: c2f3f9b476 user: shaneh tags: trunk
06:27
Removed the old random*.proto files as they are not needed. Generated a series of .test files for DBs with INDEXes based on email from DRH. Includes ORDER BY, IN, BETWEEN, commuted, and random expression testing. Tests included for table sizes of 10, 100, and 1000 rows. check-in: 3bb31cb87e user: shaneh tags: trunk
2008-12-24
05:05
Random SQL expressions. No FROM clauses. Passes on SQLite, MySQL, and MSSQL. check-in: 0748319a3a user: shaneh tags: trunk
2008-12-23
20:29
More updates for PostgreSQL compatibility. check-in: 9483eb157c user: shaneh tags: trunk
04:48
Updated to skip tests for PostgreSQL where output column is (re)named without an AS term. check-in: 9b5974b19a user: shaneh tags: trunk
2008-12-22
21:58
Send ODBC error messages to stderr instead of stdout. check-in: c715699ccb user: drh tags: trunk
21:23
Merged in the SQLite amalgamation update. check-in: d3b0d1eea2 user: drh tags: trunk
21:10
Test cases stressing aggregate functions. All tests pass on SQLite, MySQL, and MSSQL. check-in: c43d6f3f98 user: shaneh tags: trunk
2008-12-16
13:55
Update SQLite to CVS check-in 6031. check-in: d202f9faa0 user: drh tags: trunk
2008-12-11
05:16
Test cases for SQLite, MSSQL, and MySQL stressing GROUP BY, HAVING, and aggregate functions. check-in: e3edcb9099 user: shaneh tags: trunk
2008-12-08
01:29
Added .test versions of random\select\slt_good*.proto scripts as all cases pass SQLite, MSSQL, and MySQL. check-in: 577c81ab01 user: shaneh tags: trunk
01:02
Updated scripts so that all cases pass on SQLite, MSSQL, and MySQL. Many cases had "skipif mysql" and comparable "onlyif mysql" records added. Added labels between equivalent "onlyif mysql" and other queries. Made attempt to add "skipif postgresql" to queries with miss "AS" keywords. check-in: db2551f6d3 user: shaneh tags: trunk
00:58
Some cases that report different results between SQLite and MSSQL. check-in: 02c4b16a7a user: shaneh tags: trunk
00:57
Consistent line endings. check-in: 3200dc168f user: shaneh tags: trunk
00:54
Send summary line to stderr. check-in: 7a52c0f372 user: shaneh tags: trunk
2008-12-06
02:37
Update the about.wiki page to talk about the new skipif and onlyif modifiers and how to use them to work around database incompatibilities. check-in: 816758c2ee user: drh tags: trunk
02:02
Add the "onlyif" condition prefix. Implement hash checking of skipped by labeled queries in verify mode. check-in: 4e38bbb44f user: drh tags: trunk
2008-12-05
23:09
Initial set of test files with "random" selects. slt_bad_*.proto produced different results on the engines, or didn't run at all. slt_good_*.proto produced exactly the same results with both SQLite and MSSQL, with mostly the same results on MySQL. Will be updating these to skip more tests MySQL has problems with. check-in: 2663d48f3c user: shaneh tags: trunk
20:33
Added "skipif" logic. Added xGetEngineName() method to each interface. This may be different then the registered named for ODBC connections, "ODBC3". Various tweaks to error messges. check-in: 0a1f217d6b user: shaneh tags: trunk
2008-12-03
00:44
Add the select5 test script that stresses multi-way joins up to 64 deep. check-in: 599e260e37 user: drh tags: trunk