Changeset: b28a5ef63a53 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b28a5ef63a53
Added Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Modified Files:
sql/test/SQLancer/Tests/All
Branch: Oct2020
Log Message:
SQLancer: GDK reported error: project_oid: does not match always
diffs (26 lines):
diff --git a/sql/test/SQLancer/Tests/All b/sql/test/SQLancer/Tests/All
--- a/sql/test/SQLancer/Tests/All
+++ b/sql/test/SQLancer/Tests/All
@@ -2,3 +2,4 @@ sqlancer01
sqlancer02
sqlancer03
sqlancer04
+sqlancer05
diff --git a/sql/test/SQLancer/Tests/sqlancer05.sql
b/sql/test/SQLancer/Tests/sqlancer05.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer05.sql
@@ -0,0 +1,13 @@
+CREATE TABLE "sys"."t1" (
+ "c0" INTERVAL SECOND NOT NULL,
+ CONSTRAINT "t1_c0_pkey" PRIMARY KEY ("c0"),
+ CONSTRAINT "t1_c0_unique" UNIQUE ("c0")
+);
+INSERT INTO t1(c0) VALUES(INTERVAL '1474617942' SECOND), (NULL);
+INSERT INTO t1(c0) VALUES(INTERVAL '1427502482' SECOND), (INTERVAL
'-1598854979' SECOND);
+DELETE FROM t1 WHERE CASE r'FALSE' WHEN r'879628043' THEN TRUE ELSE
((((t1.c0)>=(t1.c0)))OR(((TRUE)OR(TRUE)))) END;
+INSERT INTO t1(c0) VALUES(INTERVAL '236620278' SECOND);
+INSERT INTO t1(c0) VALUES(INTERVAL '1448897349' SECOND);
+DELETE FROM t1 WHERE CAST(TRUE AS BOOLEAN);
+ -- all rows deleted
+DROP TABLE sys.t1;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
