Devart Forums

Posted: **Tue 21 Dec 2010 15:17**

Steps to reproduce:

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

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

and the result is an empty string!

If you use this SQL

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

or this

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)

Posted: **Tue 21 Dec 2010 16:00**

Hello,

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

Posted: **Fri 24 Dec 2010 10:09**

Hello

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

Wrong result from function GetOrderBy (ora.pas)