On 5 Apr 2011, at 11:59pm, Eric Promislow 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.
Could you make us a demonstration sample ? Make a database with one row in and the simplest SELECT you can that gives one result on Windows and the other in Unix. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users