sqllogictest

Timeline
Login

Timeline

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

42 check-ins that include changes to files matching 'test/*'

2022-11-07
12:19
Update requirements marks to match typo corrections in the documentation. check-in: e6b18bef1a 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
2020-05-15
16:06
Adjustment to evidence mark. No code changes. check-in: cd9a67b547 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
2016-11-22
19:15
Updates to requirement marks. No code changes. check-in: 484d0e58e0 user: drh tags: trunk
2015-09-11
20:54
Fix evidence marks due to wording changes. check-in: 62245fe6d0 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
2012-12-05
15:02
Fix aggregate function evidence tests to work with the scan-by-index optimization. check-in: fb12af96c2 user: drh tags: trunk
2011-06-23
17:33
Fixes to evidence marks. check-in: b1158b0aff user: drh tags: trunk
2010-12-07
03:38
More changes in support of evidence testing. check-in: fb75130b8f 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
2009-03-20
02:27
Test cases for views. check-in: d7cce3fca8 user: shaneh tags: trunk
2009-01-23
23:53
Added more 'commute' test cases. Added simple tests for DELETE. check-in: 6b97c59722 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:10
Test cases stressing aggregate functions. All tests pass on SQLite, MySQL, and MSSQL. check-in: c43d6f3f98 user: shaneh 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
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
2008-12-02
23:08
Extend the select4 test script to do lots of multi-way joins. check-in: e9c99b6893 user: drh tags: trunk
20:57
Revise the format of the hash string when the result set size exceeds the hash threshold. Use a named file for the SQLite database. Added select4. check-in: c236fecb76 user: drh tags: trunk
16:27
Update the references scripts in test/ to conform to the lastest prototypes and to the latest version of the sqllogictest program. check-in: 2024d548ed user: drh tags: trunk
15:22
Regened after changes to select2.tcl. check-in: 954bc6c11b user: shaneh tags: trunk
13:35
In select2.test, changed coalesce(a,b,c,d,e) in conditions to coalesce(a,b,c,d,e)<>0 to work with MSSQL. check-in: 1cc2a5df15 user: shaneh tags: trunk
2008-12-01
20:41
Fix the select2.test output. check-in: 8d24867c8a user: drh tags: trunk
20:39
Change the hash format to show the number of rows hashed. check-in: 6897209ec7 user: drh tags: trunk
20:33
Add the select2 test. Similar to select1 but adds NULL values and omits the ORDER BY clauses. check-in: 37156697d4 user: drh tags: trunk
14:42
Modified select1.* scripts to work with MS SQL (namely, removing OFFSET/LIMIT clauses); Fixed handle leak in slt_odbc3.c. check-in: 5c63a5e855 user: shaneh tags: trunk
2008-11-30
20:42
Fix the select1.proto test script so that avoids the use of NULL values. In about.wiki, warn user to not use NULL values together with ORDER BY. check-in: f84e0eed40 user: drh tags: trunk
00:37
First sample prototype script with its generator. check-in: c7bfa7e3cf user: drh tags: trunk