Sqlite-net: Issue: 'SQL logic error' when upgrading to version 1.7.335 (UWP)

[rneeft]

I'm having a SQL script that is giving me an error when I upgrade to version 1.7.335 of the sqlite-net-pcl version. Version 1.6.292 it is working fine.

Actual

Exception SQL logic error is thrown.

Expected

No issues

Reproduction

I've created a repository with a reproduction scenario: https://github.com/rneeft/SqliteNetIssue. To see the issue (and a working version):

• Start debugging
• Click the button
• Verify that everything is working (Debugger stops at line 91)
• Stop debugging
• Upgrade sqlite-net-pcl to the latest version 1.7.335
• Start debugging
• Click the button
• Exception SQL logic error is thrown.

The files 0039 and 0044 are similar (except for the content) and I don't see anything that could cause this issue. Executing the files in SQL Server works fine.

Any help is very appreciated.

[ivosnoza]

I have the same issue in my Xamarin project. But it is reproducible for UWP only - Android and iOS work well with the same data. So I think it has something to do with version upgrade of the underlying library in this commit https://github.com/praeclarum/sqlite-net/commit/6f3b3d851c37a30f213b19deaad08a1e2ca647db

I assume we are encountering already reported similar issue https://github.com/dotnet/efcore/issues/20044

[tipa]

Same issue here and on UWP only. I can observe the problem when attaching another database and trying to copy a whole table with a command like this:
Db.Execute($"INSERT INTO Test (Row1,Row2) SELECT Row1,Row2 FROM ATTACHED_DB.Test");

[dajbych]

I have the same issue. _SQL logic error_ for VACUUM command or for very basic commands like db.Execute("UPDATE Table SET Column = ? WHERE Id = ?", "value", 1234); since version 1.7.335, no changes in the codebase or database schema.

[tomreich]

+1 on this issue for VACUUM command. Works on non-UWP platforms, fails in UWP with "SQL Logic Error".

[ericsink]

https://github.com/ericsink/SQLitePCL.raw/wiki/UWP-Init