A mtr test
--source include/have_archive.inc
|
CREATE TABLE gis_point (fid INTEGER PRIMARY KEY AUTO_INCREMENT, g POINT)engine=archive;
|
INSERT INTO gis_point VALUES
|
(101, PointFromText('POINT(10 10)')),
|
(102, PointFromText('POINT(20 10)')),
|
(103, PointFromText('POINT(20 20)')),
|
(104, PointFromWKB(AsWKB(PointFromText('POINT(10 20)'))));
|
set @@optimizer_use_condition_selectivity=4;
|
set @@use_stat_tables=PREFERABLY;
|
ANALYZE TABLE gis_point;
|
explain select * from gis_point;
|
+----+-------------+----------+--------+----------------+------+---------+-------+-------+----------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+----+-------------+----------+--------+----------------+------+---------+-------+-------+----------+
|
| 1 | SIMPLE | gis_point| ALL | NULL | NULL | NULL | NULL | 0 | |
|
+----+-------------+----------+--------+---------------------------------+-------+-------+----------+
|
select * from mysql.table_stats;
|
db_name table_name cardinality
|
test gis_point 0
|
After debugging I see, when we enter the function collect_statistics_for_table , for archive engine we get HA_ERR_END_OF_FILE when we start reading the rows, as stats.records = 0
Bug
Major
MDEV-15253 Default optimizer setting changes for MariaDB 10.4
