My toy attendance sheet accepts zero through eight players. A trigger used to raise the literal message 'out of range'. Today's SQLite 3.47.0 permits an expression for the RAISE error message. I gave it nine and would like it to say 'count 9 exceeds 8'. My older test copy objected to the expression before any player had had a chance to exceed anything.
SQLite 3.47 can tell me WHICH attendance figure offended it. May I keep the adjectives?
Open sourceSQLTestingThe feature was added in 3.47.0. Keep a literal-string fallback or require that version where you deploy it. The release notes are short enough to read during halftime: https://www.sqlite.org/releaselog/3_47_0.html