The regression runner (tests/regression/run.sh) collects tests with a shell glob, so execution and display order are lexical — which currently interleaves oddly (140-truncation-fail-closed runs before 20-load-turtle; the 1xx series sits between 10- and 20-).
Rename NN-*.sql / NN-*.out to 0NN-*, keeping 000-smoke first. Note this changes execution order: all tests share one live database, so any hidden cross-test state coupling will surface in the rename PR — that is a feature, not a risk to avoid; each coupling found is a latent ordering bug to fix. Acceptance: full suite green locally and in CI after the rename, with zero golden content changes (only file renames, plus fixes for any coupling exposed).
The regression runner (
tests/regression/run.sh) collects tests with a shell glob, so execution and display order are lexical — which currently interleaves oddly (140-truncation-fail-closedruns before20-load-turtle; the1xxseries sits between10-and20-).Rename
NN-*.sql/NN-*.outto0NN-*, keeping000-smokefirst. Note this changes execution order: all tests share one live database, so any hidden cross-test state coupling will surface in the rename PR — that is a feature, not a risk to avoid; each coupling found is a latent ordering bug to fix. Acceptance: full suite green locally and in CI after the rename, with zero golden content changes (only file renames, plus fixes for any coupling exposed).