Using SQLite 3.7.4 on Android. To reproduce:
create table S (id string, name string); create table F (id string, sid string); explain query plan select (select count(*) from F where F.sid=S.id) as FCount, S.name from S; Result: Empty cursor, with log showing: SqliteCursor.cpp Invalid statement in fillWindow() Just running the select, without explain query plan, seems to be OK. Could not find anything like this among existing bugs. Luke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
