Hi,
INSERT INTO "foobar" SELECT * FROM CSVREAD('foobar.csv') tries to insert
values from CSV rows to wrong table columns when table and CSV column order
doesn't match. CSV has the column header row and it seems to be interpreted
at Function#getValueForColumnList
INSERT INTO "foobar" ("foo", "bar") SELECT * FROM CSVREAD('foobar.csv')
fixed the issue when CSV column order is bar,foo
I was wondering if there is a way to circumvent the need specify the
columns. I really can't reorder neither the CSV not the table columns
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
