This is the query i run first -
select user.userid, user.name, plan.duration, plan.hour, plan.minute,
plan.status, plan.date, project.projectname,project.projectid from user,
plan, project where user.userid = plan.userid and project.projectid =
plan.projectid and plan.date >= '2002-8-13' and plan.date<='2002-12-31' and
user.userid in
('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras
ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada
','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra
jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih'
,'saroop') group by plan.userid,plan.date,plan.hour
The abover returns around 13000 records
When i run the below query it only returns 8000 odd records. The only change
is adding of user.designation colum in the query.
select user.userid, user.name, user.designation, plan.duration, plan.hour,
plan.minute, plan.status, plan.date, project.projectname,project.projectid
from user, plan, project where user.userid = plan.userid and
project.projectid = plan.projectid and plan.date >= '2002-8-13' and
plan.date<='2002-12-31' and user.userid in
('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras
ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada
','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra
jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih'
,'saroop') group by plan.userid,plan.date,plan.hour
Thanks,
Karthik.
----- Original Message -----
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: "Karthik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 10:07 AM
Subject: Re: max_allowed_packet size!
> Pada Tue, 27 Aug 2002 10:03:59 +0530
> "Karthik" <[EMAIL PROTECTED]> menulis :
>
> > Hi,
> >
> > Does the mysql max_allowed_packet restrict the amount of data that a
query
> > can fetch ?
> >
> > I am facing a problem wherein my query specifies all the 13000 odd
records
> > if i specify only a few columns. If i run the same join query with lots
of
> > columns, it only fetches 8000 odd records.
>
> could u show us both of the queries ? :D
>
> --
> Let's call it an accidental feature.
> -- Larry Wall
>
> MySQL 3.23.51 : up 67 days, Queries : 357.150 per second (avg).
>
> --
> Dicky Wahyu Purnomo - System Administrator
> PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
> Phone : +62 21 79199577 - HP : +62 8551044244 - Web :
http://www.1rstwap.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
