mat02.stable.out

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

    _95 := algebra.join(v49,_85);	# 65 ALGjoin (_95:bat[:void,:int])<-(v49:bat[:void,:oid])(_85:bat[:void,:int])
    _96 := algebra.join(v49,_86);	# 66 ALGjoin (_96:bat[:void,:int])<-(v49:bat[:void,:oid])(_86:bat[:void,:int])
    _97 := algebra.join(v49,_87);	# 67 ALGjoin (_97:bat[:void,:int])<-(v49:bat[:void,:oid])(_87:bat[:void,:int])
    v51 := mat.new(_95,_96,_97);	# 68 MATnew (v51:bat[:void,:int])<-(_95:bat[:void,:int])(_96:bat[:void,:int])(_97:bat[:void,:int])
    _98 := algebra.markT(_95,0@0);	# 69 ALGtmark (_98:bat[:oid,:void])<-(_95:bat[:void,:int])(_52:oid)
    _99 := algebra.markT(_96,0@0);	# 70 ALGtmark (_99:bat[:oid,:void])<-(_96:bat[:void,:int])(_52:oid)
    _100 := algebra.markT(_97,0@0);	# 71 ALGtmark (_100:bat[:oid,:void])<-(_97:bat[:void,:int])(_52:oid)
    v56 := mat.new(_98,_99,_100);	# 72 MATnew (v56:bat[:oid,:void])<-(_98:bat[:oid,:void])(_99:bat[:oid,:void])(_100:bat[:oid,:void])
    _101 := bat.reverse(_98);	# 73 BKCreverse (_101:bat[:void,:oid])<-(_98:bat[:oid,:void])
    _102 := bat.reverse(_99);	# 74 BKCreverse (_102:bat[:void,:oid])<-(_99:bat[:oid,:void])
    _103 := bat.reverse(_100);	# 75 BKCreverse (_103:bat[:void,:oid])<-(_100:bat[:oid,:void])
    v58 := mat.new(_101,_102,_103);	# 76 MATnew (v58:bat[:void,:oid])<-(_101:bat[:void,:oid])(_102:bat[:void,:oid])(_103:bat[:void,:oid])
    _104 := algebra.join(v19,v60a);	# 77 ALGjoin (_104:bat[:void,:str])<-(v19:bat[:void,:oid])(v60a:bat[:void,:str])
    _105 := algebra.join(v19,v60b);	# 78 ALGjoin (_105:bat[:void,:str])<-(v19:bat[:void,:oid])(v60b:bat[:void,:str])
    v66 := mat.new(_104,_105);	# 79 MATnew (v66:bat[:void,:str])<-(_104:bat[:void,:str])(_105:bat[:void,:str])
    v71 := algebra.join(v36,v68);	# 80 ALGjoin (v71:bat[:void,:str])<-(v36:bat[:void,:oid])(v68:bat[:void,:str])
    _106 := bat.setAccess(_104,"w");	# 81 BKCsetAccess (_106:bat[:void,:str])<-(_104:bat[:void,:str])(_56:str)
    _107 := bat.setAccess(_105,"w");	# 82 BKCsetAccess (_107:bat[:void,:str])<-(_105:bat[:void,:str])(_56:str)
    v73 := mat.new(_106,_107);	# 83 MATnew (v73:bat[:void,:str])<-(_106:bat[:void,:str])(_107:bat[:void,:str])
    bat.append(_107,v71);	# 84 BKCbat_append_void_bat_wrap (_108:void)<-(_107:bat[:void,:str])(v71:bat[:void,:str])
    _109 := algebra.join(v49,_106);	# 85 ALGjoin (_109:bat[:void,:str])<-(v49:bat[:void,:oid])(_106:bat[:void,:str])
    _110 := algebra.join(v49,_107);	# 86 ALGjoin (_110:bat[:void,:str])<-(v49:bat[:void,:oid])(_107:bat[:void,:str])
    v77 := mat.new(_109,_110);	# 87 MATnew (v77:bat[:void,:str])<-(_109:bat[:void,:str])(_110:bat[:void,:str])
    v58 := mat.pack(_101,_102,_103);	# 88 MATpack (v58:bat[:void,:oid])<-(_101:bat[:void,:oid])(_102:bat[:void,:oid])(_103:bat[:void,:oid])
    _111 := algebra.join(v58,_109);	# 89 ALGjoin (_111:bat[:void,:str])<-(v58:bat[:void,:oid])(_109:bat[:void,:str])
    _112 := algebra.join(v58,_110);	# 90 ALGjoin (_112:bat[:void,:str])<-(v58:bat[:void,:oid])(_110:bat[:void,:str])
    v79 := mat.new(_111,_112);	# 91 MATnew (v79:bat[:void,:str])<-(_111:bat[:void,:str])(_112:bat[:void,:str])
#   v81 := sql.resultSet(1,3,v79); 	# 92  (_69:str)
#   sql.rsColumn(v81,"tables","name","varchar",1024,0,v79); 	# 93  (_70:str)
    v79 := mat.pack(_111,_112);	# 94 MATpack (v79:bat[:void,:str])<-(_111:bat[:void,:str])(_112:bat[:void,:str])
    io.print(v79);	# 95 IOprint_val (_71:int)<-(v79:bat[:void,:str])
end main;	# 96  
function user.main():void;
    mdb.list();
# simulate the SQL behavior 
#   v2:bat[:void,:int]  := sql.bind("sys","ptables","id",0); 
#   v60:bat[:void,:str]  := sql.bind("sys","ptables","name",0); 
    v2v0 := bat.new(:void,:int);
    bat.insert(v2v0,0@0,0);
    v2v1 := bat.new(:void,:int);
    bat.insert(v2v1,1@0,1);
    v2v2 := bat.new(:void,:int);
    bat.setSequenceBase(v2v2,2@0);
    bat.insert(v2v2,nil,2);
    v2 := mat.new(v2v0,v2v1,v2v2);
    io.print(v2v2);
    v60a := bat.new(:void,:str);
    bat.insert(v60a,0@0,"first");
    v60b := bat.new(:void,:str);
    bat.insert(v60b,1@0,"second");
    v60 := mat.new(v60a,v60b);
#   v23:bat[:void,:int]  := sql.bindvdbat("sys","ptables",0); 
    v23 := bat.new(:void,:int);
#   v68:bat[:void,:str]  := sql.bind("sys","ptables","name",0); 
    v68 := bat.new(:void,:str);
#   v8:bat[:void,:oid]  := sql.bindvdbat("sys","ptables",0); 
    v8 := bat.new(:void,:oid);
    v10 := bat.reverse(v8);
    _73 := algebra.kdifference(v2v0,v10);
    _74 := algebra.kdifference(v2v1,v10);
    _75 := algebra.kdifference(v2v2,v10);
    v12 := mat.new(_73,_74,_75);
    _76 := algebra.markT(_73,0@0);
    _77 := algebra.markT(_74,0@0);
    _78 := algebra.markT(_75,0@0);
    v17 := mat.new(_76,_77,_78);
    _79 := bat.reverse(_76);
    _80 := bat.reverse(_77);
    _81 := bat.reverse(_78);
    v19 := mat.new(_79,_80,_81);
    v19 := mat.pack(_79,_80,_81);
    _82 := algebra.join(v19,v2v0);
    _83 := algebra.join(v19,v2v1);
    _84 := algebra.join(v19,v2v2);
    v21 := mat.new(_82,_83,_84);
#   v26:bat[:void,:oid]  := sql.bindvdbat("sys","ttables",0); 
    v26 := bat.new(:void,:oid);
    v28 := bat.reverse(v26);
    v30 := algebra.kdifference(v23,v28);
    v34 := algebra.markT(v30,0@0);
    v36 := bat.reverse(v34);
    v38 := algebra.join(v36,v23);
    _85 := bat.setAccess(_82,"w");
    _86 := bat.setAccess(_83,"w");
    _87 := bat.setAccess(_84,"w");
    v40 := mat.new(_85,_86,_87);
    bat.append(_87,v38);
    _89 := algebra.markT(_85,0@0);
    _90 := algebra.markT(_86,0@0);
    _91 := algebra.markT(_87,0@0);
    v47 := mat.new(_89,_90,_91);
    _92 := bat.reverse(_89);
    _93 := bat.reverse(_90);
    _94 := bat.reverse(_91);
    v49 := mat.new(_92,_93,_94);
    v49 := mat.pack(_92,_93,_94);
    _95 := algebra.join(v49,_85);
    _96 := algebra.join(v49,_86);
    _97 := algebra.join(v49,_87);
    v51 := mat.new(_95,_96,_97);
    _98 := algebra.markT(_95,0@0);
    _99 := algebra.markT(_96,0@0);
    _100 := algebra.markT(_97,0@0);
    v56 := mat.new(_98,_99,_100);
    _101 := bat.reverse(_98);
    _102 := bat.reverse(_99);
    _103 := bat.reverse(_100);
    v58 := mat.new(_101,_102,_103);
    _104 := algebra.join(v19,v60a);
    _105 := algebra.join(v19,v60b);
    v66 := mat.new(_104,_105);
    v71 := algebra.join(v36,v68);
    _106 := bat.setAccess(_104,"w");
    _107 := bat.setAccess(_105,"w");
    v73 := mat.new(_106,_107);
    bat.append(_107,v71);
    _109 := algebra.join(v49,_106);
    _110 := algebra.join(v49,_107);
    v77 := mat.new(_109,_110);
    v58 := mat.pack(_101,_102,_103);
    _111 := algebra.join(v58,_109);
    _112 := algebra.join(v58,_110);
    v79 := mat.new(_111,_112);
#   v81 := sql.resultSet(1,3,v79); 
#   sql.rsColumn(v81,"tables","name","varchar",1024,0,v79); 
    v79 := mat.pack(_111,_112);
    io.print(v79);
end main;
#-----------------#
# h	t	  # name
# void	int	  # type
#-----------------#
[ 2@0,	  2	  ]

# 23:56:30 >  
# 23:56:30 >  Done.
# 23:56:30 >