>it is a bug.
>
>the origin of this bug is into this simple example:
>

>CREATE CURSOR bb (x i)
>INSERT INTO bb VALUES (3)
>INSERT INTO bb VALUES (1)
>SELECT -X AS X FROM bb ORDER BY X
>
>* return
>* -1
>* -3
>

>
>on MSSQL and others engines the correct result it is:
>

>CREATE TABLE #bb (x iNT)
>INSERT INTO #bb VALUES (3)
>INSERT INTO #bb VALUES (1)
>SELECT -X AS X FROM #bb ORDER BY X
>DROP TABLE #bb
>
>-- -3
>-- -1
>
>

Thanks for the explanation, Fabio.