Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
1.1.6
-
None
Description
There was a one varchar(79) column table that was populated with cpimport. Every time I insert 7500000 records. I measured a number of segment files existed in the installation. Then I run DELETE from table_name and measued number of files again. Inserted another 7500000 records and measured the number of segment files. The number monotonically increased. Here is the bash log
MariaDB [test]> create table `cs27`(`o_comment` varchar(79) default null) engine=columnstore default charset=latin1;
|
Query OK, 0 rows affected (0.86 sec)
|
|
|
root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
|
43
|
|
|
root@c983d37cec14:/# for i in $(seq 1 5); do cpimport -s '|' test cs27 /git/orders_rows.tbl; done
|
|
|
root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
|
45
|
|
|
MariaDB [test]> delete from cs27;
|
Query OK, 7500000 rows affected (19.31 sec)
|
|
|
root@c983d37cec14:/# for i in $(seq 1 5); do cpimport -s '|' test cs27 /git/orders_rows.tbl; done
|
|
|
root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
|
47
|