Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dolt table importing csv using UTF-8 with BOM encoding prepends BOM (U+FEFF) to first column's name #3790

Closed
druvv opened this issue Jul 11, 2022 · 1 comment · Fixed by #4285
Assignees
Labels
bug Something isn't working cli

Comments

@druvv
Copy link
Contributor

druvv commented Jul 11, 2022

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

@druvv druvv changed the title Dolt table importing file with UTF-8 with BOM encoding prepends BOM (U+FEFF) to first column's name Dolt table importing csv using UTF-8 with BOM encoding prepends BOM (U+FEFF) to first column's name Jul 11, 2022
@fulghum fulghum added the bug Something isn't working label Jul 11, 2022
@timsehn timsehn added the cli label Aug 31, 2022
@jycor
Copy link
Contributor

jycor commented Sep 7, 2022

Fix has been merged to main

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working cli
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants