[sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

[Justin Ng]

I just encountered something weird with "temp" and "sqlite_master".
I was wondering if it was another bug, or intentional.

-----

This throws a "column not found" error,

SELECT
    sqlite_master.sql
FROM
    temp.sqlite_master;

-----

This throws a "column not found" error,

SELECT
    temp.sqlite_master.sql
FROM
    temp.sqlite_master;

-----

This works fine,

SELECT
    x.sql
FROM
    temp.sqlite_master AS x;

-----

Referring to temp.sqlite_master columns directly in the WHERE clause also 
causes the error.
I assume it's the same for every other part of a query.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users