[sqlite] Shell .dump incorrectly quotes the table name in 3.7.11

[Martin]

Shell .dump command produces incorrect output when using keyword as a
table name.

Example:

SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE "table" ("column" TEXT);
sqlite> INSERT INTO "table" VALUES('value');
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE "table" ("column" TEXT);
INSERT INTO table VALUES('value');
COMMIT;

Reading this dump will cause a syntax error:

sqlite> .read dump.sql
Error: near line 4: near "table": syntax error

The table name in the insert statement is not properly quoted.
I think that this behavior is related to the change (3) at
http://www.sqlite.org/src/info/e6eea8d50d

Thanks

Martin
_______________________________________________
sqlite-users mailing list
sqlite...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users