Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
13.1
-
None
-
Not for Release Notes
Description
PROCEDURE ANALYSE() is silently ignored on INFORMATION_SCHEMA.TABLES
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='user' PROCEDURE ANALYSE(); |
CLI Output
13.1.0-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='user' PROCEDURE ANALYSE(); |
+------------+ |
| TABLE_NAME |
|
+------------+ |
| user | |
+------------+ |
1 row in set (0.000 sec) |
|
|
13.1.0-opt>
|
Expected output
13.1.1-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='user' PROCEDURE ANALYSE(); |
+--------------------------------------+-----------+-----------+------------+------------+------------------+-------+-------------------------+------+-----------------------+ |
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|
+--------------------------------------+-----------+-----------+------------+------------+------------------+-------+-------------------------+------+-----------------------+ |
| information_schema.TABLES.TABLE_NAME | user | user | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('user') NOT NULL | |
+--------------------------------------+-----------+-----------+------------+------------+------------------+-------+-------------------------+------+-----------------------+ |
1 row in set (0.001 sec) |
|
|
13.1.1-opt>
|
Attachments
Issue Links
- blocks
-
MDEV-31342 I_S optimization: avoid temp table
-
- In Testing
-