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

Odd fnx error when creating CSV tables with index

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.10
    • Fix Version/s: 10.0.11
    • Component/s: None
    • Labels:
    • Environment:
      CentOS 6.5, MariaDB 10 from the repository provided at downloads.mariadb.org

      Description

      CSV files are simple:

      test1.csv
      test;2342

      test2.csv
      test2;34134

      MariaDB [cleanconnect]> CREATE TABLE `test_all` (
          ->   name varchar(10) not NULL,
          ->   price bigint
          -> ) ENGINE=CONNECT 
          -> DEFAULT CHARSET=utf8 
          -> `table_type`=CSV 
          -> `file_name`='/tmp/test*.csv' 
          -> `sep_char`=';' `compress`=0 `multiple`=1;
      Query OK, 0 rows affected (0.02 sec)

      MariaDB [cleanconnect]> CREATE TABLE `test_all2` (
          ->   name varchar(10) not NULL,
          ->   price bigint,
          ->   key (name)
          -> ) ENGINE=CONNECT 
          -> DEFAULT CHARSET=utf8 
          -> `table_type`=CSV 
          -> `file_name`='/tmp/test*.csv' 
          -> `sep_char`=';' `compress`=0 `multiple`=1;
      Query OK, 0 rows affected, 1 warning (0.00 sec)
       
      MariaDB [cleanconnect]> show warnings;
      +---------+------+-----------------------------+
      | Level   | Code | Message                     |
      +---------+------+-----------------------------+
      | Warning | 1105 | This table is not indexable |
      +---------+------+-----------------------------+
      1 row in set (0.00 sec)

      MariaDB [cleanconnect]> select count(*) from test_all;
      +----------+
      | count(*) |
      +----------+
      |        2 |
      +----------+
      1 row in set (0.00 sec)
       
      MariaDB [cleanconnect]> select count(*) from test_all2;
      ERROR 1296 (HY000): Got error 122 'Open error 2 in mode rb on /tmp/test*.fnx: No such file or directory' from CONNECT

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            colin Colin Charles
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration