Changeset: e3dea1429c1e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e3dea1429c1e
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:
Make test query run (it gives wrong results) and added expected outputs
diffs (97 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
@@ -107,10 +107,12 @@ INSERT INTO "t0" VALUES (''), ('Ral%}?U*
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));
- -- 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));
- -- error while converting empty string to bit
+select t0.c1 from t0 where (5) in (case when t0.c1 = 'a' then 1 end, (select
3));
+ -- empty
+select t0.c1 from t0 where (5) in (case when t0.c1 = 'a' then 1 end, (select 3
from t0));
+ -- empty
+select t0.c1 from t0 where (-5) in (case when t0.c1 = 'a' then 1 else -2 end,
(select -3 from t0, t2 where false));
+ -- empty
DROP TABLE t0;
DROP TABLE t2;
@@ -138,6 +140,8 @@ INSERT INTO "t1" VALUES (1457011207),(98
CREATE TABLE "t2" ("c0" BIGINT NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY KEY
("c0"));
INSERT INTO "t2" VALUES (596983192), (-601428889), (1688368391);
+SELECT 1 FROM t2, t0 CROSS JOIN t1 WHERE t0.c0 % (SELECT 1 WHERE FALSE) <=
t1.c0;
+ -- empty
SELECT t1.c0 FROM t2, t0 CROSS JOIN t1 WHERE ((((t0.c0)%((SELECT DISTINCT
t0.c0 FROM t1, t0, t2 WHERE FALSE))))<=(t1.c0));
-- empty
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(((((t0.c0)%((SELECT
DISTINCT t0.c0 FROM t1, t0, t2 WHERE FALSE))))<=(t1.c0)) AS INT) as count FROM
t2, t0 CROSS JOIN t1) as res;
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,15 +19,7 @@ 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
+MAPI = (monetdb) /var/tmp/mtest-195720/.s.monetdb.38351
QUERY = INSERT INTO t1(c0)
VALUES((0.6548429615298178*0.3050008736497528)/(0.5061323979270875)); --error,
scale too large
ERROR = !Scale (48) overflows type
CODE = 42000
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
@@ -151,6 +151,21 @@ stdout of test 'sqlancer07` in directory
#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 ]
+#select t0.c1 from t0 where (5) in (case when t0.c1 = 'a' then 1 end, (select
3));
+% .t0 # table_name
+% c1 # name
+% varchar # type
+% 0 # length
+#select t0.c1 from t0 where (5) in (case when t0.c1 = 'a' then 1 end, (select
3 from t0));
+% .t0 # table_name
+% c1 # name
+% varchar # type
+% 0 # length
+#select t0.c1 from t0 where (-5) in (case when t0.c1 = 'a' then 1 else -2 end,
(select -3 from t0, t2 where false));
+% .t0 # table_name
+% c1 # name
+% varchar # type
+% 0 # length
#DROP TABLE t0;
#DROP TABLE t2;
#CREATE TABLE t1 (c0 DOUBLE PRECISION NOT NULL);
@@ -180,6 +195,22 @@ stdout of test 'sqlancer07` in directory
#CREATE TABLE "t2" ("c0" BIGINT NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY KEY
("c0"));
#INSERT INTO "t2" VALUES (596983192), (-601428889), (1688368391);
[ 3 ]
+#SELECT 1 FROM t2, t0 CROSS JOIN t1 WHERE t0.c0 % (SELECT 1 WHERE FALSE) <=
t1.c0;
+% .%4 # table_name
+% %4 # name
+% tinyint # type
+% 1 # length
+#SELECT t1.c0 FROM t2, t0 CROSS JOIN t1 WHERE ((((t0.c0)%((SELECT DISTINCT
t0.c0 FROM t1, t0, t2 WHERE FALSE))))<=(t1.c0));
+% sys.t1 # table_name
+% c0 # name
+% bigint # type
+% 1 # length
+#SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(((((t0.c0)%((SELECT
DISTINCT t0.c0 FROM t1, t0, t2 WHERE FALSE))))<=(t1.c0)) AS INT) as count FROM
t2, t0 CROSS JOIN t1) as res;
+% .%4 # table_name
+% %4 # name
+% bigint # type
+% 1 # length
+[ NULL ]
#ROLLBACK;
# 10:16:14 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
