/ Ticket Change Details

Artifact ID: 13db8a68b5ddf20232d7a40bc2ecc7994d0d8d7f
Ticket: dec444cd6817755b293558c79d55fabc227c0f09
rowid not usable in complex queries
User & Date: drh 2012-12-19 12:46:56

  1. Change icomment to:
    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.
  2. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change priority to "Immediate"
  5. Change resolution to "Not_A_Bug"
  6. Change status to "Closed"
  7. Change subsystem to "Unknown"