Re: what is the character limit for monetdb queries?

17 Feb 2014


      I think you're hitting a bug that I fixed after the Feb2013-SP6 release.
 What version are you running?  Can you try the Jan2014 candidate
release (see http://dev.monetdb.org/downloads/testing/)?

On 2014-02-17 13:46, Anthony Damico wrote:
...
hi stefan, my guess is the server's just truncating the query at
wherever the character limit is, then getting whatever error you'd
expect from the incomplete query..  i agree that sending a 1.7 million
character query is pretty extreme, but i believe very long strings are
unavoidable in dr. lumley's R sqlsurvey code
http://sqlsurvey.r-forge.r-project.org/ even if he takes steps to
minimize what he can.  i don't mean to create a bunch of work for you, i
was really just curious if you knew of any hard ceiling.  :)  thank you!
Error in .local(conn, statement, ...) :
  Unable to execute statement 'select avg(_s__api00_AcaciaElementa),
avg(_s__api00_AdamsElementar), avg(_s__api00_AeolianElement), ...'.
Server says 'syntax error, unexpected $end, expecting ')' in: "select
avg(_s__api00_acaciaelementa), avg(_s__api00_adamselementar),
avg(_s__api00_aeolianelement),
On Mon, Feb 17, 2014 at 6:57 AM, Stefan Manegold mailto:Stefan.Manegold@cwi.nl> wrote:
Hi,
trying to suppress my worries about why one would need a single SQL
    query consisting of more than 1.7 million characters
    (you might want to consider using views, prepared queries, or alike
    ...) (;-)),
what is the exact error you get when you reach/exceed the limit?
Thanks!
    Stefan
----- Original Message -----
    > i'm definitely hitting one around 1.7 million characters, but i'm
    wondering
    > how much lower the actual limit is?
    >
    > thanks!
    >
    > _______________________________________________
    > users-list mailing list
    > users-list@monetdb.org mailto:users-list@monetdb.org
    > https://www.monetdb.org/mailman/listinfo/users-list
    >
--
    | Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
    | www.CWI.nl/~manegold/ http://www.CWI.nl/~manegold/  | Science
    Park 123 (L321) |
    | +31 (0)20 592-4212 tel:%2B31%20%280%2920%20592-4212     | 1098
    XG Amsterdam  (NL) |
_______________________________________________
    users-list mailing list
    users-list@monetdb.org mailto: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
-- 
Sjoerd Mullender