On Tue, Apr 5, 2011 at 6:59 PM, Eric Promislow <eric.promis...@gmail.com>wrote:
> Notice the clause in the middle of the query: > and (substr(p2.path, length(p1.path) + 1, 1) = "/" > or substr(p2.path, length(p1.path) + 1, 1) != "/") > > If I comment out this full clause, the query returns the expected result > set. > > But if I leave it uncommented, the query returns an empty set. But the > clause > should be tautologically true -- either the character after the prefix is > "/" or it > isn't. > Can you please post values of p2.path and p1.path for which the above expression returns false? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
