450769 - pragma table_info does not support database-name.table-name argument

Status: RESOLVED INVALID

(Core :: SQLite and Embedded Database Bindings, defect)

Description

[lazierthanthou]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1

This is needed to specify the table correctly in a scenario where more than one table with same name exist in the main db and the attached db(s)

Reproducible: Always

Steps to Reproduce:
1. Connect to a sqlite db, 
2. then attach another db as "att", say. Suppose the attached db has a table "t1".
3. execute the following query:
pragma table_info("att"."t1")

Actual Results:  
The following error is reported on executing the pragma query:
near ".": syntax error

Expected Results:  
We should see the info from the specified tablename from the specified attached dbname. This is essential when the table name t1 may occur in the main db or another attached db too.

Observed in sqlite 3.5.9 in Gecko 1.9.0.1

Comment 1

[lazierthanthou]

The same problem occurs with the following pragma queries too:
PRAGMA index_list
PRAGMA index_info
PRAGMA foreign_key_list

Comment 2

[lazierthanthou]

OK. This is not a bug. Got the following response from the sqlite users mailing list:
Try PRAGMA [database.]table_info(table-name);

Most other databse specific PRAGMAs support the
databasealias. prefix, so does this one, although it isn't
documented in http://www.sqlite.org/pragma.html#schema.

It works.

So, this bug should be treated as INVALID.