Changeset: 046b0acdf2f1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=046b0acdf2f1
Modified Files:
sql/test/SQLancer/Tests/sqlancer09.sql
sql/test/SQLancer/Tests/sqlancer09.stable.err
sql/test/SQLancer/Tests/sqlancer09.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (109 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer09.sql
b/sql/test/SQLancer/Tests/sqlancer09.sql
--- a/sql/test/SQLancer/Tests/sqlancer09.sql
+++ b/sql/test/SQLancer/Tests/sqlancer09.sql
@@ -227,7 +227,9 @@ START TRANSACTION;
create or replace view v74(vc0, vc1) as (values (-1, 0.014)) with check option;
create or replace view v84(vc0, vc1) as (values (1, 1222), (12,10)) with check
option;
select 1 from v74 cross join v84 join (values ('b'), ('a'), (1)) as sub0 on
(v84.vc0)^(-9223372036854775807) is not null;
+ROLLBACK;
+START TRANSACTION;
create or replace view v74(vc0, vc1) as (values (cosh(case 0.82292664 when
0.3286772 then least(-1542994811, 28216) end),
abs(round(0.014417256786389054, 1390068457)))) with check option;
@@ -243,7 +245,7 @@ end as string)), (case ((+ (0.07023401))
then r'n%y]' when cast(case 599601669 when 993501855 then 934684161 when
1426216310 then -46477174
when 0.326376321343257114193647794309072196483612060546875 then 1762363571
else 1836924027 end as int) then ltrim(r'<>?')
else splitpart(cast(126 as string), cast(1768691589 as string), 21) end)) as
sub0 on (((((v84.vc0)^(-9223372036854775807)))
-is not null)and(cast(lower(r'2') as boolean)));
+is not null)and(cast(true as boolean)));
ROLLBACK;
START TRANSACTION;
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
@@ -13,6 +13,18 @@ MAPI = (monetdb) /var/tmp/mtest-349169/
QUERY = values (0.51506835), (2), (least('a', 0.5667308));
ERROR = !value too long for type (var)char(8)
CODE = 22001
+MAPI = (monetdb) /var/tmp/mtest-307586/.s.monetdb.36528
+QUERY = select 1 from v74 cross join v84 join (values ('b'), ('a'), (1)) as
sub0 on (v84.vc0)^(-9223372036854775807) is not null;
+ERROR = !overflow in calculation 1XOR-9223372036854775807.
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-307586/.s.monetdb.36528
+QUERY = select all count(all least(((null)*(v74.vc1)), cast(0.7407841 as
bigint))) from v74 cross join v84 join (values
+ (cast(cast(((-1660927937)+(-1322418229)) as bigint) as string)),
(cast(case upper(r'#+6') when least(r'', r'l9O+,s5?')
+ then r'0.8101890506861533' when greatest(r'', r'B+') then
sql_max(r'?''', r'E|!H4p') else cast(0.6526341396196464 as string(381))
+ end as string)), (case ((+ (0.07023401))/(- (1190953480))) when
((((-1138638151)>>(31055)))*(least(-1433171609, 0.67441124)))
+ then r'n%y]' when cast(case 599601669 when 993501855 then 934684161
when 1426216310 then -46477174
+ERROR = !overflow in calculation 1XOR-9223372036854775807.
+CODE = 22003
# 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
@@ -63,20 +63,6 @@ stdout of test 'sqlancer09` in directory
[ 0 ]
#ROLLBACK;
#START TRANSACTION;
-#CREATE TABLE "sys"."t0" ("c0" TIME NOT NULL, "c1" VARCHAR(143),
-# CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"), CONSTRAINT "t0_c0_unique"
UNIQUE ("c0"), CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
-#COPY 7 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
-#21:19:08 ""
-#13:02:49 NULL
-#01:02:11 NULL
-#16:34:25 NULL
-#12:11:43 NULL
-#10:35:38 NULL
-#04:26:50 NULL
-[ 7 ]
-#CREATE TABLE "sys"."t1" ("c0" CHAR(375) NOT NULL, CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"), CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES
"sys"."t0" ("c1"));
-#ROLLBACK;
-#START TRANSACTION;
#CREATE TABLE "sys"."t1" ("c0" BIGINT);
#COPY 4 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
#1096730569
@@ -262,6 +248,40 @@ stdout of test 'sqlancer09` in directory
[ 1 ]
[ 1 ]
#ROLLBACK;
+#START TRANSACTION;
+#create or replace view v74(vc0, vc1) as (values (-1, 0.014)) with check
option;
+#create or replace view v84(vc0, vc1) as (values (1, 1222), (12,10)) with
check option;
+#ROLLBACK;
+#START TRANSACTION;
+#create or replace view v74(vc0, vc1) as (values (cosh(case 0.82292664 when
0.3286772 then least(-1542994811, 28216) end),
+#abs(round(0.014417256786389054, 1390068457)))) with check option;
+#create or replace view v84(vc0, vc1) as (values (cast(not (least(false,
false)) as int), case when nullif(((-763905586)=(0.8063365267447331)),
+#"isauuid"(r'87')) then case ((-1573098947)%(0.22336472349933323)) when
nullif(7159, 26015) then ((-1216247830)*(-580027885))
+#when - (0.17724898013816237) then -1847868202 else - (-7.96515311E8) end else
0.854441498295166 end), (cast(not (false) as int),
+#greatest(scale_up(+ (48), 0.9562314161003085), ((- (85))+(-
(-1290129393)))))) with check option;
+#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t1" ("c0" DECIMAL(18,3),"c1" VARCHAR(253));
+#COPY 7 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#-804767602.000 ".c("
+#0.799 ".c("
+#0.763 ".c("
+#0.957 NULL
+#NULL "5"
+#NULL "j"
+#NULL "UXNW/#綒"
+[ 7 ]
+#CREATE TABLE "sys"."t2" ("c0" DECIMAL(18,3),"c1" VARCHAR(253),CONSTRAINT
"t2_c1_unique" UNIQUE ("c1"));
+#COPY 7 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#0.120 "0.2251036314022229"
+#0.120 "-677904380"
+#NULL "['퓵h'iI"
+#NULL "3128"
+#1.000 "+EUSP1"
+#0.968 "1403896159"
+#0.565 "0.8224972062481081"
+[ 7 ]
+#ROLLBACK;
# 14:35:03 >
# 14:35:03 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
