Icon View Incident Report

Serious Serious
Reported By: Sergey Kolotov
Reported On: 8/5/2010
For: Version 2.03 Build 18
# 3268 ORDER BY Sorting Not Correct When Only Descending Index Present and RequestSensitive=True

Error of sorting in ElevateDB 2.03 Build 18 when RequestSensitive is set.

When Request Sensitive Result Set flag is not set then the following result is present:
F1 F2
1 9
2 8
3 7

It is all right.

When Request Sensitive Result Set flag is set then the following result is present:

F1 F2
3 7
2 8
1 9

CREATE TABLE Table1
(
F1 INTEGER,
F2 INTEGER
)

CREATE INDEX Index1 ON Table1 (F1 DESC)

INSERT INTO Table1 (F1, F2)
VALUES(1, 9)

INSERT INTO Table1 (F1, F2)
VALUES(2, 8)

INSERT INTO Table1 (F1, F2)
VALUES(3, 7)

SELECT * FROM Table1
ORDER BY F1



Comments Comments and Workarounds
This as a carry-over of the same issue from build 18 that was reported in incident #3253. The workaround is to use the explicit ASC flag in the ORDER BY.


Resolution Resolution
Fixed Problem on 8/5/2010 in version 2.03 build 19


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image