Dear all,
I am trying to write and execute MAL queries. The overall goal is to
translate Cypher to MAL and to use Cypher as an input language for
MonetDB. I am using the "explain" statement to get some example MAL
queries. This is an output of explain (without the optimizer stuff at
the end):
function user.s4_1():void;
X_0:void := querylog.define("explain select source, target from
graph where source = \\'A\\';","default_pipe",14:int);
X_30 := bat.new(nil:str);
X_36 := bat.new(nil:int);
X_34 := bat.new(nil:int);
X_33 := bat.new(nil:str);
X_32 := bat.new(nil:str);
X_3 := sql.mvc();
X_7:bat[:str] := sql.bind(X_3,"sys","graph","source",0:int);
C_4:bat[:oid] := sql.tid(X_3,"sys","graph");
C_18 := algebra.thetasubselect(X_7,C_4,"A","==");
X_21:bat[:str] := sql.bind(X_3,"sys","graph","target",0:int);
X_28 := algebra.projection(C_18,X_21);
X_20 := algebra.projection(C_18,X_7);
X_37 := bat.append(X_30,"sys.graph");
X_39 := bat.append(X_32,"source");
X_40 := bat.append(X_33,"varchar");
X_42 := bat.append(X_34,31:int);
X_44 := bat.append(X_36,0:int);
X_46 := bat.append(X_37,"sys.graph");
X_47 := bat.append(X_39,"target");
X_48 := bat.append(X_40,"varchar");
X_49 := bat.append(X_42,31:int);
X_50 := bat.append(X_44,0:int);
sql.resultSet(X_46,X_47,X_48,X_49,X_50,X_20,X_28);
end user.s4_1;
But when I try to execute this query I get errors like that:
ERROR = !TypeException:user.main[8]:'sql.tid' undefined in:
C_4:bat[:oid] := sql.tid("sys":str,"sys":str,"graph":str);
I don't know why the "X_3" is replaced by "sys". I see changes like that
in the queries regularly.
Does someone know what is wrong or missing in this query?
Thanks a lot in advance!
Best regards,
Dennis
