Bug #3197 SELECT Statement is erroneous

• Submitted: 17 Mar 2004 2:30
• Modified: 17 Apr 2004 14:11
• Reporter: Ahmet Tokalak
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.0.18
• OS: Windows (Windows XP, maybe ANY)
• Assigned to: Assigned Account
• CPU Architecture: Any

[17 Mar 2004 2:30] Ahmet Tokalak

Description:
Select statement causes an empty resultset if using ORDER BY clause with DESC argument.

Here is an example:

SELECT OrderNo FROM Orders WHERE Customer=1 ORDER BY OrderNo DESC

If i omit DESC option or use ASC option the query functions correct.

example:
SELECT OrderNo FROM Orders WHERE Customer=1 ORDER BY OrderNo ASC
or
SELECT OrderNo FROM Orders WHERE Customer=1 ORDER BY OrderNo
or 
SELECT OrderNo FROM Orders WHERE Customer=1

How to repeat:
SELECT OrderNo FROM Orders WHERE Customer=1 ORDER BY OrderNo DESC

[17 Mar 2004 14:11] Dean Ellis

Please submit a complete test case, including the SQL to create, populate and query the table, which demonstrates this behavior.  I am unable to repeat otherwise.

[14 Feb 2005 22:54] 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".