mat04.stable.out

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

stdout of test 'mat04` 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  mat04.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 i, sum(j) from t group by i having i>4;
#mdb.list();
##   v3:bat[:void,:int]  := sql.bind("sys","t","i",0);
#    v3v0:= bat.new(:void,:int);
#    bat.insert(v3v0,nil,0);
#    v3v1:= bat.new(:void,:int);
#    bat.insert(v3v1,nil,1);
#    v3:= mat.new(v3v0,v3v1);
#
##   v47:bat[:void,:int]  := sql.bind("sys","t","j",0);
#    v47v0:= bat.new(:void,:int);
#    bat.insert(v47v0,nil,0);
#    v47v1:= bat.new(:void,:int);
#    bat.insert(v47v1,nil,1);
#    v47:= mat.new(v47v0,v47v1);
#
##   v9:bat[:void,:oid]  := sql.bindvdbat("sys","t",0);
#	v9 := bat.new(:void,:oid);
#    v11 := bat.reverse(v9);
#    v13 := algebra.kdifference(v3,v11);
#    v18 := algebra.markT(v13,0@0);
#    v20 := bat.reverse(v18);
#    v22 := algebra.join(v20,v3);
#    (ext26,grp24):= group.new(v22);
#    v28 := bat.mirror(ext26);
#    v30 := algebra.join(v20,v3);
#    v32 := algebra.join(v28,v30);
#    v35 := calc.int(3);
#    v37 := algebra.uselect(v32,v35,nil:int,false,false);
#    v41 := algebra.semijoin(v28,v37);
#    v43 := algebra.join(v20,v3);
#    v45 := algebra.join(v41,v43);
#    v53 := algebra.join(v20,v47);
#    v57 := algebra.select(v53,nil:int,nil:int,false,false);
#    v59 := bat.reverse(grp24);
#    v61 := algebra.semijoin(v59,v37);
#    v63 := bat.reverse(v61);
#    v65 := aggr.sum(v57,v63,v41);
##   v67 := sql.resultSet(2,3,v45);
##   sql.rsColumn(v67,"t","i","int",32,0,v45);
##   sql.rsColumn(v67,"t","sumvj","bigint",64,0,v65);
##   sql.exportResult(v67);
#	io.print(v45,v65);
#
#optimizer.multitable();
#
function user.main():void;	# 0  (main:void)
# select i, sum(j) from t group by i having i>4; 	# 1  (_1:str)
    mdb.list();	# 2 MDBlist (_2:void)
#   v3:bat[:void,:int]  := sql.bind("sys","t","i",0); 	# 3  (_3:str)
    v3v0 := bat.new(:void,:int);	# 4 CMDBATnew (v3v0:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v3v0,nil,0);	# 5 BKCinsert_bun (_7:void)<-(v3v0:bat[:void,:int])(_8:void)(_9:int)
    v3v1 := bat.new(:void,:int);	# 6 CMDBATnew (v3v1:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v3v1,nil,1);	# 7 BKCinsert_bun (_11:void)<-(v3v1:bat[:void,:int])(_8:void)(_12:int)
    v3 := mat.new(v3v0,v3v1);	# 8 MATnew (v3:bat[:void,:int])<-(v3v0:bat[:void,:int])(v3v1:bat[:void,:int])
#   v47:bat[:void,:int]  := sql.bind("sys","t","j",0); 	# 9  (_14:str)
    v47v0 := bat.new(:void,:int);	# 10 CMDBATnew (v47v0:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v47v0,nil,0);	# 11 BKCinsert_bun (_16:void)<-(v47v0:bat[:void,:int])(_8:void)(_9:int)
    v47v1 := bat.new(:void,:int);	# 12 CMDBATnew (v47v1:bat[:void,:int])<-(_5:void)(_6:int)
    bat.insert(v47v1,nil,1);	# 13 BKCinsert_bun (_18:void)<-(v47v1:bat[:void,:int])(_8:void)(_12:int)
    v47 := mat.new(v47v0,v47v1);	# 14 MATnew (v47:bat[:void,:int])<-(v47v0:bat[:void,:int])(v47v1:bat[:void,:int])
#   v9:bat[:void,:oid]  := sql.bindvdbat("sys","t",0); 	# 15  (_20:str)
    v9 := bat.new(:void,:oid);	# 16 CMDBATnew (v9:bat[:void,:oid])<-(_5:void)(_22:oid)
    v11 := bat.reverse(v9);	# 17 BKCreverse (v11:bat[:oid,:void])<-(v9:bat[:void,:oid])
    _54 := algebra.kdifference(v3v0,v11);	# 18 ALGkdiff (_54:bat[:oid,:int])<-(v3v0:bat[:void,:int])(v11:bat[:oid,:void])
    _55 := algebra.kdifference(v3v1,v11);	# 19 ALGkdiff (_55:bat[:oid,:int])<-(v3v1:bat[:void,:int])(v11:bat[:oid,:void])
    v13 := mat.new(_54,_55);	# 20 MATnew (v13:bat[:oid,:int])<-(_54:bat[:oid,:int])(_55:bat[:oid,:int])
    _56 := algebra.markT(_54,0@0);	# 21 ALGtmark (_56:bat[:oid,:void])<-(_54:bat[:oid,:int])(_26:oid)
    _57 := algebra.markT(_55,0@0);	# 22 ALGtmark (_57:bat[:oid,:void])<-(_55:bat[:oid,:int])(_26:oid)
    v18 := mat.new(_56,_57);	# 23 MATnew (v18:bat[:oid,:void])<-(_56:bat[:oid,:void])(_57:bat[:oid,:void])
    _58 := bat.reverse(_56);	# 24 BKCreverse (_58:bat[:void,:oid])<-(_56:bat[:oid,:void])
    _59 := bat.reverse(_57);	# 25 BKCreverse (_59:bat[:void,:oid])<-(_57:bat[:oid,:void])
    v20 := mat.new(_58,_59);	# 26 MATnew (v20:bat[:void,:oid])<-(_58:bat[:void,:oid])(_59:bat[:void,:oid])
    v20 := mat.pack(_58,_59);	# 27 MATpack (v20:bat[:void,:oid])<-(_58:bat[:void,:oid])(_59:bat[:void,:oid])
    _60 := algebra.join(v20,v3v0);	# 28 ALGjoin (_60:bat[:void,:int])<-(v20:bat[:void,:oid])(v3v0:bat[:void,:int])
    _61 := algebra.join(v20,v3v1);	# 29 ALGjoin (_61:bat[:void,:int])<-(v20:bat[:void,:oid])(v3v1:bat[:void,:int])
    v22 := mat.new(_60,_61);	# 30 MATnew (v22:bat[:void,:int])<-(_60:bat[:void,:int])(_61:bat[:void,:int])
    v22 := mat.pack(_60,_61);	# 31 MATpack (v22:bat[:void,:int])<-(_60:bat[:void,:int])(_61:bat[:void,:int])
    (ext26,grp24):= group.new(v22);	# 32 GRPgroup (ext26:bat[:void,:int])(grp24:bat[:void,:oid])<-(v22:bat[:void,:int])
    v28 := bat.mirror(ext26);	# 33 BKCmirror (v28:bat[:void,:void])<-(ext26:bat[:void,:int])
    _62 := algebra.join(v20,v3v0);	# 34 ALGjoin (_62:bat[:void,:int])<-(v20:bat[:void,:oid])(v3v0:bat[:void,:int])
    _63 := algebra.join(v20,v3v1);	# 35 ALGjoin (_63:bat[:void,:int])<-(v20:bat[:void,:oid])(v3v1:bat[:void,:int])
    v30 := mat.new(_62,_63);	# 36 MATnew (v30:bat[:void,:int])<-(_62:bat[:void,:int])(_63:bat[:void,:int])
    _64 := algebra.join(v28,_62);	# 37 ALGjoin (_64:bat[:void,:int])<-(v28:bat[:void,:void])(_62:bat[:void,:int])
    _65 := algebra.join(v28,_63);	# 38 ALGjoin (_65:bat[:void,:int])<-(v28:bat[:void,:void])(_63:bat[:void,:int])
    v32 := mat.new(_64,_65);	# 39 MATnew (v32:bat[:void,:int])<-(_64:bat[:void,:int])(_65:bat[:void,:int])
    v35 := calc.int(3);	# 40 CALCint2int (v35:int)<-(_35:int)
    _66 := algebra.uselect(_64,v35,nil:int,false,false);	# 41 ALGuselectInclusive (_66:bat[:void,:int])<-(_64:bat[:void,:int])(v35:int)(_37:int)(_38:bit)(_38:bit)
    _67 := algebra.uselect(_65,v35,nil:int,false,false);	# 42 ALGuselectInclusive (_67:bat[:void,:int])<-(_65:bat[:void,:int])(v35:int)(_37:int)(_38:bit)(_38:bit)
    v37 := mat.new(_66,_67);	# 43 MATnew (v37:bat[:void,:int])<-(_66:bat[:void,:int])(_67:bat[:void,:int])
    v37 := mat.pack(_66,_67);	# 44 MATpack (v37:bat[:void,:int])<-(_66:bat[:void,:int])(_67:bat[:void,:int])
    v41 := algebra.semijoin(v28,v37);	# 45 ALGsemijoin (v41:bat[:void,:void])<-(v28:bat[:void,:void])(v37:bat[:void,:int])
    _68 := algebra.join(v20,v3v0);	# 46 ALGjoin (_68:bat[:void,:int])<-(v20:bat[:void,:oid])(v3v0:bat[:void,:int])
    _69 := algebra.join(v20,v3v1);	# 47 ALGjoin (_69:bat[:void,:int])<-(v20:bat[:void,:oid])(v3v1:bat[:void,:int])
    v43 := mat.new(_68,_69);	# 48 MATnew (v43:bat[:void,:int])<-(_68:bat[:void,:int])(_69:bat[:void,:int])
    _70 := algebra.join(v41,_68);	# 49 ALGjoin (_70:bat[:void,:int])<-(v41:bat[:void,:void])(_68:bat[:void,:int])
    _71 := algebra.join(v41,_69);	# 50 ALGjoin (_71:bat[:void,:int])<-(v41:bat[:void,:void])(_69:bat[:void,:int])
    v45 := mat.new(_70,_71);	# 51 MATnew (v45:bat[:void,:int])<-(_70:bat[:void,:int])(_71:bat[:void,:int])
    _72 := algebra.join(v20,v47v0);	# 52 ALGjoin (_72:bat[:void,:int])<-(v20:bat[:void,:oid])(v47v0:bat[:void,:int])
    _73 := algebra.join(v20,v47v1);	# 53 ALGjoin (_73:bat[:void,:int])<-(v20:bat[:void,:oid])(v47v1:bat[:void,:int])
    v53 := mat.new(_72,_73);	# 54 MATnew (v53:bat[:void,:int])<-(_72:bat[:void,:int])(_73:bat[:void,:int])
    _74 := algebra.select(_72,nil:int,nil:int,false,false);	# 55 ALGselectInclusive (_74:bat[:void,:int])<-(_72:bat[:void,:int])(_37:int)(_37:int)(_38:bit)(_38:bit)
    _75 := algebra.select(_73,nil:int,nil:int,false,false);	# 56 ALGselectInclusive (_75:bat[:void,:int])<-(_73:bat[:void,:int])(_37:int)(_37:int)(_38:bit)(_38:bit)
    v57 := mat.new(_74,_75);	# 57 MATnew (v57:bat[:void,:int])<-(_74:bat[:void,:int])(_75:bat[:void,:int])
    v59 := bat.reverse(grp24);	# 58 BKCreverse (v59:bat[:oid,:void])<-(grp24:bat[:void,:oid])
    v61 := algebra.semijoin(v59,v37);	# 59 ALGsemijoin (v61:bat[:oid,:void])<-(v59:bat[:oid,:void])(v37:bat[:void,:int])
    v63 := bat.reverse(v61);	# 60 BKCreverse (v63:bat[:void,:oid])<-(v61:bat[:oid,:void])
    v57 := mat.pack(_74,_75);	# 61 MATpack (v57:bat[:void,:int])<-(_74:bat[:void,:int])(_75:bat[:void,:int])
    v65 := aggr.sum(v57,v63,v41);	# 62 AX3aggrX3_sum3_int_lng (v65:bat[:void,:lng])<-(v57:bat[:void,:int])(v63:bat[:void,:oid])(v41:bat[:void,:void])
#   v67 := sql.resultSet(2,3,v45); 	# 63  (_48:str)
#   sql.rsColumn(v67,"t","i","int",32,0,v45); 	# 64  (_49:str)
#   sql.rsColumn(v67,"t","sumvj","bigint",64,0,v65); 	# 65  (_50:str)
#   sql.exportResult(v67); 	# 66  (_51:str)
    v45 := mat.pack(_70,_71);	# 67 MATpack (v45:bat[:void,:int])<-(_70:bat[:void,:int])(_71:bat[:void,:int])
    io.print(v45,v65);	# 68 IOtable (_52:int)<-(v45:bat[:void,:int])(v65:bat[:void,:lng])
end main;	# 69  
function user.main():void;
# select i, sum(j) from t group by i having i>4; 
    mdb.list();
#   v3:bat[:void,:int]  := sql.bind("sys","t","i",0); 
    v3v0 := bat.new(:void,:int);
    bat.insert(v3v0,nil,0);
    v3v1 := bat.new(:void,:int);
    bat.insert(v3v1,nil,1);
    v3 := mat.new(v3v0,v3v1);
#   v47:bat[:void,:int]  := sql.bind("sys","t","j",0); 
    v47v0 := bat.new(:void,:int);
    bat.insert(v47v0,nil,0);
    v47v1 := bat.new(:void,:int);
    bat.insert(v47v1,nil,1);
    v47 := mat.new(v47v0,v47v1);
#   v9:bat[:void,:oid]  := sql.bindvdbat("sys","t",0); 
    v9 := bat.new(:void,:oid);
    v11 := bat.reverse(v9);
    _54 := algebra.kdifference(v3v0,v11);
    _55 := algebra.kdifference(v3v1,v11);
    v13 := mat.new(_54,_55);
    _56 := algebra.markT(_54,0@0);
    _57 := algebra.markT(_55,0@0);
    v18 := mat.new(_56,_57);
    _58 := bat.reverse(_56);
    _59 := bat.reverse(_57);
    v20 := mat.new(_58,_59);
    v20 := mat.pack(_58,_59);
    _60 := algebra.join(v20,v3v0);
    _61 := algebra.join(v20,v3v1);
    v22 := mat.new(_60,_61);
    v22 := mat.pack(_60,_61);
    (ext26,grp24):= group.new(v22);
    v28 := bat.mirror(ext26);
    _62 := algebra.join(v20,v3v0);
    _63 := algebra.join(v20,v3v1);
    v30 := mat.new(_62,_63);
    _64 := algebra.join(v28,_62);
    _65 := algebra.join(v28,_63);
    v32 := mat.new(_64,_65);
    v35 := calc.int(3);
    _66 := algebra.uselect(_64,v35,nil:int,false,false);
    _67 := algebra.uselect(_65,v35,nil:int,false,false);
    v37 := mat.new(_66,_67);
    v37 := mat.pack(_66,_67);
    v41 := algebra.semijoin(v28,v37);
    _68 := algebra.join(v20,v3v0);
    _69 := algebra.join(v20,v3v1);
    v43 := mat.new(_68,_69);
    _70 := algebra.join(v41,_68);
    _71 := algebra.join(v41,_69);
    v45 := mat.new(_70,_71);
    _72 := algebra.join(v20,v47v0);
    _73 := algebra.join(v20,v47v1);
    v53 := mat.new(_72,_73);
    _74 := algebra.select(_72,nil:int,nil:int,false,false);
    _75 := algebra.select(_73,nil:int,nil:int,false,false);
    v57 := mat.new(_74,_75);
    v59 := bat.reverse(grp24);
    v61 := algebra.semijoin(v59,v37);
    v63 := bat.reverse(v61);
    v57 := mat.pack(_74,_75);
    v65 := aggr.sum(v57,v63,v41);
#   v67 := sql.resultSet(2,3,v45); 
#   sql.rsColumn(v67,"t","i","int",32,0,v45); 
#   sql.rsColumn(v67,"t","sumvj","bigint",64,0,v65); 
#   sql.exportResult(v67); 
    v45 := mat.pack(_70,_71);
    io.print(v45,v65);
end main;
#-------------------------#
# h	t	t	  # name
# void	int	lng	  # type
#-------------------------#

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