Hello there,
It seems text file interaction still requires refinement .. please see below..
sql> set table t1 source "soduc.csv;ignore_first=true";
sql> select count(*) from t1;
4321
sql> set table t1 source "soduc.csv;ignore_first=true;all_quoted=true";
sql> select count(*) from t1;
8642
sql> set table t1 source "soduc.csv;ignore_first=true";
sql> select count(*) from t1;
12963
sql> select count(*) from t1;
12963
sql> set table t1 source "soduc.csv;ignore_first=true";
sql> select count(*) from t1;
12963
sql> set table t1 source "soduc.csv;ignore_first=true;all_quoted=true";
sql> select count(*) from t1;
17284
sql>
Above file is not opened anywhere else. Just FYI.
Thanks for reporting.
Fixed and committed to SVN trunk.
Diff: