You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The vsv extension seems to handle CSV data incorrectly for the first row if there are any empty column values in that row itself.
For example - save as mock_broken.csv:
a,b,c,d
,,,lastcol
foo,bar,baz,bill
and load as:
.load ./vsv
create virtual table tblfoo using vsv(
header=1,
filename='mock_broken.csv'
);
.headers on
select * from tblfoo
will yield:
a|b|c|d
lastcol|||
foo|bar|baz|bill
Note that if rows 2/3 are swapped in mock_broken.csv you get the correct result for the row with empty values and the lastcol value is in the 'd' column as it should be. So this is a bug specifically with the first row containing empty values for CSV parsing in the vsv extension.
The text was updated successfully, but these errors were encountered:
The vsv extension seems to handle CSV data incorrectly for the first row if there are any empty column values in that row itself.
For example - save as mock_broken.csv:
and load as:
will yield:
Note that if rows 2/3 are swapped in
mock_broken.csv
you get the correct result for the row with empty values and thelastcol
value is in the 'd' column as it should be. So this is a bug specifically with the first row containing empty values for CSV parsing in the vsv extension.The text was updated successfully, but these errors were encountered: