|Subject||Re: [Firebird-Java] Jaybird and SELECTs with ORDER BY|
> To be specific the results I get in IB Expert are sorted stable - i.e.Strange. In general, Jaybird respects (or should respect, at least
> parts that were not affected by ORDER BY remain in place, in the order
> they were added to the table.
> The same SQL SELECT query in my Java app returns results which are not
> stable sorted - some rows are in reverse entered-to-table order.
nothing was coded differently) the order in which data are returned from
Can you also check in isql, in what order it returns the data for your
> I can overcome the problem by expanding Java app SELECT query withIn general you should not rely on the order of not ordered columns. :)
> primary key ORDER BY clause, because in general the pk increases as
> the rows are added, but there could be exceptions, as always...
Why can't you add those columns to the ORDER BY clause?