[sqlite] Unqualified table name and pragma

[gwenn]

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||0

But 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users