this actually only aesthetic issue, here we have an empty headerless csv file with zero bytes size
when we issue select to this empty file, hxtt will return empty resultset with predefined 25 columns (column1 to column25)
the test query is:
select column1 as id, column26 as my_column from empty.csv
this csv file is generated by other program, and normally have about 150 columns, so when the file is empty, the query will return error "Invalid column or variable: column26"
is it possible to make the resultset column definition (ResultSet.getMetaData().getColumnLabel) matches the query so this error does not happen ?
_CSV_ColumnCount4EmptyFile: To specify the default column count for an empty text file without header information and data rows. Default: 25
You can use _CSV_ColumnCount4EmptyFile=150 connection property.