indo2605 wrote:

>everything works fine, until I replace the last line with:
>
>ORDER BY BILLNO, BILLNO
>
>It is not correctly sorted anymore (column "BILLNO").
>
>The same behaviour when I use "ORDER BY BILLNO, BILLNO, BILLNO" but
>when in use it more then threetimes it works again, e.g. "ORDER BY
>BILLNO, BILLNO, BILLNO, BILLNO"
>
>I use Firebird 1.52 and the IBOConsole, have you the same problems? Is
>this a known bug?
>
>

Sorry, can't help you with your problem, but I made two observations:
- works for me with 3 (and more) x BILLNO (ORDER BY BILLNO, BILLNO,
BILLNO), only 2 x BILLNO fails
- the plan is always PLAN SORT (SORT ((TEST NATURAL))), except in the
case with 2 x BILLNO, where the plan changes to PLAN SORT ((TEST NATURAL))

Tested with Firebird 1.52/WinXP/IBConsole

--
Magnus