Changeset: 5d6fc16e391d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5d6fc16e391d
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
These steps make the table corrupted. Reproducible on Jun2020 branch, so it
wasn't due to my changes
diffs (17 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -224,6 +224,13 @@ DROP TABLE t0;
DROP TABLE t1;
DROP TABLE t2;
+CREATE TABLE t0(c0 CHAR(473) UNIQUE, c1 INTERVAL SECOND UNIQUE NOT NULL);
+ALTER TABLE t0 ADD UNIQUE(c0, c1);
+DROP INDEX t0_c1_unique;
+INSERT INTO t0 VALUES ('Qnec4v3|', INTERVAL '2071616848' SECOND), ('B',
INTERVAL '2052804659' SECOND), (NULL, INTERVAL '2052029418' SECOND);
+UPDATE t0 SET c1 = INTERVAL '916700621' SECOND; --error, unique constraint
violated
+DROP TABLE t0;
+
START TRANSACTION;
CREATE TABLE "sys"."t0" ("c0" CHAR(473),"c1" INTERVAL SECOND NOT NULL,
CONSTRAINT "t0_c0_unique" UNIQUE ("c0"),
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
