Changeset: 28d08769660b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=28d08769660b Added Files: sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.sql sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.err sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.out Branch: Oct2012 Log Message:
add test for bug 3181 diffs (169 lines): diff --git a/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.sql b/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.sql @@ -0,0 +1,45 @@ + +CREATE TABLE RX ( + u int NOT NULL, + v int NOT NULL, + r int NOT NULL +); + +CREATE TABLE trans ( + s int NOT NULL, + t int NOT NULL, + comp int NOT NULL +); + +CREATE INDEX trans_st_idx ON trans (s, t); + + +INSERT INTO trans(s, t, comp) VALUES +(1, 2, 31), +(1, 16, 31), +(1, 3, 255), +(255, 3, 255); + +INSERT INTO RX (u, v, r) VALUES +(0, 1, 1), +(1, 2, 3), +(2, 4, 3), +(1, 4, 16), +(1, 3, 2), +(3, 2, 255); + + +SELECT TR.x, TR.z, comp +FROM +(SELECT TR1.u as x, TR1.v as y, TR2.v as z, TR1.r as rxy, TR2.r as ryz + FROM + RX as TR1 JOIN R as TR2 + ON (TR1.v = TR2.u AND TR1.u <> TR2.v) + ) as TR + JOIN + trans + ON (TR.rxy = s AND TR.ryz = t); + +Drop index trans_st_idx; +Drop table trans; +Drop table rx; diff --git a/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.err b/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.err @@ -0,0 +1,36 @@ +stderr of test 'join_over_multitable_using_index.Bug-3181` in directory 'test/BugTracker-2012` itself: + + +# 15:30:47 > +# 15:30:47 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=35063" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_BugTracker-2012" "--set" "mal_listing=0" +# 15:30:47 > + +# builtin opt gdk_dbname = demo +# builtin opt gdk_dbfarm = /home/niels/scratch/rc-clean/Linux-x86_64/var/monetdb5/dbfarm +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = yes +# 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 gdk_dbfarm = /home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 35063 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_test_BugTracker-2012 +# cmdline opt mal_listing = 0 + +# 15:30:48 > +# 15:30:48 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" "--port=35063" +# 15:30:48 > + + +# 15:30:48 > +# 15:30:48 > "Done." +# 15:30:48 > + diff --git a/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.out b/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.stable.out @@ -0,0 +1,73 @@ +stdout of test 'join_over_multitable_using_index.Bug-3181` in directory 'test/BugTracker-2012` itself: + + +# 15:30:47 > +# 15:30:47 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=35063" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_BugTracker-2012" "--set" "mal_listing=0" +# 15:30:47 > + +# MonetDB 5 server v11.13.4 +# This is an unreleased version +# Serving database 'mTests_test_BugTracker-2012', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 3.778 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://niels.nesco.mine.nu:35063/ +# MonetDB/GIS module loaded +# MonetDB/JAQL module loaded +# MonetDB/SQL module loaded + +Ready. + +# 15:30:48 > +# 15:30:48 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" "--port=35063" +# 15:30:48 > + +#CREATE TABLE RX ( +# u int NOT NULL, +# v int NOT NULL, +# r int NOT NULL +#); +#CREATE TABLE trans ( +# s int NOT NULL, +# t int NOT NULL, +# comp int NOT NULL +#); +#CREATE INDEX trans_st_idx ON trans (s, t); +#INSERT INTO trans(s, t, comp) VALUES +#(1, 2, 31), +#(1, 16, 31), +#(1, 3, 255), +#(255, 3, 255); +[ 4 ] +#INSERT INTO RX (u, v, r) VALUES +#(0, 1, 1), +#(1, 2, 3), +#(2, 4, 3), +#(1, 4, 16), +#(1, 3, 2), +#(3, 2, 255); +[ 6 ] +#SELECT TR.x, TR.z, comp +#FROM +#(SELECT TR1.u as x, TR1.v as y, TR2.v as z, TR1.r as rxy, TR2.r as ryz +# FROM +# RX as TR1 JOIN R as TR2 +# ON (TR1.v = TR2.u AND TR1.u <> TR2.v) +# ) as TR +# JOIN +# trans +# ON (TR.rxy = s AND TR.ryz = t); +% sys.tr, sys.tr, sys.trans # table_name +% x, z, comp # name +% int, varchar, int # type +% 1, 0, 1 # length +#Drop index trans_st_idx; +#Drop table trans; +#Drop table rx; + +# 15:30:48 > +# 15:30:48 > "Done." +# 15:30:48 > + _______________________________________________ checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
