Hi, This still does not work in the latest version - Feb2010+SP2 - on Windows XP 32bit, Windows Server 2003 64bit,Ubuntu 9.10 64 bit,Fedora 12 64bit. Dariusz.
Martin Kersten wrote:
Thanks for the example, we will look into it.
dariuszs wrote:
Martin,
- Table schema
sql>\d zip_codes CREATE TABLE "sys"."zip_codes" ( "zip_code" varchar(5) ); sql>
- From mclient
sql>< /tmp/test.sql MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = select count(*) from zip_codes WHERE zip_code IN ('00501','00544','01001','01002','01003','01004','01005','01007','01008','01009','01010','01011','01012','01013','01014','01020','01021','01022','01026','01027','01028','01029','01030','01031','01032','01033','01034','01035','01036','01037','01038','01039','01040','01041','01050','01053','01054','01056','01057','01059','01060','01061','01062','01063','01066','01068','01069','01070','01071','01072','01073','01074','01075','01077','01079','01080','01081','01082
ERROR = Connection terminated sql> 3) From shell root@monetdb:/tmp# mclient -lsql < test.sql MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = select count(*) from zip_codes WHERE zip_code IN ('00501','00544','01001','01002','01003','01004','01005','01007','01008','01009','01010','01011','01012','01013','01014','01020','01021','01022','01026','01027','01028','01029','01030','01031','01032','01033','01034','01035','01036','01037','01038','01039','01040','01041','01050','01053','01054','01056','01057','01059','01060','01061','01062','01063','01066','01068','01069','01070','01071','01072','01073','01074','01075','01077','01079','01080','01081','01082
ERROR = Connection terminated root@monetdb:/tmp# 4) SQL
Dariusz
Martin Kersten wrote:
Hi Dariusz,
A bug or a system limitation. It should at least never crash.
How did you submit the query? To mclient? or mserver? or through a mapi libary call?
I would have to look into the SQL parser. The underlying stream would expand upon need. It is, however, an interesting query. What kind of application generates it?
regards, Martin
ps. we should keep a profile of users to avoid asking platform details.
dariuszs wrote:
Hi Martin, Then I guess it's a bug. Please try running a query over 44k, you'll get 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)
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