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
