Overview
Artifact ID: | 13db8a68b5ddf20232d7a40bc2ecc7994d0d8d7f |
---|---|
Ticket: | dec444cd6817755b293558c79d55fabc227c0f09
rowid not usable in complex queries |
User & Date: | drh 2012-12-19 12:46:56 |
Changes
- 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.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- priority changed to: "Immediate"
- resolution changed to: "Not_A_Bug"
- status changed to: "Closed"
- subsystem changed to: "Unknown"