Subqueries do not (necessarily) have rowids.  This is not a bug.

You should not use rowids.  If you want an integer primary key, then declare
one as part of your schema and use that instead.  Rowids are an example of the
implementation showing through into the interface and should be avoided
in all applications.