Changeset: fd429e504b48 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd429e504b48
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
sql/test/SQLancer/Tests/sqlancer07.stable.err
sql/test/SQLancer/Tests/sqlancer07.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (110 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer07.sql
b/sql/test/SQLancer/Tests/sqlancer07.sql
--- a/sql/test/SQLancer/Tests/sqlancer07.sql
+++ b/sql/test/SQLancer/Tests/sqlancer07.sql
@@ -102,26 +102,24 @@ SELECT CASE '1' WHEN COALESCE((SELECT t0
-- 7 NULL rows
ROLLBACK;
-START TRANSACTION;
CREATE TABLE "t0" ("c1" VARCHAR(388) NOT NULL,CONSTRAINT "t0_c1_pkey" PRIMARY
KEY ("c1"),CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
INSERT INTO "t0" VALUES (''), ('Ral%}?U*A'), ('Dz '), ('P');
CREATE TABLE "t2" ("c1" VARCHAR(388) NOT NULL);
INSERT INTO "t2" VALUES
('4'),('4'),('3eSU8,'),(''),('5E~쟱'),('~'),('1386006226'),('0.19005213960704492'),('''{Mdd뒆VB'''),('\015%L%]'),('+'),(''),('㕚o+k');
select t0.c1 from t0 where (-5) in (case when t0.c1 then 1 end, (select -3
from t0));
- -- empty
+ -- error while converting empty string to bit
select t0.c1 from t0 where (-5) in (case when t0.c1 then 1 else -2 end,
(select -3 from t0, t2 where false));
- -- empty
-ROLLBACK;
+ -- error while converting empty string to bit
+DROP TABLE t0;
+DROP TABLE t2;
-START TRANSACTION;
CREATE TABLE t1 (c0 DOUBLE PRECISION NOT NULL);
-INSERT INTO t1(c0)
VALUES((0.6548429615298178*0.3050008736497528)/(0.5061323979270875));
-INSERT INTO t1(c0) VALUES(((((COALESCE(0.6548429615298178,
0.20317629894456002))*(COALESCE(0.3050008736497528,
0.2277902039419617))))/(0.5061323979270875)));
+INSERT INTO t1(c0)
VALUES((0.6548429615298178*0.3050008736497528)/(0.5061323979270875)); --error,
scale too large
+INSERT INTO t1(c0) VALUES(((((COALESCE(0.6548429615298178,
0.20317629894456002))*(COALESCE(0.3050008736497528,
0.2277902039419617))))/(0.5061323979270875))); --error, scale too large
SELECT t1.c0 FROM t1;
- -- 0.3946154725285108
- -- 0.3946154725285108
-ROLLBACK;
+ -- empty
+DROP TABLE t1;
START TRANSACTION;
CREATE TABLE "t0" ("c0" DECIMAL(18,3) NOT NULL,"c1" DOUBLE PRECISION NOT NULL);
diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.err
b/sql/test/SQLancer/Tests/sqlancer07.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer07.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer07.stable.err
@@ -19,6 +19,22 @@ MAPI = (monetdb) /var/tmp/mtest-240512/
QUERY = select 1 from t0, t1 inner join t0 on true;
ERROR = !SELECT: relation name "t0" specified more than once
CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-56630/.s.monetdb.38424
+QUERY = select t0.c1 from t0 where (-5) in (case when t0.c1 then 1 end,
(select -3 from t0));
+ERROR = !conversion of string '' to type bit failed.
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-56630/.s.monetdb.38424
+QUERY = select t0.c1 from t0 where (-5) in (case when t0.c1 then 1 else -2
end, (select -3 from t0, t2 where false));
+ERROR = !conversion of string '' to type bit failed.
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-57059/.s.monetdb.30988
+QUERY = INSERT INTO t1(c0)
VALUES((0.6548429615298178*0.3050008736497528)/(0.5061323979270875)); --error,
scale too large
+ERROR = !Scale (48) overflows type
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-57059/.s.monetdb.30988
+QUERY = INSERT INTO t1(c0) VALUES(((((COALESCE(0.6548429615298178,
0.20317629894456002))*(COALESCE(0.3050008736497528,
0.2277902039419617))))/(0.5061323979270875))); --error, scale too large
+ERROR = !Scale (49) overflows type
+CODE = 42000
# 10:16:14 >
# 10:16:14 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.out
b/sql/test/SQLancer/Tests/sqlancer07.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer07.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer07.stable.out
@@ -145,6 +145,42 @@ stdout of test 'sqlancer07` in directory
[ NULL ]
[ NULL ]
#ROLLBACK;
+#CREATE TABLE "t0" ("c1" VARCHAR(388) NOT NULL,CONSTRAINT "t0_c1_pkey" PRIMARY
KEY ("c1"),CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+#INSERT INTO "t0" VALUES (''), ('Ral%}?U*A'), ('Dz '), ('P');
+[ 4 ]
+#CREATE TABLE "t2" ("c1" VARCHAR(388) NOT NULL);
+#INSERT INTO "t2" VALUES
('4'),('4'),('3eSU8,'),(''),('5E~쟱'),('~'),('1386006226'),('0.19005213960704492'),('''{Mdd뒆VB'''),('\015%L%]'),('+'),(''),('㕚o+k');
+[ 13 ]
+#DROP TABLE t0;
+#DROP TABLE t2;
+#CREATE TABLE t1 (c0 DOUBLE PRECISION NOT NULL);
+#SELECT t1.c0 FROM t1;
+% sys.t1 # table_name
+% c0 # name
+% double # type
+% 24 # length
+#DROP TABLE t1;
+#START TRANSACTION;
+#CREATE TABLE "t0" ("c0" DECIMAL(18,3) NOT NULL,"c1" DOUBLE PRECISION NOT
NULL);
+#CREATE TABLE "t1" ("c1" DOUBLE PRECISION);
+#CREATE TABLE "t2" ("c0" DECIMAL(18,3),"c1" DOUBLE PRECISION);
+#SELECT (SELECT 1 FROM t1, t2, t0 JOIN (SELECT 1) AS sub0 ON (t1.c1) BETWEEN
(t2.c1) AND (t1.c1)) FROM t2, t0 CROSS JOIN t1;
+% .%2 # table_name
+% %2 # name
+% tinyint # type
+% 1 # length
+#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "t0" ("c0" BIGINT NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY KEY
("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+#INSERT INTO "t0" VALUES (0),(-1557127883),(-488477810);
+[ 3 ]
+#CREATE TABLE "t1" ("c0" BIGINT NOT NULL);
+#INSERT INTO "t1" VALUES (1457011207),(98933083),(1259938486);
+[ 3 ]
+#CREATE TABLE "t2" ("c0" BIGINT NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY KEY
("c0"));
+#INSERT INTO "t2" VALUES (596983192), (-601428889), (1688368391);
+[ 3 ]
+#ROLLBACK;
# 10:16:14 >
# 10:16:14 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
