SqliteException(1): while preparing statement, near "RETURNING": syntax error, SQL logic error dart test about drift

[simolus3]

The error indicates that you're using an old sqlite3 version. RETURNING requires sqlite 3.35.0 or later. As unit tests in drift have to use the sqlite3 from the system (they're not running in a Flutter engine, so sqlite3_flutter_libs doesn't apply), they can fail if running against old sqlite3 versions.

The easiest fix is to upgrade your sqlite3 install. If that's not possible because you don't control the environment, you can compile sqlite3 yourself, say as part of the CI. I'm not experienced with Jenkins, but for GitHub actions you could take a look at this workflow for inspiration. It's caching the compilation so it doesn't slow down runs, and with a custom libsqlite3.so, you can use this to priotize it over the one from the system: https://github.com/simolus3/sqlite3.dart/blob/2ffd871606e0f43f68f1364d8f4e1428dcbf3792/.github/workflows/main.yml#L145-L150 You can also grab precompiled libraries from here and put them into LD_LIBRARY_PATH.

[bytepoets-jhe]

Thank you for the explanation!