On 7 Apr 2017, at 11:02pm, Richard Hipp <d...@sqlite.org> wrote:
> On 4/7/17, Tony Papadimitriou <to...@acm.org> wrote:
>> The following dump cannot be used to rebuild the database because the column
>> name is not properly quoted giving an error.
>>
>> To reproduce:
>>
>> sql xxx.db "CREATE TABLE xxx(`time zone`)" "insert into xxx values('1')"
>> sql .dump xxx.db | sql
>
> I'm unable to repro.
I notice that the command on those lines is "sql" rather than the "sqlite3" I
would expect. Tony, do you get the same error if you type those things into
the SQLite3 shell, rather than feeding them in using your command shell ? It
works fine for me. If not, what shell are you using ?
179:sqlite-tools-osx-x86-3180000 simon$ ./sqlite3
SQLite version 3.18.0 2017-03-28 18:48:43
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE xxx(`time zone`);
sqlite> insert into xxx values('1');
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE xxx(`time zone`);
INSERT INTO xxx VALUES('1');
COMMIT;
sqlite>
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
