Tag - SELECT

Non-Deterministic Order for SELECT with LIMIT

Non-Deterministic Order

In this blog, we’ll look at how queries in systems with parallel processing can return rows in a non-deterministic order (and how to fix it).
Short story:
Do not rely on the order of your rows if your query does not use
ORDER BY. Even with
ORDER BY, rows with the same values can be sorted differently. To […]

Read more