Main | My View | View Issues | Change Log | Roadmap | Docs
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000597 [NexusDB] SQL Engine minor always 2010-05-20 08:58 2010-09-03 13:31
Reporter Eivind View Status public  
Assigned To hdanzl
Priority normal Resolution fixed  
Status closed   Product Version V3.0401 Release
Summary 0000597: ORDER BY returns different order depending on the order of SELECT clause fields
Description Hello,

I'm using the NexusDB 3.04 and I have a trouble with this query. This was working correctly in the previous version.

This request give a good result, the order is correct.
Code:

SELECT Section, Parametre,Valeur,RecNo FROM SoluneBDD WHERE Section='Non_conformités' AND Parametre<>'Général' ORDER BY Section,RecNo

If I change the RecNo filed at the second position, the order is incorrect.

Code:

SELECT Section, RecNo, Parametre,ValeurFROM SoluneBDD WHERE Section='Non_conformités' AND Parametre<>'Général' ORDER BY Section,RecNo
Additional Information
Attached Files 7z file icon SoluneBDD.7z (73,476 bytes) 2010-05-20 08:58

- Relationships

There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2010-05-20 08:58 Eivind New Issue
2010-05-20 08:58 Eivind Status new => assigned
2010-05-20 08:58 Eivind Assigned To => hdanzl
2010-05-20 08:58 Eivind File Added: SoluneBDD.7z
2010-06-08 17:11 hdanzl Status assigned => QA Testing
2010-06-08 17:11 hdanzl Resolution open => fixed
2010-06-08 17:11 hdanzl Fixed in Version => V3.05 Release
2010-06-08 17:11 hdanzl Target Version => V3.05 Release
2010-09-03 13:31 hdanzl Status QA Testing => closed

Mantis 1.1.0a3[^]
Copyright © 2000 - 2007 Mantis Group
35 total queries executed.
31 unique queries executed.
Powered by Mantis Bugtracker