Details
-
Type:
Bug
-
Status: Closed
-
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
This was concerning all Multiple and Compressed tables, not only CSV.
Fixed by raising an error when trying to index a table not indexable because it is Multiple or Compressed.