Changeset: 7c01f7e97d7e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c01f7e97d7e
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.stable.err
sql/test/SQLancer/Tests/sqlancer05.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (53 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.err
b/sql/test/SQLancer/Tests/sqlancer05.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer05.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.err
@@ -9,6 +9,10 @@ MAPI = (monetdb) /var/tmp/mtest-282348/
QUERY = INSERT INTO t1(c0) VALUES(INTERVAL '1474617942' SECOND), (NULL);
ERROR = !INSERT INTO: NOT NULL constraint violated for column t1.c0
CODE = 40002
+MAPI = (monetdb) /var/tmp/mtest-311844/.s.monetdb.34866
+QUERY = UPDATE t1 SET c0 = 0.28 WHERE (CAST(INTERVAL '31' MONTH AS STRING))
NOT IN (COALESCE('靟', 'P먌+}I*CpQ'));
+ERROR = !UPDATE: PRIMARY KEY constraint 't1.t1_c0_pkey' violated
+CODE = 40002
# 12:00:38 >
# 12:00:38 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.out
b/sql/test/SQLancer/Tests/sqlancer05.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer05.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.out
@@ -111,6 +111,35 @@ stdout of test 'sqlancer05` in directory
#NOT BETWEEN SYMMETRIC (COALESCE(TIMESTAMP '1969-12-30 12:07:22', TIMESTAMP
'1970-01-05 05:04:47')) AND (CASE WHEN TRUE THEN TIMESTAMP '1970-01-01
20:00:35' END)), 2);
[ 1 ]
#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t1" ("c0" TIMESTAMP NOT NULL,CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"));
+#CREATE TABLE "sys"."t2" ("c0" TIMESTAMP);
+#COPY 3 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#"1970-01-25 08:23:04.000000"
+#"1970-01-06 08:19:06.000000"
+#"1970-01-19 15:18:44.000000"
+[ 3 ]
+#create view v0(c0) as (select all -1454749390 from t2, t1 where not
+#((interval '990585801' month) in (interval '1558064353' month, interval
'1877885111' month, interval '1286819945' month)))
+#with check option;
+#ROLLBACK;
+#CREATE TABLE "sys"."t1" ("c0" DECIMAL(18,3) NOT NULL,CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"));
+#COPY 2 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#0.403
+#0.008
+[ 2 ]
+#DELETE FROM t1 WHERE (((0.86983466) IS NOT NULL) = TRUE) = TRUE;
+[ 2 ]
+#INSERT INTO t1(c0) VALUES(0.40), (0.75);
+[ 2 ]
+#SELECT c0 FROM t1;
+% sys.t1 # table_name
+% c0 # name
+% decimal # type
+% 20 # length
+[ 0.400 ]
+[ 0.750 ]
+#DROP TABLE t1;
# 12:00:38 >
# 12:00:38 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
