Changeset: d993c5c0bc0a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d993c5c0bc0a
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.sql
sql/test/SQLancer/Tests/sqlancer09.stable.err
sql/test/SQLancer/Tests/sqlancer09.stable.out
Branch: Oct2020
Log Message:
Approved output and simplify further
diffs (43 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql
b/sql/test/SQLancer/Tests/sqlancer04.sql
--- a/sql/test/SQLancer/Tests/sqlancer04.sql
+++ b/sql/test/SQLancer/Tests/sqlancer04.sql
@@ -431,5 +431,5 @@ CREATE TABLE t1(c0 BOOLEAN, c1 DOUBLE);
ALTER TABLE t1 ADD PRIMARY KEY(c0, c1);
INSERT INTO t1(c1, c0) VALUES(0.3, FALSE), (0.5, true), (0.0, true), (4,
false), (1, true), (4, true);
DELETE FROM t1 WHERE NOT t1.c0;
-UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN 3 AND 7 + t1.c1;
+UPDATE t1 SET c1 = 0 WHERE t1.c1 > 3;
DROP TABLE t1;
diff --git a/sql/test/SQLancer/Tests/sqlancer09.stable.err
b/sql/test/SQLancer/Tests/sqlancer09.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer09.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer09.stable.err
@@ -55,6 +55,10 @@ QUERY = select all v0.vc2, greatest(min(
or(v0.vc1)) group by v0.vc1) as sub1 where (v0.vc0) in (0.06683239)
group by least(-1913343924, 10622),
ERROR = !overflow in conversion of 220424338 to sht.
CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-19665/.s.monetdb.32608
+QUERY = UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN SYMMETRIC 3 AND t1.c1;
+ERROR = !UPDATE: PRIMARY KEY constraint 't1.t1_c0_c1_pkey' violated
+CODE = 40002
# 14:35:03 >
# 14:35:03 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer09.stable.out
b/sql/test/SQLancer/Tests/sqlancer09.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer09.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer09.stable.out
@@ -482,6 +482,15 @@ stdout of test 'sqlancer09` in directory
#create or replace view v0(vc0, vc1, vc2) as (values (nullif(cast(220424338 as
smallint), case 0.04487378302689426501359548637992702424526214599609375 when
126710153 then 0.6929207132873739 when 26968 then 26968.0 when 1679982115 then
29 else 0.8204445662571608 end), cast(sql_min(r'', r'#Ts9.H') as boolean),
0.45182237213592768565462165497592650353908538818359375));
#create or replace view v1(vc0, vc1) as (select
round(0.80863825841427316998277774473535828292369842529296875,
0.6571010204254646), r'䝀i8jPo' where not (false));
#ROLLBACK;
+#CREATE TABLE t1(c0 BOOLEAN, c1 DOUBLE);
+#INSERT INTO t1(c0) VALUES(true);
+[ 1 ]
+#TRUNCATE t1;
+[ 1 ]
+#ALTER TABLE t1 ADD PRIMARY KEY(c0, c1);
+#INSERT INTO t1(c1, c0) VALUES(7,true),(5,false),(2,true),(4,false);
+[ 4 ]
+#DROP TABLE t1;
# 14:35:03 >
# 14:35:03 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
