Changeset: 650342fc1924 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=650342fc1924 Modified Files: sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit Branch: Jun2010 Log Message:
disable parallelism (mitosis & dataflow) to avoid ambiguous explain output diffs (113 lines): diff -r 7899f7abf279 -r 650342fc1924 sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit --- a/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit Sun Jul 18 11:02:44 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,109 +0,0 @@ -stdout of test 'jdbc_no_debug.SF-1739356` in directory 'src/test/BugTracker` itself: - - -# 13:44:44 > -# 13:44:44 > 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=36629 --set xrpc_port=45999 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. -# 13:44:44 > - -# MonetDB server v5.12.0, based on kernel v1.30.0 -# Serving database 'mTests_src_test_BugTracker', 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:36629/ -# MonetDB/SQL module v2.30.0 loaded - -Ready. -#function user.main():void; -# clients.quit(); -#end main; - -Over.. - -# 13:30:19 > -# 13:30:19 > ./jdbc_no_debug.SF-1739356.SQL.sh jdbc_no_debug.SF-1739356 -# 13:30:19 > - - -# 13:30:19 > -# 13:30:19 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -h rig -p 39462 -d mTests_src_test_BugTracker -f "../../../../../source/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql" -# 13:30:19 > - -+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ -| rel | -+===========================================================================================================================================================================================================================================================================================================+ -| project ( | -| | group by ( | -| | | project ( | -| | | | union ( | -| | | | | project ( | -| | | | | | select ( | -| | | | | | | table(sys._tables) [ _tables.id as p.id, _tables.name as p.name, _tables.schema_id as p.schema_id, _tables.query as p.query, _tables.type as p.type, _tables.system as p.system, _tables.commit_action as p.commit_action, _tables.readonly as p.readonly, _tables.%TID% NOT NULL as p.%TID% ] | -| | | | | | ) [ p.type < convert(2) ] | -| | | | | ) [ p.id, p.name, p.schema_id, p.query, p.type, p.system, p.commit_action, p.readonly, 0 as temporary ], | -| | | | | project ( | -| | | | | | select ( | -| | | | | | | table(tmp._tables) [ _tables.id as t.id, _tables.name as t.name, _tables.schema_id as t.schema_id, _tables.query as t.query, _tables.type as t.type, _tables.system as t.system, _tables.commit_action as t.commit_action, _tables.readonly as t.readonly, _tables.%TID% NOT NULL as t.%TID% ] | -| | | | | | ) [ t.type < convert(2) ] | -| | | | | ) [ t.id, t.name, t.schema_id, t.query, t.type, t.system, t.commit_action, t.readonly, 1 as temporary ] | -| | | | ) [ id as tables.id, name as tables.name, schema_id as tables.schema_id, query as tables.query, type as tables.type, system as tables.system, commit_action as tables.commit_action, readonly as tables.readonly, temporary as tables.temporary ] | -| | | ) [ tables.id ] | -| | ) [ ] [ count NOT NULL as L1 ] | -| ) [ L1 NOT NULL ] | -+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ -18 rows - -+--------+ -| mal | -+========+ -| function user.s2_1{autoCommit=true}():void; | -| _2 := sql.mvc(); | -| barrier _70 := language.dataflow(); | -| _19:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",0); | -| _21 := algebra.thetauselect(_19,2:sht,"<"); | -| _22:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",2); | -| _24 := algebra.kdifference(_21,_22); | -| _25 := algebra.thetauselect(_22,2:sht,"<"); | -| _26 := algebra.kunion(_24,_25); | -| _27:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",1); | -| _28 := algebra.thetauselect(_27,2:sht,"<"); | -| _29 := algebra.kunion(_26,_28); | -| _30:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","_tables",1); | -| _32 := bat.reverse(_30); | -| _33 := algebra.kdifference(_29,_32); | -| _34 := algebra.markT(_33,0...@0); | -| _35 := bat.reverse(_34); | -| _36:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",0); | -| _38:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",2); | -| _39 := algebra.kdifference(_36,_38); | -| _40 := algebra.kunion(_39,_38); | -| _41:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",1); | -| _43 := algebra.kunion(_40,_41); | -| _44 := algebra.leftjoin(_35,_43); | -| _3:bat[:oid,:sht] := sql.bind(_2,"tmp","_tables","type",0); | -| _8 := algebra.thetauselect(_3,2:sht,"<"); | -| _10:bat[:oid,:oid] := sql.bind_dbat(_2,"tmp","_tables",1); | -| _12 := bat.reverse(_10); | -| _13 := algebra.kdifference(_8,_12); | -| _14 := algebra.markT(_13,0...@0); | -| _15 := bat.reverse(_14); | -| _16:bat[:oid,:int] := sql.bind(_2,"tmp","_tables","id",0); | -| _18 := algebra.leftjoin(_15,_16); | -| exit _70; | -| _45:bat[:oid,:int] := bat.new(nil:oid,nil:int); | -| barrier _73 := language.dataflow(); | -| _48 := bat.append(_45,_44,true); | -| _50 := bat.append(_48,_18,true); | -| _51 := aggr.count(_50); | -| exit _73; | -| sql.exportValue(1,".tables","L2","wrd",32,0,6,_51,""); | -| end s2_1; | -+--------+ -42 rows - - -# 13:30:20 > -# 13:30:20 > Done. -# 13:30:20 > - _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
