MonetDB: default - merged new test from Jun2010
Changeset: 761c1b3288e9 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=761c1b3288e9
Modified Files:
sql/src/test/BugTracker-2010/Tests/All
Branch: default
Log Message:
merged new test from Jun2010
diffs (200 lines):
diff -r 3e51cbb43e60 -r 761c1b3288e9 sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 19:04:04 2010 +0200
+++ b/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 19:39:17 2010 +0200
@@ -29,3 +29,4 @@
prepare_stmt.Bug-2533.Bug-2534
predicate_in_select.Bug-2535
subselect.Bug-2537
+group-by_ordered_column.Bug-2564
diff -r 3e51cbb43e60 -r 761c1b3288e9
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql
Sat Jul 10 19:39:17 2010 +0200
@@ -0,0 +1,8 @@
+create table t2564 (c1 int, c2 int, c3 int);
+insert into t2564 values (3,1,2);
+insert into t2564 values (1,2,1);
+insert into t2564 values (2,3,3);
+select * from t2564;
+explain select count(*) from t2564 group by c1, c2, c3;
+select count(*) from t2564 group by c1, c2, c3;
+drop table t2564;
diff -r 3e51cbb43e60 -r 761c1b3288e9
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++
b/sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.err
Sat Jul 10 19:39:17 2010 +0200
@@ -0,0 +1,78 @@
+stderr of test 'group-by_ordered_column.Bug-2564` in directory
'src/test/BugTracker-2010` itself:
+
+
+# 19:36:51 >
+# 19:36:51 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30272 --set
xrpc_port=42483 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
+# 19:36:51 >
+
+# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
+# builtin opt gdk_version = 1.38.1
+# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# builtin opt exec_prefix = ${prefix}
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_admin = adm
+# builtin opt monet_prompt = >
+# builtin opt monet_welcome = yes
+# builtin opt monet_mod_path = ${exec_prefix}/lib64/MonetDB
+# builtin opt monet_daemon = no
+# builtin opt host = localhost
+# builtin opt mapi_port = 5
+# builtin opt mapi_clients = 2
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_debug = 0
+# builtin opt standoff_ns =
+# builtin opt standoff_start = start
+# builtin opt standoff_end = end
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt config = ${prefix}/etc/monetdb5.conf
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt exec_prefix = ${prefix}
+# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
+# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
+# config opt mero_controlport = 50001
+# config opt sql_optimizer = default_pipe
+# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
+# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,
MonetDB: Jun2010 - added test for bug 2564
Changeset: 7f15fd046eb2 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7f15fd046eb2
Modified Files:
sql/src/test/BugTracker-2010/Tests/All
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.err
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
Branch: Jun2010
Log Message:
added test for bug 2564
diffs (200 lines):
diff -r 9c253dc27961 -r 7f15fd046eb2 sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 19:03:03 2010 +0200
+++ b/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 19:38:41 2010 +0200
@@ -29,3 +29,4 @@
prepare_stmt.Bug-2533.Bug-2534
predicate_in_select.Bug-2535
subselect.Bug-2537
+group-by_ordered_column.Bug-2564
diff -r 9c253dc27961 -r 7f15fd046eb2
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql
Sat Jul 10 19:38:41 2010 +0200
@@ -0,0 +1,8 @@
+create table t2564 (c1 int, c2 int, c3 int);
+insert into t2564 values (3,1,2);
+insert into t2564 values (1,2,1);
+insert into t2564 values (2,3,3);
+select * from t2564;
+explain select count(*) from t2564 group by c1, c2, c3;
+select count(*) from t2564 group by c1, c2, c3;
+drop table t2564;
diff -r 9c253dc27961 -r 7f15fd046eb2
sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++
b/sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.err
Sat Jul 10 19:38:41 2010 +0200
@@ -0,0 +1,78 @@
+stderr of test 'group-by_ordered_column.Bug-2564` in directory
'src/test/BugTracker-2010` itself:
+
+
+# 19:36:51 >
+# 19:36:51 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30272 --set
xrpc_port=42483 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
+# 19:36:51 >
+
+# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
+# builtin opt gdk_version = 1.38.1
+# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# builtin opt exec_prefix = ${prefix}
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_admin = adm
+# builtin opt monet_prompt = >
+# builtin opt monet_welcome = yes
+# builtin opt monet_mod_path = ${exec_prefix}/lib64/MonetDB
+# builtin opt monet_daemon = no
+# builtin opt host = localhost
+# builtin opt mapi_port = 5
+# builtin opt mapi_clients = 2
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_debug = 0
+# builtin opt standoff_ns =
+# builtin opt standoff_start = start
+# builtin opt standoff_end = end
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt config = ${prefix}/etc/monetdb5.conf
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt exec_prefix = ${prefix}
+# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
+# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
+# config opt mero_controlport = 50001
+# config opt sql_optimizer = default_pipe
+# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
+# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,co
MonetDB: default - merged new test from Jun2010
Changeset: 3e51cbb43e60 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3e51cbb43e60 Modified Files: pathfinder/tests/BugTracker/Tests/All Branch: default Log Message: merged new test from Jun2010 diffs (truncated from 319 to 300 lines): diff -r 1fb46778df7a -r 3e51cbb43e60 pathfinder/tests/BugTracker/Tests/All --- a/pathfinder/tests/BugTracker/Tests/All Sat Jul 10 10:12:58 2010 +0200 +++ b/pathfinder/tests/BugTracker/Tests/All Sat Jul 10 19:04:04 2010 +0200 @@ -212,3 +212,5 @@ compilation_error.SF-2860037_1 compilation_error.SF-2860037_2 slow_compilation.SF-2898944 +node-name.Bug-2600.-d10 +node-name.Bug-2600.-d0 diff -r 1fb46778df7a -r 3e51cbb43e60 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.dbinit --- /dev/null Thu Jan 01 00:00:00 1970 + +++ b/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.dbinit Sat Jul 10 19:04:04 2010 +0200 @@ -0,0 +1,1 @@ +debugmask(and(debugmask(),xor(INT_MAX,8+2))); diff -r 1fb46778df7a -r 3e51cbb43e60 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err --- /dev/null Thu Jan 01 00:00:00 1970 + +++ b/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err Sat Jul 10 19:04:04 2010 +0200 @@ -0,0 +1,17 @@ +stderr of test 'node-name.Bug-2600.-d0` in directory 'tests/BugTracker` itself: + + +# 18:52:05 > +# 18:52:05 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/MonetDB.conf" --debug=0 --set gdk_nr_threads=1 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/dbfarm" --set mapi_open=true --set xrpc_open=true --set mapi_port=38866 --set xrpc_port=49469 --set monet_prompt= --trace "--dbname=mTests_tests_BugTracker" "--dbinit=debugmask(and(debugmask(),xor(INT_MAX,8+2))); module(p athfinder);" ; echo ; echo Over.. +# 18:52:05 > + + +# 18:52:06 > +# 18:52:06 > mclient -lxquery -fxml --host=rig --port=38866 node-name.Bug-2600.-d0.xq +# 18:52:06 > + + +# 18:52:06 > +# 18:52:06 > Done. +# 18:52:06 > + diff -r 1fb46778df7a -r 3e51cbb43e60 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.patch-16479 --- /dev/null Thu Jan 01 00:00:00 1970 + +++ b/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.patch-16479 Sat Jul 10 19:04:04 2010 +0200 @@ -0,0 +1,24 @@ +--- /net/rig.ins.cwi.nl/export/scratch0/manegold/Monet/HG/Jun2010/source/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.ORG 2010-07-10 18:52:17.0 +0200 /net/rig.ins.cwi.nl/export/scratch0/manegold/Monet/HG/Jun2010/source/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err 2010-07-10 18:52:17.0 +0200 +@@ -0,0 +1,21 @@ ++stderr of test 'node-name.Bug-2600.-d0` in directory 'tests/BugTracker` itself: ++ ++ ++# 18:52:05 > ++# 18:52:05 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/MonetDB.conf" --debug=0 --set gdk_nr_threads=1 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/dbfarm" --set mapi_open=true --set xrpc_open=true --set mapi_port=38866 --set xrpc_port=49469 --set monet_prompt= --trace "--dbname=mTests_tests_BugTracker" "--dbinit=debugmask(and(debugmask(),xor(INT_MAX,8+2))); module( pathfinder);" ; echo ; echo Over.. ++# 18:52:05 > ++ ++ ++# 18:52:06 > ++# 18:52:06 > mclient -lxquery -fxml --host=rig --port=38866 node-name.Bug-2600.-d0.xq ++# 18:52:06 > ++ ++MAPI = mone...@rig:38866 ++QUERY = declare namespace pxmlsup = "http://www.cs.utwente.nl/~keulen/pxmlsup";; ++ERROR = !ERROR: merged_union: BAT/column 2 of table 1 must have a dense head. ++!ERROR: CMDmerged_union: operation failed. ++ ++# 18:52:06 > ++# 18:52:06 > Done. ++# 18:52:06 > ++ diff -r 1fb46778df7a -r 3e51cbb43e60 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.out --
MonetDB: Jun2010 - added test for bug 2600
Changeset: 9c253dc27961 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9c253dc27961 Modified Files: pathfinder/tests/BugTracker/Tests/All pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.dbinit pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.patch-16479 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.out pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.out.patch-16479 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.xq pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d10.dbinit pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d10.stable.err pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d10.stable.err.patch-16479 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d10.stable.out pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d10.stable.out.patch-16479 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d10.xq Branch: Jun2010 Log Message: added test for bug 2600 As reported, a query containing node-name() compiles fine after Jan R.'s fix. However, as reported, such query now triggers a runtime error (when run without property checking, which it the default): !ERROR: merged_union: BAT/column 2 of table 1 must have a dense head. When run with property checking enabled (`Mserver --debug=10`), the query works fine. Replacing node-name() by local-name() make the query run fine with and without property checking. diffs (truncated from 319 to 300 lines): diff -r a923f341841d -r 9c253dc27961 pathfinder/tests/BugTracker/Tests/All --- a/pathfinder/tests/BugTracker/Tests/All Sat Jul 10 10:12:07 2010 +0200 +++ b/pathfinder/tests/BugTracker/Tests/All Sat Jul 10 19:03:03 2010 +0200 @@ -226,3 +226,5 @@ compilation_error.SF-2860037_1 compilation_error.SF-2860037_2 slow_compilation.SF-2898944 +node-name.Bug-2600.-d10 +node-name.Bug-2600.-d0 diff -r a923f341841d -r 9c253dc27961 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.dbinit --- /dev/null Thu Jan 01 00:00:00 1970 + +++ b/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.dbinit Sat Jul 10 19:03:03 2010 +0200 @@ -0,0 +1,1 @@ +debugmask(and(debugmask(),xor(INT_MAX,8+2))); diff -r a923f341841d -r 9c253dc27961 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err --- /dev/null Thu Jan 01 00:00:00 1970 + +++ b/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err Sat Jul 10 19:03:03 2010 +0200 @@ -0,0 +1,17 @@ +stderr of test 'node-name.Bug-2600.-d0` in directory 'tests/BugTracker` itself: + + +# 18:52:05 > +# 18:52:05 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/MonetDB.conf" --debug=0 --set gdk_nr_threads=1 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/dbfarm" --set mapi_open=true --set xrpc_open=true --set mapi_port=38866 --set xrpc_port=49469 --set monet_prompt= --trace "--dbname=mTests_tests_BugTracker" "--dbinit=debugmask(and(debugmask(),xor(INT_MAX,8+2))); module(p athfinder);" ; echo ; echo Over.. +# 18:52:05 > + + +# 18:52:06 > +# 18:52:06 > mclient -lxquery -fxml --host=rig --port=38866 node-name.Bug-2600.-d0.xq +# 18:52:06 > + + +# 18:52:06 > +# 18:52:06 > Done. +# 18:52:06 > + diff -r a923f341841d -r 9c253dc27961 pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.patch-16479 --- /dev/null Thu Jan 01 00:00:00 1970 + +++ b/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.patch-16479 Sat Jul 10 19:03:03 2010 +0200 @@ -0,0 +1,24 @@ +--- /net/rig.ins.cwi.nl/export/scratch0/manegold/Monet/HG/Jun2010/source/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err.ORG 2010-07-10 18:52:17.0 +0200 /net/rig.ins.cwi.nl/export/scratch0/manegold/Monet/HG/Jun2010/source/pathfinder/tests/BugTracker/Tests/node-name.Bug-2600.-d0.stable.err 2010-07-10 18:52:17.0 +0200 +@@ -0,0 +1,21 @@ ++stderr of test 'node-name.Bug-2600.-d0` in directory 'tests/BugTracker` itself: ++ ++ ++# 18:52:05 > ++# 18:52:05 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/MonetDB.conf" --debug=0 --set gdk_nr_threads=
Re: MonetDB: Jun2010 - createdb.sql was removed, hopefully simply re...
I sincerely doubt that this is going to work. Please use the proper
tools to edit the Windows installers (or leave it to me).
On 2010-07-10 10:12, Fabian Groffen wrote:
> Changeset: a923f341841d for MonetDB
> URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a923f341841d
> Modified Files:
> sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj
> sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj
> sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj
> sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj
> Branch: Jun2010
> Log Message:
>
> createdb.sql was removed, hopefully simply removing the 'key' from the
> installer files 'just' works
>
>
> diffs (120 lines):
>
> diff -r dc4901d8243e -r a923f341841d
> sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj
> --- a/sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj Sat Jul 10
> 10:03:21 2010 +0200
> +++ b/sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj Sat Jul 10
> 10:12:07 2010 +0200
> @@ -5941,26 +5941,6 @@
> "IsDependency" = "11:FALSE"
> "IsolateTo" = "8:"
> }
> -
> "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_CEF22C247B2E476FBBAB8046DDBC0F1A"
> -{
> -"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
> -"TargetName" = "8:createdb.sql"
> -"Tag" = "8:"
> -"Folder" = "8:_B593DAA0787744D6A44D17884E0C3951"
> -"Condition" = "8:"
> -"Transitive" = "11:FALSE"
> -"Vital" = "11:TRUE"
> -"ReadOnly" = "11:FALSE"
> -"Hidden" = "11:FALSE"
> -"System" = "11:FALSE"
> -"Permanent" = "11:FALSE"
> -"SharedLegacy" = "11:FALSE"
> -"PackageAs" = "3:1"
> -"Register" = "3:1"
> -"Exclude" = "11:FALSE"
> -"IsDependency" = "11:FALSE"
> -"IsolateTo" = "8:"
> -}
>
> "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_CF5DC8BD4BFA4D7EA31F3B1BBB4EB5A1"
> {
> "SourcePath" = "8:Lib\\MonetDB5\\lib_run_octopus.dll"
> diff -r dc4901d8243e -r a923f341841d sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj
> --- a/sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj Sat Jul 10 10:03:21 2010 +0200
> +++ b/sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj Sat Jul 10 10:12:07 2010 +0200
> @@ -299,26 +299,6 @@
> "IsDependency" = "11:FALSE"
> "IsolateTo" = "8:"
> }
> -
> "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_4E285A2638A04D71AC11F06FA1EF0AA7"
> -{
> -"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
> -"TargetName" = "8:createdb.sql"
> -"Tag" = "8:"
> -"Folder" = "8:_2ACFF9E534394C7DA2FC0E2D947C98CE"
> -"Condition" = "8:"
> -"Transitive" = "11:FALSE"
> -"Vital" = "11:TRUE"
> -"ReadOnly" = "11:FALSE"
> -"Hidden" = "11:FALSE"
> -"System" = "11:FALSE"
> -"Permanent" = "11:FALSE"
> -"SharedLegacy" = "11:FALSE"
> -"PackageAs" = "3:1"
> -"Register" = "3:1"
> -"Exclude" = "11:FALSE"
> -"IsDependency" = "11:FALSE"
> -"IsolateTo" = "8:"
> -}
>
> "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_60556A506BDF4F0A83013CA0B54EDC9E"
> {
> "SourcePath" = "8:Lib\\MonetDB5\\times.sql"
> diff -r dc4901d8243e -r a923f341841d sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj
> --- a/sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj Sat Jul 10 10:03:21
> 2010 +0200
> +++ b/sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj Sat Jul 10 10:12:07
> 2010 +0200
> @@ -499,26 +499,6 @@
> "IsDependency" = "11:FALSE"
> "IsolateTo" = "8:"
> }
> -
> "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_A095E6625D794D4AA25BDDFC71B855D4"
> -{
> -"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
> -"TargetName" = "8:createdb.sql"
> -"Tag" = "8:"
> -"Folder" = "8:_2ACFF9E534394C7DA2FC0E2D947C98CE"
> -"Condition" = "8:"
> -"Transitive" = "11:FALSE"
> -"Vital" = "11:TRUE"
> -"ReadOnly" = "11:FALSE"
> -"Hidden" = "11:FALSE"
> -"System" = "11:FALSE"
> -"Permanent" = "11:FALSE"
> -"SharedLegacy" = "11:FALSE"
> -"PackageAs" = "3:1"
> -"Register" = "3:1"
> -"Exclude" = "11:FALSE"
> -"IsDependency" = "11:FALSE"
> -"IsolateTo" = "8:"
> -}
>
> "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_A83A85D1131B4E8E95AB48367C69141D"
> {
> "SourcePath" = "8:Lib\\MonetDB5\\autoload\\40_sql.mal"
> diff -r dc4901d8243e -r a923f341841d
> sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj
> --- a/sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj Sat Jul 10
> 10:03:21 2010 +0200
MonetDB: default - Merged from Jun2010 (ignore any differences)
Changeset: 1fb46778df7a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1fb46778df7a Modified Files: sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj Branch: default Log Message: Merged from Jun2010 (ignore any differences) ___ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
MonetDB: Jun2010 - createdb.sql was removed, hopefully simply re...
Changeset: a923f341841d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a923f341841d
Modified Files:
sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj
sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj
sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj
sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj
Branch: Jun2010
Log Message:
createdb.sql was removed, hopefully simply removing the 'key' from the
installer files 'just' works
diffs (120 lines):
diff -r dc4901d8243e -r a923f341841d
sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj
--- a/sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj Sat Jul 10 10:03:21
2010 +0200
+++ b/sql/NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj Sat Jul 10 10:12:07
2010 +0200
@@ -5941,26 +5941,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_CEF22C247B2E476FBBAB8046DDBC0F1A"
-{
-"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
-"TargetName" = "8:createdb.sql"
-"Tag" = "8:"
-"Folder" = "8:_B593DAA0787744D6A44D17884E0C3951"
-"Condition" = "8:"
-"Transitive" = "11:FALSE"
-"Vital" = "11:TRUE"
-"ReadOnly" = "11:FALSE"
-"Hidden" = "11:FALSE"
-"System" = "11:FALSE"
-"Permanent" = "11:FALSE"
-"SharedLegacy" = "11:FALSE"
-"PackageAs" = "3:1"
-"Register" = "3:1"
-"Exclude" = "11:FALSE"
-"IsDependency" = "11:FALSE"
-"IsolateTo" = "8:"
-}
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_CF5DC8BD4BFA4D7EA31F3B1BBB4EB5A1"
{
"SourcePath" = "8:Lib\\MonetDB5\\lib_run_octopus.dll"
diff -r dc4901d8243e -r a923f341841d sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj
--- a/sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj Sat Jul 10 10:03:21 2010 +0200
+++ b/sql/NT/MonetDB5-SQL/MonetDB5-SQL.vdproj Sat Jul 10 10:12:07 2010 +0200
@@ -299,26 +299,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_4E285A2638A04D71AC11F06FA1EF0AA7"
-{
-"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
-"TargetName" = "8:createdb.sql"
-"Tag" = "8:"
-"Folder" = "8:_2ACFF9E534394C7DA2FC0E2D947C98CE"
-"Condition" = "8:"
-"Transitive" = "11:FALSE"
-"Vital" = "11:TRUE"
-"ReadOnly" = "11:FALSE"
-"Hidden" = "11:FALSE"
-"System" = "11:FALSE"
-"Permanent" = "11:FALSE"
-"SharedLegacy" = "11:FALSE"
-"PackageAs" = "3:1"
-"Register" = "3:1"
-"Exclude" = "11:FALSE"
-"IsDependency" = "11:FALSE"
-"IsolateTo" = "8:"
-}
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_60556A506BDF4F0A83013CA0B54EDC9E"
{
"SourcePath" = "8:Lib\\MonetDB5\\times.sql"
diff -r dc4901d8243e -r a923f341841d sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj
--- a/sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj Sat Jul 10 10:03:21 2010 +0200
+++ b/sql/NT/MonetDB5-SQL/MonetDB5-SQL64.vdproj Sat Jul 10 10:12:07 2010 +0200
@@ -499,26 +499,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_A095E6625D794D4AA25BDDFC71B855D4"
-{
-"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
-"TargetName" = "8:createdb.sql"
-"Tag" = "8:"
-"Folder" = "8:_2ACFF9E534394C7DA2FC0E2D947C98CE"
-"Condition" = "8:"
-"Transitive" = "11:FALSE"
-"Vital" = "11:TRUE"
-"ReadOnly" = "11:FALSE"
-"Hidden" = "11:FALSE"
-"System" = "11:FALSE"
-"Permanent" = "11:FALSE"
-"SharedLegacy" = "11:FALSE"
-"PackageAs" = "3:1"
-"Register" = "3:1"
-"Exclude" = "11:FALSE"
-"IsDependency" = "11:FALSE"
-"IsolateTo" = "8:"
-}
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_A83A85D1131B4E8E95AB48367C69141D"
{
"SourcePath" = "8:Lib\\MonetDB5\\autoload\\40_sql.mal"
diff -r dc4901d8243e -r a923f341841d
sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj
--- a/sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj Sat Jul 10
10:03:21 2010 +0200
+++ b/sql/NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj Sat Jul 10
10:12:07 2010 +0200
@@ -4661,26 +4661,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_981F356AD9144ACFA0F368DEC3CCD599"
-{
-"SourcePath" = "8:Lib\\MonetDB5\\createdb.sql"
-"TargetName" = "8:createdb.sql"
-
MonetDB: default - Merged from Jun2010
Changeset: 6d9e3fcff77c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6d9e3fcff77c Modified Files: Branch: default Log Message: Merged from Jun2010 diffs (13 lines): diff -r 647fe7705b69 -r 6d9e3fcff77c sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err --- a/sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err Sat Jul 10 10:02:43 2010 +0200 +++ b/sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err Sat Jul 10 10:04:50 2010 +0200 @@ -80,9 +80,6 @@ MAPI = mone...@alf:39317 QUERY = drop schema intro2; ERROR = !SQLException:sql.catalog:DROP SCHEMA: name intro2 does not exist -MAPI = mone...@alf:39317 -QUERY = create schema intro3 -ERROR = !sql_stmt symbol(7f74f4007a98)->token = CREATE_SCHEMA # 18:47:50 > # 18:47:50 > Done. ___ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
MonetDB: Jun2010 - drop (accidentially) approved unexpected (and...
Changeset: dc4901d8243e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dc4901d8243e Modified Files: sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err Branch: Jun2010 Log Message: drop (accidentially) approved unexpected (and obviously wrong) error, see .sql file diffs (13 lines): diff -r c29148e9f9f2 -r dc4901d8243e sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err --- a/sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err Sat Jul 10 10:00:00 2010 +0200 +++ b/sql/src/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err Sat Jul 10 10:03:21 2010 +0200 @@ -80,9 +80,6 @@ MAPI = mone...@alf:39317 QUERY = drop schema intro2; ERROR = !SQLException:sql.catalog:DROP SCHEMA: name intro2 does not exist -MAPI = mone...@alf:39317 -QUERY = create schema intro3 -ERROR = !sql_stmt symbol(7f74f4007a98)->token = CREATE_SCHEMA # 18:47:50 > # 18:47:50 > Done. ___ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
MonetDB: default - merged new tests from Jun2010
Changeset: 647fe7705b69 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=647fe7705b69
Modified Files:
sql/src/test/BugTracker-2010/Tests/All
Branch: default
Log Message:
merged new tests from Jun2010
diffs (truncated from 451 to 300 lines):
diff -r d1ef8f3c2038 -r 647fe7705b69 sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 09:00:54 2010 +0200
+++ b/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 10:02:43 2010 +0200
@@ -26,3 +26,6 @@
and_not_broken.Bug-2602
insert-into-except.Bug-2569
not-in-union-except-union.Bug-2577
+prepare_stmt.Bug-2533.Bug-2534
+predicate_in_select.Bug-2535
+subselect.Bug-2537
diff -r d1ef8f3c2038 -r 647fe7705b69
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.sql
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.sql
Sat Jul 10 10:02:43 2010 +0200
@@ -0,0 +1,2 @@
+select (select count(*) from _tables) > 5;
+select 5 < (select count(*) from _tables);
diff -r d1ef8f3c2038 -r 647fe7705b69
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++
b/sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.err
Sat Jul 10 10:02:43 2010 +0200
@@ -0,0 +1,78 @@
+stderr of test 'predicate_in_select.Bug-2535` in directory
'src/test/BugTracker-2010` itself:
+
+
+# 09:50:31 >
+# 09:50:31 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=39893 --set
xrpc_port=40127 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
+# 09:50:31 >
+
+# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
+# builtin opt gdk_version = 1.38.1
+# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# builtin opt exec_prefix = ${prefix}
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_admin = adm
+# builtin opt monet_prompt = >
+# builtin opt monet_welcome = yes
+# builtin opt monet_mod_path = ${exec_prefix}/lib64/MonetDB
+# builtin opt monet_daemon = no
+# builtin opt host = localhost
+# builtin opt mapi_port = 5
+# builtin opt mapi_clients = 2
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_debug = 0
+# builtin opt standoff_ns =
+# builtin opt standoff_start = start
+# builtin opt standoff_end = end
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt config = ${prefix}/etc/monetdb5.conf
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt exec_prefix = ${prefix}
+# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
+# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
+# config opt mero_controlport = 50001
+# config opt sql_optimizer = default_pipe
+# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
+# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector
+# config opt accumulator_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,
MonetDB: Jun2010 - added test for bug 2537
Changeset: c29148e9f9f2 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c29148e9f9f2
Modified Files:
sql/src/test/BugTracker-2010/Tests/All
sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.sql
sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.stable.err
sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.stable.out
Branch: Jun2010
Log Message:
added test for bug 2537
diffs (176 lines):
diff -r a6cd9e12ddd6 -r c29148e9f9f2 sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 09:52:03 2010 +0200
+++ b/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 10:00:00 2010 +0200
@@ -28,3 +28,4 @@
not-in-union-except-union.Bug-2577
prepare_stmt.Bug-2533.Bug-2534
predicate_in_select.Bug-2535
+subselect.Bug-2537
diff -r a6cd9e12ddd6 -r c29148e9f9f2
sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.sql
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.sql Sat Jul 10
10:00:00 2010 +0200
@@ -0,0 +1,23 @@
+CREATE TABLE Image (ImageId integer, imageBinaries string);
+
+INSERT INTO Image VALUES (1, 'A');
+
+SELECT * from Image;
+
+INSERT INTO Image
+ (ImageId
+ ,imageBinaries)
+VALUES
+ (MAX(ImageId)+1,'data');
+
+SELECT * from Image;
+
+INSERT INTO Image
+ (ImageId
+ ,imageBinaries)
+VALUES
+ ( (SELECT MAX(ImageId)+1 from Image),'data');
+
+SELECT * from Image;
+
+DROP TABLE Image;
diff -r a6cd9e12ddd6 -r c29148e9f9f2
sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/subselect.Bug-2537.stable.err Sat Jul
10 10:00:00 2010 +0200
@@ -0,0 +1,81 @@
+stderr of test 'subselect.Bug-2537` in directory 'src/test/BugTracker-2010`
itself:
+
+
+# 09:57:59 >
+# 09:57:59 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38583 --set
xrpc_port=45294 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
+# 09:57:59 >
+
+# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
+# builtin opt gdk_version = 1.38.1
+# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# builtin opt exec_prefix = ${prefix}
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_admin = adm
+# builtin opt monet_prompt = >
+# builtin opt monet_welcome = yes
+# builtin opt monet_mod_path = ${exec_prefix}/lib64/MonetDB
+# builtin opt monet_daemon = no
+# builtin opt host = localhost
+# builtin opt mapi_port = 5
+# builtin opt mapi_clients = 2
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_debug = 0
+# builtin opt standoff_ns =
+# builtin opt standoff_start = start
+# builtin opt standoff_end = end
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt config = ${prefix}/etc/monetdb5.conf
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt exec_prefix = ${prefix}
+# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
+# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
+# config opt mero_controlport = 50001
+# config opt sql_optimizer = default_pipe
+# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
+# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadco
MonetDB: Jun2010 - added test for bug 2535
Changeset: a6cd9e12ddd6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a6cd9e12ddd6
Modified Files:
sql/src/test/BugTracker-2010/Tests/All
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.sql
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.err
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.out
Branch: Jun2010
Log Message:
added test for bug 2535
diffs (143 lines):
diff -r 1e48c4327e11 -r a6cd9e12ddd6 sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 09:48:28 2010 +0200
+++ b/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 09:52:03 2010 +0200
@@ -27,3 +27,4 @@
insert-into-except.Bug-2569
not-in-union-except-union.Bug-2577
prepare_stmt.Bug-2533.Bug-2534
+predicate_in_select.Bug-2535
diff -r 1e48c4327e11 -r a6cd9e12ddd6
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.sql
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.sql
Sat Jul 10 09:52:03 2010 +0200
@@ -0,0 +1,2 @@
+select (select count(*) from _tables) > 5;
+select 5 < (select count(*) from _tables);
diff -r 1e48c4327e11 -r a6cd9e12ddd6
sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++
b/sql/src/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.err
Sat Jul 10 09:52:03 2010 +0200
@@ -0,0 +1,78 @@
+stderr of test 'predicate_in_select.Bug-2535` in directory
'src/test/BugTracker-2010` itself:
+
+
+# 09:50:31 >
+# 09:50:31 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=39893 --set
xrpc_port=40127 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
+# 09:50:31 >
+
+# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
+# builtin opt gdk_version = 1.38.1
+# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# builtin opt exec_prefix = ${prefix}
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_admin = adm
+# builtin opt monet_prompt = >
+# builtin opt monet_welcome = yes
+# builtin opt monet_mod_path = ${exec_prefix}/lib64/MonetDB
+# builtin opt monet_daemon = no
+# builtin opt host = localhost
+# builtin opt mapi_port = 5
+# builtin opt mapi_clients = 2
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_debug = 0
+# builtin opt standoff_ns =
+# builtin opt standoff_start = start
+# builtin opt standoff_end = end
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt config = ${prefix}/etc/monetdb5.conf
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt exec_prefix = ${prefix}
+# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
+# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
+# config opt mero_controlport = 50001
+# config opt sql_optimizer = default_pipe
+# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
+# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTer
MonetDB: Jun2010 - added test for bugs 2533 & 2534
Changeset: 1e48c4327e11 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1e48c4327e11
Modified Files:
sql/src/test/BugTracker-2010/Tests/All
sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.sql
sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out
Branch: Jun2010
Log Message:
added test for bugs 2533 & 2534
diffs (146 lines):
diff -r f5cb2db5f58f -r 1e48c4327e11 sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 09:00:15 2010 +0200
+++ b/sql/src/test/BugTracker-2010/Tests/AllSat Jul 10 09:48:28 2010 +0200
@@ -26,3 +26,4 @@
and_not_broken.Bug-2602
insert-into-except.Bug-2569
not-in-union-except-union.Bug-2577
+prepare_stmt.Bug-2533.Bug-2534
diff -r f5cb2db5f58f -r 1e48c4327e11
sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.sql
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++ b/sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.sql
Sat Jul 10 09:48:28 2010 +0200
@@ -0,0 +1,3 @@
+prepare select count(*) from _tables having count(*) = ?;
+exec 0(1);
+exec 0(2.3);
diff -r f5cb2db5f58f -r 1e48c4327e11
sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +
+++
b/sql/src/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
Sat Jul 10 09:48:28 2010 +0200
@@ -0,0 +1,81 @@
+stderr of test 'prepare_stmt.Bug-2533.Bug-2534` in directory
'src/test/BugTracker-2010` itself:
+
+
+# 09:32:45 >
+# 09:32:45 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33580 --set
xrpc_port=46288 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
+# 09:32:45 >
+
+# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
+# builtin opt gdk_version = 1.38.1
+# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# builtin opt exec_prefix = ${prefix}
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_admin = adm
+# builtin opt monet_prompt = >
+# builtin opt monet_welcome = yes
+# builtin opt monet_mod_path = ${exec_prefix}/lib64/MonetDB
+# builtin opt monet_daemon = no
+# builtin opt host = localhost
+# builtin opt mapi_port = 5
+# builtin opt mapi_clients = 2
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_debug = 0
+# builtin opt standoff_ns =
+# builtin opt standoff_start = start
+# builtin opt standoff_end = end
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt config = ${prefix}/etc/monetdb5.conf
+# config opt prefix =
/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
+# config opt exec_prefix = ${prefix}
+# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
+# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
+# config opt mero_controlport = 50001
+# config opt sql_optimizer = default_pipe
+# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
+# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
+# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constan
MonetDB: default - merge with Jun2010
Changeset: d1ef8f3c2038 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d1ef8f3c2038 Modified Files: Branch: default Log Message: merge with Jun2010 diffs (19 lines): diff -r f4461e83c0bc -r d1ef8f3c2038 testing/src/Mfilter.py.in --- a/testing/src/Mfilter.py.in Sat Jul 10 08:52:26 2010 +0200 +++ b/testing/src/Mfilter.py.in Sat Jul 10 09:00:54 2010 +0200 @@ -144,6 +144,7 @@ r'^(.*: )(illegal|invalid)( option -- .*)\n', # 23: 3 r'^(01/Jan/1970 01:00:00 shttpd_open_port: bind\(|!ERROR: MAPIlisten:binding to stream socket \()([0-9]+)(\): Address already in use|\) failed)\n', # 24: 3 r'^(!.*Exception:remote\.[^:]*:\(mapi:monetdb://monetdb@)([^/]*)(/mTests_.*\).*)\n', # 25: 3 +r'^(ERROR = !sql_stmt symbol\()(.*)(\)->token = CREATE_SCHEMA)\n', # 26: 3 r'^(.*: at )(\([0-9]+,[0-9]+\-[0-9]+,[0-9]+\))(: .*)\n', # 90: 3 r'^(fatal error|ERROR)(: err:FORG0005, fn:exactly-one called with a sequence containing zero or more than one item..*)()\n',# 99: 3 ])+')', re.MULTILINE) @@ -176,6 +177,7 @@ None, 'invalid', None, # 23: 3 None, '...', None, # 24: 3 None, 'localhost', None, # 25: 3 +None, '...', None, # 26: 3 None, '...', None, # 90: 3 '=ERROR', None, '\n#', # 99: 3 ##'=ERROR', None, ''' ___ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
MonetDB: Jun2010 - ignore varying address in error message
Changeset: f5cb2db5f58f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f5cb2db5f58f Modified Files: testing/src/Mfilter.py.in Branch: Jun2010 Log Message: ignore varying address in error message of test for bug 2547 diffs (19 lines): diff -r 64774fd570aa -r f5cb2db5f58f testing/src/Mfilter.py.in --- a/testing/src/Mfilter.py.in Sat Jul 10 08:51:09 2010 +0200 +++ b/testing/src/Mfilter.py.in Sat Jul 10 09:00:15 2010 +0200 @@ -144,6 +144,7 @@ r'^(.*: )(illegal|invalid)( option -- .*)\n', # 23: 3 r'^(01/Jan/1970 01:00:00 shttpd_open_port: bind\(|!ERROR: MAPIlisten:binding to stream socket \()([0-9]+)(\): Address already in use|\) failed)\n', # 24: 3 r'^(!.*Exception:remote\.[^:]*:\(mapi:monetdb://monetdb@)([^/]*)(/mTests_.*\).*)\n', # 25: 3 +r'^(ERROR = !sql_stmt symbol\()(.*)(\)->token = CREATE_SCHEMA)\n', # 26: 3 r'^(.*: at )(\([0-9]+,[0-9]+\-[0-9]+,[0-9]+\))(: .*)\n', # 90: 3 r'^(fatal error|ERROR)(: err:FORG0005, fn:exactly-one called with a sequence containing zero or more than one item..*)()\n',# 99: 3 ])+')', re.MULTILINE) @@ -176,6 +177,7 @@ None, 'invalid', None, # 23: 3 None, '...', None, # 24: 3 None, 'localhost', None, # 25: 3 +None, '...', None, # 26: 3 None, '...', None, # 90: 3 '=ERROR', None, '\n#', # 99: 3 ##'=ERROR', None, ''' ___ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
