1 files changed, 7 insertions, 8 deletions
diff --git a/mysql-test/t/stat_tables_innodb.test b/mysql-test/t/stat_tables_innodb.test
index e4a11955aba..008ca6911e9 100644
--- a/mysql-test/t/stat_tables_innodb.test
+++ b/mysql-test/t/stat_tables_innodb.test
@@ -1,4 +1,5 @@
 --source include/have_innodb.inc
+--source include/have_sequence.inc
 
 SET SESSION STORAGE_ENGINE='InnoDB';
 
@@ -13,21 +14,19 @@ set optimizer_switch=@save_optimizer_switch_for_stat_tables_test;
 --echo # MDEV-22851: Engine independent index statistics are incorrect for large tables on Windows.
 --echo #
 
-CREATE TABLE t1 AS SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.COLUMNS;
-INSERT INTO t1 SELECT * FROM t1;
-INSERT INTO t1 SELECT * FROM t1;
-INSERT INTO t1 SELECT * FROM t1;
-INSERT INTO t1 SELECT * FROM t1;
-INSERT INTO t1 SELECT * FROM t1;
+CREATE TABLE t1(a INT) ENGINE=INNODB;
+INSERT INTO t1 SELECT 1 FROM seq_1_to_60000;
 
 SET @save_use_stat_tables= @@use_stat_tables;
 SET use_stat_tables= preferably;
 SELECT count(*) FROM t1;
-CREATE INDEX idx ON t1(TABLE_CATALOG);
-ANALYZE TABLE t1 PERSISTENT FOR COLUMNS (TABLE_CATALOG) INDEXES (idx);
+CREATE INDEX idx ON t1(a);
+ANALYZE TABLE t1 PERSISTENT FOR COLUMNS (a) INDEXES (idx);
 SELECT * FROM mysql.index_stats where table_name='t1';
 SELECT * FROM mysql.column_stats where table_name='t1';
 SET use_stat_tables= @save_use_stat_tables;
 DROP TABLE t1;
 
+--echo # end of 10.1 tests
+
 SET SESSION STORAGE_ENGINE=DEFAULT;