> Are they really peers if there's a unique primary key? Yes, they are if this primary key isn't included into sort specification. If rows aren't distinct with respect to the sort specification, they are peers of each other. Columns aren't included into sort specification don't matter here.
Database systems don't shuffle rows intentionally, but ordering of peers depends on index construction, query execution plan (it can be changed even for the same query with the same parameters in some cases), sometimes on row insertion order and other data modification operations. There are too many unknown variables. You can't rely on them. -- 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/53ab2276-4ef2-4134-b4d7-07b2a6133628n%40googlegroups.com.
