Re: [MonetDB-users] sql query size

27 Apr 2010


      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,
1) Table schema
sql>\d zip_codes
CREATE TABLE "sys"."zip_codes" (
       "zip_code" varchar(5)
);
sql>
2) 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

dariuszs

tags

participants (1)