On Thursday, November 21, 2013 10:15:23 AM UTC+1, Noel Grandin wrote: > 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. >
Thanks for clarifying, Noel! -hendrik -- 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.
