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
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
