Test code is provided below. If you change the sql query to include 'val2
= ?' rather than 'val2 LIKE ?', you will see trace output.
#include <stdio.h>
#include <stdlib.h>
#include "sqlite3.h"
static void trace_callback( void* udp, const char* sql ) {
printf("TRACE: %s\n", sql);
};
int main(int argc, char* argv[])
{
sqlite3 *db;
char *sql;
sqlite3_open("test.db", &db);
// Enable tracing
sqlite3_trace(db, trace_callback, 0);
sql = "SELECT val1, val2 from t where val2 LIKE ?";
sqlite3_stmt* statement = NULL;
sqlite3_prepare_v2(db, sql, -1, &statement, NULL);
sqlite3_bind_text(statement, 1, "A%", -1, NULL);
sqlite3_step(statement);
sqlite3_close(db);
return 0;
}
On Fri, Sep 26, 2014 at 6:20 PM, Richard Hipp <[email protected]> wrote:
> On Thu, Sep 25, 2014 at 5:58 PM, Hody Crouch <[email protected]>
> wrote:
>
> > While using sqlite3 with node, I used trace and found that a specific
> query
> > did not result in a callback invocation. I have only seen this behavior
> if
> > all of the following conditions are met:
> > - sql query includes 'LIKE ?'
> > - prepare the query
> > - bind a parameter
> > - execute the query
> >
>
> I am unable to reproduce the problem. Please send more hints. Perhaps
> send source code.
>
>
> >
> > If I change the query to use '=' instead of 'LIKE', the trace callback is
> > invoked as expected.
> >
> > I looked at http://www.sqlite.org/src/info/11d5aa455e0d98f3c1e6a08 in
> > hopes
> > that this issue might be resolved. Using
> sqlite-amalgamation-201409200035
> > and a test app in c, the issue is still reproducible.
> >
> > Test table schema: CREATE TABLE t (val1 TEXT, val2 TEXT);
> >
> > Query to reproduce the issue:
> > SELECT val1, val2 from t where val2 LIKE ?
> >
> > The description of the ticket I mentioned seems similar, but I don't know
> > enough about the sqlite3 inner workings to offer much more than the above
> > report. Let me know if you need to see the test app as well.
> >
> > Thanks.
> > _______________________________________________
> > sqlite-users mailing list
> > [email protected]
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> [email protected]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
