Parameterless prepared select throws (code 101)

[pti]

Parameterless prepared select throws (code 101)

[simolus3]

This is definitely a bug, thanks!

I am struggling to understand how an exception could be thrown though. If you look at the check, error 101 (SQLITE_DONE) should be handled there:

sqlite3.dart/sqlite3/lib/src/ffi/impl/statement.dart

Lines 158 to 160 in a8e9989

	if (resultCode != SqlError.SQLITE_OK &&
	resultCode != SqlError.SQLITE_DONE) {
	throwException(

I then thought that we might be missing data by forgetting to call sqlite3_reset, but it seems like (at least my) sqlite3 implicitly resets a statement after _step() has returned SQLITE_DONE.

So while this should be fixed in the library, I'm wondering which sqlite3 (the native library, not the Dart package) you are using? Something from your OS or a custom build? What does sqlite3.version return?

[simolus3]

Ah well, the test indicates the problem - looks like the sqlite3 on macOS is behaving differently.

[pti]

Yep, I was using macOS - print(sqlite3.version) outputs:

Version(libVersion: 3.39.5, sourceId: 2022-10-14 20:58:05 554764a6e721fab307c63a4f98cd958c8428a5d9d8edfde951858d6fd02daapl, number: 3039005)

On Linux the exception isn't thrown, version:

Version(libVersion: 3.37.2, sourceId: 2022-01-06 13:25:41 872ba256cbf61d9290b571c0e6d82a20c224ca3ad82971edc46b29818d5dalt1, number: 3037002)

[simolus3]

Fixed in sqlite3: 1.9.3 - thanks again for the report!

[pti]

That was quick! 👍