D 2020-03-19T09:35:40.196
J foundin 1.0.112
J icomment Integers\sare\sbeing\sreturned\sfrom\squeries\sas\s32\sbit\sintegers\seven\sthrough\sthe\svalue\sis\stoo\sbig.\s\sI\sam\snot\ssure\sif\syou\sintend\sfor\sthe\sintegers\sto\sbe\sreturned\sas\sInt32\sor\sInt64.\s\sI\sexpected\sthem\sall\sto\sbe\sreturned\sas\sInt64,\sbut\sI\scast\sthem\sInt32\sto\sget\sthe\sfirst\s3\sAsserts\sto\spass.\s\sThe\s4th\sAsserts\sfails\sand\sdoes\snot\shave\sthe\scorrect\svalue.\r\n\r\n\r\n\r\n\s\s\s\s\s\s\s\s[TestMethod]\r\n\s\s\s\s\s\s\s\spublic\svoid\sInt_Sqlite()\r\n\s\s\s\s\s\s\s\s{\r\n\s\s\s\s\s\s\s\s\s\s\s\sSQLiteConnectionStringBuilder\sbuilder\s=\snew\sSQLiteConnectionStringBuilder();\r\n\s\s\s\s\s\s\s\s\s\s\s\sbuilder.DataSource\s=\s":memory:";\r\n\s\s\s\s\s\s\s\s\s\s\s\sbuilder.FailIfMissing\s=\sfalse;\r\n\s\s\s\s\s\s\s\s\s\s\s\sbuilder.JournalMode\s=\sSQLiteJournalModeEnum.Memory;\r\n\s\s\s\s\s\s\s\s\s\s\s\sbuilder.SyncMode\s=\sSynchronizationModes.Off;\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\sbyte\stestValue8\s=\sbyte.MaxValue;\r\n\s\s\s\s\s\s\s\s\s\s\s\sshort\stestValue16\s=\sshort.MaxValue;\r\n\s\s\s\s\s\s\s\s\s\s\s\sint\stestValue32\s=\sint.MaxValue;\r\n\s\s\s\s\s\s\s\s\s\s\s\slong\stestValue64\s=\slong.MaxValue;\r\n\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\susing\s(SQLiteConnection\sconnection\s=\snew\sSQLiteConnection(builder.ConnectionString))\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\sconnection.Open();\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\susing\s(SQLiteTransaction\stransaction\s=\sconnection.BeginTransaction())\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\susing\s(SQLiteCommand\scommand\s=\sconnection.CreateCommand())\r\n\s\s\s\s\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\s\s\s\s\scommand.CommandText\s=\s"CREATE\sTABLE\sTestValues\s(Value8\sINT\sNOT\sNULL,\sValue16\sINT\sNOT\sNULL,\sValue32\sINT\sNOT\sNULL,\sValue64\sINT\sNOT\sNULL)";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Transaction\s=\stransaction;\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.ExecuteNonQuery();\r\n\s\s\s\s\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\s\s\s\s\s\s\s\stransaction.Commit();\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\s\s\s\susing\s(SQLiteTransaction\stransaction\s=\sconnection.BeginTransaction())\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\susing\s(SQLiteCommand\scommand\s=\sconnection.CreateCommand())\r\n\s\s\s\s\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\s\s\s\s\scommand.CommandText\s=\s"INSERT\sINTO\sTestValues\s(Value8,\sValue16,\sValue32,\sValue64)\sVALUES\s(@Value8,\s@Value16,\s@Value32,\s@Value64)";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Transaction\s=\stransaction;\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Parameters.AddWithValue("@Value8",\stestValue8);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Parameters.AddWithValue("@Value16",\stestValue16);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Parameters.AddWithValue("@Value32",\stestValue32);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Parameters.AddWithValue("@Value64",\stestValue64);\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.ExecuteNonQuery();\r\n\s\s\s\s\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\stransaction.Commit();\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s}\r\n\r\n\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\susing\s(SQLiteTransaction\stransaction\s=\sconnection.BeginTransaction())\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\susing\s(SQLiteCommand\scommand\s=\sconnection.CreateCommand())\r\n\s\s\s\s\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\s\s\s\s\scommand.CommandText\s=\s"SELECT\s*\sfrom\sTestValues";\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\scommand.Transaction\s=\stransaction;\r\n\r\n\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\s\s\s\s\susing\s(SQLiteDataReader\sreader\s=\scommand.ExecuteReader())\r\n\s\s\s\s\s\s\s\s\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\s\s\s\s\s\s\s\s\sif\s(reader.Read())\r\n\s\s\s\s\s\s\s\s\s\s\s\s\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\s\s\s\s\s\s\s\s\s\s\s\s\sAssert.AreEqual((int)testValue8,\sreader[0]);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sAssert.AreEqual((int)testValue16,\sreader[1]);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sAssert.AreEqual((int)testValue32,\sreader[2]);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sAssert.AreEqual((long)testValue64,\sreader[3]);\r\n\s\s\s\s\s\s\s\s\s\s\s\s\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\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\s}\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\stransaction.Commit();\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}\r\n\s\s\s\s\s\s\s\s}
J login anonymous
J mimetype text/plain
J private_contact 66326f94cdccdf9c5e246ecc963e50c1a3e2b6b0
J severity Important
J status Open
J title Integers\sbeing\sreturned\sas\sInt32\sinstead\sof\sInt64\sresulting\sin\sincorrect\sdata
J type Code_Defect
K f60c439a6a3117a480bb460d76314a7cef3698a4
U anonymous
Z e152cd76c14841d29500aff9c96d40fd