Thanks for your fast response Stefan! Unfortunately it didn't change the output. I tried sql.start(); as well but this causes mclient to get killed when executing the query. (ERROR = !unrecognized X command: _30 := bat.new(nil:str);....) Every additional idea is appreciated. Best regards, Dennis On 03.09.2017 16:50, Stefan Manegold wrote:
try sql.start2(); --- as undocumented as it is cryptic ... ... just a guess, not sure whether it helps/works ...
Best, Stefan
----- On Sep 3, 2017, at 4:22 PM, Dennis Fassl dennis.fassl@uni-konstanz.de wrote:
Dear all,
I got the hint to use "sql.init();" before executing MAL queries with SQL operations. I have added the statement to my query but I get the same error. Is there anything else I could try to solve this problem?
Thanks and regards, Dennis
On 02.09.2017 18:30, Dennis Fassl wrote:
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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list