weizuo93 opened a new pull request, #32233:
URL: https://github.com/apache/doris/pull/32233
## Proposed changes
Issue Number: close #xxx
There is column with type `date/datetime/decimal`when create table，but the
column type returned from `SHOW FULL COLUMNS FROM xxx`is
`dateV2/datetimeV2/decimalv3`. For example:
Create table:
```
CREATE TABLE `test_table` (
`a` DATETIME NULL,
`b` DATE NULL,
`c` DECIMAL(5, 1) NULL,
`d` INT NULL
) ENGINE=OLAP
DUPLICATE KEY(`a`, `b`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`a`) BUCKETS 4
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"storage_format" = "V2"
);
```
Show columns:
```
mysql> SHOW FULL COLUMNS FROM test_table;
+-------+-------------------+--------------+------+------+-----------+---------+--------------+--------------+
| Field | Type | Collation | Null | Key | Default |
Extra | Privileges | Comment |
+-------+-------------------+--------------+------+------+-----------+---------+--------------+--------------+
| a | datetimev2(0) | | YES | YES | NULL
| | | |
| b | datev2 | | YES | YES
| NULL | | | |
| c | decimalv3(5, 1) | | YES | NO | NULL
| NONE | | |
| d | int | | YES
| NO | NULL | NONE | | |
+-------+-------------------+--------------+------+------+-----------+--------+---------------+--------------+
4 rows in set (0.00 sec)
```
It is necessary to display `dateV2/datetimeV2/decimalv3` as
`date/datetime/decimal` in `ShowColumnStmt`. As follows：
```
mysql> SHOW FULL COLUMNS FROM test_table;
+-------+-------------------+--------------+------+------+-----------+---------+--------------+--------------+
| Field | Type | Collation | Null | Key | Default |
Extra | Privileges | Comment |
+-------+-------------------+--------------+------+------+-----------+---------+--------------+--------------+
| a | datetime | | YES | YES | NULL
| | | |
| b | date | | YES | YES
| NULL | | | |
| c | decimal(5, 1) | | YES | NO | NULL
| NONE | | |
| d | int | | YES | NO
| NULL | NONE | | |
+-------+-------------------+--------------+------+------+-----------+--------+---------------+--------------+
4 rows in set (0.00 sec)
```
Related PR：#18358
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
