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