List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:October 6 2005 6:17pm
Subject:Re: Cursors in 5.0.13
View as plain text  
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



Thread
Cursors in 5.0.13Rob Hall5 Oct
  • Re: Cursors in 5.0.13Jeff Smelser5 Oct
    • Re: Cursors in 5.0.13Rob Hall6 Oct
      • Re: Cursors in 5.0.13Gleb Paharenko7 Oct