strongduanmu commented on issue #12803:
URL: 
https://github.com/apache/shardingsphere/issues/12803#issuecomment-931196702


   At present, the result of executing `show table status` through the proxy is 
wrong, and the kernel needs to support this statement.
   
   ```sql
   mysql> show table status;
   +----------------+
   | Name           |
   +----------------+
   | t_order_item_0 |
   | t_order        |
   | t_order_item_1 |
   | t_order_0      |
   | t_order_1      |
   | t2             |
   +----------------+
   6 rows in set (18.20 sec)
   ```
   
   The correct result should be:
   
   | Name | Engine | Version | Row\_format | Rows | Avg\_row\_length | 
Data\_length | Max\_data\_length | Index\_length | Data\_free | Auto\_increment 
| Create\_time | Update\_time | Check\_time | Collation | Checksum | 
Create\_options | Comment |
   | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- 
| :--- | :--- | :--- | :--- | :--- | :--- | :--- |
   | t\_order | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 
2021-09-30 08:37:24 | NULL | NULL | latin1\_swedish\_ci | NULL |  |  |
   | t\_order\_item | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 | 
NULL | 2021-09-28 03:40:20 | NULL | NULL | latin1\_swedish\_ci | NULL |  |  |
   
   For the Rows, Avg_row_length, Data_length, and Max_data_length fields, the 
results need to be processed by the merge engine.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to