Changeset: 806cf12a9135 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=806cf12a9135
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
I overlooked. The issue is by removing the index, the constraint remains in the
catalog. So the constraint can be violated while is still there. Dependency
missing?
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,11 +224,9 @@ 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);
+CREATE TABLE t0(c1 INTERVAL SECOND UNIQUE);
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
+INSERT INTO t0 VALUES (INTERVAL '2071616848' SECOND), (INTERVAL '2071616848'
SECOND); --error, unique constraint violated
DROP TABLE t0;
START TRANSACTION;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
