sqllogictest

Timeline
Login

Timeline

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

49 ancestors of 0748319a3a8ba9fe

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
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:44
Update the about.wiki to show the -odbc argument and to talk about the label parameter to query records. check-in: ccae19bc34 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
16:06
Fix the schema deleter in the ODBC3 driver so that it works with PostgreSQL. check-in: 0937105b6d user: drh tags: trunk
15:49
Fix an ODBC parameter that should not be NULL. check-in: c33e964f18 user: drh tags: trunk
15:22
Regened after changes to select2.tcl. check-in: 954bc6c11b user: shaneh tags: trunk
15:20
Consistent capitalization on error messages. check-in: 7edbc9e250 user: shaneh tags: trunk
15:19
Changed default hash threshold to 8. Added command line option -ht NUM that overrides any hash threshold in the test script (useful for debugging differences between DB engines). check-in: d1697d2d5f user: shaneh tags: trunk
15:16
Modified ODBC interface to check zType length on xQuery to be consistent with SQLite interface. check-in: d3d496700a 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
05:32
MSSQL doesn't like calling SQLGetData() twice on the same column for the same row. check-in: 4140649727 user: shaneh tags: trunk
04:57
Made the xQuery method of the odbc interface match the SQLite version more closely, honoring type information and formatting in the same manor. check-in: b5897694e8 user: shaneh tags: trunk
02:28
Added more error checking. Updated to allow specifing DSN and DATABASE name in -odbc option. check-in: 2014c5b9c3 user: shaneh tags: trunk
02:24
Updated usage. check-in: dafa60c487 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
20:02
Use a single -odbc CONNSTR command-line argument instead of -engine ODBC3 and -connection CONNSTR. Added hash-threshold and halt record types. Added the OMIT_ODBC compile-time option. check-in: 96bff359ee 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
04:54
Broke out SQLite interface; Added ODBC3 interface; Minor bug fixes. check-in: 86ab9a0ad0 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
13:09
Fix typos and poor wording in the about.wiki document. check-in: f30534fbb0 user: drh tags: trunk
01:58
Updates to the About document. check-in: 1e99bb8828 user: drh tags: trunk
00:37
First sample prototype script with its generator. check-in: c7bfa7e3cf user: drh tags: trunk
2008-11-29
22:50
Change the typestring character for strings from "S" to "T". check-in: 9c52972f34 user: drh tags: trunk
22:31
The sqllogictest program builds and runs on Linux. check-in: 2cffc96fd2 user: drh tags: trunk
21:44
Client-side sorting is not in place, but the rest compiles and links. check-in: 87d382225d user: drh tags: trunk
19:41
Initial check-in of untested code. check-in: 7ab3183840 user: drh tags: trunk
15:44
initial empty baseline check-in: 4342810c67 user: drh tags: trunk