Changeset: 93a3b7826ee4 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=93a3b7826ee4
Modified Files:
Branch: default
Log Message:
merge with Jun2010
diffs (truncated from 493 to 300 lines):
diff -r 29c41a7efa82 -r 93a3b7826ee4
sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out.Debian
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++
b/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out.Debian
Wed Jul 07 23:50:20 2010 +0200
@@ -0,0 +1,74 @@
+stdout of test 'POWER_vs_prod.SF-2596114` in directory
'src/test/BugTracker-2009` itself:
+
+
+# 23:02:29 >
+# 23:02:29 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/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/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrp
c_open=true --set mapi_port=33742 --set xrpc_port=44239 --set monet_prompt=
--trace "--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 23:02:29 >
+
+# MonetDB server v5.10.3, based on kernel v1.28.3
+# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:33742/
+# MonetDB/SQL module v2.28.1 loaded
+
+Ready.
+#function user.main():void;
+# clients.quit();
+#end main;
+
+Over..
+
+# 15:46:08 >
+# 15:46:08 > mclient -lsql -i -umonetdb -Pmonetdb --host=rig --port=35464
+# 15:46:08 >
+
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s0_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+ _3:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",0);
+ _8:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",2);
+ _10 := algebra.kdifference(_3,_8);
+ _11 := algebra.kunion(_10,_8);
+ _12:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",1);
+ _14 := algebra.kunion(_11,_12);
+ _15:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","sf_2596114",1);
+ _16 := bat.reverse(_15);
+ _17 := algebra.kdifference(_14,_16);
+ _18:bat[:oid,:dbl] := batmmath.pow(_17,2);
+ _19 := sql.resultSet(1,1,_18);
+ sql.rsColumn(_19,"sys.","power_x","double",53,0,_18);
+ _25 := io.stdout();
+ sql.exportResult(_25,_19);
+end s0_1;
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s1_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+ _3:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",0);
+ _8:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",2);
+ _10 := algebra.kdifference(_3,_8);
+ _11 := algebra.kunion(_10,_8);
+ _12:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",1);
+ _14 := algebra.kunion(_11,_12);
+ _15:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","sf_2596114",1);
+ _16 := bat.reverse(_15);
+ _17 := algebra.kdifference(_14,_16);
+ _18:bat[:oid,:dbl] := batcalc.*(_17,_17);
+ _19 := sql.resultSet(1,1,_18);
+ sql.rsColumn(_19,"sys.","sql_mul_x","double",53,0,_18);
+ _25 := io.stdout();
+ sql.exportResult(_25,_19);
+end s1_1;
+
+# 23:02:30 >
+# 23:02:30 > Done.
+# 23:02:30 >
+
diff -r 29c41a7efa82 -r 93a3b7826ee4
sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out.Windows
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++
b/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out.Windows
Wed Jul 07 23:50:20 2010 +0200
@@ -0,0 +1,74 @@
+stdout of test 'POWER_vs_prod.SF-2596114` in directory
'src/test/BugTracker-2009` itself:
+
+
+# 23:02:29 >
+# 23:02:29 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/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/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrp
c_open=true --set mapi_port=33742 --set xrpc_port=44239 --set monet_prompt=
--trace "--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 23:02:29 >
+
+# MonetDB server v5.10.3, based on kernel v1.28.3
+# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:33742/
+# MonetDB/SQL module v2.28.1 loaded
+
+Ready.
+#function user.main():void;
+# clients.quit();
+#end main;
+
+Over..
+
+# 15:46:08 >
+# 15:46:08 > mclient -lsql -i -umonetdb -Pmonetdb --host=rig --port=35464
+# 15:46:08 >
+
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s0_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+ _3:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",0);
+ _8:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",2);
+ _10 := algebra.kdifference(_3,_8);
+ _11 := algebra.kunion(_10,_8);
+ _12:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",1);
+ _14 := algebra.kunion(_11,_12);
+ _15:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","sf_2596114",1);
+ _16 := bat.reverse(_15);
+ _17 := algebra.kdifference(_14,_16);
+ _18:bat[:oid,:dbl] := batmmath.pow(_17,2);
+ _19 := sql.resultSet(1,1,_18);
+ sql.rsColumn(_19,"sys.","power_x","double",53,0,_18);
+ _25 := io.stdout();
+ sql.exportResult(_25,_19);
+end s0_1;
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s1_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+ _3:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",0);
+ _8:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",2);
+ _10 := algebra.kdifference(_3,_8);
+ _11 := algebra.kunion(_10,_8);
+ _12:bat[:oid,:dbl] := sql.bind(_2,"sys","sf_2596114","x",1);
+ _14 := algebra.kunion(_11,_12);
+ _15:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","sf_2596114",1);
+ _16 := bat.reverse(_15);
+ _17 := algebra.kdifference(_14,_16);
+ _18:bat[:oid,:dbl] := batcalc.*(_17,_17);
+ _19 := sql.resultSet(1,1,_18);
+ sql.rsColumn(_19,"sys.","sql_mul_x","double",53,0,_18);
+ _25 := io.stdout();
+ sql.exportResult(_25,_19);
+end s1_1;
+
+# 23:02:30 >
+# 23:02:30 > Done.
+# 23:02:30 >
+
diff -r 29c41a7efa82 -r 93a3b7826ee4
sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out.Debian
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++
b/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out.Debian
Wed Jul 07 23:50:20 2010 +0200
@@ -0,0 +1,90 @@
+stdout of test 'explain_gives_crash.SF-2741829` in directory
'src/test/BugTracker-2009` itself:
+
+
+# 22:45:54 >
+# 22:45:54 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35519 --set
xrpc_port=48894 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
+# 22:45:54 >
+
+# MonetDB server v5.12.0, based on kernel v1.30.0
+# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35519/
+# MonetDB/SQL module v2.30.0 loaded
+
+Ready.
+#function user.main():void;
+# clients.quit();
+#end main;
+
+Over..
+
+# 21:13:40 >
+# 21:13:40 > mclient -lsql -i --host=alf --port=39638
+# 21:13:40 >
+
+#~BeginVariableOutput~#
+function user.s1_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+" sql.catalog(29\,\"sys\"\,144639848\,0);"
+" _7:bat[:oid\,:int] := sql.bind(_2\,\"sys\"\,\"blabla\"\,\"id\"\,0);"
+ _10 := algebra.selectNotNil(_7);
+" _11:bat[:oid\,:oid] := sql.bind_dbat(_2\,\"sys\"\,\"blabla\"\,1);"
+ _13 := bat.reverse(_11);
+" _14 := algebra.kdifference(_10\,_13);"
+" (ext21\,grp19) := group.done(_14);"
+ _17 := bat.mirror(ext21);
+" _18:bat[:oid\,:wrd] := aggr.count(grp19\,grp19\,_17);"
+ _19 := aggr.count(_18);
+ _20:wrd := aggr.sum(_18);
+ _21 := calc.isnil(_20);
+" _23 := calc.ifthenelse(_21\,0:wrd\,_20);"
+" _24 := calc.!=(_19\,_23);"
+" sql.assert(_24\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s1_1;
+function user.s2_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+" sql.catalog(29\,\"sys\"\,144902088\,0);"
+" _7:bat[:oid\,:int] := sql.bind(_2\,\"sys\"\,\"blabla\"\,\"id\"\,0);"
+ _10 := algebra.selectNotNil(_7);
+" _11:bat[:oid\,:oid] := sql.bind_dbat(_2\,\"sys\"\,\"blabla\"\,1);"
+ _13 := bat.reverse(_11);
+" _14 := algebra.kdifference(_10\,_13);"
+" (ext21\,grp19) := group.done(_14);"
+ _17 := bat.mirror(ext21);
+" _18:bat[:oid\,:wrd] := aggr.count(grp19\,grp19\,_17);"
+ _19 := aggr.count(_18);
+ _20:wrd := aggr.sum(_18);
+ _21 := calc.isnil(_20);
+" _23 := calc.ifthenelse(_21\,0:wrd\,_20);"
+" _24 := calc.!=(_19\,_23);"
+" sql.assert(_24\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s2_1;
+#~EndVariableOutput~#
+#~BeginVariableOutput~#
+function user.s1_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+" sql.catalog(29\,\"sys\"\,144639848\,0);"
+" _7:bat[:oid\,:int] := sql.bind(_2\,\"sys\"\,\"blabla\"\,\"id\"\,0);"
+ _10 := algebra.selectNotNil(_7);
+" _11:bat[:oid\,:oid] := sql.bind_dbat(_2\,\"sys\"\,\"blabla\"\,1);"
+ _13 := bat.reverse(_11);
+" _14 := algebra.kdifference(_10\,_13);"
+" (ext21\,grp19) := group.done(_14);"
+ _17 := bat.mirror(ext21);
+" _18:bat[:oid\,:wrd] := aggr.count(grp19\,grp19\,_17);"
+ _19 := aggr.count(_18);
+ _20:wrd := aggr.sum(_18);
+ _21 := calc.isnil(_20);
+" _23 := calc.ifthenelse(_21\,0:wrd\,_20);"
+" _24 := calc.!=(_19\,_23);"
+" sql.assert(_24\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s1_1;
+#~EndVariableOutput~#
+
+# 11:37:28 >
+# 11:37:28 > Done.
+# 11:37:28 >
+
diff -r 29c41a7efa82 -r 93a3b7826ee4
sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out.Windows
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++
b/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out.Windows
Wed Jul 07 23:50:20 2010 +0200
@@ -0,0 +1,90 @@
+stdout of test 'explain_gives_crash.SF-2741829` in directory
'src/test/BugTracker-2009` itself:
+
+
+# 22:45:54 >
+# 22:45:54 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35519 --set
xrpc_port=48894 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
+# 22:45:54 >
+
+# MonetDB server v5.12.0, based on kernel v1.30.0
+# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35519/
+# MonetDB/SQL module v2.30.0 loaded
+
+Ready.
+#function user.main():void;
+# clients.quit();
+#end main;
+
+Over..
+
+# 21:13:40 >
+# 21:13:40 > mclient -lsql -i --host=alf --port=39638
+# 21:13:40 >
+
+#~BeginVariableOutput~#
+function user.s1_1{autoCommit=true}():void;
+ _2 := sql.mvc();
+" sql.catalog(29\,\"sys\"\,127543840\,0);"
+" _7:bat[:oid\,:int] := sql.bind(_2\,\"sys\"\,\"blabla\"\,\"id\"\,0);"
+ _10 := algebra.selectNotNil(_7);
+" _11:bat[:oid\,:oid] := sql.bind_dbat(_2\,\"sys\"\,\"blabla\"\,1);"
+ _13 := bat.reverse(_11);
+" _14 := algebra.kdifference(_10\,_13);"
+" (ext21\,grp19) := group.done(_14);"
+ _17 := bat.mirror(ext21);
+" _18:bat[:oid\,:wrd] := aggr.count(grp19\,grp19\,_17);"
+ _19 := aggr.count(_18);
+ _20:wrd := aggr.sum(_18);
+ _21 := calc.isnil(_20);
+" _23 := calc.ifthenelse(_21\,0:wrd\,_20);"
+" _24 := calc.!=(_19\,_23);"
+" sql.assert(_24\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s1_1;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
