Re: [sqlite] Bug? "no such column" referring to a table by name, works by alias

Quoth Igor Tandetnik , on 2010-09-24 08:16:07 -0400: > sqlite> create table A (id integer primary key); > sqlite> create table B (id integer primary key, name text); > sqlite> select * from A as X order by (select name from B where B.id = A.id); > Error: no such column: A.id > sqlite> select * from

[sqlite] Bug? "no such column" referring to a table by name, works by alias

Consider this SQLite session: sqlite> create table A (id integer primary key); sqlite> create table B (id integer primary key, name text); sqlite> select * from A as X order by (select name from B where B.id = A.id); Error: no such column: A.id sqlite> select * from A as X order by (select name fr