Changeset: 713cba7ff571 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=713cba7ff571
Added Files:
sql/test/prepare/Tests/prepare-complex.sql
Branch: mtest
Log Message:
add first test (moved from sqlancer07)
diffs (12 lines):
diff --git a/sql/test/prepare/Tests/prepare-complex.sql
b/sql/test/prepare/Tests/prepare-complex.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/prepare/Tests/prepare-complex.sql
@@ -0,0 +1,7 @@
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" DATE,"c2" INTEGER);
+CREATE TABLE "t1" ("c1" TIMESTAMP,"c2" INTEGER);
+CREATE TABLE "t2" ("c0" DATE,"c1" TIMESTAMP,"c2" INTEGER);
+PREPARE (SELECT ?, t1.c2 FROM t1, t0 WHERE (SELECT DISTINCT (t1.c2) BETWEEN
ASYMMETRIC (?) AND (t1.c2) FROM t1 CROSS JOIN
+((SELECT DISTINCT 6.9089063E7, TRUE FROM t2 WHERE TRUE) EXCEPT (SELECT ALL
0.4, FALSE FROM t2, t1 INNER JOIN t0 ON FALSE)) AS sub0 WHERE FALSE)) INTERSECT
DISTINCT (SELECT DISTINCT 0.2, ? FROM t0, t2 WHERE ?);
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
