cannot load double quote(") character string

Setsu FUJITA

i have a csv file which made by sqlcl select /*csv*/ from test.

test.csv

 "FIRST","SECOND"
"""quote"" cannot load","second column"

load test test.csv command produces sql below

 INSERT INTO TEST(FIRST,SECOND)
VALUES ('""quote"" cannot load','second column');

expects

INSERT INTO TEST(FIRST,SECOND)
VALUES ('"quote" cannot load','second column');

Craig Elliott

This appears to be a bug.

create table test(first varchar(40), second varchar(40));

Table test created.

INSERT INTO TEST(FIRST,SECOND) VALUES ('"quote" cannot load','second column');

1 row inserted.

commit;

Commit complete.

set sqlformat

select * from test

"quote" cannot load                      second column                         

set sqlformat csv

select * from test

"FIRST","SECOND"

"""quote"" cannot load","second column"

spool test.csv

select * from test;

"FIRST","SECOND"

"""quote"" cannot load","second column"

spool off

load test test.csv

select * from test

"FIRST","SECOND"

"""quote"" cannot load","second column"

"""""quote"""" cannot load","second column"

set sqlformat

select * from test

"quote" cannot load                      second column                         

""quote"" cannot load                    second column