[MDEV-9540] SHOW SPATIAL_REF_SYS and SHOW SYSTEM_VARIABLES return empty results with numerous warnings Created: 2016-02-09  Updated: 2016-02-23  Resolved: 2016-02-23

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 10.1
Fix Version/s: 10.1.12

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9538 Server crashes in check_show_access o... Closed
relates to MDEV-9539 Server crashes in make_columns_old_fo... Closed
Sprint: 10.1.12

 Description    

MariaDB [test]> SHOW SYSTEM_VARIABLES;
 
Query OK, 0 rows affected, 18515 warnings (0.02 sec)
 
 
 
MariaDB [(none)]> show warnings;
 
ERROR 2006 (HY000): MySQL server has gone away
 
No connection. Trying to reconnect...
 
Connection id:    6
 
Current database: *** NONE ***
 
 
 
Empty set (0.00 sec)
 
 
 
MariaDB [(none)]> select @@max_allowed_packet;
 
+----------------------+
 
| @@max_allowed_packet |
 
+----------------------+
 
|           1073741824 |
 
+----------------------+
 
1 row in set (0.00 sec)

Same for SHOW SPATIAL_REF_SYS.
Generated at Thu Feb 08 07:35:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.