MySQL 8.0.22 Bug #101504 对应解决思路

set session optimizer_switch='derived_merge=off';
SELECT a.*, b.* FROM            ( SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_ROWS FROM   information_schema.TABLES t           WHERE TABLE_SCHEMA NOT IN ('information_schema','performance_schema','mysql','sys') AND   TABLE_TYPE = 'BASE TABLE'  AND   TABLE_ROWS >= 10000 ) AS a                LEFT JOIN ( SELECT TABLE_SCHEMA,                     TABLE_NAME FROM   information_schema.TABLE_CONSTRAINTS c                      WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'                      ) AS b USING (TABLE_SCHEMA, TABLE_NAME)                           WHERE b.TABLE_NAME IS NULL             ORDER BY TABLE_ROWS DESC;ERROR 3566 (HY000): Access to native function 'internal_table_rows' is rejected.

set session optimizer_switch='derived_merge=off,derived_condition_pushdown=off';
SELECT a.*, b.* FROM( SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_ROWS FROM   information_schema.TABLES t           WHERE TABLE_SCHEMA NOT IN ('information_schema','performance_schema','mysql','sys') AND   TABLE_TYPE = 'BASE TABLE'  AND   TABLE_ROWS >= 10000 ) AS a                LEFT JOIN ( SELECT TABLE_SCHEMA,                     TABLE_NAME FROM   information_schema.TABLE_CONSTRAINTS c                      WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'                      ) AS b USING (TABLE_SCHEMA, TABLE_NAME)                           WHERE b.TABLE_NAME IS NULL             ORDER BY TABLE_ROWS DESC;+--------------+------------------+------------+--------------+------------+| TABLE_SCHEMA | TABLE_NAME       | TABLE_ROWS | TABLE_SCHEMA | TABLE_NAME |+--------------+------------------+------------+--------------+------------+| employees    | dept_emp2        |     331008 | NULL         | NULL       || employees    | emp2             |     299590 | NULL         | NULL       || employees    | salaries2        |    2837194 | NULL         | NULL       || employees    | salaries4_up_20w |     249796 | NULL         | NULL       || employees    | t11_1            |      99450 | NULL         | NULL       || employees    | t_group4         |    2615040 | NULL         | NULL       || employees    | t_group5         |    2165088 | NULL         | NULL       || test         | history          |      30020 | NULL         | NULL       |+--------------+------------------+------------+--------------+------------+