remote02.mal

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

#An example for the SQL front-end
#The remote table is located

cat:= inspect.getEnvironment();
fs := algebra.find(cat,"mapi_port");
port := calc.int(fs);
io.printf("port %d\n",port);

mid:= mserver.reconnect("s0_0","localhost",port,"monetdb","monetdb","mal");
mserver.rpc(mid,"include sql;sql.init();");
io.print("ready for remote SQL interaction");

b:bat[:void,:int] := mserver.bind(mid,"sys","ptables","schema_id",0);
c:=algebra.select(b,0,6000);
io.print(c);
d:=algebra.select(b,5,6000);
low:= 5+1;
io.print("kk");
e:=algebra.select(d,low,7);
io.print("k2");
i:=aggr.count(e);
io.printf(" count %d\n",i);
io.print(d);
optimizer.remoteQueries();