SQLite
View Ticket
Not logged in
Ticket UUID: c34d0557f740c450709d6e33df72d4f3f651a3cc
Title: Name resolution issue with WITHOUT ROWID
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-02-12 14:43:48
Version Found In: 3.8.3
User Comments:
drh added on 2014-02-12 14:11:16: (text/x-fossil-wiki)
The following SQL gives a "no such column" error while parsing the second
query:

<blockquote><verbatim>
CREATE TABLE t1(a PRIMARY KEY) WITHOUT ROWID;
INSERT INTO t1 VALUES('abc');
CREATE TABLE t2(x);
INSERT INTO t2 VALUES('xyz');
SELECT t2.rowid FROM t1, t2; -- works
SELECT t2.rowid FROM t2, t1; -- "no such column" error
</verbatim></blockquote>

Note that the error only arises if the second of the two tables in the
join is a WITHOUT ROWID table.