Changeset: 2d05a0216453 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2d05a0216453
Branch: Oct2020
Log Message:
merged
diffs (26 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;
@@ -315,6 +313,8 @@ 0.713 1970-01-07
0.199 1970-01-07
0.109 1970-01-07
+SELECT count(*) FROM t1 WHERE t1.c0 <> ALL(SELECT '1' WHERE FALSE);
+ -- 40
SELECT t1.c0 FROM t1 WHERE t1.c0 <> ALL(SELECT DISTINCT
CAST(0.5646222839477373 AS INT) FROM t0, t1 WHERE (t0.c1) NOT BETWEEN
ASYMMETRIC (COALESCE(t0.c1, t0.c1)) AND (t0.c1));
-- 40 rows
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(t1.c0 <> ALL(SELECT
DISTINCT CAST(0.5646222839477373 AS INT) FROM t0, t1 WHERE (t0.c1) NOT BETWEEN
ASYMMETRIC (COALESCE(t0.c1, t0.c1)) AND (t0.c1)) AS INT) as count FROM t1) as
res;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
