Changeset: 58a5cc858d62 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=58a5cc858d62 Modified Files: sql/test/SQLancer/Tests/sqlancer01.stable.out Branch: Jun2020 Log Message:
approved output diffs (21 lines): 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 @@ -231,6 +231,17 @@ stdout of test 'sqlancer01` in directory % bigint # type % 1 # length [ 1 ] +#START TRANSACTION; --Bug 6893 +#create view v0(c0) as (select distinct - (tbl_productsales.totalsales) from tbl_productsales, another_t); +#create view v1(c0) as (select distinct not (not ((((v0.c0)=(1560867215))) = false)) from integers, another_t, tbl_productsales, v0); +#create view v2(c0, c1) as (select v1.c0, -3.025584E8 from v0, tbl_productsales, v1, another_t); +#create view v3(c0, c1, c2) as (select all 0.9104878744438205107059047804796136915683746337890625, -705263737, 0.7147939 from v2 where (cast(v2.c0 as varchar(32))) is null order by v2.c1 desc, v2.c0 desc); +#SELECT v3.c0 FROM v3, v0, tbl_productsales FULL OUTER JOIN v2 ON v2.c0 RIGHT OUTER JOIN integers ON (tbl_productsales.TotalSales) BETWEEN (NULL) AND (v2.c1) JOIN another_t ON v2.c0; +% .v3 # table_name +% c0 # name +% double # type +% 24 # 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