Bug #67147 Problem with Decode on Win 7
Submitted: 9 Oct 2012 15:54 Modified: 30 May 2013 12:58
Reporter: Alfonso García Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.1.11 OS:Windows (7 )
Assigned to: CPU Architecture:Any
Tags: MySQL Decode Win7

[9 Oct 2012 15:54] Alfonso García
Description:
When I make a query with more than one result with Decode, it breaks on the second row and close the program.

For example, when i do that:

Sql.Add ( 'SELECT DECODE( USER, "key") FROM A00USERS ORDER BY DECODE(USER, "key")' ) ;
Open ;
while not Eof do
begin
    showmessage(Fields[0].AsString);
    Next ;
end ;

It will show a message with "Arthur" but when i press OK, and goes to the second row ("Braian") the program crashes.

How to repeat:
When I make a query with more than one result with Decode, it breaks on the second row and close the program.
[9 Oct 2012 16:11] MySQL Verification Team
Which client program application are you using? and Why do you think is MySQL bug the crash of your application?. Thanks.
[10 Oct 2012 7:16] Alfonso García
I'm using Delphi7 with MySQL ODBC 5.1.11 (32b) Driver and BDE.

This problem's show on Win 7 32b & 64b, but works perfect on XP
[8 Jan 2013 10:22] Bogdan Degtyariov
Can you check in the Event logger which module caused the crash?
Was it myodbc5.dll?
Please send the entire event text.
[9 Feb 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[30 May 2013 12:58] Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.