Hi there guys,
I'm having a problem when using System.Data.SQLite on .net 4.6.1 project running on mono armv7:
When i call ExecuteReader() to execute a query, i have the following problem:
If i try to get the decimal value via the ordinal place call (reader.GetDecimal(4)) evetyhing is OK, but if i try to collect the value via column name (reader["Value"]), i got the following exception:
System.OverflowException: Value was either too large or too small for a Decimal.
at System.Decimal+DecCalc.VarDecFromR8 (System.Double input, System.Decimal+DecCalc& result) [0x0001f] in <1030e815d9104f2a8a218067776e8f42>:0
at System.Decimal..ctor (System.Double value) [0x00007] in <1030e815d9104f2a8a218067776e8f42>:0
at System.Decimal.op_Explicit (System.Double value) [0x00000] in <1030e815d9104f2a8a218067776e8f42>:0
at System.Convert.ToDecimal (System.Double value) [0x00000] in <1030e815d9104f2a8a218067776e8f42>:0
at System.Double.System.IConvertible.ToDecimal (System.IFormatProvider provider) [0x00000] in <1030e815d9104f2a8a218067776e8f42>:0
at System.Convert.ChangeType (System.Object value, System.Type conversionType, System.IFormatProvider provider) [0x00170] in <1030e815d9104f2a8a218067776e8f42>:0
at System.Data.SQLite.SQLite3.GetValue (System.Data.SQLite.SQLiteStatement stmt, System.Data.SQLite.SQLiteConnectionFlags flags, System.Int32 index, System.Data.SQLite.SQLiteType typ) [0x0011f] in <8608caf0ec6d4022a0b00f2f8ebe892e>:0
at System.Data.SQLite.SQLiteDataReader.GetValue (System.Int32 i) [0x000fc] in <8608caf0ec6d4022a0b00f2f8ebe892e>:0
at System.Data.SQLite.SQLiteDataReader.get_Item (System.String name) [0x0000e] in <8608caf0ec6d4022a0b00f2f8ebe892e>:0
at sqlite_arm32_tes.Program.LoadDataTestOnArm () [0x000f0] in <81a927715fef462aa7cdc35e7131b04a>:0
at sqlite_arm32_tes.Program.Main (System.String[] args) [0x00000] in <81a927715fef462aa7cdc35e7131b04a>:0
Wasn't it supposed to be the same result? (It only happens with decimals)
Regards