Repository navigation
Executing multiple statements with ExecuteNonQuery might result in lost rows #32740
Description
File a bug
Having multiple statements in a query (for example, multiple inserts) and executing them via ExecuteNonQuery might result in no error, but inserts being rollbacked. I presume it's because any errors during later statements are catched:
efcore/src/Microsoft.Data.Sqlite.Core/SqliteDataReader.cs
Lines 252 to 260 in b5b1abf
Reminds me of the exact same bug we had in Npgsql @roji
Include your code
vonzshik/Microsoft.Data.Sqlite-LostInsertBug
Include version information
Microsoft.Data.Sqlite version: 8.0.0
Target framework: .NET 8
Operating system: Windows 10
Activity
[-]Querying multiple statements with ExecuteNonQuery might result in lost rows[/-][+]Executing multiple statements with ExecuteNonQuery might result in lost rows[/+]SQLite: do not report success when a later statement or a busy commit…
SQLite: do not report success when a later statement or a busy commit…