mat03.mal

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

#select * from t,s where t.i=s.j;

mdb.list();
#   v2:bat[:oid,:int]  := sql.bind("sys","t","i",0);
	v2v0:= bat.new(:oid,:int);
    bat.insert(v2v0,nil,0);
    v2v1:= bat.new(:oid,:int);
    bat.insert(v2v1,nil,1);
	v2:= mat.new(v2v0,v2v1);

#   v14:bat[:oid,:int]  := sql.bind("sys","s","j",0);
    v14v0:= bat.new(:oid,:int);
    bat.insert(v14v0,nil,0);
    v14v1:= bat.new(:oid,:int);
    bat.insert(v14v1,nil,1);
	v14:= mat.new(v14v0,v14v1);


#   v8:bat[:oid,:oid]  := sql.bindvdbat("sys","t",0);
	v8:= bat.new(:oid,:oid);
    v10 := bat.reverse(v8);
    v12 := algebra.kdifference(v2,v10);

#   v18:bat[:oid,:oid]  := sql.bindvdbat("sys","s",0);
	v18:= bat.new(:oid,: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();