On Fri, Nov 1, 2013 at 7:55 PM, Christian Kleinke wrote:

Hi,

I have problem regarding executing a script with ruby-monetdb-sql. The connection works and simple statements are executed as expected. However, when I try to send a large script, nearly 20000 characters, nothing happens. Neither an exception is thrown nor a SQL error is produced by

So, which command do you use to execute the script?

MonetDB. However, I use "\<" with the same 20000 character script, it works as expected.

Two questions: 1. Is there a char limitation for ruby-monetdb-sql? The above bug, if it is related to your problem, had a limitation on

This reminds me of an older bug that has been fixed by now: http://bugs.monetdb.org/show_bug.cgi?id=2960 What's in the ruby-monetdb.sql that makes it large? The number of INSERT statements? Or maybe there is a single large INSERT statement? Have you tried to inspect the log of the server as well (located under where you have place your dbfarm directory)? the number of tuples inserted as VALUES (), (), ()... in a single INSERT statement. Otherwise, there is no such a limitation (and there shouldn't be), as far as I know.

2. Is there a MonetDB-SQL command to load scripts, something like sql>load("my_script.sql")?

To the best of my knowledge, the answer is no. Babis

Thank you very much in advance. Christian

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list