EVOLUTION-MANAGER

Edit File: archive_eits.test

-- source include/have_archive.inc --disable_warnings drop table if exists t1; --enable_warnings --echo # --echo # MDEV-17297: stats.records=0 for a table of Archive engine when it has rows, when we run ANALYZE command --echo # CREATE TABLE t1 (fid INTEGER PRIMARY KEY AUTO_INCREMENT, g POINT)engine=archive; INSERT INTO t1 VALUES (101, PointFromText('POINT(10 10)')), (102, PointFromText('POINT(20 10)')), (103, PointFromText('POINT(20 20)')), (104, PointFromWKB(AsWKB(PointFromText('POINT(10 20)')))); set @tmp1= @@optimizer_use_condition_selectivity; set @tmp2= @@use_stat_tables; set optimizer_use_condition_selectivity=4; set use_stat_tables=PREFERABLY; ANALYZE TABLE t1; select * from mysql.table_stats where table_name='t1' and db_name=database(); drop table t1; set optimizer_use_condition_selectivity=@tmp1; set use_stat_tables=@tmp2;