1# 2# MDEV-9538 Server crashes in check_show_access on SHOW STATISTICS 3# MDEV-9539 Server crashes in make_columns_old_format on SHOW GEOMETRY_COLUMNS 4# MDEV-9540 SHOW SPATIAL_REF_SYS and SHOW SYSTEM_VARIABLES return empty results with numerous warnings 5# 6show statistics; 7ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'statistics' at line 1 8show spatial_ref_sys 9--error ER_PARSE_ERROR 10show system_variables; 11ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'spatial_ref_sys 12--error ER_PARSE_ERROR 13show system_variables' at line 2 14show geometry_columns; 15ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'geometry_columns' at line 1 16show nonexistent; 17ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nonexistent' at line 1 18# 19# MDEV-21603 Crashing SHOW TABLES with derived table in WHERE condition 20# 21create table t1 (nm varchar(32), a int); 22insert t1 values ('1',1),('2',2),('3',3); 23show tables 24where tables_in_test in (select * 25from (select nm from test.t1 group by nm) dt); 26Tables_in_test 27show fields from test.t1 28where field in (select * from (select nm from test.t1 group by nm) dt); 29Field Type Null Key Default Extra 30insert t1 values ('nm',0); 31show fields from test.t1 32where field in (select * from (select nm from test.t1 group by nm) dt); 33Field Type Null Key Default Extra 34nm varchar(32) YES NULL 35show fields from test.t1 where field in 36(select * from (select column_name from information_schema.columns 37where table_name='t1' group by column_name) dt); 38Field Type Null Key Default Extra 39nm varchar(32) YES NULL 40a int(11) YES NULL 41drop table t1; 42# 43# MDEV-4621 select returns null for information_schema.statistics.collation field 44# 45create table t1 (f varchar(64), key(f)); 46select index_name, column_name, collation, cardinality from information_schema.STATISTICS where table_schema='test' and table_name='t1'; 47index_name column_name collation cardinality 48f f A NULL 49select index_name, column_name, collation from information_schema.STATISTICS where table_schema='test' and table_name='t1'; 50index_name column_name collation 51f f A 52drop table t1; 53# 54# End of 10.2 tests 55# 56