MonetDB: Mar2018 - approved output
Changeset: 5550f56434fc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5550f56434fc Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.err sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.stable.err sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.stable.out Branch: Mar2018 Log Message: approved output diffs (168 lines): diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.err b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.err @@ -0,0 +1,34 @@ +stderr of test 'sqlitelogictest-in-query.Bug-6545` in directory 'sql/test/BugTracker-2018` itself: + + +# 13:58:13 > +# 13:58:13 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=37083" "--set" "mapi_usock=/var/tmp/mtest-9356/.s.monetdb.37083" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018" +# 13:58:13 > + +# builtin opt gdk_dbpath = /home/niels/scratch/rc-monetdb/Linux-x86_64/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = no +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 5 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 37083 +# cmdline opt mapi_usock = /var/tmp/mtest-9356/.s.monetdb.37083 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /home/niels/scratch/rc-monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018 +# cmdline opt gdk_debug = 553648138 + +# 13:58:13 > +# 13:58:13 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-9356" "--port=37083" +# 13:58:13 > + + +# 13:58:13 > +# 13:58:13 > "Done." +# 13:58:13 > + diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.out b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.stable.out @@ -0,0 +1,40 @@ +stdout of test 'sqlitelogictest-in-query.Bug-6545` in directory 'sql/test/BugTracker-2018` itself: + + +# 13:58:13 > +# 13:58:13 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=37083" "--set" "mapi_usock=/var/tmp/mtest-9356/.s.monetdb.37083" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018" +# 13:58:13 > + +# MonetDB 5 server v11.29.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2018', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 7.324 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.nes.nl:37083/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-9356/.s.monetdb.37083 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 13:58:13 > +# 13:58:13 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-9356" "--port=37083" +# 13:58:13 > + +#CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +#INSERT INTO tab0 VALUES (97,1,99),(15,81,47),(87,21,10); +[ 3] +#SELECT DISTINCT * FROM tab0 AS cor0 WHERE - 60 + ( + - col0 ) IN ( + - CAST ( 35 AS INTEGER ) * + ( - 3 ) * - 91 * + + 87, - col0 * + col2 * 18 ); +% sys.cor0,sys.cor0, sys.cor0 # table_name +% col0,col1, col2 # name +% int, int,int # type +% 1, 1, 1 # length +#DROP TABLE tab0; + +# 13:58:13 > +# 13:58:13 > "Done." +# 13:58:13 > + diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.stable.err b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.stable.err @@ -0,0 +1,34 @@ +stderr of test 'sqlitelogictest-in-with-division.Bug-6546` in directory 'sql/test/BugTracker-2018` itself: + + +# 13:58:13 > +# 13:58:13 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=37083" "--set" "mapi_usock=/var/tmp/mtest-9356/.s.monetdb.37083"
MonetDB: Mar2018 - approved output
Changeset: 209a36cef5ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=209a36cef5ba
Modified Files:
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
Branch: Mar2018
Log Message:
approved output
diffs (275 lines):
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
@@ -77,7 +77,7 @@ Ready.
% .plan # table_name
% rel # name
% clob # type
-% 148 # length
+% 150 # length
project (
| group by (
| | project (
@@ -88,36 +88,240 @@ project (
| | | | | | | project (
| | | | | | | | project (
| | | | | | | | | project (
-| | | | | | | | | | left outer join (
+| | | | | | | | | | project (
| | | | | | | | | | | left outer join (
-| | | | | | | | | | | | join (
+| | | | | | | | | | | | left outer 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" ],
-| | | | | | | | | | | | table(sys.systemfunctions) [
"systemfunctions"."function_id" NOT NULL as "sf"."function_id" ] COUNT
-| | | | | | | | | | | ) [ "f"."id" = "sf"."function_id" NOT NULL ],
-| | | | | | | | | | | 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", "p"."number" ASC ]
-| | | | | | | | ) [ "f"."id", "p"."number" ]
-| | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id", "p"."number" ]
-| | | | | | ) [ "f"."id", "p"."number" ]
-| | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
-| | | | ) [ "f"."id" ]
+| | | | | | | | | | | | | | 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" ],
+| | | | | | | | | | | | | table(sys.systemfunctions) [
"systemfunctions"."function_id" NOT NULL as "sf"."function_id" ] COUNT
+| | | | | | | | | | | | ) [ "f"."id" = "sf"."function_id" NOT NULL ],
+| | | | | | | | | | | | 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", "p"."number" ASC ]
+| | | | | | | | | ) [ "f"."id", "p"."number" ]
+| | | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id", "p"."number" ]
+| | | | | | | ) [ "f"."id", "p"."number" ]
+| | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
+| | | | | ) [ "f"."id", "p"."number", sys.row_number("f"."id", boolean
"false", sys.diff(sys.diff("f"."id" ASC), "p"."number" ASC)) as "L37"."L37" ]
+| | | | ) [ "f"."id", "L37"."L37" ]
| | | ) [ "f"."id" as "L2"."fid", "L37"."L37" as "L40"."line" ] [ "L40"."line"
ASC ]
| | ) [ "L2"."fid" as "commented_function_signatures"."fid" ]
| ) [ ] [ sys.count() NOT NULL as "L46"."L46" ]
) [ "L46" NOT NULL as "L47"."L46" ]
#explain select count (*) from sys.commented_function_signatures;
-fill in the explain output when it no longer does:
dev/sql/backends/monet5/rel_bin.c:575: exp_bin: Assertion `s' failed.
+% .explain # table_name
+% mal # name
+% clob # type
+% 145 # length
+function user.s4_1():void;
+X_1:void := querylog.define("explain select count (*) from
sys.commented_function_signatures;":str, "default_pipe":str, 159:int);
+barrier X_399:bit := language.dataflow();
+X_74:bat[:int] := bat.new(nil:int);
+X_4:int := sql.mvc();
+C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
+X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "functions":str, "id":str,
0:int);
+(X_13:bat[:oid], X_14:bat[:int]) := sql.bind(X_4:int, "sys":str,
"functions":str, "id":str,
