On Thu, Sep 25, 2014 at 5:58 PM, Hody Crouch <hody.cro...@gmail.com> 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
