SQLite nowhere guarantees or even suggests that subqueries have rowids. In fact, they might or they might not, depending what query plan the optimizer chooses. The optimizer was improved between 3.7.13 and 3.7.14, resulting in a new query plan that does not have a rowid. This is not a bug. -- D. Richard Hipp [email protected]
