Multiple File Tables MariaDB -

i'm running mariadb (10.0.2-mariadb) on centos 6.4 , use mariadb's connect-engine read log files. since log files way big recreated error 2 csv files consisting of 1 line each.

mariadb [jedi]> create table test1 ( char(10), b char(10) ) engine=connect table_type=csv file_name='/tmp/test1.csv' sep_char=';' compress=0 multiple=0; query ok, 0 rows affected (0.00 sec)  mariadb [jedi]> create table test2 ( char(10), b char(10) ) engine=connect table_type=csv file_name='/tmp/test2.csv' sep_char=';' compress=0 multiple=0; query ok, 0 rows affected (0.01 sec)  mariadb [jedi]> select * test1; +------+------+ |    | b    | +------+------+ | test | bla  | +------+------+ 1 row in set (0.00 sec)  mariadb [jedi]> select * test2; +-------+------+ |     | b    | +-------+------+ | test2 | blub | +-------+------+ 1 row in set (0.00 sec) 

now interesting feature merge these files 1 table, should possible (says https://kb.askmonty.org/en/connect-table-types-data-files/#multiple-file-tables).

but if it:

mariadb [jedi]> create table test_all ( char(10), b char(10) ) engine=connect table_type=csv file_name='/tmp/test*.csv' sep_char=';' compress=0 multiple=1; query ok, 0 rows affected (0.00 sec)  mariadb [jedi]> select * test_all; error 2013 (hy000): lost connection mysql server during query 

does know explanation? never mind "compress=0", tested reading gzipped files, works charme... until try read 2 files 1 table.

thanks, jens

this bug in mariadb 10.0.2 fixed in 10.0.3 (the corresponding ticket says 10.0.4 error not happen anymore 10.0.3).