sqllogictest
Timeline
Not logged in

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

50 descendants and 39 ancestors of [02c4b16a7a]

2010-12-07
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
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