Hello! The problem is only with virtual tables. With ordinary tables "IN (...)" work fine:
sqlite> explain query plan select count(*) from data_content where rowid in (1); 0|0|TABLE data_content USING PRIMARY KEY CPU Time: user 0.004000 sys 0.000000 sqlite> select count(*) from data_content where rowid in (1); 1 CPU Time: user 0.000000 sys 0.000000 sqlite> Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users