Changeset: 785982196d52 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=785982196d52
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.sql
sql/test/SQLancer/Tests/sqlancer01.stable.out
Branch: Jun2020
Log Message:
Approved output
diffs (104 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer01.sql
b/sql/test/SQLancer/Tests/sqlancer01.sql
--- a/sql/test/SQLancer/Tests/sqlancer01.sql
+++ b/sql/test/SQLancer/Tests/sqlancer01.sql
@@ -86,9 +86,9 @@ SELECT another_t.col1 FROM tbl_productsa
START TRANSACTION; --Bug 6896
CREATE TABLE t0 (c0 int, c1 int);
insert into t0 values (1, 1);
-select all t0.c0 from t0 where (sql_min("locate"(reverse('qﺛ}(C.0D?\r'),
cast(t0.c1 as string), cast(-1483214882 as int)), ((cast('1186727519' as
int))||(abs(785610124))))) not in (1.52414541E9, 0.13482326)
-union all select all t0.c0 from t0 where not
((sql_min("locate"(reverse('qﺛ}(C.0D?\r'), cast(t0.c1 as string),
cast(-1483214882 as int)), ((cast('1186727519' as int))||(abs(785610124)))))
not in (1.52414541E9, 0.13482326))
-union all select t0.c0 from t0 where
((sql_min("locate"(reverse('qﺛ}(C.0D?\r'), cast(t0.c1 as string),
cast(-1483214882 as int)), ((cast('1186727519' as int))||(abs(785610124)))))
not in (1.52414541E9, 0.13482326)) is null;
+select all t0.c0 from t0 where (1) not in (1.52414541E9, 0.13482326)
+union all select all t0.c0 from t0 where not (1) not in (1.52414541E9,
0.13482326)
+union all select t0.c0 from t0 where (1) not in (1.52414541E9, 0.13482326) is
null;
select 1 from t0 where (3 in (1, 2)) is null; --simplified
-- empty
@@ -122,8 +122,8 @@ CREATE TABLE t0 (c0 int, c1 int);
insert into t0 values (1, 1);
CREATE TABLE v0 (c0 int, c1 int);
insert into v0 values (1, 1);
-select all count(all 0.5923759) from v0 left outer join t0 on
((((substr(cast(0.2753589295956522 as string), cast(cast(0.1980253 as string)
as int), ((+ (v0.c0))^(((v0.c0)+(v0.c0))))))||
-((0.95672141382556563637962199209141544997692108154296875) in
(0.93132256561636328484610203304328024387359619140625, t0.c0))))like('jBlZöx
TW9*ࡈxw㟩*'));
+select all count(all 0.5923759) from v0 left outer join t0 on (('1')||
+cast((0.95672141382556563637962199209141544997692108154296875) in
(0.93132256561636328484610203304328024387359619140625, t0.c0) as varchar(32))
like('jBlZöx TW9*ࡈxw㟩*'));
select 1 from v0 join t0 on (((substr('1', 1, v0.c0)) || (1) in (1, t0.c0))
like 'a'); --simplified
-- empty
diff --git a/sql/test/SQLancer/Tests/sqlancer01.stable.out
b/sql/test/SQLancer/Tests/sqlancer01.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer01.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer01.stable.out
@@ -259,6 +259,73 @@ stdout of test 'sqlancer01` in directory
% col1 # name
% int # type
% 1 # length
+#START TRANSACTION; --Bug 6896
+#CREATE TABLE t0 (c0 int, c1 int);
+#insert into t0 values (1, 1);
+[ 1 ]
+#select all t0.c0 from t0 where (1) not in (1.52414541E9, 0.13482326)
+#union all select all t0.c0 from t0 where not (1) not in (1.52414541E9,
0.13482326)
+#union all select t0.c0 from t0 where (1) not in (1.52414541E9, 0.13482326) is
null;
+% .%23 # table_name
+% c0 # name
+% int # type
+% 1 # length
+[ 1 ]
+#select 1 from t0 where (3 in (1, 2)) is null; --simplified
+% .%5 # table_name
+% %5 # name
+% tinyint # type
+% 1 # length
+#SELECT 1 FROM t0 WHERE t0.c0 BETWEEN SYMMETRIC (1 IN (2, 1)) AND t0.c0;
+% .%4 # table_name
+% %4 # name
+% tinyint # type
+% 1 # length
+[ 1 ]
+#ROLLBACK;
+#START TRANSACTION; --Bug 6897
+#CREATE TABLE "t0"("c0" DECIMAL(18,3), "c1" BIGINT);
+#COPY 12 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#0.244 NULL
+#0.578 NULL
+#0.119 NULL
+#0.773 495026350
+#0.329 2108706088
+#0.483 1298757529
+#0.880 39
+#0.084 1
+#0.332 859611948
+#0.607 NULL
+#0.835 0
+#0.455 -1239303309
+[ 12 ]
+#SELECT MIN(DISTINCT t0.c1) FROM t0 WHERE 1 >= t0.c0 GROUP BY true;
+% sys.%2 # table_name
+% %2 # name
+% bigint # type
+% 11 # length
+[ -1239303309 ]
+#ROLLBACK;
+#START TRANSACTION; --Bug 6898
+#CREATE TABLE t0 (c0 int, c1 int);
+#insert into t0 values (1, 1);
+[ 1 ]
+#CREATE TABLE v0 (c0 int, c1 int);
+#insert into v0 values (1, 1);
+[ 1 ]
+#select all count(all 0.5923759) from v0 left outer join t0 on (('1')||
+#cast((0.95672141382556563637962199209141544997692108154296875) in
(0.93132256561636328484610203304328024387359619140625, t0.c0) as varchar(32))
like('jBlZöx TW9*ࡈxw㟩*'));
+% .%6 # table_name
+% %6 # name
+% bigint # type
+% 1 # length
+[ 1 ]
+#select 1 from v0 join t0 on (((substr('1', 1, v0.c0)) || (1) in (1, t0.c0))
like 'a'); --simplified
+% .%10 # table_name
+% %10 # name
+% tinyint # type
+% 1 # length
+#ROLLBACK;
#DROP TABLE tbl_ProductSales;
#DROP TABLE another_T;
#DROP TABLE integers;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
