sqllogictest
Timeline
Not logged in

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

16 check-ins that include changes to files matching 'proto/*'

2009-01-13
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-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: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
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
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
15:22
Regened after changes to select2.tcl. check-in: 954bc6c11b user: shaneh tags: trunk
14:25
Make sure the number of columns returned by the query matches the number of columns that the test script expects. Generate an error if they disagree. Fix a bug in select2.tcl that was causing the wrong number of columns to be generated. check-in: fdbe3f356a user: drh tags: trunk
14:05
Add the ability to label query results. Demonstrate the behavior with select3.tcl which permutes the terms of the WHERE clause. check-in: cdee9945da user: drh 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: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