Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.10
-
None
-
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 |