SQLite

Ticket Change Details
Login
Overview

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

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