Hi Noel, Thanks for the reply. Why I'm curious, because it wasn't affected till 1.4.188 version without using order by clause. So is there any special improvements after 188 to act like this.
On Monday, August 5, 2019 at 1:56:31 PM UTC+5:30, Noel Grandin wrote: > > Unless you are using an ORDER BY clause, the order of results is undefined > in SQL, so it can change at any time > > >> >> -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/66d4b8c0-4cf3-4ef5-abda-03d6de13adaa%40googlegroups.com.