Menu

#1561 Issues with set table source parameters.. (ignore_first, fs , all_quoted etc..)

version 2.5.x
open-fixed
None
5
2019-10-24
2019-10-23
max jr.
No

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.

Discussion

  • Fred Toussi

    Fred Toussi - 2019-10-24

    Thanks for reporting.

    Fixed and committed to SVN trunk.

     
  • Fred Toussi

    Fred Toussi - 2019-10-24
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,26 +1,28 @@
     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>
    -> --
    -> 
    +
    +~~~
    
    + 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.
    
     

Log in to post a comment.

MongoDB Logo MongoDB