Should be fixed on trunk.
On 4/7/17, Simon Slavin <slav...@bigfraud.org> wrote:
>
>> On 8 Apr 2017, at 12:44am, Tony Papadimitriou <to...@acm.org> wrote:
>>
>> So, please try this instead:
>>
>> sql xxx.db ".headers on" ".dump"
>
> sqlite> .headers on
> 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(time zone) VALUES('1');
> COMMIT;
> sqlite>
>
> Yes, you have isolated the problem. Without ".headers on" you get
>
> INSERT INTO xxx VALUES('1');
>
> But with ".headers on" you get
>
> INSERT INTO xxx(time zone) VALUES('1');
>
> However, it is not quoting the column name, so the command is invalid.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
