/ View Ticket
Login
Ticket UUID: d1d84037b90a44966c67827086526b3bdff22cba
Title: import doesn't work on attached databases due to unnecessary quoting
Status: Fixed Type: Feature_Request
Severity: Important Priority: Immediate
Subsystem: Shell Resolution: Fixed
Last Modified: 2011-09-28 01:11:07
Version Found In: 3.7.8
Description:
Trying to import to an attached database fails. This is because the code does this:
  sqlite3_mprintf("SELECT * FROM '%q'", zTable);
  sqlite3_snprintf(... "INSERT INTO '%q' VALUES(?", zTable);

If you put single quotes around a table name then database names within are not parsed.

  sqlite> attach '/tmp/foo' as foo;
  sqlite> create table foo.bar(x);
  sqlite> select * from foo.bar;
  sqlite> select * from 'foo.bar';
  SQLError: no such table: foo.bar

The code should not be using single quotes or SQLite should be changed to parse database names when single quotes are used.