Changeset: e420421d4be7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e420421d4be7 Added Files: sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.sql sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.err sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.out Modified Files: sql/test/BugTracker-2016/Tests/All Branch: Dec2016 Log Message:
Added test for bug 6140 diffs (181 lines): diff --git a/sql/test/BugTracker-2016/Tests/All b/sql/test/BugTracker-2016/Tests/All --- a/sql/test/BugTracker-2016/Tests/All +++ b/sql/test/BugTracker-2016/Tests/All @@ -70,3 +70,4 @@ select-in-from.Bug-6119 select-in-from.Bug-6121 nested-subquery-in-select.Bug-6125 column_name_lost_in_in_operator.Bug-6123 +inner_join_cross_join.Bug-6140 diff --git a/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.sql b/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.sql @@ -0,0 +1,43 @@ +create table "foo" +( +"key_var" int, +"value_var2" int +); + +create table "bar" +( +"key_var" int, +"value_var1" int +); + +insert into "foo" values (1, 630); +insert into "foo" values (2, 420); +insert into "bar" values (1, 11); +insert into "bar" values (2, 27); + +SELECT t1.key_var, t1.value_var2, t2.key_var, t2.value_var1 +FROM +( + SELECT t1."key_var" AS "key_var", + SUM(t2."value_var1") AS "value_var1" + FROM "bar" t2 + RIGHT OUTER JOIN + ( + SELECT t2."key_var" AS "key_var" + FROM "foo" t2 + GROUP BY t2."key_var" + ) t1 + ON t1."key_var" = t2."key_var" + GROUP BY t1."key_var" +) t2 +INNER JOIN +( + SELECT t3."key_var" AS "key_var", + SUM(t3."value_var2") AS "value_var2" + FROM "foo" t3 + GROUP BY t3."key_var" +) t1 +ON t2."key_var" = t1."key_var"; + +DROP TABLE "foo"; +DROP TABLE "bar"; diff --git a/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.err b/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.err @@ -0,0 +1,36 @@ +stderr of test 'inner_join_cross_join.Bug-6140` in directory 'sql/test/BugTracker-2016` itself: + +# 12:30:58 > +# 12:30:58 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=37683" "--set" "mapi_usock=/var/tmp/mtest-32537/.s.monetdb.37683" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch2/dinther/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2016" "--set" "embedded_r=yes" "--set" "embedded_py=true" +# 12:30:58 > + +# builtin opt gdk_dbpath = /export/scratch2/dinther/INSTALL/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 = 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 = 37683 +# cmdline opt mapi_usock = /var/tmp/mtest-32537/.s.monetdb.37683 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /export/scratch2/dinther/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2016 +# cmdline opt embedded_r = yes +# cmdline opt embedded_py = true +# cmdline opt gdk_debug = 536870922 + +# 12:30:59 > +# 12:30:59 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-32537" "--port=37683" +# 12:30:59 > + + + +# 12:30:59 > +# 12:30:59 > "Done." +# 12:30:59 > + diff --git a/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.out b/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/inner_join_cross_join.Bug-6140.stable.out @@ -0,0 +1,79 @@ +stdout of test 'inner_join_cross_join.Bug-6140` in directory 'sql/test/BugTracker-2016` itself: + + +# 18:15:02 > +# 18:15:02 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34376" "--set" "mapi_usock=/var/tmp/mtest-78057/.s.monetdb.34376" "--set" "monet_prompt=" "--forcemito" "--dbpath=/Users/rkoopmanschap/projects/MonetDB-installation/var/MonetDB/mTests_sql_test_BugTracker-2016" +# 18:15:02 > + +# MonetDB 5 server v11.26.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2016', using 4 threads +# Compiled for x86_64-apple-darwin16.1.0/64bit with 128bit integers +# Found 16.000 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://dhcp-183.eduroam.cwi.nl:34376/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-78057/.s.monetdb.34376 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 18:15:02 > +# 18:15:02 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-78057" "--port=34376" +# 18:15:02 > + +#create table "foo" +#( +#"key_var" int, +#"value_var2" int +#); +#create table "bar" +#( +#"key_var" int, +#"value_var1" int +#); +#insert into "foo" values (1, 630); +[ 1 ] +#insert into "foo" values (2, 420); +[ 1 ] +#insert into "bar" values (1, 11); +[ 1 ] +#insert into "bar" values (2, 27); +[ 1 ] +#SELECT t1.key_var, t1.value_var2, t2.key_var, t2.value_var1 +#FROM +#( +# SELECT t1."key_var" AS "key_var", +# SUM(t2."value_var1") AS "value_var1" +# FROM "bar" t2 +# RIGHT OUTER JOIN +# ( +# SELECT t2."key_var" AS "key_var" +# FROM "foo" t2 +# GROUP BY t2."key_var" +# ) t1 +# ON t1."key_var" = t2."key_var" +# GROUP BY t1."key_var" +#) t2 +#INNER JOIN +#( +# SELECT t3."key_var" AS "key_var", +# SUM(t3."value_var2") AS "value_var2" +# FROM "foo" t3 +# GROUP BY t3."key_var" +#) t1 +#ON t2."key_var" = t1."key_var"; +% sys.t1, sys.t1, .t2, .t2 # table_name +% key_var, value_var2, key_var, value_var1 # name +% int, hugeint, int, hugeint # type +% 1, 3, 1, 2 # length +[ 1, 630, 1, 11 ] +[ 2, 420, 2, 27 ] +#DROP TABLE "foo"; +#DROP TABLE "bar"; + +# 18:15:02 > +# 18:15:02 > "Done." +# 18:15:02 > _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
