matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: show table status : Para ROWS can't be display correctly

Open goodMan-code opened this issue 3 years ago • 0 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

DDL : DROP TABLE IF EXISTS t; CREATE TABLE t( tiny TINYINT, small SMALLINT, int_t INT, big BIGINT, str1 VARCHAR(200), str2 CHAR(200), float_32 FLOAT, float_64 DOUBLE, d1 DATE, d2 DATETIME, d3 TIMESTAMP );

DML : INSERT INTO t(str1,str2) VALUES ('jixlzvcxfiowurioewmnklrn', 'abc');

The SQL stmt is : SHOW TABLE STATUS LIKE 't' \G;

It's return value on MO : Name: t Engine: Tae Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 0 Index_length: 0 Data_free: NULL Auto_increment: 0 Create_time: 2022-10-12 11:15:27 Update_time: NULL Check_time: NULL Collation: utf-8 Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec)

It's return value on MySQL : Name: t Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2022-10-12 10:53:14 Update_time: 2022-10-12 10:53:16 Check_time: NULL Collation: utf8mb4_0900_ai_ci Checksum: NULL Create_options: Comment: 1 row in set (0.06 sec)

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

goodMan-code avatar Oct 12 '22 03:10 goodMan-code