On 4/16/2024 10:19 AM, 'Peter Borissow' via H2 Database wrote:
(2) The query response is inconsistent. I see 4 different responses coming back from the same query on a static table. I
don't think that's right.
SQL databases implement the relational model. The relational model works with
sets, not lists.
Sets do not have ordering, so, if you want repeatable results and ordering, then you have to impose that ordering using
an ORDER BY clause, and that ORDER BY clause needs to impose a total order, not a partial order.
--
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/f6cc0800-8e66-48fc-842e-25a40d32f907%40gmail.com.
