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>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 https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list