Hello,
SQLite behaviour is consistent (temp database is searched first):
create table test (main text);
create temporary table test (temporary text);
insert into test values ('unqualified'); -- in temp table
select * from test; -- temp table
-- unqualified
pragma table_info("test"); -- temp table
-- 0|temporary|text|0||0But pragma documentation page is misleading: http://sqlite.org/pragma.html "A pragma may have an optional database name before the pragma name. The database name is the name of an ATTACH-ed database or it can be "main" or "temp" for the main and the TEMP databases. If the optional database name is omitted, "main" is assumed." pragma table_info("test"); -- is same as pragma temp.table_info("test"); -- and not: pragma main.table_info("test"); Regards. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
