MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 78498a26d715 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=78498a26d715
Modified Files:
sql/benchmarks/tpcds/Tests/40.stable.out
sql/benchmarks/tpcds/Tests/40.stable.out.int128
Branch: Jun2020
Log Message:

Approved output


diffs (24 lines):

diff --git a/sql/benchmarks/tpcds/Tests/40.stable.out 
b/sql/benchmarks/tpcds/Tests/40.stable.out
--- a/sql/benchmarks/tpcds/Tests/40.stable.out
+++ b/sql/benchmarks/tpcds/Tests/40.stable.out
@@ -35,7 +35,7 @@ stdout of test '40` in directory 'sql/be
 #   END) AS sales_after
 #FROM catalog_sales
 #LEFT OUTER JOIN catalog_returns ON (cs_order_number = cr_order_number
-% sys.warehouse,   sys.item,   sys.,   sys. # table_name
+% sys.warehouse,   .item,  sys.,   sys. # table_name
 % w_state, i_item_id,  sales_before,   sales_after # name
 % char,char,   decimal,decimal # type
 % 2,   16, 20, 20 # length
diff --git a/sql/benchmarks/tpcds/Tests/40.stable.out.int128 
b/sql/benchmarks/tpcds/Tests/40.stable.out.int128
--- a/sql/benchmarks/tpcds/Tests/40.stable.out.int128
+++ b/sql/benchmarks/tpcds/Tests/40.stable.out.int128
@@ -35,7 +35,7 @@ stdout of test '40` in directory 'sql/be
 #   END) AS sales_after
 #FROM catalog_sales
 #LEFT OUTER JOIN catalog_returns ON (cs_order_number = cr_order_number
-% sys.warehouse,   sys.item,   sys.,   sys. # table_name
+% sys.warehouse,   .item,  sys.,   sys. # table_name
 % w_state, i_item_id,  sales_before,   sales_after # name
 % char,char,   decimal,decimal # type
 % 2,   16, 40, 40 # length
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - approved output

[Niels Nes]

Changeset: 7bfe54cd70cd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7bfe54cd70cd
Modified Files:
sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out

sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out

sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out

sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.sql
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out

sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.single

sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.sql

sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out

sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
sql/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.stable.out
sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.stable.out
sql/test/BugTracker/Tests/crash_on_cast.SF-1357271.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out

sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out
sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out

sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out

sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out

sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out

sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out

sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out

sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/miscellaneous/Tests/simple_plans.stable.out
sql/test/remote/Tests/partition_elim.stable.out
Branch: Jun2020
Log Message:

approved output


diffs (truncated from 4095 to 300 lines):

diff --git a/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out 
b/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
@@ -169,20 +169,20 @@ end user.s8_0;
 % clob # type
 % 114 # length
 function user.s16_0():void;
-X_1:void := querylog.define("explain select fuse(a,b) from udf_fuse;":str, 
"sequential_pipe":str, 26:int);
-X_34:bat[:str] := bat.pack("sys.%1":str);
-X_35:bat[:str] := bat.pack("%1":str);
-X_36:bat[:str] := bat.pack("smallint":str);
-X_37:bat[:int] := bat.pack(16:int);
-X_38:bat[:int] := bat.pack(0:int);
+X_1:void := querylog.define("explain select fuse(a,b) from udf_fuse;":str, 
"sequential_pipe":str, 22:int);
+X_29:bat[:str] := bat.pack("sys.%1":str);
+X_30:bat[:str] := bat.pack("%1":str);
+X_31:bat[:str] := bat.pack("smallint":str);
+X_32:bat[:int] := bat.pack(16:int);
+X_33:bat[:int] := bat.pack(0:int);
 X_4:int := sql.mvc();
 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "udf_fuse":str);
-X_17:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "a":str, 
0:int);
-X_28:bat[:bte] := algebra.projection(C_5:bat[:oid], X_17:bat[:bte]);
-X_22:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "b":str, 
0:int);
-X_29:bat[:bte] := algebra.projection(C_5:bat[:oid], X_22:bat[:bte]);
-X_30:bat[:sht] := batudf.fuse(X_28:bat[:bte], X_29:bat[:bte]);
-sql.resultSet(X_34:bat[:str], X_35:bat[:str], X_36:bat[:str], 
X_37:bat[:int], X_38:bat[:int], X_30:bat[:sht]);
+X_8:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "a":str, 
0:int);
+X_23:bat[:bte] := algebra.projection(C_5:bat[:oid], X_8:bat[:bte]);
+X_17:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "b":str, 
0:int);
+X_24:bat[:bte] := algebra.projection(C_5:bat[:oid], X_17:bat[:bte]);
+X_25:bat[:sht] := batudf.fuse(X_23:bat[:bte], X_24:bat[:bte]);
+sql.resultSet(X_29:bat[:str], X_30:bat[:str], X_31:bat[:str], 
X_32:bat[:int], X_33:bat[:int], X_25:bat[:sht]);
 end user.s16_0;
 #inline   actions= 0 time=1 usec 
 #remapactions= 1 time=6 usec 
@@ -215,20 +215,20 @@ end user.s16_0;
 % clob # type
 % 114 # length
 function user.s18_0():void;
-X_1:void := querylog.define("explain select fuse(c,d) from udf_fuse;":str, 
"

MonetDB: Jun2020 - approved output

[Niels Nes]

Changeset: 3ec653401c66 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3ec653401c66
Modified Files:
clients/Tests/exports.stable.out
Branch: Jun2020
Log Message:

approved output


diffs (23 lines):

diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -501,6 +501,7 @@ gdk_return log_bat_clear(logger *lg, con
 gdk_return log_bat_persists(logger *lg, BAT *b, const char *n, char tpe, oid 
id);
 gdk_return log_bat_transient(logger *lg, const char *n, char tpe, oid id);
 gdk_return log_delta(logger *lg, BAT *uid, BAT *uval, const char *n, char tpe, 
oid id);
+lng log_save_id(logger *lg);
 gdk_return log_sequence(logger *lg, int seq, lng id);
 gdk_return log_tend(logger *lg);
 gdk_return log_tstart(logger *lg);
@@ -510,9 +511,9 @@ gdk_return logger_cleanup(logger *lg);
 logger *logger_create(int debug, const char *fn, const char *logdir, int 
version, preversionfix_fptr prefuncp, postversionfix_fptr postfuncp);
 gdk_return logger_del_bat(logger *lg, log_bid bid) 
__attribute__((__warn_unused_result__));
 void logger_destroy(logger *lg);
-gdk_return logger_exit(logger *lg);
+gdk_return logger_exit(logger *lg, lng save_id);
 log_bid logger_find_bat(logger *lg, const char *name, char tpe, oid id);
-gdk_return logger_restart(logger *lg);
+gdk_return logger_restart(logger *lg, lng save_id);
 int logger_sequence(logger *lg, int seq, lng *id);
 gdk_return logger_upgrade_bat(logger *lg, const char *name, char tpe, oid id) 
__attribute__((__warn_unused_result__));
 void logger_with_ids(logger *lg);
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output after reducing number of queries

[Pedro Ferreira]

Changeset: 61ff98534ea5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=61ff98534ea5
Modified Files:
sql/jdbc/tests/Tests/Bug_LargeQueries_6571_6693.stable.out
sql/jdbc/tests/Tests/Test_PSsomeamount.stable.out
sql/jdbc/tests/Tests/Test_Sbatching.stable.out
Branch: Jun2020
Log Message:

Approved output after reducing number of queries


diffs (293 lines):

diff --git a/sql/jdbc/tests/Tests/Bug_LargeQueries_6571_6693.stable.out 
b/sql/jdbc/tests/Tests/Bug_LargeQueries_6571_6693.stable.out
--- a/sql/jdbc/tests/Tests/Bug_LargeQueries_6571_6693.stable.out
+++ b/sql/jdbc/tests/Tests/Bug_LargeQueries_6571_6693.stable.out
@@ -32,14 +32,14 @@ stdout of test 'Bug_LargeQueries_6571_66
 # 18:48:54 >  
 
 Created table: tbl6693 Inserting rows. 3 rows inserted
-Script size is 296607
+Script size is 27960
 First test repeat 10 times
 Iteration: 1 2 3 4 5 6 7 8 9 10 
 Completed first test
 Second test repeat 10 times
 Iteration: 1 2 3 4 5 6 7 8 9 10 
 Completed second test
-Script size is 112838
+Script size is 1092
 Third test repeat 3 times
 Iteration: 1 2 3 
 Completed third test
diff --git a/sql/jdbc/tests/Tests/Test_PSsomeamount.stable.out 
b/sql/jdbc/tests/Tests/Test_PSsomeamount.stable.out
--- a/sql/jdbc/tests/Tests/Test_PSsomeamount.stable.out
+++ b/sql/jdbc/tests/Tests/Test_PSsomeamount.stable.out
@@ -27,17 +27,12 @@ stdout of test 'Test_PSsomeamount` in di
 0. truetrue
 1. Preparing and executing a unique statement
 0, true
-1000, true
-2000, true
-3000, true
-4000, true
-5000, true
-6000, true
-7000, true
-8000, true
-9000, true
+20, true
+40, true
+60, true
+80, true
 
-# 18:56:08 >  
-# 18:56:08 >  "Done."
-# 18:56:08 >  
+# 11:53:16 >  
+# 11:53:16 >  "Done."
+# 11:53:16 >  
 
diff --git a/sql/jdbc/tests/Tests/Test_Sbatching.stable.out 
b/sql/jdbc/tests/Tests/Test_Sbatching.stable.out
--- a/sql/jdbc/tests/Tests/Test_Sbatching.stable.out
+++ b/sql/jdbc/tests/Tests/Test_Sbatching.stable.out
@@ -24,234 +24,18 @@ stdout of test 'Test_Sbatching` in direc
 
 0. truetrue
 1. create...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. checking update counts (should all be 1)...passed :)
-2. executing batch (400 inserts)...passed :)
-3. checking number of update counts...400 passed :)
-4. check

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 1be2855f5d97 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1be2855f5d97
Added Files:
sql/test/SQLancer/Tests/sqlancer04.stable.err
sql/test/SQLancer/Tests/sqlancer04.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (58 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.err 
b/sql/test/SQLancer/Tests/sqlancer04.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'sqlancer04` in directory 'sql/test/SQLancer` itself:
+
+
+# 09:44:50 >  
+# 09:44:50 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-36890" "--port=30177"
+# 09:44:50 >  
+
+
+# 09:44:50 >  
+# 09:44:50 >  "Done."
+# 09:44:50 >  
+
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.out 
b/sql/test/SQLancer/Tests/sqlancer04.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.out
@@ -0,0 +1,36 @@
+stdout of test 'sqlancer04` in directory 'sql/test/SQLancer` itself:
+
+
+# 09:44:50 >  
+# 09:44:50 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-36890" "--port=30177"
+# 09:44:50 >  
+
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" INTERVAL MONTH NOT NULL);
+#COPY 3 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#150184010
+#332127116
+#2136089006
+[ 3]
+#SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 WHERE 
((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), nullif(t0.c0, 
t0.c0) GROUP BY 0.1 
+#HAVING MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538) 
+#UNION ALL SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), 
nullif(t0.c0, t0.c0) GROUP BY 0.1 
+#HAVING NOT (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS 
STRING(538)) 
+% .%26 # table_name
+% %2 # name
+% double # type
+% 24 # length
+#SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 WHERE 
((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), nullif(t0.c0, 
t0.c0) GROUP BY 0.1 
+#HAVING MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538) 
+#UNION ALL SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), 
nullif(t0.c0, t0.c0) GROUP BY 0.1 
+#HAVING NOT (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS 
STRING(538)) 
+% .%26 # table_name
+% %2 # name
+% double # type
+% 24 # length
+#ROLLBACK;
+
+# 09:44:50 >  
+# 09:44:50 >  "Done."
+# 09:44:50 >  
+
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 8cc79ef98a60 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8cc79ef98a60
Modified Files:
sql/test/miscellaneous/Tests/simple_plans.stable.out.single
Branch: Jun2020
Log Message:

Approved output


diffs (14 lines):

diff --git a/sql/test/miscellaneous/Tests/simple_plans.stable.out.single 
b/sql/test/miscellaneous/Tests/simple_plans.stable.out.single
--- a/sql/test/miscellaneous/Tests/simple_plans.stable.out.single
+++ b/sql/test/miscellaneous/Tests/simple_plans.stable.out.single
@@ -134,8 +134,8 @@ end user.s20_0;
 % 175 # length
 function user.s22_0():void;
 X_4:void := querylog.define("explain select 1 from another_t t1 inner join 
another_t t2 on t1.col1 between t2.col1 - 1 and t2.col1 + 1;":str, 
"default_pipe":str, 34:int);
-X_48:bat[:str] := bat.pack(".%15":str);
-X_49:bat[:str] := bat.pack("%15":str);
+X_48:bat[:str] := bat.pack(".%13":str);
+X_49:bat[:str] := bat.pack("%13":str);
 X_50:bat[:str] := bat.pack("tinyint":str);
 X_51:bat[:int] := bat.pack(1:int);
 X_52:bat[:int] := bat.pack(0:int);
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - approved output

[Niels Nes]

Changeset: a861b6f4eba5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a861b6f4eba5
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:

approved output


diffs (18 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out 
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -365,6 +365,14 @@ stdout of test 'sqlancer03` in directory
 [ NULL ]
 [ NULL ]
 #ROLLBACK;
+#START TRANSACTION;
+#CREATE TEMPORARY TABLE t0(c0 integer AUTO_INCREMENT UNIQUE NOT NULL, c1 FLOAT 
DEFAULT (0.9323624));
+#select t0.c0 from t0 where -t0.c0 <= 1 and t0.c0 between t0.c0 and -t0.c0;
+% tmp.t0 # table_name
+% c0 # name
+% int # type
+% 1 # length
+#ROLLBACK;
 #START TRANSACTION; -- Bug 6924
 #CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT 
"t0_a_b_unique" UNIQUE ("a","b"));
 #COPY 39 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 5ee9e628f186 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5ee9e628f186
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (50 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out 
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -325,6 +325,46 @@ stdout of test 'sqlancer03` in directory
 [ NULL ]
 [ NULL ]
 #ROLLBACK;
+#START TRANSACTION; -- Bug 6926
+#CREATE TABLE t0(c0 TIME, c1 VARCHAR(1000) DEFAULT (upper(CAST((('')||(DATE 
'1970-01-19')) AS VARCHAR(152 PRIMARY KEY UNIQUE NULL);
+#INSERT INTO t0(c0, c1) VALUES(TIME '19:29:38', '');
+[ 1]
+#INSERT INTO t0(c1, c0) VALUES(CAST(TIME '06:50:34' AS VARCHAR(256)), TIME 
'01:39:55');
+[ 1]
+#INSERT INTO t0(c1, c0) VALUES(CAST(0.6 AS VARCHAR(411)), TIME '22:07:22'), 
('#B', TIME '05:51:00'), (CAST('434' AS VARCHAR(849)))||(0.4)))||(TIME 
'04:05:28')), TIME '06:50:34');
+[ 3]
+#INSERT INTO t0(c1) VALUES(CAST(INTERVAL '42' SECOND AS VARCHAR(102)));
+[ 1]
+#INSERT INTO t0(c0, c1) VALUES(TIME '16:29:13', 'J'), (TIME '05:57:44', 
'49䄎y_}');
+[ 2]
+#INSERT INTO t0(c1, c0) VALUES('2', TIME '07:15:50'), (CAST(TIME '16:29:13' AS 
VARCHAR(1000)), TIME '03:00:56');
+[ 2]
+#INSERT INTO t0(c1) VALUES('O큑LSGAM||Z赐'), ('.n');
+[ 2]
+#INSERT INTO t0(c1, c0) VALUES('c蠷웵', TIME '04:59:13');
+[ 1]
+#INSERT INTO t0(c1) VALUES('0.0');
+[ 1]
+#INSERT INTO t0(c0, c1) VALUES(TIME '20:29:28', '-343'), (TIME '01:19:51', 
'j'), (TIME '11:37:23', CAST(DATE '1970-01-23' AS 
VARCHAR(849)))||(INTERVAL '23' MONTH)))||(INTERVAL '-535' 
SECOND)))||(lower((('鮥*Qß4')||(DATE '1970-01-01'))||(0.4)));
+[ 3]
+#INSERT INTO t0(c0, c1) VALUES(TIME '02:38:14', lower(CAST(INTERVAL '342' 
SECOND AS VARCHAR(1000, (TIME '23:43:33', '64');
+[ 2]
+#DELETE FROM t0 WHERE 1 IS NOT NULL)AND(FALSE)))OR(((CAST(0.3 AS 
VARCHAR(836)))<(upper(t0.c1);
+[ 14   ]
+#INSERT INTO t0(c0, c1) VALUES(TIME '20:59:23', ')TD)Dnö'), (TIME '22:09:19', 
'aaJ즳#B!sJNG㡩');
+[ 2]
+#INSERT INTO t0(c0, c1) VALUES(TIME '20:02:19', CAST(0.1 AS VARCHAR(927)));
+[ 1]
+#INSERT INTO t0(c0, c1) VALUES(TIME '00:17:15', '{'), (TIME '06:51:52', 
CAST(4.1230238E7 AS VARCHAR(459)));
+[ 2]
+#SELECT ALL t0.c0 FROM t0 WHERE (((t0.c0)<>(t0.c0))) IS NULL;
+% sys.t0 # table_name
+% c0 # name
+% time # type
+% 8 # length
+[ NULL ]
+[ NULL ]
+#ROLLBACK;
 #START TRANSACTION; -- Bug 6924
 #CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT 
"t0_a_b_unique" UNIQUE ("a","b"));
 #COPY 39 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - approved output

[Niels Nes]

Changeset: f31151e2f3fd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f31151e2f3fd
Modified Files:
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out

sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
sql/test/miscellaneous/Tests/groupby_error.stable.out
Branch: Jun2020
Log Message:

approved output


diffs (76 lines):

diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out 
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
@@ -97,7 +97,7 @@ single project (
 | ) [ "o"."open_auction_id" NOT NULL * = "%32"."%32" NOT NULL ]
 ) [ "o"."id" NOT NULL HASHCOL , "o"."open_auction_id" NOT NULL, "o"."initial" 
NOT NULL, "o"."reserve" NOT NULL, "o"."aktuell" NOT NULL, "o"."privacy" NOT 
NULL, "o"."itemref" NOT NULL, "o"."seller" NOT NULL, "o"."quantity" NOT NULL, 
"o"."type" NOT NULL, "o"."start" NOT NULL, "o"."ende" NOT NULL, "o"."%TID%" NOT 
NULL, "b"."id" NOT NULL HASHCOL , "b"."open_auction_id" NOT NULL, "b"."date" 
NOT NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL, "b"."increase" NOT 
NULL, "b"."%TID%" NOT NULL, "b3"."increase" NOT NULL as "%2"."%2" ]
 project (
-| select (
+| single select (
 | | single join (
 | | | & REF 2 ,
 | | | project (
diff --git 
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
 
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
--- 
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
+++ 
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
@@ -92,29 +92,25 @@ project (
 | | | | | project (
 | | | | | | project (
 | | | | | | | project (
-| | | | | | | | project (
-| | | | | | | | | project (
-| | | | | | | | | | left outer join (
-| | | | | | | | | | | left outer join (
-| | | | | | | | | | | | join (
-| | | | | | | | | | | | | join (
-| | | | | | | | | | | | | | table(sys.functions) [ "functions"."id" as 
"f"."id", "functions"."schema_id" as "f"."schema_id" ] COUNT ,
-| | | | | | | | | | | | | | table(sys.comments) [ "comments"."id" NOT NULL 
HASHCOL  as "c"."id" ] COUNT 
-| | | | | | | | | | | | | ) [ "f"."id" = "c"."id" NOT NULL HASHCOL  ],
-| | | | | | | | | | | | | table(sys.schemas) [ "schemas"."id" as "s"."id" ] 
COUNT 
-| | | | | | | | | | | | ) [ "f"."schema_id" = "s"."id" ],
-| | | | | | | | | | | | select (
-| | | | | | | | | | | | | table(sys.functions) [ "functions"."id", 
"functions"."system" ] COUNT 
-| | | | | | | | | | | | ) [ "functions"."system" = boolean "true" ]
-| | | | | | | | | | | ) [ "f"."id" = "functions"."id" ],
-| | | | | | | | | | | select (
-| | | | | | | | | | | | table(sys.args) [ "args"."func_id" as "p"."func_id", 
"args"."inout" as "p"."inout", "args"."number" as "p"."number" ] COUNT 
-| | | | | | | | | | | ) [ "p"."inout" = tinyint "1" ]
-| | | | | | | | | | ) [ "f"."id" = "p"."func_id" ]
-| | | | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" 
ASC ]
-| | | | | | | | ) [ "f"."id", "p"."number" ]
-| | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" NULLS 
LAST ]
-| | | | | | ) [ "f"."id", "p"."number" ]
+| | | | | | | | left outer join (
+| | | | | | | | | left outer join (
+| | | | | | | | | | join (
+| | | | | | | | | | | join (
+| | | | | | | | | | | | table(sys.functions) [ "functions"."id" as "f"."id", 
"functions"."schema_id" as "f"."schema_id" ] COUNT ,
+| | | | | | | | | | | | table(sys.comments) [ "comments"."id" NOT NULL HASHCOL 
 as "c"."id" ] COUNT 
+| | | | | | | | | | | ) [ "f"."id" = "c"."id" NOT NULL HASHCOL  ],
+| | | | | | | | | | | table(sys.schemas) [ "schemas"."id" as "s"."id" ] COUNT 
+| | | | | | | | | | ) [ "f"."schema_id" = "s"."id" ],
+| | | | | | | | | | select (
+| | | | | | | | | | | table(sys.functions) [ "functions"."id", 
"functions"."system" ] COUNT 
+| | | | | | | | | | ) [ "functions"."system" = boolean "true" ]
+| | | | | | | | | ) [ "f"."id" = "functions"."id" ],
+| | | | | | | | | select (
+| | | | | | | | | | table(sys.args) [ "args"."func_id" as "p"."func_id", 
"args"."inout" as "p"."inout", "args"."number" as "p"."number" ] COUNT 
+| | | | | | | | | ) [ "p"."inout" = tinyint "1" ]
+| | | | | | | | ) [ "f"."id" = "p"."func_id" ]
+| | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
+| | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" NULLS 
LAST ]
 | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
 | | | | ) [ "f"."id", sys.row_number("f"."id", boolean "false" as "%17"."%17", 
sys.diff(sys.diff("f"."id" ASC), "p"."number" ASC) as "%20"."%20") as "line" ]
 | | | ) [ "f"."id" as "fid", "line" ]
diff --git a/sql/test/miscellaneous/Tests/groupby_error.stable.out 
b/sql/test/miscellaneous/Tes

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 13e51292cfc6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=13e51292cfc6
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/SQLancer/Tests/sqlancer03.stable.out
sql/test/subquery/Tests/subquery6.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (145 lines):

diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out 
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
@@ -83,8 +83,8 @@ stdout of test 'storagemodel` in directo
 % sys.storagemodel,sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel # table_name
 % schema,  table,  column, type,   count,  columnsize, heapsize,   
hashsize,   imprintsize,orderidxsize,   sorted, unique, isacolumn # name
 % varchar, varchar,varchar,varchar,bigint, bigint, 
bigint, bigint, bigint, bigint, boolean,boolean,boolean # type
-% 3,   7,  1,  3,  5,  5,  1,  1,  4,  1,  
5,  5,  5 # length
-[ "sys",   "bug3923",  "i","int",  1,  4,  0,  0,  
8000,   0,  true,   NULL,   true]
+% 3,   7,  1,  3,  5,  5,  4,  1,  4,  1,  
5,  5,  5 # length
+[ "sys",   "bug3923",  "i","int",  1,  1,  8312,   0,  
2000,   0,  true,   NULL,   true]
 #drop table bug3923;
 #create table bug3923(i integer);
 #select "schema", "table", "column", "type", "mode", case when typewidth < 14 
then typewidth else 99 end as typewidth, hashes, phash, imprints from 
sys.storage('sys','_tables');
@@ -108,8 +108,8 @@ stdout of test 'storagemodel` in directo
 % sys.storagemodel,sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel # table_name
 % schema,  table,  column, type,   count,  columnsize, heapsize,   
hashsize,   imprintsize,orderidxsize,   sorted, unique, isacolumn # name
 % varchar, varchar,varchar,varchar,bigint, bigint, 
bigint, bigint, bigint, bigint, boolean,boolean,boolean # type
-% 13,  7,  1,  3,  5,  5,  1,  1,  4,  1,  
5,  5,  5 # length
-[ "bug3923schema", "bug3923",  "i","int",  1,  4,  0,  
0,  8000,   0,  true,   NULL,   true]
+% 13,  7,  1,  3,  5,  5,  4,  1,  4,  1,  
5,  5,  5 # length
+[ "bug3923schema", "bug3923",  "i","int",  1,  1,  8312,   
0,  2000,   0,  true,   NULL,   true]
 #drop table bug3923;
 
 # 23:38:44 >  
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out 
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -258,6 +258,55 @@ stdout of test 'sqlancer03` in directory
 % date,int # type
 % 10,  1 # length
 #ROLLBACK;
+#START TRANSACTION; -- Bug 6924
+#CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT 
"t0_a_b_unique" UNIQUE ("a","b"));
+#COPY 39 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#-88162543 18
+#-88162543 20
+#-15649686 -544149211
+#-88162543 1544983640
+#NULL  -22365094
+#NULL  1606640302
+#NULL  -2022118335
+#-706411503-1573662742
+#-88162543 117340240
+#NULL  14
+#1724946985-1967779742
+#NULL  -1500350327
+#NULL  -174249097
+#-88162543 29
+#-88162543 42
+#100
+#NULL  1861748843
+#NULL  -1709541615
+#NULL  -143945879
+#NULL  1
+#NULL  1158178587
+#-88162543 14
+#-8460707880
+#-88162543 1242658499
+#1149990738-106077877
+#NULL  -70926511
+#NULL  138623502
+#NULL  -1613851459
+[ 39   ]
+#SELECT 1 FROM t0 GROUP BY 1, 2 HAVING MAX(TRUE);
+% .%1 # table_name
+% %1 # name
+% tinyint # type
+% 1 # length
+[ 1]
+#SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING), 
trim(r'W', r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING 
FROM t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING MAX(ALL TRUE)
+#UNION ALL
+#SELECT COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING), trim(r'W', 
r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING FROM t0 WHERE 
((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING NOT (MAX(ALL TRUE))
+#UNION ALL
+#SELECT ALL COUNT(ALL DATE '1970-01-02')

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: ae0662640514 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ae0662640514
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.sql
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (37 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql 
b/sql/test/SQLancer/Tests/sqlancer03.sql
--- a/sql/test/SQLancer/Tests/sqlancer03.sql
+++ b/sql/test/SQLancer/Tests/sqlancer03.sql
@@ -147,4 +147,8 @@ START TRANSACTION;
 create table t0 (a int, b int);
 insert into t0 values (1,1), (2,2);
 select min(t0.a), pi() from t0 group by t0.b;
+
+SELECT 1 FROM t0 WHERE DATE '1970-01-01' = NULL;
+SELECT 1 FROM t0 WHERE NULL IN (DATE '1970-01-01');
+SELECT ALL DATE '1970-01-01', CAST(COUNT(ALL TIMESTAMP '1970-01-01 01:06:52') 
AS INT) FROM t0 WHERE (NULL) NOT IN (DATE '1970-01-01') GROUP BY ((CAST(0.6 AS 
STRING))||(0.75)), INTERVAL '-13' SECOND;
 ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out 
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -242,6 +242,21 @@ stdout of test 'sqlancer03` in directory
 % 1,   24 # length
 [ 1,   3.141592654 ]
 [ 2,   3.141592654 ]
+#SELECT 1 FROM t0 WHERE DATE '1970-01-01' = NULL;
+% .%1 # table_name
+% %1 # name
+% tinyint # type
+% 1 # length
+#SELECT 1 FROM t0 WHERE NULL IN (DATE '1970-01-01');
+% .%3 # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+#SELECT ALL DATE '1970-01-01', CAST(COUNT(ALL TIMESTAMP '1970-01-01 01:06:52') 
AS INT) FROM t0 WHERE (NULL) NOT IN (DATE '1970-01-01') GROUP BY ((CAST(0.6 AS 
STRING))||(0.75)), INTERVAL '-13' SECOND;
+% .%11,.%7 # table_name
+% %11, %7 # name
+% date,int # type
+% 10,  1 # length
 #ROLLBACK;
 
 # 17:14:16 >  
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 8f93575cf911 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8f93575cf911
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (44 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out 
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -186,8 +186,39 @@ stdout of test 'sqlancer03` in directory
 #  CONSTRAINT "t0_c2_pkey" PRIMARY KEY ("c2"),
 #  CONSTRAINT "t0_c0_c1_unique" UNIQUE ("c0", "c1")
 #);
+#INSERT INTO "sys"."t0" VALUES (NULL, true, 10),
+# (NULL, false, 11),
+# (true, NULL, 12),
+# (NULL, false, 13),
+# (NULL, true, 14),
+# (true, false, 15),
+# (NULL, true, 16),
+# (true, true, 17),
+# (NULL, true, 18),
+# (NULL, false, 19),
+# (true, NULL, 20),
+# (true, NULL, 21),
+# (NULL, NULL, 22),
+# (false, true, 23);
+[ 14   ]
 #TRUNCATE t0;
-[ 0]
+[ 14   ]
+#COPY 14 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#NULL  true10
+#NULL  false   11
+#true  NULL12
+#NULL  false   13
+#NULL  true14
+#true  false   15
+#NULL  true16
+#true  true17
+#NULL  true18
+#NULL  false   19
+#true  NULL20
+#true  NULL21
+#NULL  NULL22
+#false true23
+[ 14   ]
 #DROP TABLE t0;
 
 # 17:14:16 >  
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output. Time to look at the csv issue

[Pedro Ferreira]

Changeset: 4c3a27a8805a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4c3a27a8805a
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:

Approved output. Time to look at the csv issue


diffs (99 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out 
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -128,6 +128,95 @@ stdout of test 'sqlancer03` in directory
 [ "屁1珙",   "屁抔珙",  "屁ಜ珙"   ]
 [ "屁1珙",   "屁抔珙",  "屁ಜ珙"   ]
 #ROLLBACK;
+#CREATE TABLE t0(c0 boolean, c1 boolean, c2 serial, UNIQUE(c0, c1)); -- Bug 
6920
+#INSERT INTO t0(c1) VALUES((0.5968066098520423) NOT  BETWEEN SYMMETRIC 
(CAST(length(upper(r'z')) AS INT)) AND (1347145665)), (FALSE);
+[ 2]
+#INSERT INTO t0(c0) VALUES(TRUE);
+[ 1]
+#INSERT INTO t0(c1) VALUES(FALSE), (TRUE);
+[ 2]
+#INSERT INTO t0(c2, c0, c1) VALUES(1347145665, (ltrim(lower(r'K'), 
((upper(r'296348087'))||(- (1582370739) IS NOT NULL, (((lower(r'ö
+#eg#K,纗HSJw!{cOw⇒l/l!B*H'))||(((CAST(0.12411368110083143 AS 
INT))+(-1795901173) IN (lower(CAST(TRUE AS STRING, (-1795901173, NULL, 
(0.9575114678279173) NOT IN (2.96348087E8, 0.501053365665)), (1922411524, 
TRUE, (0.5020325273627405) NOT IN (-1388966352, 1163825182));
+[ 3]
+#INSERT INTO t0(c1) VALUES(TRUE);
+[ 1]
+#INSERT INTO t0(c1, c2) VALUES(FALSE, 623585248);
+[ 1]
+#INSERT INTO t0(c0) VALUES(NOT (NOT -1388966352)*(-984145454))) NOT IN 
(0.7356286, (FALSE);
+[ 2]
+#INSERT INTO t0(c0) VALUES(TRUE);
+[ 1]
+#INSERT INTO t0(c2) VALUES(-1235619315);
+[ 1]
+#DELETE FROM t0 WHERE (t0.c0) = FALSE;
+[ 1]
+#INSERT INTO t0(c1, c0, c2) VALUES(TRUE, ((+ (- 
(1580722914)))>(charindex(CAST(0.347536126443453330381316845887340605258941650390625
 AS STRING), ((CAST(TRUE AS 
STRING(771)))||(0.2182260714120349831546263885684311389923095703125)), 
length(r'd', -1819817735);
+[ 1]
+#UPDATE t0 SET c2 = DEFAULT WHERE t0.c1)OR(CAST(t0.c2 AS 
BOOLEANOR((CAST(0.6873694879073857 AS DECIMAL)) NOT IN 
(0.10021624439224552371996423971722833812236785888671875)));
+[ 14   ]
+#SELECT t0.c0 FROM t0 WHERE ((CAST(t0.c2 AS INT)) NOT  BETWEEN ASYMMETRIC 
(abs(t0.c2)) AND (((t0.c2)/(t0.c2 NOT  BETWEEN ASYMMETRIC (t0.c0) AND 
((t0.c2) NOT IN (t0.c2));
+% sys.t0 # table_name
+% c0 # name
+% boolean # type
+% 5 # length
+[ NULL ]
+[ NULL ]
+[ true ]
+[ NULL ]
+[ NULL ]
+[ true ]
+[ NULL ]
+[ true ]
+[ NULL ]
+[ NULL ]
+[ true ]
+[ false]
+[ true ]
+[ NULL ]
+#SELECT t0.c0 FROM t0 WHERE (t0.c2) BETWEEN (t0.c0) AND ((t0.c2) NOT IN 
(t0.c2));
+% sys.t0 # table_name
+% c0 # name
+% boolean # type
+% 5 # length
+#DROP TABLE t0;
+#CREATE TABLE "sys"."t0" (
+#  "c0" BOOLEAN,
+#  "c1" BOOLEAN,
+#  "c2" INTEGER,
+#  CONSTRAINT "t0_c2_pkey" PRIMARY KEY ("c2"),
+#  CONSTRAINT "t0_c0_c1_unique" UNIQUE ("c0", "c1")
+#);
+#INSERT INTO "sys"."t0" VALUES (NULL, true, 10);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, false, 11);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (true, NULL, 12);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, false, 13);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, true, 14);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (true, false, 15);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, true, 16);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (true, true, 17);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, true, 18);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, false, 19);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (true, NULL, 20);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (true, NULL, 21);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (NULL, NULL, 22);
+[ 1]
+#INSERT INTO "sys"."t0" VALUES (false, true, 23);
+[ 1]
+#TRUNCATE t0;
+[ 14   ]
+#DROP TABLE t0;
 
 # 17:14:16 >  
 # 17:14:16 >  "Done."
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - approved output

[Niels Nes]

Changeset: dd0cdf3d1cb8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dd0cdf3d1cb8
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
Branch: Jun2020
Log Message:

approved output


diffs (25 lines):

diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out 
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
@@ -83,8 +83,8 @@ stdout of test 'storagemodel` in directo
 % sys.storagemodel,sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel # table_name
 % schema,  table,  column, type,   count,  columnsize, heapsize,   
hashsize,   imprintsize,orderidxsize,   sorted, unique, isacolumn # name
 % varchar, varchar,varchar,varchar,bigint, bigint, 
bigint, bigint, bigint, bigint, boolean,boolean,boolean # type
-% 3,   7,  1,  3,  5,  5,  4,  1,  4,  1,  
5,  5,  5 # length
-[ "sys",   "bug3923",  "i","int",  1,  1,  8312,   0,  
2000,   0,  true,   NULL,   true]
+% 3,   7,  1,  3,  5,  5,  1,  1,  4,  1,  
5,  5,  5 # length
+[ "sys",   "bug3923",  "i","int",  1,  4,  0,  0,  
8000,   0,  true,   NULL,   true]
 #drop table bug3923;
 #create table bug3923(i integer);
 #select "schema", "table", "column", "type", "mode", case when typewidth < 14 
then typewidth else 99 end as typewidth, hashes, phash, imprints from 
sys.storage('sys','_tables');
@@ -108,8 +108,8 @@ stdout of test 'storagemodel` in directo
 % sys.storagemodel,sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel # table_name
 % schema,  table,  column, type,   count,  columnsize, heapsize,   
hashsize,   imprintsize,orderidxsize,   sorted, unique, isacolumn # name
 % varchar, varchar,varchar,varchar,bigint, bigint, 
bigint, bigint, bigint, bigint, boolean,boolean,boolean # type
-% 13,  7,  1,  3,  5,  5,  4,  1,  4,  1,  
5,  5,  5 # length
-[ "bug3923schema", "bug3923",  "i","int",  1,  1,  8312,   
0,  2000,   0,  true,   NULL,   true]
+% 13,  7,  1,  3,  5,  5,  1,  1,  4,  1,  
5,  5,  5 # length
+[ "bug3923schema", "bug3923",  "i","int",  1,  4,  0,  
0,  8000,   0,  true,   NULL,   true]
 #drop table bug3923;
 
 # 23:38:44 >  
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 32e0e10a1cfb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=32e0e10a1cfb
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (25 lines):

diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out 
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
@@ -83,8 +83,8 @@ stdout of test 'storagemodel` in directo
 % sys.storagemodel,sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel # table_name
 % schema,  table,  column, type,   count,  columnsize, heapsize,   
hashsize,   imprintsize,orderidxsize,   sorted, unique, isacolumn # name
 % varchar, varchar,varchar,varchar,bigint, bigint, 
bigint, bigint, bigint, bigint, boolean,boolean,boolean # type
-% 3,   7,  1,  3,  5,  5,  1,  1,  4,  1,  
5,  5,  5 # length
-[ "sys",   "bug3923",  "i","int",  1,  4,  0,  0,  
8000,   0,  true,   NULL,   true]
+% 3,   7,  1,  3,  5,  5,  4,  1,  4,  1,  
5,  5,  5 # length
+[ "sys",   "bug3923",  "i","int",  1,  1,  8312,   0,  
2000,   0,  true,   NULL,   true]
 #drop table bug3923;
 #create table bug3923(i integer);
 #select "schema", "table", "column", "type", "mode", case when typewidth < 14 
then typewidth else 99 end as typewidth, hashes, phash, imprints from 
sys.storage('sys','_tables');
@@ -108,8 +108,8 @@ stdout of test 'storagemodel` in directo
 % sys.storagemodel,sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel,   sys.storagemodel,   sys.storagemodel,   
sys.storagemodel # table_name
 % schema,  table,  column, type,   count,  columnsize, heapsize,   
hashsize,   imprintsize,orderidxsize,   sorted, unique, isacolumn # name
 % varchar, varchar,varchar,varchar,bigint, bigint, 
bigint, bigint, bigint, bigint, boolean,boolean,boolean # type
-% 13,  7,  1,  3,  5,  5,  1,  1,  4,  1,  
5,  5,  5 # length
-[ "bug3923schema", "bug3923",  "i","int",  1,  4,  0,  
0,  8000,   0,  true,   NULL,   true]
+% 13,  7,  1,  3,  5,  5,  4,  1,  4,  1,  
5,  5,  5 # length
+[ "bug3923schema", "bug3923",  "i","int",  1,  1,  8312,   
0,  2000,   0,  true,   NULL,   true]
 #drop table bug3923;
 
 # 23:38:44 >  
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: b1e60ea29862 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b1e60ea29862
Added Files:
sql/test/miscellaneous/Tests/vessels.sql
sql/test/miscellaneous/Tests/vessels.stable.err
sql/test/miscellaneous/Tests/vessels.stable.out
Modified Files:
sql/test/miscellaneous/Tests/All
Branch: Jun2020
Log Message:

Approved output


diffs (120 lines):

diff --git a/sql/test/miscellaneous/Tests/All b/sql/test/miscellaneous/Tests/All
--- a/sql/test/miscellaneous/Tests/All
+++ b/sql/test/miscellaneous/Tests/All
@@ -16,3 +16,4 @@ deallocate
 table_udf_missing_var
 create_func_temp
 simple_plans
+vessels
diff --git a/sql/test/miscellaneous/Tests/vessels.sql 
b/sql/test/miscellaneous/Tests/vessels.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/vessels.sql
@@ -0,0 +1,34 @@
+start transaction;
+create table vessels (type int, id int, lat real, log real, nav_status int, 
sog int, rot int, timestamp timestamp, insertion_time timestamp);
+CREATE VIEW distinct_vessels AS 
+   SELECT type, id, lat, log, nav_status, sog, rot, timestamp, 
insertion_time from vessels
+   WHERE (timestamp, id) IN (SELECT max(timestamp), id FROM vessels GROUP 
BY id);
+
+CREATE FUNCTION distance_in_km_quick (p1_lat REAL, p1_log REAL, p2_lat REAL, 
p2_log REAL)
+RETURNS REAL
+BEGIN
+   RETURN 111.319 * 
+   SQRT(
+   (p2_lat-p1_lat) * 
+   (p2_lat-p1_lat) + 
+   ((p2_log-p1_log) * cos((p2_lat+p1_lat)*0.00872664626)) * 
+   ((p2_log-p1_log) * cos((p2_lat+p1_lat)*0.00872664626))
+   );
+END;
+
+WITH distance AS (
+   SELECT v1.id AS ship, v2.id AS neighbour_ship, 
distance_in_km_quick(v1.lat,v1.log,v2.lat,v2.log) AS distance_in_km 
+   FROM distinct_vessels AS v1
+   JOIN distinct_vessels AS v2 ON v1.id <> v2.id
+   )
+   SELECT current_timestamp AS calc_time, ship, neighbour_ship, 
distance_in_km FROM distance
+   WHERE (distance_in_km) IN (SELECT min(distance_in_km) FROM distance 
GROUP BY ship);
+
+WITH distance AS (
+   SELECT v1.id AS ship, v2.id AS neighbour_ship, 
distance_in_km_quick(v1.lat,v1.log,v2.lat,v2.log) AS distance_in_km 
+   FROM distinct_vessels AS v1
+   JOIN distinct_vessels AS v2 ON v1.id <> v2.id
+   )
+   SELECT current_timestamp AS calc_time, ship, neighbour_ship, 
distance_in_km FROM distance
+   WHERE (ship, distance_in_km) IN (SELECT ship, min(distance_in_km) FROM 
distance GROUP BY ship);
+rollback;
diff --git a/sql/test/miscellaneous/Tests/vessels.stable.err 
b/sql/test/miscellaneous/Tests/vessels.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/vessels.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'vessels` in directory 'sql/test/miscellaneous` itself:
+
+
+# 17:20:32 >  
+# 17:20:32 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-683674" "--port=37229"
+# 17:20:32 >  
+
+
+# 17:20:32 >  
+# 17:20:32 >  "Done."
+# 17:20:32 >  
+
diff --git a/sql/test/miscellaneous/Tests/vessels.stable.out 
b/sql/test/miscellaneous/Tests/vessels.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/vessels.stable.out
@@ -0,0 +1,51 @@
+stdout of test 'vessels` in directory 'sql/test/miscellaneous` itself:
+
+
+# 17:20:32 >  
+# 17:20:32 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-683674" "--port=37229"
+# 17:20:32 >  
+
+#start transaction;
+#create table vessels (type int, id int, lat real, log real, nav_status int, 
sog int, rot int, timestamp timestamp, insertion_time timestamp);
+#CREATE VIEW distinct_vessels AS 
+#  SELECT type, id, lat, log, nav_status, sog, rot, timestamp, 
insertion_time from vessels
+#  WHERE (timestamp, id) IN (SELECT max(timestamp), id FROM vessels GROUP 
BY id);
+#CREATE FUNCTION distance_in_km_quick (p1_lat REAL, p1_log REAL, p2_lat REAL, 
p2_log REAL)
+#RETURNS REAL
+#BEGIN
+#  RETURN 111.319 * 
+#  SQRT(
+#  (p2_lat-p1_lat) * 
+#  (p2_lat-p1_lat) + 
+#  ((p2_log-p1_log) * cos((p2_lat+p1_lat)*0.00872664626)) * 
+#  ((p2_log-p1_log) * cos((p2_lat+p1_lat)*0.00872664626))
+#  );
+#END;
+#WITH distance AS (
+#  SELECT v1.id AS ship, v2.id AS neighbour_ship, 
distance_in_km_quick(v1.lat,v1.log,v2.lat,v2.log) AS distance_in_km 
+#  FROM distinct_vessels AS v1
+#  JOIN distinct_vessels AS v2 ON v1.id <> v2.id
+#  )
+#  SELECT current_timestamp AS calc_time, ship, neighbour_ship, 
distance_in_km FROM distance
+#  WHERE (distance_in_km) IN (SELECT min(distance_in_km) FROM distance 
GROUP BY ship);
+% .,   sys.distance,   sys.distance,   sys.distance # table_name
+% calc_time,   ship,   neighbour_ship, distance_in_km # name
+% timestamptz, int,int,real # type
+% 32,  1,  1,  15 # length
+#WITH distance AS (
+# 

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 0bd953f385a4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0bd953f385a4
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (23 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
@@ -428,6 +428,19 @@ stdout of test 'sqlancer01` in directory
 #0.17914678733737166
 [ 29   ]
 #ROLLBACK;
+#START TRANSACTION; --Bug 6901
+#CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64));
+#INSERT INTO "t0" VALUES (0.10155454782177964, 'FALSE'), (594212101, NULL), 
(0.5981662672233894, NULL);
+[ 3]
+#SELECT t0.c0 FROM t0 WHERE 
CAST((0.3101399424332040855034620108199305832386016845703125) NOT IN 
(0.6446234112932121007588648353703320026397705078125) AS BOOLEAN);
+% sys.t0 # table_name
+% c0 # name
+% double # type
+% 24 # length
+[ 0.1015545478 ]
+[ 594212101]
+[ 0.5981662672 ]
+#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

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 9eb951b718c3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9eb951b718c3
Modified Files:
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (77 lines):

diff --git a/sql/test/subquery/Tests/subquery6.sql 
b/sql/test/subquery/Tests/subquery6.sql
--- a/sql/test/subquery/Tests/subquery6.sql
+++ b/sql/test/subquery/Tests/subquery6.sql
@@ -87,6 +87,10 @@ SELECT (SELECT 1 FROM another_t t1 WHERE
-- NULL
-- NULL
 
+SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON 
t1.product_category NOT LIKE t2.product_category ORDER BY t1.colid;
+
+SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON 
t1.product_category NOT LIKE t2.product_name ORDER BY t1.colid;
+
 DROP TABLE tbl_ProductSales;
 DROP TABLE another_T;
 DROP TABLE integers;
diff --git a/sql/test/subquery/Tests/subquery6.stable.out 
b/sql/test/subquery/Tests/subquery6.stable.out
--- a/sql/test/subquery/Tests/subquery6.stable.out
+++ b/sql/test/subquery/Tests/subquery6.stable.out
@@ -33,14 +33,14 @@ stdout of test 'subquery6` in directory 
 % tinyint # type
 % 1 # length
 #SELECT (SELECT (SELECT SUM(col1)) IN (MAX(col2))) FROM another_t;
-% sys.%6 # table_name
-% %6 # name
+% sys.%5 # table_name
+% %5 # name
 % boolean # type
 % 5 # length
 [ false]
 #SELECT (SELECT (SELECT SUM(col1)) IN (MAX(col2), '12')) FROM another_t;
-% sys.%7 # table_name
-% %7 # name
+% sys.%6 # table_name
+% %6 # name
 % boolean # type
 % 5 # length
 [ false]
@@ -107,6 +107,40 @@ stdout of test 'subquery6` in directory 
 [ NULL ]
 [ NULL ]
 [ NULL ]
+#SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON 
t1.product_category NOT LIKE t2.product_category ORDER BY t1.colid;
+% sys.t1 # table_name
+% colid # name
+% int # type
+% 1 # length
+[ 1]
+[ 1]
+[ 2]
+[ 2]
+[ 3]
+[ 3]
+[ 4]
+[ 4]
+#SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON 
t1.product_category NOT LIKE t2.product_name ORDER BY t1.colid;
+% sys.t1 # table_name
+% colid # name
+% int # type
+% 1 # length
+[ 1]
+[ 1]
+[ 1]
+[ 1]
+[ 2]
+[ 2]
+[ 2]
+[ 2]
+[ 3]
+[ 3]
+[ 3]
+[ 3]
+[ 4]
+[ 4]
+[ 4]
+[ 4]
 #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

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

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.c0like('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

MonetDB: Jun2020 - approved output

[Niels Nes]

Changeset: cb761c34b7fd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cb761c34b7fd
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.stable.out
Branch: Jun2020
Log Message:

approved output


diffs (15 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
@@ -254,6 +254,11 @@ stdout of test 'sqlancer01` in directory
 % 18 # length
 [ "0.9407860360743894" ]
 #ROLLBACK;
+#SELECT another_t.col1 FROM tbl_productsales CROSS JOIN another_t WHERE 
((tbl_productsales.product_category) NOT IN (tbl_productsales.product_category, 
tbl_productsales.product_category)) IS NULL;
+% sys.another_t # table_name
+% col1 # name
+% int # type
+% 1 # length
 #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

MonetDB: Jun2020 - approved output

[Niels Nes]

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

MonetDB: Jun2020 - Approved output, since bug 6883 has been fixed

[Pedro Ferreira]

Changeset: 82d510745c09 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=82d510745c09
Added Files:
sql/test/SQLancer/Tests/sqlancer01.stable.err
sql/test/SQLancer/Tests/sqlancer01.stable.out
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:

Approved output, since bug 6883 has been fixed


diffs (156 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
@@ -8,7 +8,10 @@ INSERT INTO integers VALUES (1), (2), (3
 START TRANSACTION;
 -- Bug 6883
 select 1 from integers where (((0.7161494983624688) in (integers.i)) = true) = 
false;
-   --empty
+   -- 1
+   -- 1
+   -- 1
+
 delete from integers where (((0.7161494983624688) in (integers.i)) = true) = 
false;
-- 3 rows affected
 select i from integers;
diff --git a/sql/test/SQLancer/Tests/sqlancer01.stable.err 
b/sql/test/SQLancer/Tests/sqlancer01.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer01.stable.err
@@ -0,0 +1,31 @@
+stderr of test 'sqlancer01` in directory 'sql/test/SQLancer` itself:
+
+
+# 11:08:10 >  
+# 11:08:10 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=30085" "--set" 
"mapi_usock=/var/tmp/mtest-117725/.s.monetdb.30085" "--forcemito" 
"--dbpath=/home/ferreira/repositories/MonetDB-Jun2020/BUILD/var/MonetDB/mTests_sql_test_SQLancer"
 "--set" "embedded_c=true"
+# 11:08:10 >  
+
+# builtin opt  gdk_dbpath = 
/home/ferreira/repositories/MonetDB-Jun2020/BUILD/var/monetdb5/dbfarm/demo
+# builtin opt  mapi_port = 5
+# 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 = 30085
+# cmdline opt  mapi_usock = /var/tmp/mtest-117725/.s.monetdb.30085
+# cmdline opt  gdk_dbpath = 
/home/ferreira/repositories/MonetDB-Jun2020/BUILD/var/MonetDB/mTests_sql_test_SQLancer
+# cmdline opt  embedded_c = true
+
+# 11:08:12 >  
+# 11:08:12 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-117725" "--port=30085"
+# 11:08:12 >  
+
+
+# 11:08:12 >  
+# 11:08:12 >  "Done."
+# 11:08:12 >  
+
diff --git a/sql/test/SQLancer/Tests/sqlancer01.stable.out 
b/sql/test/SQLancer/Tests/sqlancer01.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer01.stable.out
@@ -0,0 +1,100 @@
+stdout of test 'sqlancer01` in directory 'sql/test/SQLancer` itself:
+
+
+# 11:08:10 >  
+# 11:08:10 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=30085" "--set" 
"mapi_usock=/var/tmp/mtest-117725/.s.monetdb.30085" "--forcemito" 
"--dbpath=/home/ferreira/repositories/MonetDB-Jun2020/BUILD/var/MonetDB/mTests_sql_test_SQLancer"
 "--set" "embedded_c=true"
+# 11:08:10 >  
+
+# MonetDB 5 server v11.37.0 (hg id: a964bf319dab)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_SQLancer', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
+# Found 15.496 GiB available main-memory of which we use 12.629 GiB
+# Copyright (c) 1993 - July 2008 CWI.
+# Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved
+# Visit https://www.monetdb.org/ for further information
+# Listening for connection requests on 
mapi:monetdb://localhost.localdomain:30085/
+# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-117725/.s.monetdb.30085
+# MonetDB/GIS module loaded
+# SQL catalog created, loading sql scripts once
+# loading sql script: 09_like.sql
+# loading sql script: 10_math.sql
+# loading sql script: 12_url.sql
+# loading sql script: 13_date.sql
+# loading sql script: 14_inet.sql
+# loading sql script: 15_querylog.sql
+# loading sql script: 16_tracelog.sql
+# loading sql script: 17_temporal.sql
+# loading sql script: 18_index.sql
+# loading sql script: 20_vacuum.sql
+# loading sql script: 21_dependency_views.sql
+# loading sql script: 22_clients.sql
+# loading sql script: 23_skyserver.sql
+# loading sql script: 25_debug.sql
+# loading sql script: 26_sysmon.sql
+# loading sql script: 27_rejects.sql
+# loading sql script: 39_analytics.sql
+# loading sql script: 39_analytics_hge.sql
+# loading sql script: 40_geom.sql
+# loading sql script: 40_json.sql
+# loading sql script: 40_json_hge.sql
+# loading sql script: 41_md5sum.sql
+# loading sql script: 45_uuid.sql
+# loading sql script: 46_profiler.sql
+# loading sql script: 51_sys_schema_extension.sql
+# loading sql script: 58_hot_snapshot.sql
+# loading sql script: 60_wlcr.sql
+# loading sql script: 61_wlcr.sql
+# loading sql script: 72_fits.sql
+# loading sql script: 74_netcdf.sql
+# loading sql script: 

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 1ea955fc42c0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1ea955fc42c0
Added Files:
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out
Modified Files:
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql
Branch: Jun2020
Log Message:

Approved output


diffs (99 lines):

diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql 
b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql
--- a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql
+++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql
@@ -17,5 +17,7 @@ 0.715
 0.809
 0.504
 
+
+select (temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, 
temp_table where temp_value.vvalue<=temp_table.norm_max and 
temp_value.vvalue>temp_table.norm_min;
 select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin 
from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and 
temp_value.vvalue>temp_table.norm_min;
 rollback;
diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err 
b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'select-and.Bug-6878` in directory 'sql/test/BugTracker-2020` 
itself:
+
+
+# 12:06:59 >  
+# 12:06:59 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-28423" "--port=31728"
+# 12:06:59 >  
+
+
+# 12:06:59 >  
+# 12:06:59 >  "Done."
+# 12:06:59 >  
+
diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out 
b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out
@@ -0,0 +1,66 @@
+stdout of test 'select-and.Bug-6878` in directory 'sql/test/BugTracker-2020` 
itself:
+
+
+# 12:06:59 >  
+# 12:06:59 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-28423" "--port=31728"
+# 12:06:59 >  
+
+#start transaction;
+#CREATE TABLE temp_table(norm_min float, norm_max float, mmin float, mmax 
float);
+#INSERT INTO temp_table VALUES (0.0,0.17424371009,6.0,12.25);
+[ 1]
+#INSERT INTO temp_table VALUES (0.17424371009,0.2865480811,12.5,18.5);
+[ 1]
+#INSERT INTO temp_table VALUES (0.2865480811,0.7201958679,18.5,24.75);
+[ 1]
+#INSERT INTO temp_table VALUES (0.7201958679,1.0,24.75,31.0);
+[ 1]
+#CREATE TABLE temp_value(vvalue float);
+#COPY 10 RECORDS INTO "sys"."temp_value" FROM stdin USING DELIMITERS 
E'\t',E'\n','"';
+#0.72
+#0.524
+#0.782
+#0.936
+#0.94
+#0.111
+#0.776
+#0.715
+#0.809
+#0.504
+[ 10   ]
+#select (temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, 
temp_table where temp_value.vvalue<=temp_table.norm_max and 
temp_value.vvalue>temp_table.norm_min;
+% sys.%1 # table_name
+% %1 # name
+% double # type
+% 24 # length
+[ 24.75]
+[ 24.75]
+[ 31   ]
+[ 31   ]
+[ 31   ]
+[ 12.25]
+[ 31   ]
+[ 24.75]
+[ 24.75]
+[ 31   ]
+#select (0.72/2147483648.0)*(temp_table.mmax - 
temp_table.mmin)+temp_table.mmin from temp_value, temp_table where 
temp_value.vvalue<=temp_table.norm_max and 
temp_value.vvalue>temp_table.norm_min;
+% .%1 # table_name
+% %1 # name
+% double # type
+% 24 # length
+[ 18.5 ]
+[ 18.5 ]
+[ 24.75]
+[ 24.75]
+[ 24.75]
+[ 6]
+[ 24.75]
+[ 18.5 ]
+[ 18.5 ]
+[ 24.75]
+#rollback;
+
+# 12:06:59 >  
+# 12:06:59 >  "Done."
+# 12:06:59 >  
+
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output and a small new bug (cardinal...

[Pedro Ferreira]

Changeset: 1c03f60e1b53 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1c03f60e1b53
Modified Files:
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.out
Branch: Jun2020
Log Message:

Approved output and a small new bug (cardinality check done wrong)


diffs (64 lines):

diff --git a/sql/test/subquery/Tests/subquery6.sql 
b/sql/test/subquery/Tests/subquery6.sql
--- a/sql/test/subquery/Tests/subquery6.sql
+++ b/sql/test/subquery/Tests/subquery6.sql
@@ -63,12 +63,24 @@ SELECT ColID FROM tbl_ProductSales WHERE
-- 3
-- 4
 
-SELECT SUM((SELECT col1)) FROM another_t;
+SELECT CAST(SUM((SELECT col1)) AS BIGINT) FROM another_t;
-- 1234
 
-SELECT SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) FROM another_t;
+SELECT CAST(SUM((SELECT col1 + col2)) AS BIGINT) FROM another_t;
+   -- 3702
+
+SELECT CAST(SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) AS BIGINT) FROM 
another_t;
-- 4
 
+SELECT CAST(SUM((SELECT (SELECT col1 + col2))) AS BIGINT) FROM another_t;
+   -- 3702
+
+SELECT CAST((SELECT SUM((SELECT col1))) AS BIGINT) FROM another_t;
+   -- 1234
+
+SELECT CAST((SELECT SUM((SELECT col1 + col2))) AS BIGINT) FROM another_t;
+   -- 3702
+
 DROP TABLE tbl_ProductSales;
 DROP TABLE another_T;
 DROP TABLE integers;
diff --git a/sql/test/subquery/Tests/subquery6.stable.out 
b/sql/test/subquery/Tests/subquery6.stable.out
--- a/sql/test/subquery/Tests/subquery6.stable.out
+++ b/sql/test/subquery/Tests/subquery6.stable.out
@@ -65,15 +65,27 @@ stdout of test 'subquery6` in directory 
 #SELECT SUM((SELECT col1)) FROM another_t;
 % sys.%2 # table_name
 % %2 # name
-% hugeint # type
+% bigint # type
 % 4 # length
 [ 1234 ]
-#SELECT SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) FROM another_t;
+#SELECT CAST(SUM((SELECT col1 + col2)) AS BIGINT) FROM another_t;
+% sys.%2 # table_name
+% %2 # name
+% bigint # type
+% 4 # length
+[ 3702 ]
+#SELECT CAST(SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) AS BIGINT) FROM 
another_t;
 % sys.%3 # table_name
 % %3 # name
-% hugeint # type
+% bigint # type
 % 1 # length
 [ 4]
+#SELECT CAST(SUM((SELECT (SELECT col1 + col2))) AS BIGINT) FROM another_t;
+% sys.%2 # table_name
+% %2 # name
+% bigint # type
+% 4 # length
+[ 3702 ]
 #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

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: e8d0eb4724e9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e8d0eb4724e9
Modified Files:
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: Jun2020
Log Message:

Approved output


diffs (22 lines):

diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out 
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -1140,6 +1140,7 @@ stdout of test 'systemfunctions` in dire
 [ "sys",   "listagg",  1,  "varchar",  ""  ]
 [ "sys",   "listagg",  0,  "varchar",  "str_group_concat"  
]
 [ "sys",   "listagg",  1,  "varchar",  ""  ]
+[ "sys",   "listagg",  2,  "varchar",  ""  ]
 [ "sys",   "listagg",  0,  "varchar",  "str_group_concat"  
]
 [ "sys",   "listagg",  1,  "varchar",  ""  ]
 [ "sys",   "listagg",  0,  "varchar",  "str_group_concat"  
]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 
b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
@@ -1231,6 +1231,7 @@ stdout of test 'systemfunctions` in dire
 [ "sys",   "listagg",  1,  "varchar",  ""  ]
 [ "sys",   "listagg",  0,  "varchar",  "str_group_concat"  
]
 [ "sys",   "listagg",  1,  "varchar",  ""  ]
+[ "sys",   "listagg",  2,  "varchar",  ""  ]
 [ "sys",   "listagg",  0,  "varchar",  "str_group_concat"  
]
 [ "sys",   "listagg",  1,  "varchar",  ""  ]
 [ "sys",   "listagg",  0,  "varchar",  "str_group_concat"  
]
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output and added missing cardinality...

[Pedro Ferreira]

Changeset: 3b6769af644a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3b6769af644a
Modified Files:
sql/server/rel_rel.h
sql/server/rel_select.c
sql/server/rel_updates.c
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.err
Branch: Jun2020
Log Message:

Approved output and added missing cardinality check for merge statements


diffs (108 lines):

diff --git a/sql/server/rel_rel.h b/sql/server/rel_rel.h
--- a/sql/server/rel_rel.h
+++ b/sql/server/rel_rel.h
@@ -29,6 +29,7 @@
 #define sql_psm_set  (1 << 13) //ORed
 #define sql_values   (1 << 14) //ORed
 #define psm_call (1 << 15) //ORed
+#define sql_merge(1 << 16) //ORed
 
 #define is_sql_from(X) ((X & sql_from) == sql_from)
 #define is_sql_where(X)((X & sql_where) == sql_where)
@@ -46,6 +47,7 @@
 #define is_sql_psm_set(X)  ((X & sql_psm_set) == sql_psm_set)
 #define is_sql_values(X)   ((X & sql_values) == sql_values)
 #define is_psm_call(X) ((X & psm_call) == psm_call)
+#define is_sql_merge(X)((X & sql_merge) == sql_merge)
 
 #define is_updateble(rel) \
(rel->op == op_basetable || \
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -2451,7 +2451,7 @@ rel_logical_value_exp(sql_query *query, 
return NULL;
if (ek.card <= card_set && is_project(sq->op) && 
list_length(sq->exps) > 1)
return sql_error(sql, 02, SQLSTATE(42000) "SELECT: 
subquery must return only one column");
-   if (ek.card < card_set && sq->card >= CARD_MULTI && 
(is_sql_sel(f) | is_sql_having(f) | ( is_sql_where(f) && rel && (!*rel || 
is_basetable((*rel)->op) || is_simple_project((*rel)->op)
+   if (ek.card < card_set && sq->card >= CARD_MULTI && 
(is_sql_sel(f) | is_sql_having(f) | ( is_sql_where(f) && rel && (!*rel || 
is_basetable((*rel)->op) || is_simple_project((*rel)->op) || is_sql_merge(f)
sq = rel_zero_or_one(sql, sq, ek);
return exp_rel(sql, sq);
}
diff --git a/sql/server/rel_updates.c b/sql/server/rel_updates.c
--- a/sql/server/rel_updates.c
+++ b/sql/server/rel_updates.c
@@ -1300,7 +1300,7 @@ merge_into_table(sql_query *query, dlist
if (isMergeTable(t))
return sql_error(sql, 02, SQLSTATE(42000) "MERGE: merge 
statements not available for merge tables yet");
 
-   bt = rel_basetable(sql, t, alias ? alias : t->base.name);
+   bt = rel_basetable(sql, t, alias ? alias : tname);
joined = table_ref(query, NULL, tref, 0);
if (!bt || !joined)
return NULL;
@@ -1335,7 +1335,7 @@ merge_into_table(sql_query *query, dlist
join_rel = rel_dup(join_rel);
} else {
join_rel = rel_crossproduct(sql->sa, 
joined, bt, op_left);
-   if (!(join_rel = rel_logical_exp(query, 
join_rel, search_cond, sql_where | sql_join)))
+   if (!(join_rel = rel_logical_exp(query, 
join_rel, search_cond, sql_where | sql_join | sql_merge)))
return NULL;
set_processed(join_rel);
}
@@ -1372,7 +1372,7 @@ merge_into_table(sql_query *query, dlist
join_rel = rel_dup(join_rel);
} else {
join_rel = rel_crossproduct(sql->sa, 
joined, bt, op_left);
-   if (!(join_rel = rel_logical_exp(query, 
join_rel, search_cond, sql_where | sql_join)))
+   if (!(join_rel = rel_logical_exp(query, 
join_rel, search_cond, sql_where | sql_join | sql_merge)))
return NULL;
set_processed(join_rel);
}
@@ -1413,7 +1413,7 @@ merge_into_table(sql_query *query, dlist
join_rel = rel_dup(join_rel);
} else {
join_rel = rel_crossproduct(sql->sa, joined, 
bt, op_left);
-   if (!(join_rel = rel_logical_exp(query, 
join_rel, search_cond, sql_where | sql_join)))
+   if (!(join_rel = rel_logical_exp(query, 
join_rel, search_cond, sql_where | sql_join | sql_merge)))
return NULL;
set_processed(join_rel);
}
diff --git a/sql/test/subquery/Tests/subquery6.sql 
b/sql/test/subquery/Tests/subquery6.sql
--- a/sql/test/subquery/Tests/subquery6.sql
+++ b/sql/test/subquery/Tests/subquery6.sql
@@ -11,6 +11,15 @

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: c04b8dfd8d59 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c04b8dfd8d59
Modified Files:
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: Jun2020
Log Message:

Approved output


diffs (38 lines):

diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out 
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -3503,15 +3503,6 @@ stdout of test 'systemfunctions` in dire
 [ "sys",   "sinh", 1,  "real", ""  ]
 [ "sys",   "sinh", 0,  "double",   "sinh"  ]
 [ "sys",   "sinh", 1,  "double",   ""  ]
-[ "sys",   "sleep",0,  "tinyint",  "create procedure 
sys.\"sleep\"(msecs tinyint)\n external name \"alarm\".\"sleep\";"]
-[ "sys",   "sleep",0,  "smallint", "create procedure 
sys.\"sleep\"(msecs smallint)\n external name \"alarm\".\"sleep\";"   ]
-[ "sys",   "sleep",0,  "int",  "create procedure 
sys.\"sleep\"(msecs int)\n external name \"alarm\".\"sleep\";"]
-[ "sys",   "sleep",0,  "tinyint",  "create function 
sys.\"sleep\"(msecs tinyint) returns tinyint\n external name 
\"alarm\".\"sleep\";" ]
-[ "sys",   "sleep",1,  "tinyint",  ""  ]
-[ "sys",   "sleep",0,  "smallint", "create function 
sys.\"sleep\"(msecs smallint) returns smallint\n external name 
\"alarm\".\"sleep\";"   ]
-[ "sys",   "sleep",1,  "smallint", ""  ]
-[ "sys",   "sleep",0,  "int",  "create function 
sys.\"sleep\"(msecs int) returns int\n external name \"alarm\".\"sleep\";" ]
-[ "sys",   "sleep",1,  "int",  ""  ]
 [ "sys",   "soundex",  0,  "char", "soundex"   ]
 [ "sys",   "soundex",  1,  "char", ""  ]
 [ "sys",   "soundex",  0,  "varchar",  "soundex"   ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 
b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
@@ -3923,15 +3923,6 @@ stdout of test 'systemfunctions` in dire
 [ "sys",   "sinh", 1,  "real", ""  ]
 [ "sys",   "sinh", 0,  "double",   "sinh"  ]
 [ "sys",   "sinh", 1,  "double",   ""  ]
-[ "sys",   "sleep",0,  "tinyint",  "create procedure 
sys.\"sleep\"(msecs tinyint)\n external name \"alarm\".\"sleep\";"]
-[ "sys",   "sleep",0,  "smallint", "create procedure 
sys.\"sleep\"(msecs smallint)\n external name \"alarm\".\"sleep\";"   ]
-[ "sys",   "sleep",0,  "int",  "create procedure 
sys.\"sleep\"(msecs int)\n external name \"alarm\".\"sleep\";"]
-[ "sys",   "sleep",0,  "tinyint",  "create function 
sys.\"sleep\"(msecs tinyint) returns tinyint\n external name 
\"alarm\".\"sleep\";" ]
-[ "sys",   "sleep",1,  "tinyint",  ""  ]
-[ "sys",   "sleep",0,  "smallint", "create function 
sys.\"sleep\"(msecs smallint) returns smallint\n external name 
\"alarm\".\"sleep\";"   ]
-[ "sys",   "sleep",1,  "smallint", ""  ]
-[ "sys",   "sleep",0,  "int",  "create function 
sys.\"sleep\"(msecs int) returns int\n external name \"alarm\".\"sleep\";" ]
-[ "sys",   "sleep",1,  "int",  ""  ]
 [ "sys",   "soundex",  0,  "char", "soundex"   ]
 [ "sys",   "soundex",  1,  "char", ""  ]
 [ "sys",   "soundex",  0,  "varchar",  "soundex"   ]
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 212d5a3aa687 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=212d5a3aa687
Modified Files:
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: Jun2020
Log Message:

Approved output


diffs (24 lines):

diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out 
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -857,7 +857,7 @@ stdout of test 'systemfunctions` in dire
 [ "sys",   "host", 1,  "inet", ""  ]
 [ "sys",   "hostmask", 0,  "inet", "create function \"hostmask\" 
(p inet) returns inet\n external name inet.\"hostmask\";" ]
 [ "sys",   "hostmask", 1,  "inet", ""  ]
-[ "sys",   "hot_snapshot", 0,  "clob", "create procedure 
hot_snapshot(tarfile string)\n external name sql.hot_snapshot;"   ]
+[ "sys",   "hot_snapshot", 0,  "clob", "create procedure 
sys.hot_snapshot(tarfile string)\n external name sql.hot_snapshot;"   ]
 [ "sys",   "hour", 0,  "int",  "hours" ]
 [ "sys",   "hour", 1,  "time", ""  ]
 [ "sys",   "hour", 0,  "int",  "hours" ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 
b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
@@ -920,7 +920,7 @@ stdout of test 'systemfunctions` in dire
 [ "sys",   "host", 1,  "inet", ""  ]
 [ "sys",   "hostmask", 0,  "inet", "create function \"hostmask\" 
(p inet) returns inet\n external name inet.\"hostmask\";" ]
 [ "sys",   "hostmask", 1,  "inet", ""  ]
-[ "sys",   "hot_snapshot", 0,  "clob", "create procedure 
hot_snapshot(tarfile string)\n external name sql.hot_snapshot;"   ]
+[ "sys",   "hot_snapshot", 0,  "clob", "create procedure 
sys.hot_snapshot(tarfile string)\n external name sql.hot_snapshot;"   ]
 [ "sys",   "hour", 0,  "int",  "hours" ]
 [ "sys",   "hour", 1,  "time", ""  ]
 [ "sys",   "hour", 0,  "int",  "hours" ]
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 3c2417633475 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3c2417633475
Modified Files:
sql/test/subquery/Tests/subquery5.stable.err
Branch: Jun2020
Log Message:

Approved output


diffs (22 lines):

diff --git a/sql/test/subquery/Tests/subquery5.stable.err 
b/sql/test/subquery/Tests/subquery5.stable.err
--- a/sql/test/subquery/Tests/subquery5.stable.err
+++ b/sql/test/subquery/Tests/subquery5.stable.err
@@ -30,6 +30,18 @@ MAPI  = (monetdb) /var/tmp/mtest-371889/
 QUERY = CREATE OR REPLACE FUNCTION evilfunction(input INT) RETURNS INT BEGIN 
RETURN SELECT input, 2; END; --error, more than 1 return
 ERROR = !SELECT: subquery must return only one column
 CODE  = 42000
+MAPI  = (monetdb) /var/tmp/mtest-232134/.s.monetdb.30965
+QUERY = SELECT evilfunction(1);
+ERROR = !Cardinality violation, scalar value expected
+CODE  = 21000
+MAPI  = (monetdb) /var/tmp/mtest-232134/.s.monetdb.30965
+QUERY = SELECT evilfunction(1);
+ERROR = !Cardinality violation, scalar value expected
+CODE  = 21000
+MAPI  = (monetdb) /var/tmp/mtest-232134/.s.monetdb.30965
+QUERY = SELECT evilfunction(1), 1;
+ERROR = !Cardinality violation, scalar value expected
+CODE  = 21000
 
 # 08:41:39 >  
 # 08:41:39 >  "Done."
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: e32a784535f7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e32a784535f7
Added Files:
sql/test/subquery/Tests/subquery5.stable.err
sql/test/subquery/Tests/subquery5.stable.out
Modified Files:
sql/test/subquery/Tests/subquery5.sql
Branch: Jun2020
Log Message:

Approved output


diffs (113 lines):

diff --git a/sql/test/subquery/Tests/subquery5.sql 
b/sql/test/subquery/Tests/subquery5.sql
--- a/sql/test/subquery/Tests/subquery5.sql
+++ b/sql/test/subquery/Tests/subquery5.sql
@@ -9,21 +9,19 @@ SELECT
 (SELECT MIN(col1) GROUP BY col2)
 FROM another_T; --error, subquery uses ungrouped column "another_T.col2" from 
outer query
 
-
 SELECT
 (SELECT MIN(col1) WHERE SUM(col2) > 1),
 CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) AS BIGINT)
 FROM another_T GROUP BY col2;
-
-SELECT
-(SELECT MIN(col1) WHERE SUM(SUM(col2)) > 1),
-CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) AS BIGINT)
-FROM another_T GROUP BY col2;
-- 11
-- 11   11
-- 111  111
--  
--- The crash happens because of the nested aggregates
+
+SELECT
+(SELECT MIN(col1) WHERE SUM(SUM(col2)) > 1),
+CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) AS BIGINT)
+FROM another_T GROUP BY col2; --error, aggregate function calls cannot be 
nested
 
 SELECT 
 CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) OVER () AS 
BIGINT), 
diff --git a/sql/test/subquery/Tests/subquery5.stable.err 
b/sql/test/subquery/Tests/subquery5.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/subquery/Tests/subquery5.stable.err
@@ -0,0 +1,25 @@
+stderr of test 'subquery5` in directory 'sql/test/subquery` itself:
+
+
+# 08:41:39 >  
+# 08:41:39 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-11456" "--port=33245"
+# 08:41:39 >  
+
+MAPI  = (monetdb) /var/tmp/mtest-11456/.s.monetdb.33245
+QUERY = SELECT
+(SELECT MIN(col1) GROUP BY col2)
+FROM another_T; --error, subquery uses ungrouped column 
"another_T.col2" from outer query
+ERROR = !SELECT: subquery uses ungrouped column "another_t.col2" from outer 
query
+CODE  = 42000
+MAPI  = (monetdb) /var/tmp/mtest-11456/.s.monetdb.33245
+QUERY = SELECT
+(SELECT MIN(col1) WHERE SUM(SUM(col2)) > 1),
+CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) AS 
BIGINT)
+FROM another_T GROUP BY col2; --error, aggregate function calls cannot 
be nested
+ERROR = !SELECT: aggregate function calls cannot be nested
+CODE  = 42000
+
+# 08:41:39 >  
+# 08:41:39 >  "Done."
+# 08:41:39 >  
+
diff --git a/sql/test/subquery/Tests/subquery5.stable.out 
b/sql/test/subquery/Tests/subquery5.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/subquery/Tests/subquery5.stable.out
@@ -0,0 +1,48 @@
+stdout of test 'subquery5` in directory 'sql/test/subquery` itself:
+
+
+# 08:41:39 >  
+# 08:41:39 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-11456" "--port=33245"
+# 08:41:39 >  
+
+#CREATE TABLE tbl_ProductSales (ColID int, Product_Category  varchar(64), 
Product_Name  varchar(64), TotalSales int); 
+#INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO 
Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100);
+[ 4]
+#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), (,,,,,,,);
+[ 4]
+#CREATE TABLE integers(i INTEGER);
+#INSERT INTO integers VALUES (1), (2), (3), (NULL);
+[ 4]
+#SELECT
+#(SELECT MIN(col1) WHERE SUM(col2) > 1),
+#CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) AS BIGINT)
+#FROM another_T GROUP BY col2;
+% .%2, .%5 # table_name
+% %2,  %5 # name
+% int, bigint # type
+% 4,   4 # length
+[ 1,   1   ]
+[ 11,  11  ]
+[ 111, 111 ]
+[ ,]
+#SELECT 
+#CAST(SUM((SELECT col1 FROM tbl_ProductSales GROUP BY col2)) OVER () AS 
BIGINT), 
+#CAST(SUM((SELECT SUM(ColID) FROM tbl_ProductSales GROUP BY col2)) OVER () 
AS BIGINT)
+#FROM another_T;
+% .%11,.%22 # table_name
+% %11, %22 # name
+% bigint,  bigint # type
+% 4,   2 # length
+[ 1234,40  ]
+[ 1234,40  ]
+[ 1234,40  ]
+[ 1234,40  ]
+#DROP TABLE tbl_ProductSales;
+#DROP TABLE another_T;
+#DROP TABLE integers;
+
+# 08:41:39 >  
+# 08:41:39 >  "Done."
+# 08:41:39 >  
+
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output after changeset ef41ae0f5e1c ...

[Pedro Ferreira]

Changeset: 4932665f33d4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4932665f33d4
Modified Files:
sql/test/miscellaneous/Tests/groupby_error.sql
sql/test/miscellaneous/Tests/groupby_error.stable.out
Branch: Jun2020
Log Message:

Approved output after changeset ef41ae0f5e1c Added new failing queries from 
batcalc changes.


diffs (53 lines):

diff --git a/sql/test/miscellaneous/Tests/groupby_error.sql 
b/sql/test/miscellaneous/Tests/groupby_error.sql
--- a/sql/test/miscellaneous/Tests/groupby_error.sql
+++ b/sql/test/miscellaneous/Tests/groupby_error.sql
@@ -45,6 +45,25 @@ SELECT col0 FROM tab0 ORDER BY tab0.col0
-- 87
-- 97
 
+SELECT DISTINCT 99 col2 FROM tab1 WHERE NOT - ( 43 ) + + 98 = + col2;
+   -- 99
+
+SELECT * FROM tab2 AS cor0 WHERE NOT - 59 + + 47 <> + ( + col0 );
+   -- empty
+
+SELECT + col2 * col2 FROM tab2 AS cor0 WHERE NOT - CAST ( NULL AS INTEGER ) <> 
- - col1 AND NOT NULL NOT BETWEEN ( NULL ) AND - 91 - - + 27 * + col2;
+   -- empty
+
+SELECT + 2 FROM tab0 AS cor0 WHERE NOT - 29 IS NULL OR NOT NULL IS NULL AND 
NOT NULL BETWEEN + col1 - + 60 AND + 37 * + col1 + + col0;
+   -- 2
+   -- 2
+   -- 2
+
+SELECT DISTINCT * FROM tab2 WHERE NOT ( - + 50 + ( 70 ) ) = + col2;
+   -- 64 77 40
+   -- 46 51 23
+   -- 75 67 58
+
 SELECT col0 FROM tab0 ORDER BY sys.tab0.col0; --error, TODO
 
 prepare select col0 from tab0 where (?) in (select col0 from tab0);
diff --git a/sql/test/miscellaneous/Tests/groupby_error.stable.out 
b/sql/test/miscellaneous/Tests/groupby_error.stable.out
--- a/sql/test/miscellaneous/Tests/groupby_error.stable.out
+++ b/sql/test/miscellaneous/Tests/groupby_error.stable.out
@@ -112,6 +112,20 @@ stdout of test 'groupby_error` in direct
 % col0,col1,   col2 # name
 % int, int,int # type
 % 1,   1,  1 # length
+#SELECT * FROM tab2 AS cor0 WHERE NOT - ( - + 57 ) + - ( ( - - col2 ) ) 
BETWEEN + - col2 AND + col2;
+% sys.cor0,sys.cor0,   sys.cor0 # table_name
+% col0,col1,   col2 # name
+% int, int,int # type
+% 2,   2,  2 # length
+[ 46,  51, 23  ]
+#SELECT col0 FROM tab2 WHERE - - col2;
+% sys.tab2 # table_name
+% col0 # name
+% int # type
+% 2 # length
+[ 64   ]
+[ 75   ]
+[ 46   ]
 #PLAN SELECT col0 FROM tab2 WHERE CAST(col2 AS BIGINT) = 40;
 % .plan # table_name
 % rel # name
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: Jun2020 - Approved output

[Pedro Ferreira]

Changeset: 6d7388f68bff for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6d7388f68bff
Modified Files:
sql/test/subquery/Tests/subquery4.stable.out
Branch: Jun2020
Log Message:

Approved output


diffs (16 lines):

diff --git a/sql/test/subquery/Tests/subquery4.stable.out 
b/sql/test/subquery/Tests/subquery4.stable.out
--- a/sql/test/subquery/Tests/subquery4.stable.out
+++ b/sql/test/subquery/Tests/subquery4.stable.out
@@ -300,6 +300,12 @@ stdout of test 'subquery4` in directory 
 [ 3,   2   ]
 [ 3,   3   ]
 [ 3,   NULL]
+#SELECT 1 IN ((SELECT MIN(col2)), (SELECT SUM(col4))) FROM another_t;
+% .%20 # table_name
+% %20 # name
+% boolean # type
+% 5 # length
+[ false]
 #DECLARE myvar INT;
 #DECLARE ovar INT;
 #DECLARE abc,def INT;
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list