On 2013-11-19 17:06, hendrik wrote:
My question is, is it wrong to assume that a join query like the one above,
returns results in the same order, even when
different offsets are used and the column I order by is not unique?
Sorry, but yes, you cannot assume that.
By default, SQL results are unordered.
The only way to impose ordering is to use an ORDER BY clause, and even then, if the columns specified in the ORDER BY
CLAUSE are insufficient to impose a total order, then the total order is undefined and may change.
The longer answer is that this is necessary for performance - ordering imposes
cost, so we order things only when necessary.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
