Changeset: 1bd54bb58ca7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1bd54bb58ca7 Added Files: sql/test/SQLite_regress/sqllogictest/Tests/select6.test Modified Files: sql/test/SQLite_regress/sqllogictest/Tests/All Branch: default Log Message:
add new test for > 64 joins diffs (truncated from 2516 to 300 lines): diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/All b/sql/test/SQLite_regress/sqllogictest/Tests/All --- a/sql/test/SQLite_regress/sqllogictest/Tests/All +++ b/sql/test/SQLite_regress/sqllogictest/Tests/All @@ -3,3 +3,4 @@ select2 select3 select4 select5 +select6 diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select6.test b/sql/test/SQLite_regress/sqllogictest/Tests/select6.test new file mode 100644 --- /dev/null +++ b/sql/test/SQLite_regress/sqllogictest/Tests/select6.test @@ -0,0 +1,2503 @@ +statement ok +CREATE TABLE t1( + a1 INTEGER PRIMARY KEY, + b1 INTEGER, + x1 VARCHAR(40) +) + +statement ok +INSERT INTO t1 VALUES(1,1,'table t1 row 1') + +statement ok +INSERT INTO t1 VALUES(2,9,'table t1 row 2') + +statement ok +INSERT INTO t1 VALUES(3,8,'table t1 row 3') + +statement ok +INSERT INTO t1 VALUES(4,4,'table t1 row 4') + +statement ok +INSERT INTO t1 VALUES(5,2,'table t1 row 5') + +statement ok +INSERT INTO t1 VALUES(6,3,'table t1 row 6') + +statement ok +INSERT INTO t1 VALUES(7,6,'table t1 row 7') + +statement ok +INSERT INTO t1 VALUES(8,7,'table t1 row 8') + +statement ok +INSERT INTO t1 VALUES(9,10,'table t1 row 9') + +statement ok +INSERT INTO t1 VALUES(10,5,'table t1 row 10') + +statement ok +CREATE TABLE t2( + a2 INTEGER PRIMARY KEY, + b2 INTEGER, + x2 VARCHAR(40) +) + +statement ok +INSERT INTO t2 VALUES(1,7,'table t2 row 1') + +statement ok +INSERT INTO t2 VALUES(2,5,'table t2 row 2') + +statement ok +INSERT INTO t2 VALUES(3,9,'table t2 row 3') + +statement ok +INSERT INTO t2 VALUES(4,3,'table t2 row 4') + +statement ok +INSERT INTO t2 VALUES(5,2,'table t2 row 5') + +statement ok +INSERT INTO t2 VALUES(6,10,'table t2 row 6') + +statement ok +INSERT INTO t2 VALUES(7,8,'table t2 row 7') + +statement ok +INSERT INTO t2 VALUES(8,6,'table t2 row 8') + +statement ok +INSERT INTO t2 VALUES(9,4,'table t2 row 9') + +statement ok +INSERT INTO t2 VALUES(10,1,'table t2 row 10') + +statement ok +CREATE TABLE t3( + a3 INTEGER PRIMARY KEY, + b3 INTEGER, + x3 VARCHAR(40) +) + +statement ok +INSERT INTO t3 VALUES(1,6,'table t3 row 1') + +statement ok +INSERT INTO t3 VALUES(2,8,'table t3 row 2') + +statement ok +INSERT INTO t3 VALUES(3,3,'table t3 row 3') + +statement ok +INSERT INTO t3 VALUES(4,2,'table t3 row 4') + +statement ok +INSERT INTO t3 VALUES(5,4,'table t3 row 5') + +statement ok +INSERT INTO t3 VALUES(6,5,'table t3 row 6') + +statement ok +INSERT INTO t3 VALUES(7,9,'table t3 row 7') + +statement ok +INSERT INTO t3 VALUES(8,10,'table t3 row 8') + +statement ok +INSERT INTO t3 VALUES(9,1,'table t3 row 9') + +statement ok +INSERT INTO t3 VALUES(10,7,'table t3 row 10') + +statement ok +CREATE TABLE t4( + a4 INTEGER PRIMARY KEY, + b4 INTEGER, + x4 VARCHAR(40) +) + +statement ok +INSERT INTO t4 VALUES(1,2,'table t4 row 1') + +statement ok +INSERT INTO t4 VALUES(2,6,'table t4 row 2') + +statement ok +INSERT INTO t4 VALUES(3,10,'table t4 row 3') + +statement ok +INSERT INTO t4 VALUES(4,4,'table t4 row 4') + +statement ok +INSERT INTO t4 VALUES(5,1,'table t4 row 5') + +statement ok +INSERT INTO t4 VALUES(6,8,'table t4 row 6') + +statement ok +INSERT INTO t4 VALUES(7,7,'table t4 row 7') + +statement ok +INSERT INTO t4 VALUES(8,5,'table t4 row 8') + +statement ok +INSERT INTO t4 VALUES(9,3,'table t4 row 9') + +statement ok +INSERT INTO t4 VALUES(10,9,'table t4 row 10') + +statement ok +CREATE TABLE t5( + a5 INTEGER PRIMARY KEY, + b5 INTEGER, + x5 VARCHAR(40) +) + +statement ok +INSERT INTO t5 VALUES(1,9,'table t5 row 1') + +statement ok +INSERT INTO t5 VALUES(2,5,'table t5 row 2') + +statement ok +INSERT INTO t5 VALUES(3,10,'table t5 row 3') + +statement ok +INSERT INTO t5 VALUES(4,7,'table t5 row 4') + +statement ok +INSERT INTO t5 VALUES(5,4,'table t5 row 5') + +statement ok +INSERT INTO t5 VALUES(6,2,'table t5 row 6') + +statement ok +INSERT INTO t5 VALUES(7,1,'table t5 row 7') + +statement ok +INSERT INTO t5 VALUES(8,8,'table t5 row 8') + +statement ok +INSERT INTO t5 VALUES(9,3,'table t5 row 9') + +statement ok +INSERT INTO t5 VALUES(10,6,'table t5 row 10') + +statement ok +CREATE TABLE t6( + a6 INTEGER PRIMARY KEY, + b6 INTEGER, + x6 VARCHAR(40) +) + +statement ok +INSERT INTO t6 VALUES(1,2,'table t6 row 1') + +statement ok +INSERT INTO t6 VALUES(2,5,'table t6 row 2') + +statement ok +INSERT INTO t6 VALUES(3,9,'table t6 row 3') + +statement ok +INSERT INTO t6 VALUES(4,3,'table t6 row 4') + +statement ok +INSERT INTO t6 VALUES(5,1,'table t6 row 5') + +statement ok +INSERT INTO t6 VALUES(6,8,'table t6 row 6') + +statement ok +INSERT INTO t6 VALUES(7,10,'table t6 row 7') + +statement ok +INSERT INTO t6 VALUES(8,6,'table t6 row 8') + +statement ok +INSERT INTO t6 VALUES(9,4,'table t6 row 9') + +statement ok +INSERT INTO t6 VALUES(10,7,'table t6 row 10') + +statement ok +CREATE TABLE t7( + a7 INTEGER PRIMARY KEY, + b7 INTEGER, + x7 VARCHAR(40) +) + +statement ok +INSERT INTO t7 VALUES(1,1,'table t7 row 1') + +statement ok +INSERT INTO t7 VALUES(2,5,'table t7 row 2') + +statement ok +INSERT INTO t7 VALUES(3,3,'table t7 row 3') + +statement ok +INSERT INTO t7 VALUES(4,9,'table t7 row 4') + +statement ok +INSERT INTO t7 VALUES(5,8,'table t7 row 5') + +statement ok +INSERT INTO t7 VALUES(6,4,'table t7 row 6') + +statement ok +INSERT INTO t7 VALUES(7,2,'table t7 row 7') + +statement ok +INSERT INTO t7 VALUES(8,10,'table t7 row 8') + +statement ok +INSERT INTO t7 VALUES(9,6,'table t7 row 9') + +statement ok +INSERT INTO t7 VALUES(10,7,'table t7 row 10') + +statement ok +CREATE TABLE t8( + a8 INTEGER PRIMARY KEY, + b8 INTEGER, + x8 VARCHAR(40) +) + +statement ok +INSERT INTO t8 VALUES(1,3,'table t8 row 1') + +statement ok +INSERT INTO t8 VALUES(2,10,'table t8 row 2') + +statement ok +INSERT INTO t8 VALUES(3,8,'table t8 row 3') + +statement ok +INSERT INTO t8 VALUES(4,6,'table t8 row 4') + +statement ok +INSERT INTO t8 VALUES(5,7,'table t8 row 5') + +statement ok +INSERT INTO t8 VALUES(6,4,'table t8 row 6') + +statement ok +INSERT INTO t8 VALUES(7,2,'table t8 row 7') + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
