[h2] How to enforce CSV column order with INSERT INTO / CSVREAD command

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)

Re: [h2] How to enforce CSV column order with INSERT INTO / CSVREAD command

Hi, In my project we use H2 table functions to read data from other databases. I found out that H2 calls our table functions more often than expected, which can lead to serious performance problems if the execution of the SQL from the other database is quite expensive. The sample code below