SQLite
Ticket Change Details
Not logged in
Overview

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

  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"