Artifact bdf18bbc8a2347b09d8d14d92765fd1f14b745de:
- File proto/random/select/slt_good_125.proto — part of check-in [db2551f6d3] at 2008-12-08 01:02:58 on branch trunk — 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. (user: shaneh size: 707)
- File proto/random/select/slt_good_126.proto — part of check-in [db2551f6d3] at 2008-12-08 01:02:58 on branch trunk — 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. (user: shaneh size: 707)
- File test/random/select/slt_good_125.test — part of check-in [577c81ab01] at 2008-12-08 01:29:59 on branch trunk — Added .test versions of random\select\slt_good*.proto scripts as all cases pass SQLite, MSSQL, and MySQL. (user: shaneh size: 707)
- File test/random/select/slt_good_126.test — part of check-in [577c81ab01] at 2008-12-08 01:29:59 on branch trunk — Added .test versions of random\select\slt_good*.proto scripts as all cases pass SQLite, MSSQL, and MySQL. (user: shaneh size: 707)
hash-threshold 8 statement ok CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok INSERT INTO tab0 VALUES(89,91,82) statement ok INSERT INTO tab0 VALUES(35,97,1) statement ok INSERT INTO tab0 VALUES(24,86,33) statement ok INSERT INTO tab1 VALUES(64,10,57) statement ok INSERT INTO tab1 VALUES(3,26,54) statement ok INSERT INTO tab1 VALUES(80,13,96) statement ok INSERT INTO tab2 VALUES(7,31,27) statement ok INSERT INTO tab2 VALUES(79,17,38) statement ok INSERT INTO tab2 VALUES(78,59,26)