matrixorigin
[Bug]: error occurs when I use show table status stmt
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
Table Structure ； CREATE TABLE t( id CHAR(200) NOT NULL DEFAULT 'FLJDIAOJFDKLA', name CHAR(200) NOT NULL, PRIMARY KEY (id) ); CREATE TABLE t1( cid FLOAT NOT NULL, cls VARCHAR(200) NOT NULL, PRIMARY KEY(cid, cls) );
DML : INSERT INTO t VALUES ('lijljidlsajfdklsafjd', 'fijiofjdizvckxzjvico'); INSERT INTO t VALUES ('&(*^&T&YD(SF(DUS(*F', '0'); INSERT INTO t1 VALUES (1.101, 'I have a dream that one day this nation will rise up'); INSERT INTO t1 VALUES (0.1, 'wo will never surender dukerke is a');
The problematic SQL stmt is : SHOW TABLE STATUS FROM test WHERE Name = 't' \G;
It's return value is : ERROR 1105 (HY000): You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 503 near ";) tbl";
It return value on MySQL is : *************************** 1. row *************************** Name: t Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2022-10-11 22:27:45 Update_time: 2022-10-11 22:27:45 Check_time: NULL Collation: utf8mb4_0900_ai_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec)
Expected Behavior
No response
Steps to Reproduce
No response
Additional information
No response
