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 <Stefan.Manegold@cwi.nl

> <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


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