Android 10 release version results in file is not a database error

[VAI2MU]

When running the Release version of the app on Android 10, connection to the database is successfully established but on the first attempt to execute an SQL command an exception with the message "file is not a database" happens.

Used in a .net 8.0 Maui application

Packages in use:
PackageReference Include="sqlite-net-sqlcipher" Version="1.8.116"
PackageReference Include="SQLitePCLRaw.bundle_e_sqlcipher" Version="2.1.8"

Also tried with:
PackageReference Include="sqlite-net-sqlcipher" Version="1.9.172"
PackageReference Include="SQLitePCLRaw.bundle_e_sqlcipher" Version="2.1.8"

This issue doesn't appear on the same Android 10 device on Debug mode. It also doesn't appear on any iOS devices or Android 11 devices.

[JonathanWebsdale]

Seeing the same problem when migrating from Xamarin.Forms application to .NET 8 MAUI.

Attempting to open a connection to an encrypted DB generated using "sqlite-net-sqlcipher" Version="1.5.231" in our Xamarin.Forms app, with our .NET Maui app, using "sqlite-net-sqlcipher" Version="1.9.172"

var connectionString = new SQLiteConnectionString(<DBPath>, SQLiteOpenFlags.Create | SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.ProtectionComplete | SQLiteOpenFlags.SharedCache | SQLiteOpenFlags.FullMutex, true, <DBKey>);
var connection = new SQLite.SQLiteAsyncConnection(connectionString); 

var table = await connection.ExecuteScalarAsync<string>(mySelectQuery);

Results in an exception with the result "SQLite.SQLite3+Result.NonDBFile"

at SQLite.SQLite3.Prepare2(sqlite3 db, String query)
at SQLite.SQLiteCommand.Prepare()
at SQLite.SQLiteCommand.ExecuteScalarString
at SQLite.SQLiteAsyncConnection.<>c__DisplayClass82_01[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].<ExecuteScalarAsync>b__0(SQLiteConnectionWithLock conn) at SQLite.SQLiteAsyncConnection.<>c__DisplayClass33_01[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].b__0()

Attempting to re-compile and run the .NET MAUI application with version "1.5.231" of the package does work on Android in debug mode, however causes a different exception when attempting to run in iOS.

System.MissingMethodException: Method not found: string SQLitePCL.raw.sqlite3_column_text(SQLitePCL.sqlite3_stmt,int)
at SQLite.SQLiteCommand.ReadCol(sqlite3_stmt stmt, Int32 index, ColType type, Type clrType)
at SQLite.SQLiteCommand.ExecuteScalarString
at SQLite.SQLiteConnection.ExecuteScalar[String](String query, Object[] args)
at SQLite.SQLiteConnection..ctor(String databasePath, SQLiteOpenFlags openFlags, Boolean storeDateTimeAsTicks, Object key)
at SQLite.SQLiteConnectionWithLock..ctor(SQLiteConnectionString connectionString, SQLiteOpenFlags openFlags)
at SQLite.SQLiteAsyncConnection..ctor(String databasePath, SQLiteOpenFlags openFlags, Boolean storeDateTimeAsTicks, Object key)