You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Tests (DuckDB error) - Malformed JSON at byte 0 of input #5387
There's been (I think) a regression within tests definition between version 0.187.6 and 0.206.1 (not necessarily exactly these versions, this is the point at which I've noticed it).
I have a model that has a nullable JSON column in DuckDB (Motherduck to be precise, though I believe it doesn't matter for tests).
When specifying test example in the .yaml file, I could previously simply omit that column in the inputs section.
After upgrading SQLMesh, I'm getting the following error when running the tests: duckdb.duckdb.InvalidInputException: Invalid Input Error: Malformed JSON at byte 0 of input: unexpected character. Input: "None"
To fix this, I need to input an empty JSON to the column, like this
The problem with that is that I have plenty of columns like this, so fixing it this way makes the tests very hard to read.
Please consider fixing it if it's indeed a regression. If it's not, I'd be happy to get to know how to work around it, if possible.
changed the title [-]Tests (DuckDB) - Malformed JSON at byte 0 of input[/-][+]Tests (DuckDB error) - Malformed JSON at byte 0 of input[/+]on Sep 16, 2025
Activity
[-]Tests (DuckDB) - Malformed JSON at byte 0 of input[/-][+]Tests (DuckDB error) - Malformed JSON at byte 0 of input[/+]jessebrowning commentedon Jun 2, 2026
Also having this issue