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
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users