I'll file a bug on this. Anyone know how to file a bug such that the formating isn't smushed into a single line?

Output from CSV mode is not properly quoted.  An example (from sqlite3):

    sqlite> .mode csv
    sqlite> .header on
    sqlite> create table "Foo" ( foo, bar );
    sqlite> insert into "Foo" values ( 1, 2 );
    sqlite> insert into "Foo" values ( 3, 4 );
    sqlite> insert into "Foo" values ( "5,6", "7,8 ""9" );
    sqlite> select * from "Foo";
    foo,bar
    1,2
    3,4
    5,6,7,8 "9

The last line of output isn't correct.  It should be quoted as

    "5,6","7,8 ""9"

instead. It would also be correct to fully quote everything.

Reply via email to