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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
