Changeset: ebabbafb5996 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ebabbafb5996 Added Files: sql/test/mergetables/Tests/sqlsmith-exists2.stable.err sql/test/mergetables/Tests/sqlsmith-exists2.stable.out Branch: default Log Message:
approved output diffs (130 lines): diff --git a/sql/test/mergetables/Tests/sqlsmith-exists2.stable.err b/sql/test/mergetables/Tests/sqlsmith-exists2.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/mergetables/Tests/sqlsmith-exists2.stable.err @@ -0,0 +1,31 @@ +stderr of test 'sqlsmith-exists2` in directory 'sql/test/mergetables` itself: + + +# 22:12:14 > +# 22:12:14 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31528" "--set" "mapi_usock=/var/tmp/mtest-20532/.s.monetdb.31528" "--forcemito" "--dbpath=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_mergetables" "--set" "embedded_c=true" +# 22:12:14 > + +# builtin opt gdk_dbpath = /home/niels/scratch/rc-clean/Linux-x86_64/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_ipv6 = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# builtin opt raw_strings = false +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 31528 +# cmdline opt mapi_usock = /var/tmp/mtest-20532/.s.monetdb.31528 +# cmdline opt gdk_dbpath = /home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_mergetables +# cmdline opt embedded_c = true + +# 22:12:14 > +# 22:12:14 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-20532" "--port=31528" +# 22:12:14 > + + +# 22:12:15 > +# 22:12:15 > "Done." +# 22:12:15 > + diff --git a/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out b/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/mergetables/Tests/sqlsmith-exists2.stable.out @@ -0,0 +1,89 @@ +stdout of test 'sqlsmith-exists2` in directory 'sql/test/mergetables` itself: + + +# 22:12:14 > +# 22:12:14 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31528" "--set" "mapi_usock=/var/tmp/mtest-20532/.s.monetdb.31528" "--forcemito" "--dbpath=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_mergetables" "--set" "embedded_c=true" +# 22:12:14 > + +# MonetDB 5 server v11.36.0 (hg id: b6ee8747a04e+) +# This is an unreleased version +# Serving database 'mTests_sql_test_mergetables', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 15.361 GiB available main-memory of which we use 12.519 GiB +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://xps13:31528/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-20532/.s.monetdb.31528 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +# 22:12:14 > +# 22:12:14 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-20532" "--port=31528" +# 22:12:14 > + +#START TRANSACTION; +#CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT); +#INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888); +[ 4 ] +#CREATE TABLE LongTable (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT); +#INSERT INTO LongTable VALUES (1,7,2,1,1,909,1,1), (2,7,2,2,3,4,4,6), (NULL,5,4,81,NULL,5,-10,1), (-90,NULL,0,NULL,2,0,1,NULL); +[ 4 ] +#CREATE TABLE integers(i INTEGER); +#INSERT INTO integers VALUES (1), (2), (3), (NULL); +[ 4 ] +#CREATE TABLE tbl_ProductSales (col1 INT, col2 varchar(64), col3 varchar(64), col4 INT, col5 REAL, col6 date); +#INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200, 1.2, date '2015-12-12'),(2,'Game','PKO Game',400, -1.0, date '2012-02-10'),(3,'Fashion','Shirt',500, NULL, date '1990-01-01'), +#(4,'Fashion','Shorts',100, 102.45, date '2000-03-08'),(5,'Sport','Ball',0, 224.78, NULL); +[ 5 ] +#CREATE TABLE analytics (aa INT, bb INT, cc BIGINT); +#INSERT INTO analytics VALUES (15, 3, 15), (3, 1, 3), (2, 1, 2), (5, 3, 5), (NULL, 2, NULL), (3, 2, 3), (4, 1, 4), (6, 3, 6), (8, 2, 8), (NULL, 4, NULL); +[ 10 ] +#CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +#INSERT INTO tab0 VALUES (97,1,99), (15,81,47),(87,21,10); +[ 3 ] +#CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); +#INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68); +[ 3 ] +#CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +#INSERT INTO tab2 VALUES (64,77,40), (75,67,58),(46,51,23); +[ 3 ] +#select +# case when subq_1.c1 is not null then subq_1.c0 else subq_1.c0 end +# as c0 +#from +# (select +# ref_0.col2 as c0 +# from +# tab2 as ref_0 +# where true +# limit 93) as subq_0 +# left join (select +# ref_1.i as c0, +# case when (true) +# or (63 is null) then ref_2.col1 else ref_2.col1 end +# as c1, +# ref_1.i as c2 +# from +# integers as ref_1 +# right join tab0 as ref_2 +# on (95 is null) +# where true +# limit 62) as subq_1 +# on ((subq_0.c0 is null) +# and (((subq_0.c0 is not null) +# or (exists ( +# select +# subq_0.c0 as c0 +# from +# analytics as ref_3 +% . # table_name +% c0 # name +% int # type +% 1 # length +#ROLLBACK; + +# 22:12:15 > +# 22:12:15 > "Done." +# 22:12:15 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
