Instead of in-memory database, I created database in a file and tried to do
select with same results.
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.521968|10101|10101|4801345|fd5cb2d226b48d5dd4645d4fe7ca12cf
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.522843|10101|10101|4801345|48cc79ae3c9029c82883843737f98ca1
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.523982|10101|10101|4801345|2522b8b56698cb805170497ebdab5858
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.524920|10101|10101|4801345|4ae983c9b1946dbc905d12333353b71a
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.525914|10101|10101|4801345|7d081eda7db33ea363b6c6655688f08d
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.526910|10101|10101|4801345|105344cb171ecaf81798df75b8d3562e
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.527911|10101|10101|4801345|34ab03b3543b1f0b2ca2f505fc6330f7
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.528910|10101|10101|4801345|8c72bd2c854598f9e817f9d85282aae8
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.529911|10101|10101|4801345|69b5c4d087a270b5b671a1765123ae8b
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.530910|10101|10101|4801345|28c45b4ab9414819bb4c75ff37bf5a7e
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.531911|10101|10101|4801345|2c726e0c63bda2d30e3f9ea38df5ece0
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.532920|10101|10101|4801345|77ac658bcc98321e298cd52d07dcc8d5
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.534031|10101|10101|4801345|0a41725b5b1a183ebf40489f2037f00d
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.535178|10101|10101|4801345|652575b633b6f4aefe5b6ddb5b085c06
1285625919|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.536085|10101|10101|4801345|3a632902e3e07bc7c20e130baf941a33
1285625919|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.537085|10101|10101|4801345|5a44897aef3d81d70dee8246d4a7748f
1285625919|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.538077|10101|10101|4801345|fd6a9a130a5c3bb46ee0e20bf6f02b52
1285625919|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.539090|10101|10101|4801345|2efba1c039c0f41361945a27a3e651cd
1285625919|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.540077|10101|10101|4801345|1fde5a8f289b299139c26260c75a6df0
1285625920|10.208.54.32|239.90.91.101|2010-09-27
17.18.40.481153|10101|10101|4801345|6d7fd3d66e0eb709c38440546a9e3a15
1285625920|10.208.54.32|239.90.91.101|2010-09-27
17.18.40.481746|10101|10101|4801345|f236a2ecf56f038ff132b91ba94287f4
sqlite>
sqlite>
sqlite>
sqlite> select * from find_retransmissions where InsTimeStamp=1285625920;
1285625920|10.208.54.32|239.90.91.101|2010-09-27
17.18.40.481153|10101|10101|4801345|6d7fd3d66e0eb709c38440546a9e3a15
1285625920|10.208.54.32|239.90.91.101|2010-09-27
17.18.40.481746|10101|10101|4801345|f236a2ecf56f038ff132b91ba94287f4
sqlite> select * from find_retransmissions where
MD5Sum='f236a2ecf56f038ff132b91ba94287f4';
sqlite>
select * displays whole table. If I do select using another column I get
appropriate rows, but if I do select on MD5Sum column it returns nothing.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Mon, 9/27/10, Hemant Shah <hj...@yahoo.com> wrote:
> From: Hemant Shah <hj...@yahoo.com>
> Subject: Re: [sqlite] sqlite cannot find the row
> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
> Date: Monday, September 27, 2010, 4:22 PM
> Sorry about that. No I do not have
> single quotes around ?.
>
> strcpy(SqlString, "INSERT INTO
> find_retransmissions(InsTimeStamp, SrcIp, DstIp, TimeStamp,
> SrcP ort, DstPort, SeqNum, MD5Sum) VALUES
> (?,?,?,?,?,?,?,?)");
>
> sprintf(SqlString, "SELECT SrcIp, DstIp, TimeStamp,
> SrcPort, DstPort, SeqNum FROM find_retransmissions WHERE
> MD5Sum = ?");
>
>
> I do not have quotes in both statemens, but insert
> statement works.
>
>
> Hemant Shah
> E-mail: hj...@yahoo.com
>
>
> --- On Mon, 9/27/10, Black, Michael (IS) <michael.bla...@ngc.com>
> wrote:
>
> > From: Black, Michael (IS) <michael.bla...@ngc.com>
> > Subject: Re: [sqlite] sqlite cannot find the row
> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
> > Date: Monday, September 27, 2010, 2:27 PM
> > Your code is chopped off and I
> > suspect the problem is on the remainder of this line:
> >
> > sprintf(SqlString, "SELECT SrcIp, DstIp, TimeStamp,
> > SrcPort, DstPort, SeqNum
> >
> > For example, did you put single quotes around the ?
> > parameter?
> >
> >
> > Michael D. Black
> > Senior Scientist
> > Advanced Analytics Directorate
> > Northrop Grumman Information Systems
> >
> >
> > ________________________________
> >
> > From: sqlite-users-boun...@sqlite.org
> > on behalf of Hemant Shah
> > Sent: Mon 9/27/2010 2:22 PM
> > To: General Discussion of SQLite Database
> > Subject: EXTERNAL:Re: [sqlite] sqlite cannot find the
> row
> >
> >
> >
> > Here is the snippet of code:
> >
> > int GetMessageFromDB(char *MD5Sum, struct ReceiveNode
> > *FromDb)
> > {
> > int ReturnCode;
> > sqlite3_stmt *SelectStmtHandle;
> >
> > sprintf(SqlString, "SELECT SrcIp, DstIp,
> > TimeStamp, SrcPort, DstPort, SeqNum
> > ReturnCode = sqlite3_prepare(DbHandle,
> > SqlString, -1, &SelectStmtHandle, NULL
> > if (ReturnCode != SQLITE_OK ||
> > SelectStmtHandle == NULL)
> > {
> > sqlite3_reset(SelectStmtHandle);
> > printf("Cannot prepare select
> > statement. %s\n", sqlite3_errmsg(DbHandle));
> > return(2);
> > }
> >
> > sqlite3_bind_text(SelectStmtHandle, 1,
> > MD5Sum, strlen(MD5Sum), SQLITE_TRANSIE
> > ReturnCode =
> > sqlite3_step(SelectStmtHandle);
> > if (ReturnCode != SQLITE_ROW)
> > {
> > sqlite3_reset(SelectStmtHandle);
> > printf("Row not found. ReturnCode: %d,
> > Error Message:%s, Error Code: %d\n"
> >
> > ReturnCode, sqlite3_errmsg(DbHandle),
> > sqlite3_errcode(DbHandle));
> > return(2);
> > }
> >
> > strcpy(FromDb->SourceIP,
> > sqlite3_column_text(SelectStmtHandle, 0));
> > strcpy(FromDb->DestIP,
> > sqlite3_column_text(SelectStmtHandle, 1));
> > strcpy(FromDb->TimeStamp,
> > sqlite3_column_text(SelectStmtHandle, 2));
> > FromDb->SourcePort =
> > sqlite3_column_int(SelectStmtHandle, 3);
> > FromDb->DestPort =
> > sqlite3_column_int(SelectStmtHandle, 4);
> > FromDb->SeqNum =
> > sqlite3_column_int(SelectStmtHandle, 5);
> > strncpy(FromDb->MD5Sum, MD5Sum,
> > MD5SUMLEN);
> > sqlite3_finalize(SelectStmtHandle);
> > return(1);
> > }
> >
> > int GetMessageFromDB(char *MD5Sum, struct ReceiveNode
> > *FromDb)
> > {
> > int ReturnCode;
> > sqlite3_stmt *SelectStmtHandle;
> >
> > sprintf(SqlString, "SELECT SrcIp, DstIp,
> > TimeStamp, SrcPort, DstPort, SeqNum
> > ReturnCode = sqlite3_prepare(DbHandle,
> > SqlString, -1, &SelectStmtHandle, NULL
> > if (ReturnCode != SQLITE_OK ||
> > SelectStmtHandle == NULL)
> > {
> > sqlite3_reset(SelectStmtHandle);
> > printf("Cannot prepare select
> > statement. %s\n", sqlite3_errmsg(DbHandle));
> > return(2);
> > }
> >
> > sqlite3_bind_text(SelectStmtHandle, 1,
> > MD5Sum, strlen(MD5Sum), SQLITE_TRANSIE
> > ReturnCode =
> > sqlite3_step(SelectStmtHandle);
> > if (ReturnCode != SQLITE_ROW)
> > {
> > sqlite3_reset(SelectStmtHandle);
> > printf("Row not found. ReturnCode: %d,
> > Error Message:%s, Error Code: %d\n"
> >
> > ReturnCode, sqlite3_errmsg(DbHandle),
> > sqlite3_errcode(DbHandle));
> > return(2);
> > }
> >
> > strcpy(FromDb->SourceIP,
> > sqlite3_column_text(SelectStmtHandle, 0));
> > strcpy(FromDb->DestIP,
> > sqlite3_column_text(SelectStmtHandle, 1));
> > strcpy(FromDb->TimeStamp,
> > sqlite3_column_text(SelectStmtHandle, 2));
> > FromDb->SourcePort =
> > sqlite3_column_int(SelectStmtHandle, 3);
> > FromDb->DestPort =
> > sqlite3_column_int(SelectStmtHandle, 4);
> > FromDb->SeqNum =
> > sqlite3_column_int(SelectStmtHandle, 5);
> > strncpy(FromDb->MD5Sum, MD5Sum,
> > MD5SUMLEN);
> > sqlite3_finalize(SelectStmtHandle);
> > return(1);
> > }
> >
> > if (FindDuplicateMessage(ReceiveBuf) == 1)
> > {
> > GetMessageFromDB(ReceiveBuf.MD5Sum,
> > &FromDb);
> > }
> >
> >
> >
> > When I execute this functions I get following output.
> >
> >
> > Cannot insert into database. column MD5Sum is not
> unique
> > error code = SQLITE_CONSTRAINT
> > Row not found. ReturnCode: 101, Error Message:not an
> error,
> > Error Code: 0
> >
> >
> > 101 is SQLITE_DONE. So I get SQLITE_DONE instead of
> > SQLITE_ROW.
> >
> >
> >
> > Hemant Shah
> > E-mail: hj...@yahoo.com
> >
> >
> >
> >
> >
> > -----Inline Attachment Follows-----
> >
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
