Changeset: 1b4a2a363dbc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1b4a2a363dbc
Added Files:
sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.sql
sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.err
sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.out
Modified Files:
sql/test/BugTracker-2020/Tests/All
Branch: Nov2019
Log Message:
Add test for bug 6818
diffs (120 lines):
diff --git a/sql/test/BugTracker-2020/Tests/All
b/sql/test/BugTracker-2020/Tests/All
--- a/sql/test/BugTracker-2020/Tests/All
+++ b/sql/test/BugTracker-2020/Tests/All
@@ -2,3 +2,4 @@ median_avg-nulls.Bug-6807
ifthenelse-crash.Bug-6815
alter-table-add-column.Bug-6816
analyze-stream-table.Bug-6817
+select-where-in-rtrim-crash.Bug-6818
diff --git
a/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.sql
b/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.sql
@@ -0,0 +1,18 @@
+CREATE TABLE "dd_field" (
+ "TABEL" VARCHAR(25) NOT NULL,
+ "VELD" VARCHAR(25) NOT NULL,
+ "TYPE" VARCHAR(4) NOT NULL
+);
+
+select "TABEL", "VELD"
+ from dd_field f
+ where ("TABEL", "VELD") in (select "TABEL", "VELD" from dd_field);
+-- no problemo
+
+select "TABEL", "VELD"
+ from dd_field f
+ where (rtrim("TABEL"), rtrim("VELD")) in (select "TABEL", "VELD" from
dd_field);
+-- sql/backends/monet5/rel_bin.c:920: exp_bin: Assertion `0' failed.
+
+DROP TABLE "dd_field";
+
diff --git
a/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.err
b/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.err
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.err
@@ -0,0 +1,30 @@
+stderr of test 'select-where-in-rtrim-crash.Bug-6818` in directory
'sql/test/BugTracker-2020` itself:
+
+
+# 15:30:21 >
+# 15:30:21 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34280" "--set"
"mapi_usock=/var/tmp/mtest-896323/.s.monetdb.34280" "--forcemito"
"--dbpath=/home/dinther/dev/dev/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2020"
"--set" "embedded_c=true"
+# 15:30:21 >
+
+# builtin opt gdk_dbpath =
/home/dinther/dev/dev/INSTALL/var/monetdb5/dbfarm/demo
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_ipv6 = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 34280
+# cmdline opt mapi_usock = /var/tmp/mtest-896323/.s.monetdb.34280
+# cmdline opt gdk_dbpath =
/home/dinther/dev/dev/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2020
+# cmdline opt embedded_c = true
+
+# 15:30:21 >
+# 15:30:21 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-896323" "--port=34280"
+# 15:30:21 >
+
+
+# 15:31:02 >
+# 15:31:02 > "Done."
+# 15:31:02 >
+
diff --git
a/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.out
b/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.out
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2020/Tests/select-where-in-rtrim-crash.Bug-6818.stable.out
@@ -0,0 +1,49 @@
+stdout of test 'select-where-in-rtrim-crash.Bug-6818` in directory
'sql/test/BugTracker-2020` itself:
+
+
+# 15:30:21 >
+# 15:30:21 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34280" "--set"
"mapi_usock=/var/tmp/mtest-896323/.s.monetdb.34280" "--forcemito"
"--dbpath=/home/dinther/dev/dev/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2020"
"--set" "embedded_c=true"
+# 15:30:21 >
+
+# MonetDB 5 server v11.35.14 (hg id: 6146f33fc10b)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_BugTracker-2020', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
+# Found 31.237 GiB available main-memory of which we use 25.459 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://monetdb-nuc2:34280/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-896323/.s.monetdb.34280
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+# 15:30:21 >
+# 15:30:21 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-896323" "--port=34280"
+# 15:30:21 >
+
+#CREATE TABLE "dd_field" (
+# "TABEL" VARCHAR(25) NOT NULL,
+# "VELD" VARCHAR(25) NOT NULL,
+# "TYPE" VARCHAR(4) NOT NULL
+#);
+#select "TABEL", "VELD"
+# from dd_field f
+# where ("TABEL", "VELD") in (select "TABEL", "VELD" from dd_field);
+% sys.f, sys.f # table_name
+% TABEL, VELD # name
+% varchar, varchar # type
+% 0, 0 # length
+#select "TABEL", "VELD"
+# from dd_field f
+# where (rtrim("TABEL"), rtrim("VELD")) in (select "TABEL", "VELD" from
dd_field);
+% sys.f, sys.f # table_name
+% TABEL, VELD # name
+% varchar, varchar # type
+% 0, 0 # length
+#DROP TABLE "dd_field";
+
+# 15:30:21 >
+# 15:30:21 > "Done."
+# 15:30:21 >
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
