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

yes, it looks like you fixed it. with the jan2014 edition, the 1.7 million character query no longer returns an error and instead (much more sensibly) overloads my computer and causes it to freeze. we've gotta get these big queries under control. thank you!!!!! On Mon, Feb 17, 2014 at 8:03 AM, Sjoerd Mullender wrote:

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

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