Wrong result from function GetOrderBy (ora.pas)

[cis-wurzen]

Steps to reproduce:

Call function GetOrderBy from unit ora.pas with this SQL-statement

Code: Select all

SELECT '(' || DUMMY || ') ' AS X
FROM DUAL
ORDER BY DUMMY

and the result is an empty string!

If you use this SQL

Code: Select all

SELECT '(' || DUMMY || ')' || ' ' AS X
FROM DUAL
ORDER BY DUMMY

or this

Code: Select all

SELECT '(' || DUMMY || ')' AS X
FROM DUAL
ORDER BY DUMMY

the result will be 'DUMMY'.

ODAC-Versions tested:
5.80.0.42 (Delphi 5)
7.0.0.2 (Delphi XE)

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.

[bork]

Hello

We have fixed this issue. This fix will be included in the next ODAC build.