Dan, thanks for that. That certainly is the issue. When I take out the ORs, we're all good. The current version of Firefox / SQLite Manager is using the old version. I'll have to recompile my project with the latest. Anyone know of a better SQLite analyzer? I switched over to the command line for now. Thanks, folks. Resolved.
On Thu, Jul 11, 2013 at 9:27 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 07/11/2013 08:21 PM, Igor Tandetnik wrote: > >> On 7/11/2013 9:19 AM, Igor Tandetnik wrote: >> >>> On 7/10/2013 1:30 PM, compscilaw . wrote: >>> >>>> The correct result is one row; SQLite returns all rows. >>>> >>> >>> I'm getting three rows (with program_id of 4, 5 and 6), which looks >>> correct to me. Why do you expect one row? >>> >> >> Note that I'm using the script and query embedded directly into your >> original post. I didn't follow your links. >> > > The linked sqlfiddle pages have an extra row in whitelist > that matches 4 and 5. > > The bug was fixed for 3.7.17. It's this one: > > > http://www.sqlite.org/src/**info/f2369304e47167e3e<http://www.sqlite.org/src/info/f2369304e47167e3e> > > > Dan. > > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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
