Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7030

CONNECT Engine: Errors in Path Substitution, when using file_name option

Details

    Description

      I tried Mariadb 10.0.14 and 10.1.1 on Windows 7
      i want to read a csv file via CONNECT Engine , but i couldn't specify a correct Path for the file.
      The ouput of my tests:

      D:\Maria\TEST>dir
      		 
       
      		 
      23.10.2014  15:42    <DIR>          .
      		 
      23.10.2014  15:42    <DIR>          ..
      		 
      22.10.2014  11:56             3.484 F80_wochenverlauf.csv
      		 
      23.10.2014  15:42               616 testcsv.sql
      		 

      create table shu.csvtest ( 
        KALWOCHE char(8) NOT NULL,
      		 
        SUMME    int(7) NOT NULL,
      		 
        AVGDAY    int(6) NOT NULL,
      		 
        AVGHOUR   int(6) NOT NULL,    
        MAXPERHOUR int(6) NOT NULL,
      		 
        AVGTIME    double  NOT NULL,
      		 
        DAYS       int NOT NULL             
      ) engine=CONNECT table_type=CSV file_name="D:\Maria\TEST\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 

      select * from shu.csvtest;
      		 
      -> Open(rt) error 2 on D:MariaTESTF80_wochenverlauf.csv: No such file or directory
      		 

      ) engine=CONNECT table_type=CSV file_name='D:\\Maria\\TEST\\F80_wochenverlauf.csv' header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
      		 

      ) engine=CONNECT table_type=CSV file_name='D:/Maria/TEST/F80_wochenverlauf.csv' header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
      		 

      ) engine=CONNECT table_type=CSV file_name="\\Maria\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */
      		 

      ) engine=CONNECT table_type=CSV file_name="\Maria\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      Open(rt) error 2 on D:\Maria\data\shu\Maria\TEST\F80_wochenverlauf.csv: No such file or directory
      		 

      ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\..\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      Open(rt) error 2 on D:\Maria\data\TEST\F80_wochenverlauf.csv: No such file or directory
      		 

      ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\..\\..\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */

      Next try: copying the file to DATA_DIR:

      D:\Maria\data\shu>dir
      		 
       
      		 
      06.11.2014  08:54    <DIR>          .
      		 
      06.11.2014  08:54    <DIR>          ..
      		 
      23.10.2014  07:56                61 db.opt
      		 
      24.10.2014  11:56             3.484 F80_wochenverlauf.csv
      		 

      ) engine=CONNECT table_type=CSV file_name='F80_wochenverlauf.csv' header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */
      		 

      ) engine=CONNECT table_type=CSV file_name='.\F80_wochenverlauf.csv' header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      Open(rt) error 2 on D:\Maria\data\shu\.F80_wochenverlauf.csv: No such file or directory
      		 

      ) engine=CONNECT table_type=CSV file_name="..\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
      		 

      ) engine=CONNECT table_type=CSV file_name="\Maria\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from shu.csvtest;
      		 
      Open(rt) error 2 on D:\Maria\data\shu\Maria\F80_wochenverlauf.csv: No such file or directory
      		 

      ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from csvtest;
      		 
      /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */
      		 

       engine=CONNECT table_type=CSV file_name="\\F80_wochenverlauf.csv" header=0 sep_char=';';
      		 
      select * from csvtest;
      		 
      Open(rt) error 2 on D:\F80_wochenverlauf.csv: No such file or directory

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          matthias Schumacher created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Description I tried Mariadb 10.0.14 and 10.1.1 on Windows 7
          i want to read a csv file via CONNECT Engine , but i couldn't specify a correct Path for the file.
          The ouput of my tests:
          D:\Maria\TEST>dir

          23.10.2014 15:42 <DIR> .
          23.10.2014 15:42 <DIR> ..
          22.10.2014 11:56 3.484 F80_wochenverlauf.csv
          23.10.2014 15:42 616 testcsv.sql




          create table shu.csvtest (
            KALWOCHE char(8) NOT NULL,
            SUMME int(7) NOT NULL,
            AVGDAY int(6) NOT NULL,
            AVGHOUR int(6) NOT NULL,
            MAXPERHOUR int(6) NOT NULL,
            AVGTIME double NOT NULL,
            DAYS int NOT NULL
          ) engine=CONNECT table_type=CSV file_name="D:\Maria\TEST\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          -> Open(rt) error 2 on D:MariaTESTF80_wochenverlauf.csv: No such file or directory

          ) engine=CONNECT table_type=CSV file_name='D:\\Maria\\TEST\\F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */

          ) engine=CONNECT table_type=CSV file_name='D:/Maria/TEST/F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */

          ) engine=CONNECT table_type=CSV file_name="\\Maria\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */

          ) engine=CONNECT table_type=CSV file_name="\Maria\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\shu\Maria\TEST\F80_wochenverlauf.csv: No such file or directory

          ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\..\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\TEST\F80_wochenverlauf.csv: No such file or directory

          ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\..\\..\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */

          Next try: copying the file to DATA_DIR:
          D:\Maria\data\shu>dir
           
          06.11.2014 08:54 <DIR> .
          06.11.2014 08:54 <DIR> ..
          23.10.2014 07:56 61 db.opt
          24.10.2014 11:56 3.484 F80_wochenverlauf.csv

          ) engine=CONNECT table_type=CSV file_name='F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */

          ) engine=CONNECT table_type=CSV file_name='.\F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\shu\.F80_wochenverlauf.csv: No such file or directory

          ) engine=CONNECT table_type=CSV file_name="..\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */

          ) engine=CONNECT table_type=CSV file_name="\Maria\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\shu\Maria\F80_wochenverlauf.csv: No such file or directory

          ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */

          ) engine=CONNECT table_type=CSV file_name="\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          Open(rt) error 2 on D:\F80_wochenverlauf.csv: No such file or directory

          		 I tried Mariadb 10.0.14 and 10.1.1 on Windows 7
          i want to read a csv file via CONNECT Engine , but i couldn't specify a correct Path for the file.
          The ouput of my tests:
          {noformat}
          D:\Maria\TEST>dir

          23.10.2014 15:42 <DIR> .
          23.10.2014 15:42 <DIR> ..
          22.10.2014 11:56 3.484 F80_wochenverlauf.csv
          23.10.2014 15:42 616 testcsv.sql
          {noformat}
          {noformat}
          create table shu.csvtest (
            KALWOCHE char(8) NOT NULL,
            SUMME int(7) NOT NULL,
            AVGDAY int(6) NOT NULL,
            AVGHOUR int(6) NOT NULL,
            MAXPERHOUR int(6) NOT NULL,
            AVGTIME double NOT NULL,
            DAYS int NOT NULL
          ) engine=CONNECT table_type=CSV file_name="D:\Maria\TEST\F80_wochenverlauf.csv" header=0 sep_char=';';
          {noformat}
          {noformat}
          select * from shu.csvtest;
          -> Open(rt) error 2 on D:MariaTESTF80_wochenverlauf.csv: No such file or directory
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name='D:\\Maria\\TEST\\F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name='D:/Maria/TEST/F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="\\Maria\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="\Maria\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\shu\Maria\TEST\F80_wochenverlauf.csv: No such file or directory
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\..\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\TEST\F80_wochenverlauf.csv: No such file or directory
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\..\\..\\TEST\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
          {noformat}
          Next try: copying the file to DATA_DIR:
          {noformat}
          D:\Maria\data\shu>dir

          06.11.2014 08:54 <DIR> .
          06.11.2014 08:54 <DIR> ..
          23.10.2014 07:56 61 db.opt
          24.10.2014 11:56 3.484 F80_wochenverlauf.csv
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name='F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name='.\F80_wochenverlauf.csv' header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\shu\.F80_wochenverlauf.csv: No such file or directory
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="..\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: Bad file descriptor' from CONNECT */
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="\Maria\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from shu.csvtest;
          Open(rt) error 2 on D:\Maria\data\shu\Maria\F80_wochenverlauf.csv: No such file or directory
          {noformat}
          {noformat}
          ) engine=CONNECT table_type=CSV file_name="\Maria\\..\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          /* SQL Fehler (1296): Got error 122 'ftell error for recd=0: No such file or directory' from CONNECT */
          {noformat}
          {noformat}
           engine=CONNECT table_type=CSV file_name="\\F80_wochenverlauf.csv" header=0 sep_char=';';
          select * from csvtest;
          Open(rt) error 2 on D:\F80_wochenverlauf.csv: No such file or directory
          {noformat}
          serg Sergei Golubchik made changes -
          Assignee Olivier Bertrand [ bertrandop ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0 [ 16000 ]
          bertrandop Olivier Bertrand made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          bertrandop Olivier Bertrand made changes -
          Fix Version/s 10.0.15 [ 17300 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 58216 ] MariaDB v3 [ 65022 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 65022 ] MariaDB v4 [ 148419 ]

          People

            bertrandop Olivier Bertrand
            matthias Schumacher
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.