Hello.
>Looks to me like a bug in the cursor handling but I'd like someone >to confirm this. See: http://bugs.mysql.com/bug.php?id=13771 Rob Hall wrote: > On Wednesday 05 Oct 2005 15:29, Jeff Smelser wrote: > >>On Wednesday 05 October 2005 04:05 am, Rob Hall wrote: >> >>>Having a few problems using cursors in 5.0.13 and I don't know wether >>>it's an 'operator error' :) >>> >>>Should this work? >> >>when loading a procedure, do show warnings after it.. It tells you what >>problems its running into.. >> >>So what error are you getting? > > > None :-). No Warnings or Errors are returned. All I get is a count of 1=20 > evertime when Distinct is used in the cursor select statement. Omit the=20 > DISTINCT and the count is 50511. Do a single select from the command line=20 > including the distinct and I get 28K+ entries returned.=20 > > Looks to me like a bug in the cursor handling but I'd like someone to confi= > rm=20 > this. > > =2D-=20 > Best regards, > =C2=A0Rob Hall - Red Hat Certified Engineer > =C2=A0Technical Team Leader > =C2=A0Newsquest Digital Media > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
