-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Xclose is something the client sends to the server to close a result set. The server keeps result sets so that the client can ask for results in batches. Once the client is done, it sends the Xclose command to tell the server that it can free the resources. If I remember right, this only works when the server is expecting SQL commands. On 06/10/14 14:21, steffen@stephensmiles.com wrote:
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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQCVAwUBVDKfBj7g04AjvIQpAQI1UAQAw2hMg0Eo6Oi0Tslfm6kMkJh94zqEUYJ8 z11g50LK7pdRwt+JqpkkrnwS5l4XPGfxI+szYnlbpeUo5ppLgOYEJqWaZwqXf5z5 yxLSExS2VQupkXXWO/zqRj1c1LSAUVocKKIVI0BltzqFfRR1/GCY2Bn2zuMYSStu j0i6DlFvul8= =icS9 -----END PGP SIGNATURE-----