Skip to content
banshee

AM09 — LIMIT/OFFSET without ORDER BY is non-deterministic

Group: Ambiguity · Auto-fixable: no

Without ORDER BY, LIMIT/OFFSET return an arbitrary subset of rows that can change between runs. Add an ORDER BY to make the result deterministic.

Configure

Section titled “Configure”

Disable this rule in banshee.toml:

[lint]
exclude = ["AM09"]

Or silence one line with -- noqa: AM09. See Linting.