dolt
dolt copied to clipboard
Dolt table importing csv using UTF-8 with BOM encoding prepends BOM (U+FEFF) to first column's name
Found the error while importing a UTF-8 with BOM encoding CSV file using:
dolt table import -c
I selected the first column of the file and received an error:
$ dolt sql -q "SELECT col1 from bom_b;"
error on line 1 for query SELECT col1 from bom_b: column "col1" could not be found in any table in scope
column "col1" could not be found in any table in scope
Splunk reveals that the column name is \ufeffcol1
You can download the file here: https://drive.google.com/file/d/1uGGIsRZQg6g_rrG8ke9QYjQ0lPQPQ0Iy/view?usp=sharing