Changeset: 43701d62ed0c for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=43701d62ed0c
Added Files:
monetdb5/extras/jaql/Tests/join03.mal
monetdb5/extras/jaql/Tests/join03.stable.err
monetdb5/extras/jaql/Tests/join03.stable.out
Modified Files:
monetdb5/extras/jaql/Tests/All
Branch: Jul2012
Log Message:
join: add test for preserve bug
diffs (99 lines):
diff --git a/monetdb5/extras/jaql/Tests/All b/monetdb5/extras/jaql/Tests/All
--- a/monetdb5/extras/jaql/Tests/All
+++ b/monetdb5/extras/jaql/Tests/All
@@ -11,6 +11,7 @@ HAVE_JAQL?transform00
HAVE_JAQL?transform02
HAVE_JAQL?join00
HAVE_JAQL?join02
+HAVE_JAQL?join03
HAVE_JAQL?group00
HAVE_JAQL?sort00
HAVE_JAQL?top00
diff --git a/monetdb5/extras/jaql/Tests/join03.mal
b/monetdb5/extras/jaql/Tests/join03.mal
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/join03.mal
@@ -0,0 +1,8 @@
+# identified a bug in preserve, preserving all inputs lead to no
+# preservation at all
+
+jaql.x("A=[1,2];");
+jaql.x("B=[{\"a\":1,\"b\":4},{\"a\":1,\"b\":5}];");
+jaql.x("join preserve A, B where A == B.a into {B.*, A};");
+jaql.x("join preserve A, preserve B where A == B.a into {B.*, A};");
+jaql.x("join A, preserve B where A == B.a into {B.*, A};");
diff --git a/monetdb5/extras/jaql/Tests/join03.stable.err
b/monetdb5/extras/jaql/Tests/join03.stable.err
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/join03.stable.err
@@ -0,0 +1,31 @@
+stderr of test 'join03` in directory 'extras/jaql` itself:
+
+
+# 09:27:06 >
+# 09:27:06 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Jul2012-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=39104" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"join03.mal"
+# 09:27:06 >
+
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm =
/ufs/fabian/scratch/ssd/monetdb/Jul2012/program-x86_64/var/lib/monetdb5/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# 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 =
/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Jul2012-sofia.ins.cwi.nl/five/dbfarm
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 39104
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbname = mTests_extras_jaql
+
+# 09:27:06 >
+# 09:27:06 > "Done."
+# 09:27:06 >
+
diff --git a/monetdb5/extras/jaql/Tests/join03.stable.out
b/monetdb5/extras/jaql/Tests/join03.stable.out
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/join03.stable.out
@@ -0,0 +1,34 @@
+stdout of test 'join03` in directory 'extras/jaql` itself:
+
+
+# 09:27:06 >
+# 09:27:06 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Jul2012-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=39104" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"join03.mal"
+# 09:27:06 >
+
+# MonetDB 5 server v11.11.6 "Jul2012-a04c99a2b437"
+# Serving database 'mTests_extras_jaql', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Found 15.629 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://sofia.ins.cwi.nl:39104/
+# MonetDB/GIS module loaded
+# MonetDB/JAQL module loaded
+# MonetDB/SQL module loaded
+# MonetDB/DataCell loaded
+function user.main():void;
+ jaql.x("A=[1,2];");
+ jaql.x("B=[{\"a\":1,\"b\":4},{\"a\":1,\"b\":5}];");
+ jaql.x("join preserve A, B where A == B.a into {B.*, A};");
+ jaql.x("join preserve A, preserve B where A == B.a into {B.*, A};");
+ jaql.x("join A, preserve B where A == B.a into {B.*, A};");
+end main;
+[ { "a": 1, "b": 4, "A": 1 }, { "a": 1, "b": 5, "A": 1 }, { "A": 2 } ]
+[ { "a": 1, "b": 4, "A": 1 }, { "a": 1, "b": 5, "A": 1 }, { "A": 2 } ]
+[ { "a": 1, "b": 4, "A": 1 }, { "a": 1, "b": 5, "A": 1 } ]
+
+# 09:27:06 >
+# 09:27:06 > "Done."
+# 09:27:06 >
+
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
