Changeset: 5d88bce0de6d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5d88bce0de6d
Added Files:
sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err
sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
Modified Files:
sql/test/BugTracker-2019/Tests/All
Branch: Apr2019
Log Message:
Copy stable output from default branch.
diffs (truncated from 591 to 300 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err
b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err
@@ -0,0 +1,38 @@
+stderr of test 'lateral-join-crash.Bug-6613` in directory
'sql/test/BugTracker-2018` itself:
+
+
+# 00:28:46 >
+# 00:28:46 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34098" "--set"
"mapi_usock=/var/tmp/mtest-13250/.s.monetdb.34098" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018"
"--set" "embedded_c=true"
+# 00:28:46 >
+
+# builtin opt gdk_dbpath =
/home/niels/scratch/monetdb/Linux-x86_64/var/monetdb5/dbfarm/demo
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# 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 = 34098
+# cmdline opt mapi_usock = /var/tmp/mtest-13250/.s.monetdb.34098
+# cmdline opt monet_prompt =
+# cmdline opt gdk_dbpath =
/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018
+# cmdline opt embedded_c = true
+#WARNING To speedup generator.series a bulk operator implementation is needed
+# X_39:bat[:hge] := batmal.multiplex("generator":str, "series":str,
X_38:bat[:hge], X_37:bat[:hge]);
+#client2:!ERROR:ParseException:SQLparser:42S22!SELECT: no such column 't.meter'
+#client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted
(please ROLLBACK)
+#client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted
(please ROLLBACK)
+#main thread:!ERROR:MALException:client.quit:Server stopped
+
+# 00:28:47 >
+# 00:28:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-13250" "--port=34098"
+# 00:28:47 >
+
+
+# 00:28:47 >
+# 00:28:47 > "Done."
+# 00:28:47 >
+
diff --git
a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out
b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out
@@ -0,0 +1,208 @@
+stdout of test 'lateral-join-crash.Bug-6613` in directory
'sql/test/BugTracker-2018` itself:
+
+
+# 00:28:46 >
+# 00:28:46 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34098" "--set"
"mapi_usock=/var/tmp/mtest-13250/.s.monetdb.34098" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018"
"--set" "embedded_c=true"
+# 00:28:46 >
+
+# MonetDB 5 server v11.34.0 (hg id: 9b9d1f1578b1+)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_BugTracker-2018', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers
+# Found 15.385 GiB available main-memory.
+# Copyright (c) 1993 - July 2008 CWI.
+# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved
+# Visit https://www.monetdb.org/ for further information
+# Listening for connection requests on
mapi:monetdb://localhost.localdomain:34098/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-13250/.s.monetdb.34098
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+# 00:28:47 >
+# 00:28:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-13250" "--port=34098"
+# 00:28:47 >
+
+#start transaction;
+#create table segments (meter int, distance int, speed int);
+#insert into segments values (1,1,1),(9,9,9);
+[ 2 ]
+#select t.* from segments as s, lateral generate_series(s.meter,
s.meter+s.distance+1) as t;
+% .t # table_name
+% value # name
+% int # type
+% 2 # length
+[ 1 ]
+[ 2 ]
+[ 9 ]
+[ 10 ]
+[ 11 ]
+[ 12 ]
+[ 13 ]
+[ 14 ]
+[ 15 ]
+[ 16 ]
+[ 17 ]
+[ 18 ]
+[ 1 ]
+[ 2 ]
+[ 9 ]
+[ 10 ]
+[ 11 ]
+[ 12 ]
+[ 13 ]
+[ 14 ]
+[ 15 ]
+[ 16 ]
+[ 17 ]
+[ 18 ]
+#select t.value, s.distance, s.speed from segments as s, lateral
generate_series(s.meter, s.meter+s.distance+1) as t;
+% .t, sys.s, sys.s # table_name
+% value, distance, speed # name
+% int, int, int # type
+% 2, 1, 1 # length
+[ 1, 1, 1 ]
+[ 2, 1, 1 ]
+[ 9, 1, 1 ]
+[ 10, 1, 1 ]
+[ 11, 1, 1 ]
+[ 12, 1, 1 ]
+[ 13, 1, 1 ]
+[ 14, 1, 1 ]
+[ 15, 1, 1 ]
+[ 16, 1, 1 ]
+[ 17, 1, 1 ]
+[ 18, 1, 1 ]
+[ 1, 9, 9 ]
+[ 2, 9, 9 ]
+[ 9, 9, 9 ]
+[ 10, 9, 9 ]
+[ 11, 9, 9 ]
+[ 12, 9, 9 ]
+[ 13, 9, 9 ]
+[ 14, 9, 9 ]
+[ 15, 9, 9 ]
+[ 16, 9, 9 ]
+[ 17, 9, 9 ]
+[ 18, 9, 9 ]
+#select * from segments as s, lateral generate_series(s.meter,
s.meter+s.distance+1);
+% sys.s, sys.s, sys.s, .L2 # table_name
+% meter, distance, speed, value # name
+% int, int, int, int # type
+% 1, 1, 1, 2 # length
+[ 1, 1, 1, 1 ]
+[ 1, 1, 1, 2 ]
+[ 1, 1, 1, 9 ]
+[ 1, 1, 1, 10 ]
+[ 1, 1, 1, 11 ]
+[ 1, 1, 1, 12 ]
+[ 1, 1, 1, 13 ]
+[ 1, 1, 1, 14 ]
+[ 1, 1, 1, 15 ]
+[ 1, 1, 1, 16 ]
+[ 1, 1, 1, 17 ]
+[ 1, 1, 1, 18 ]
+[ 9, 9, 9, 1 ]
+[ 9, 9, 9, 2 ]
+[ 9, 9, 9, 9 ]
+[ 9, 9, 9, 10 ]
+[ 9, 9, 9, 11 ]
+[ 9, 9, 9, 12 ]
+[ 9, 9, 9, 13 ]
+[ 9, 9, 9, 14 ]
+[ 9, 9, 9, 15 ]
+[ 9, 9, 9, 16 ]
+[ 9, 9, 9, 17 ]
+[ 9, 9, 9, 18 ]
+#select t.*, s.distance, s.speed from segments as s, lateral
generate_series(s.meter, s.meter+s.distance+1) as t;
+% .t, sys.s, sys.s # table_name
+% value, distance, speed # name
+% int, int, int # type
+% 2, 1, 1 # length
+[ 1, 1, 1 ]
+[ 2, 1, 1 ]
+[ 9, 1, 1 ]
+[ 10, 1, 1 ]
+[ 11, 1, 1 ]
+[ 12, 1, 1 ]
+[ 13, 1, 1 ]
+[ 14, 1, 1 ]
+[ 15, 1, 1 ]
+[ 16, 1, 1 ]
+[ 17, 1, 1 ]
+[ 18, 1, 1 ]
+[ 1, 9, 9 ]
+[ 2, 9, 9 ]
+[ 9, 9, 9 ]
+[ 10, 9, 9 ]
+[ 11, 9, 9 ]
+[ 12, 9, 9 ]
+[ 13, 9, 9 ]
+[ 14, 9, 9 ]
+[ 15, 9, 9 ]
+[ 16, 9, 9 ]
+[ 17, 9, 9 ]
+[ 18, 9, 9 ]
+#select t.meter, s.distance, s.speed from segments as s, lateral
generate_series(s.meter, s.meter+s.distance+1) as t(meter);
+% .t, sys.s, sys.s # table_name
+% meter, distance, speed # name
+% int, int, int # type
+% 2, 1, 1 # length
+[ 1, 1, 1 ]
+[ 2, 1, 1 ]
+[ 9, 1, 1 ]
+[ 10, 1, 1 ]
+[ 11, 1, 1 ]
+[ 12, 1, 1 ]
+[ 13, 1, 1 ]
+[ 14, 1, 1 ]
+[ 15, 1, 1 ]
+[ 16, 1, 1 ]
+[ 17, 1, 1 ]
+[ 18, 1, 1 ]
+[ 1, 9, 9 ]
+[ 2, 9, 9 ]
+[ 9, 9, 9 ]
+[ 10, 9, 9 ]
+[ 11, 9, 9 ]
+[ 12, 9, 9 ]
+[ 13, 9, 9 ]
+[ 14, 9, 9 ]
+[ 15, 9, 9 ]
+[ 16, 9, 9 ]
+[ 17, 9, 9 ]
+[ 18, 9, 9 ]
+#select t.*, s.distance, s.speed from segments as s, lateral
generate_series(s.meter, s.meter+s.distance+1) as t(meter);
+% .t, sys.s, sys.s # table_name
+% meter, distance, speed # name
+% int, int, int # type
+% 2, 1, 1 # length
+[ 1, 1, 1 ]
+[ 2, 1, 1 ]
+[ 9, 1, 1 ]
+[ 10, 1, 1 ]
+[ 11, 1, 1 ]
+[ 12, 1, 1 ]
+[ 13, 1, 1 ]
+[ 14, 1, 1 ]
+[ 15, 1, 1 ]
+[ 16, 1, 1 ]
+[ 17, 1, 1 ]
+[ 18, 1, 1 ]
+[ 1, 9, 9 ]
+[ 2, 9, 9 ]
+[ 9, 9, 9 ]
+[ 10, 9, 9 ]
+[ 11, 9, 9 ]
+[ 12, 9, 9 ]
+[ 13, 9, 9 ]
+[ 14, 9, 9 ]
+[ 15, 9, 9 ]
+[ 16, 9, 9 ]
+[ 17, 9, 9 ]
+[ 18, 9, 9 ]
+#rollback;
+
+# 00:28:47 >
+# 00:28:47 > "Done."
+# 00:28:47 >
+
diff --git a/sql/test/BugTracker-2019/Tests/All
b/sql/test/BugTracker-2019/Tests/All
--- a/sql/test/BugTracker-2019/Tests/All
+++ b/sql/test/BugTracker-2019/Tests/All
@@ -7,7 +7,7 @@ insert-replica-table.Bug-6684
KNOWNFAIL?subselect-count.Bug-6686
KNOWNFAIL?subselect.Bug-6688
timestamptransformation.Bug-6695
-duplicates-not-eliminated-long-CASE-stmt.Bug-6697
+KNOWNFAIL?duplicates-not-eliminated-long-CASE-stmt.Bug-6697
KNOWNFAIL?subselect.Bug-6700
alter_table_set_schema.Bug-6701
crash-in-rel_dependencies.Bug-6703
diff --git
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
@@ -0,0 +1,318 @@
+stdout of test 'duplicates-not-eliminated-long-CASE-stmt.Bug-6697` in
directory 'sql/test/BugTracker-2019` itself:
+
+
+# 14:08:13 >
+# 14:08:13 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=33481" "--set"
"mapi_usock=/var/tmp/mtest-8696/.s.monetdb.33481" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2019"
"--set" "monet_daemon=yes" "--set" "embedded_c=true"
+# 14:08:13 >
+
+# MonetDB 5 server v11.34.0 (hg id: 29627d20d2e0)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_BugTracker-2019', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers
+# Found 15.385 GiB available main-memory.
+# Copyright (c) 1993 - July 2008 CWI.
+# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved
+# Visit https://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://xps13:33481/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-8696/.s.monetdb.33481
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+# 14:08:13 >
+# 14:08:13 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-8696" "--port=33481"
+# 14:08:13 >
+
+#CREATE TABLE IF NOT EXISTS "task" (
+#"sys_class_name" VARCHAR(80),
+#"priority" BIGINT,
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
