Changeset: 3415947dec0a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3415947dec0a Modified Files: sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit Branch: Jun2010 Log Message:
approved 32-bit specific stable output diffs (109 lines): diff -r ac0b4e29d772 -r 3415947dec0a sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit Tue Aug 03 14:20:23 2010 +0200 @@ -0,0 +1,105 @@ +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.type as p.type, _tables.%TID% NOT NULL as p.%TID% ] | +| | | | | | ) [ p.type < convert(2) ] | +| | | | | ) [ p.id, p.type ], | +| | | | | project ( | +| | | | | | select ( | +| | | | | | | table(tmp._tables) [ _tables.id as t.id, _tables.type as t.type, _tables.%TID% NOT NULL as t.%TID% ] | +| | | | | | ) [ t.type < convert(2) ] | +| | | | | ) [ t.id, t.type ] | +| | | | ) [ id as tables.id, type as tables.type ] | +| | | ) [ tables.id ] | +| | ) [ ] [ count NOT NULL as L1 ] | +| ) [ L1 NOT NULL ] | ++-----------------------------------------------------------------------------------------------------------------+ +18 rows + ++--------+ +| mal | ++========+ +| function user.s3_1{autoCommit=true}():void; | +| _2 := sql.mvc(); | +| _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); | +| _45:bat[:oid,:int] := bat.new(nil:oid,nil:int); | +| _48 := bat.append(_45,_44,true); | +| _50 := bat.append(_48,_18,true); | +| _51 := aggr.count(_50); | +| sql.exportValue(1,".tables","L2","wrd",32,0,6,_51,""); | +| end s3_1; | ++--------+ +38 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
