On Tue, Apr 5, 2011 at 6:59 PM, Eric Promislow <[email protected]>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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
