On Sat, Mar 06, 2010 at 08:02:05AM -0500, dariuszs wrote:
Hi Martin, Then I guess it's a bug. Please try running a query over 44k, you'll get
most probably yes --- at least there should be a proper error message in case the query is considered "too large". Could you please file a bug report via our bug tracker on SF? Please include detailed instaructions how to reporduce the problem; if possible, consider providing your full query, table schema and data.
MAPI = monetdb@localhost:50000 ACTION= read_line. QUERY = select count(*) from plk100 WHERE c15 IN ('00501','00544','01001','01002','01003'.......... ERROR = Connection terminated Any query under 44k runs fine, so I'm assuming the limit is 64k (query + other packet data)
Well, of course further analysis is required to locate the actual cause of the problem/bug ... Does the server survive, or does it crash? In either case, are there any message on the server console (or in the log(s) in case you're using merovingian)? Thanks! Stefan
Thanks. Dariusz.
Martin Kersten wrote:
dariuszs wrote:
Hi, Is there any limit on how big the sql query can be (in bytes)? Thanks. Dariusz.
As far as i am aware no.
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |