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 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? 2. Is there a MonetDB-SQL command to load scripts, something like sql>load("my_script.sql")?
Thank you very much in advance. Christian
On Fri, Nov 1, 2013 at 7:55 PM, Christian Kleinke christian.kleinke@gmail.com 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.
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)?
Two questions:
- Is there a char limitation for ruby-monetdb-sql?
The above bug, if it is related to your problem, had a limitation on 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.
- 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
participants (2)
-
Charalampos Nikolaou
-
Christian Kleinke