Artifact
a0e52d7b75298dbee14bbbff307c91a8d09362b6:
Ticket change
[a0e52d7b75]
- Ticket
[458738515e] Invalid cast exception when using DataReader's GetString method on a string value that happens to be a string representation of an integer status still Open with 3 other changes
by
anonymous
2018-08-29 12:52:09.
D 2018-08-29T12:52:09.364
J icomment Here's\ssome\squick\scode\sthat\sreproduces\sthe\serror\s(on\s64-bit\sWindows).\sThe\sdirectory\sc:\\test\smust\sexist.\r\n\r\nSystem.Data.SQLite.SQLiteConnection\sSQLiteConn\s=\snew\sSystem.Data.SQLite.SQLiteConnection(@"Data\sSource=c:\\test\\test.db;Version=3;Pooling=True;Max\sPool\sSize=100;");\r\n\s\s\s\s\s\s\s\s\s\s\s\sSystem.Data.SQLite.SQLiteCommand\scmd\s=\sSQLiteConn.CreateCommand();\r\n\s\s\s\s\s\s\s\s\s\s\s\sSQLiteConn.Open();\r\n\s\s\s\s\s\s\s\s\s\s\s\sIDataReader\sdr\s=\snull;\r\n\s\s\s\s\s\s\s\s\s\s\s\sstring\ss;\r\n\s\s\s\s\s\s\s\s\s\s\s\stry\r\n\s\s\s\s\s\s\s\s\s\s\s\s{\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.CommandText\s=\s"Create\sTable\s\stest\s(Code\sString\sNOT\sNULL\sDEFAULT\s'')";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.ExecuteNonQuery();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.CommandText\s=\s"INSERT\sINTO\sTEST\s(Code)\sVALUES\s('Test')";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.ExecuteNonQuery();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.CommandText\s=\s"INSERT\sINTO\sTEST\s(Code)\sVALUES\s('174500')";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.ExecuteNonQuery();\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.CommandText\s=\s"SELECT\sCODE\sFROM\sTEST";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sdr\s=\scmd.ExecuteReader();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\swhile\s(dr.Read())\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s{\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\ss\s=\sdr.GetString(0);\s//invalid\scast\sexception\shere\son\s2nd\srow\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sConsole.WriteLine(s);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s}\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s}\r\n\s\s\s\s\s\s\s\s\s\s\s\sfinally\r\n\s\s\s\s\s\s\s\s\s\s\s\s{\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sdr.Close();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.CommandText\s=\s"DROP\stable\stest";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.ExecuteNonQuery();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scmd.Dispose();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sSQLiteConn.Close();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sSQLiteConn.Dispose();\r\n\s\s\s\s\s\s\s\s\s\s\s\s}
J login anonymous
J mimetype text/x-fossil-plain
K 458738515e70f99f0ce997894c9602bfce9cb2ed
U anonymous
Z aaf18e1148902a3ce0ba044c6d427d8b
