mat03.stable.out

一个内存数据库的源代码这是服务器端还有客户端

stdout of test 'mat03` in directory 'src/optimizer` itself:


# 22:52:23 >  
# 22:52:23 >  Mtimeout -timeout 60 Mserver "--config=/ufs/mk/monet5/src/mal/Tests/All.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/log" --set mapi_port=32255 --set sql_port=41881 --set xquery_port=57613 --set monet_prompt= --trace --dbname=mTests_src_optimizer  mat03.mal < /dev/null
# 22:52:23 >  

# Monet Database Server V4.99.19
# Copyright (c) 1993-2005, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 32bit OIDs; dynamically linked.
# config:/ufs/mk/monet5/src/mal/Tests/All.conf
# dbfarm:/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/dbfarm
# dbname:mTests_src_optimizer
# Visit http://monetdb.cwi.nl/ for further information.
##select * from t,s where t.i=s.j;
#
#mdb.list();
##   v2:bat[:void,:int]  := sql.bind("sys","t","i",0);
#	v2v0:= bat.new(:void,:int);
#    bat.insert(v2v0,nil,0);
#    v2v1:= bat.new(:void,:int);
#    bat.insert(v2v1,nil,1);
#	v2:= mat.new(v2v0,v2v1);
#
##   v14:bat[:void,:int]  := sql.bind("sys","s","j",0);
#    v14v0:= bat.new(:void,:int);
#    bat.insert(v14v0,nil,0);
#    v14v1:= bat.new(:void,:int);
#    bat.insert(v14v1,nil,1);
#	v14:= mat.new(v14v0,v14v1);
#
#
##   v8:bat[:void,:oid]  := sql.bindvdbat("sys","t",0);
#	v8:= bat.new(:void,:oid);
#    v10 := bat.reverse(v8);
#    v12 := algebra.kdifference(v2,v10);
#
##   v18:bat[:void,:oid]  := sql.bindvdbat("sys","s",0);
#	v18:= bat.new(:void,:oid);
#
#    v20 := bat.reverse(v18);
#    v22 := algebra.kdifference(v14,v20);
#    v24 := bat.reverse(v22);
#    v26 := algebra.join(v12,v24);
#    v31 := algebra.markT(v26,0@0);
#    v33 := bat.reverse(v31);
#    v35 := algebra.join(v33,v2);
#    v37 := bat.reverse(v26);
#    v41 := algebra.markT(v37,0@0);
#    v43 := bat.reverse(v41);
#    v45 := algebra.join(v43,v14);
##   v47 := sql.resultSet(2,3,v35);
##   sql.rsColumn(v47,"t","i","int",32,0,v35);
##   sql.rsColumn(v47,"s","j","int",32,0,v45);
##   sql.exportResult(v47);
#
#	io.print(v35,v45);
#optimizer.multitable();
#
function user.main():void;	# 0  (main:void)
#select * from t,s where t.i=s.j; 	# 1  (_1:str)
    mdb.list();	# 2 MDBlist (_2:void)
#   v2:bat[:void,:int]  := sql.bind("sys","t","i",0); 	# 3  (_3:str)
    v2v0 := bat.new(:void,:int);	# 4 CMDBATnew (v2v0:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v2v0,nil,0);	# 5 BKCinsert_bun (_7:void)<-(v2v0:bat[:void,:int])(_8:void)(_9:int)
    v2v1 := bat.new(:void,:int);	# 6 CMDBATnew (v2v1:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v2v1,nil,1);	# 7 BKCinsert_bun (_11:void)<-(v2v1:bat[:void,:int])(_8:void)(_12:int)
    v2 := mat.new(v2v0,v2v1);	# 8 MATnew (v2:bat[:void,:int])<-(v2v0:bat[:void,:int])(v2v1:bat[:void,:int])
#   v14:bat[:void,:int]  := sql.bind("sys","s","j",0); 	# 9  (_14:str)
    v14v0 := bat.new(:void,:int);	# 10 CMDBATnew (v14v0:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v14v0,nil,0);	# 11 BKCinsert_bun (_16:void)<-(v14v0:bat[:void,:int])(_8:void)(_9:int)
    v14v1 := bat.new(:void,:int);	# 12 CMDBATnew (v14v1:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v14v1,nil,1);	# 13 BKCinsert_bun (_18:void)<-(v14v1:bat[:void,:int])(_8:void)(_12:int)
    v14 := mat.new(v14v0,v14v1);	# 14 MATnew (v14:bat[:void,:int])<-(v14v0:bat[:void,:int])(v14v1:bat[:void,:int])
#   v8:bat[:void,:oid]  := sql.bindvdbat("sys","t",0); 	# 15  (_20:str)
    v8 := bat.new(:void,:oid);	# 16 CMDBATnew (v8:bat[:void,:oid])<-(_5:void)(_22:oid)
    v10 := bat.reverse(v8);	# 17 BKCreverse (v10:bat[:oid,:void])<-(v8:bat[:void,:oid])
    _45 := algebra.kdifference(v2v0,v10);	# 18 ALGkdiff (_45:bat[:oid,:int])<-(v2v0:bat[:void,:int])(v10:bat[:oid,:void])
    _46 := algebra.kdifference(v2v1,v10);	# 19 ALGkdiff (_46:bat[:oid,:int])<-(v2v1:bat[:void,:int])(v10:bat[:oid,:void])
    v12 := mat.new(_45,_46);	# 20 MATnew (v12:bat[:oid,:int])<-(_45:bat[:oid,:int])(_46:bat[:oid,:int])
#   v18:bat[:void,:oid]  := sql.bindvdbat("sys","s",0); 	# 21  (_25:str)
    v18 := bat.new(:void,:oid);	# 22 CMDBATnew (v18:bat[:void,:oid])<-(_5:void)(_22:oid)
    v20 := bat.reverse(v18);	# 23 BKCreverse (v20:bat[:oid,:void])<-(v18:bat[:void,:oid])
    _47 := algebra.kdifference(v14v0,v20);	# 24 ALGkdiff (_47:bat[:oid,:int])<-(v14v0:bat[:void,:int])(v20:bat[:oid,:void])
    _48 := algebra.kdifference(v14v1,v20);	# 25 ALGkdiff (_48:bat[:oid,:int])<-(v14v1:bat[:void,:int])(v20:bat[:oid,:void])
    v22 := mat.new(_47,_48);	# 26 MATnew (v22:bat[:oid,:int])<-(_47:bat[:oid,:int])(_48:bat[:oid,:int])
    _49 := bat.reverse(_47);	# 27 BKCreverse (_49:bat[:int,:oid])<-(_47:bat[:oid,:int])
    _50 := bat.reverse(_48);	# 28 BKCreverse (_50:bat[:int,:oid])<-(_48:bat[:oid,:int])
    v24 := mat.new(_49,_50);	# 29 MATnew (v24:bat[:int,:oid])<-(_49:bat[:int,:oid])(_50:bat[:int,:oid])
    v12 := mat.pack(_45,_46);	# 30 MATpack (v12:bat[:oid,:int])<-(_45:bat[:oid,:int])(_46:bat[:oid,:int])
    _51 := algebra.join(v12,_49);	# 31 ALGjoin (_51:bat[:oid,:oid])<-(v12:bat[:oid,:int])(_49:bat[:int,:oid])
    _52 := algebra.join(v12,_50);	# 32 ALGjoin (_52:bat[:oid,:oid])<-(v12:bat[:oid,:int])(_50:bat[:int,:oid])
    v26 := mat.new(_51,_52);	# 33 MATnew (v26:bat[:oid,:oid])<-(_51:bat[:oid,:oid])(_52:bat[:oid,:oid])
    _53 := algebra.markT(_51,0@0);	# 34 ALGtmark (_53:bat[:oid,:void])<-(_51:bat[:oid,:oid])(_32:oid)
    _54 := algebra.markT(_52,0@0);	# 35 ALGtmark (_54:bat[:oid,:void])<-(_52:bat[:oid,:oid])(_32:oid)
    v31 := mat.new(_53,_54);	# 36 MATnew (v31:bat[:oid,:void])<-(_53:bat[:oid,:void])(_54:bat[:oid,:void])
    _55 := bat.reverse(_53);	# 37 BKCreverse (_55:bat[:void,:oid])<-(_53:bat[:oid,:void])
    _56 := bat.reverse(_54);	# 38 BKCreverse (_56:bat[:void,:oid])<-(_54:bat[:oid,:void])
    v33 := mat.new(_55,_56);	# 39 MATnew (v33:bat[:void,:oid])<-(_55:bat[:void,:oid])(_56:bat[:void,:oid])
    v33 := mat.pack(_55,_56);	# 40 MATpack (v33:bat[:void,:oid])<-(_55:bat[:void,:oid])(_56:bat[:void,:oid])
    _57 := algebra.join(v33,v2v0);	# 41 ALGjoin (_57:bat[:void,:int])<-(v33:bat[:void,:oid])(v2v0:bat[:void,:int])
    _58 := algebra.join(v33,v2v1);	# 42 ALGjoin (_58:bat[:void,:int])<-(v33:bat[:void,:oid])(v2v1:bat[:void,:int])
    v35 := mat.new(_57,_58);	# 43 MATnew (v35:bat[:void,:int])<-(_57:bat[:void,:int])(_58:bat[:void,:int])
    _59 := bat.reverse(_51);	# 44 BKCreverse (_59:bat[:oid,:oid])<-(_51:bat[:oid,:oid])
    _60 := bat.reverse(_52);	# 45 BKCreverse (_60:bat[:oid,:oid])<-(_52:bat[:oid,:oid])
    v37 := mat.new(_59,_60);	# 46 MATnew (v37:bat[:oid,:oid])<-(_59:bat[:oid,:oid])(_60:bat[:oid,:oid])
    _61 := algebra.markT(_59,0@0);	# 47 ALGtmark (_61:bat[:oid,:void])<-(_59:bat[:oid,:oid])(_32:oid)
    _62 := algebra.markT(_60,0@0);	# 48 ALGtmark (_62:bat[:oid,:void])<-(_60:bat[:oid,:oid])(_32:oid)
    v41 := mat.new(_61,_62);	# 49 MATnew (v41:bat[:oid,:void])<-(_61:bat[:oid,:void])(_62:bat[:oid,:void])
    _63 := bat.reverse(_61);	# 50 BKCreverse (_63:bat[:void,:oid])<-(_61:bat[:oid,:void])
    _64 := bat.reverse(_62);	# 51 BKCreverse (_64:bat[:void,:oid])<-(_62:bat[:oid,:void])
    v43 := mat.new(_63,_64);	# 52 MATnew (v43:bat[:void,:oid])<-(_63:bat[:void,:oid])(_64:bat[:void,:oid])
    v43 := mat.pack(_63,_64);	# 53 MATpack (v43:bat[:void,:oid])<-(_63:bat[:void,:oid])(_64:bat[:void,:oid])
    _65 := algebra.join(v43,v14v0);	# 54 ALGjoin (_65:bat[:void,:int])<-(v43:bat[:void,:oid])(v14v0:bat[:void,:int])
    _66 := algebra.join(v43,v14v1);	# 55 ALGjoin (_66:bat[:void,:int])<-(v43:bat[:void,:oid])(v14v1:bat[:void,:int])
    v45 := mat.new(_65,_66);	# 56 MATnew (v45:bat[:void,:int])<-(_65:bat[:void,:int])(_66:bat[:void,:int])
#   v47 := sql.resultSet(2,3,v35); 	# 57  (_39:str)
#   sql.rsColumn(v47,"t","i","int",32,0,v35); 	# 58  (_40:str)
#   sql.rsColumn(v47,"s","j","int",32,0,v45); 	# 59  (_41:str)
#   sql.exportResult(v47); 	# 60  (_42:str)
    v35 := mat.pack(_57,_58);	# 61 MATpack (v35:bat[:void,:int])<-(_57:bat[:void,:int])(_58:bat[:void,:int])
    v45 := mat.pack(_65,_66);	# 62 MATpack (v45:bat[:void,:int])<-(_65:bat[:void,:int])(_66:bat[:void,:int])
    io.print(v35,v45);	# 63 IOtable (_43:int)<-(v35:bat[:void,:int])(v45:bat[:void,:int])
end main;	# 64  
function user.main():void;
#select * from t,s where t.i=s.j; 
    mdb.list();
#   v2:bat[:void,:int]  := sql.bind("sys","t","i",0); 
    v2v0 := bat.new(:void,:int);
    bat.insert(v2v0,nil,0);
    v2v1 := bat.new(:void,:int);
    bat.insert(v2v1,nil,1);
    v2 := mat.new(v2v0,v2v1);
#   v14:bat[:void,:int]  := sql.bind("sys","s","j",0); 
    v14v0 := bat.new(:void,:int);
    bat.insert(v14v0,nil,0);
    v14v1 := bat.new(:void,:int);
    bat.insert(v14v1,nil,1);
    v14 := mat.new(v14v0,v14v1);
#   v8:bat[:void,:oid]  := sql.bindvdbat("sys","t",0); 
    v8 := bat.new(:void,:oid);
    v10 := bat.reverse(v8);
    _45 := algebra.kdifference(v2v0,v10);
    _46 := algebra.kdifference(v2v1,v10);
    v12 := mat.new(_45,_46);
#   v18:bat[:void,:oid]  := sql.bindvdbat("sys","s",0); 
    v18 := bat.new(:void,:oid);
    v20 := bat.reverse(v18);
    _47 := algebra.kdifference(v14v0,v20);
    _48 := algebra.kdifference(v14v1,v20);
    v22 := mat.new(_47,_48);
    _49 := bat.reverse(_47);
    _50 := bat.reverse(_48);
    v24 := mat.new(_49,_50);
    v12 := mat.pack(_45,_46);
    _51 := algebra.join(v12,_49);
    _52 := algebra.join(v12,_50);
    v26 := mat.new(_51,_52);
    _53 := algebra.markT(_51,0@0);
    _54 := algebra.markT(_52,0@0);
    v31 := mat.new(_53,_54);
    _55 := bat.reverse(_53);
    _56 := bat.reverse(_54);
    v33 := mat.new(_55,_56);
    v33 := mat.pack(_55,_56);
    _57 := algebra.join(v33,v2v0);
    _58 := algebra.join(v33,v2v1);
    v35 := mat.new(_57,_58);
    _59 := bat.reverse(_51);
    _60 := bat.reverse(_52);
    v37 := mat.new(_59,_60);
    _61 := algebra.markT(_59,0@0);
    _62 := algebra.markT(_60,0@0);
    v41 := mat.new(_61,_62);
    _63 := bat.reverse(_61);
    _64 := bat.reverse(_62);
    v43 := mat.new(_63,_64);
    v43 := mat.pack(_63,_64);
    _65 := algebra.join(v43,v14v0);
    _66 := algebra.join(v43,v14v1);
    v45 := mat.new(_65,_66);
#   v47 := sql.resultSet(2,3,v35); 
#   sql.rsColumn(v47,"t","i","int",32,0,v35); 
#   sql.rsColumn(v47,"s","j","int",32,0,v45); 
#   sql.exportResult(v47); 
    v35 := mat.pack(_57,_58);
    v45 := mat.pack(_65,_66);
    io.print(v35,v45);
end main;
#-------------------------#
# h	t	t	  # name
# void	int	int	  # type
#-------------------------#

# 22:52:23 >  
# 22:52:23 >  Done.
# 22:52:23 >