sub sk79 <subs...@gmail.com> wrote: > select * from (select * from names, friends where first_name = fname) > where _rowid_ < 2; > > Above query works - which _rowid_ is this accessing?
Well, define "works". In my experiments, _rowid_ is NULL for all rows in the subselect: select typeof(_rowid_) from (select * from names, friends where first_name = fname); But the fact that this statement compiles at all looks like a bug to me (though a very minor and unimportant one). Now, why do you care about these corner cases? Do you have a practical problem you are trying to solve? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
