Hello,
i'm getting the following error when running my generated MAL code:
MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = sql.init(); mvc := sql.mvc(); (r_4:bat[:oid,:int]) := sql.bind(mvc,"sys","customer","c_custkey",0); f_1 := sql.resultSet(1,1,r_4); sql.rsColumn(f_1, "table1", "pos", "int",32,0,r_4); out1 := io.stdout(); sql.exportResult(out1, f_1);
ERROR = !SyntaxException:parseError:Xclose 0 !SyntaxException:parseError: ^';' expected
This happens after 100 tupels already got printed.
To print the results that my generated MAL code computed I use the sql.resultSet function.
I am always giving a qtype of 1 since I have not found documentation about what that is and my experiments with EXPLAIN have shown that 1 seems to be what is always used.
I then use sql.rsColumn(f_1, "table1", "pos", "varchar",0,0,r_4);. For digits and scale I always use 0.
For digits I have tried higher numbers and have found that it doesn't make any difference and I have not found documentation about what scale is and in all the experiments I did using EXPLAIN it was always set to 0.
Setting digits to a higher number will not solve the problem :(.
Can you please help me with this problem? How am I supposed to print out the results?
I am using: 'MonetDB 5 server v11.17.13 "Jan2014-SP1" (64-bit, 64-bit oids)' 'mclient, the MonetDB interactive terminal (Jan2014-SP1)'
Best regards
steffen