Hello! I've found a bug in execution queries like this: SELECT ... FROM table T JOIN table2 T2 ON T2.child=T.master WHERE T2.attr in(SELECT value FROM table3 T3 JOIN (SELECT group, MAX(value) FROM table4 T4 WHERE T4.date_value<=T2.date_value GROUP BY group) G ON G.group=T3.group) Such queries returns empty resultset because of invalid evaluation WHERE T4.date_value<=T2.date_value. It seems that SQLite evaluates WHERE T4.date_value<=null in fact. If we replace "WHERE T4.date_value<=T2.date_value" with "WHERE T4.date_value<=<const value>" everything will be okey.
Sincerely Yours, Wadim Smirnov System architect Positive Technologies CJSC, Russia _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users