aopangzi commented on issue #11905:
URL: https://github.com/apache/doris/issues/11905#issuecomment-1223455139
mysql> create table db_test.ods_daping_cmdb_jt_zstd_bak like
db_test.ods_daping_cmdb_jt_zstd;
ERROR 1105 (HY000): errCode = 2, detailMessage = Failed to execute CREATE
TABLE LIKE ods_daping_cmdb_jt_zstd. Reason: errCode = 2, detailMessage = date
literal [CURRENT_TIMESTAMP] is invalid: errCode = 2, detailMessage = Invalid
date value: CURRENT_TIMESTAMP
mysql> desc ods_daping_cmdb_jt_zstd;
+-----------------------+---------------+------+-------+-------------------+-------+
| Field | Type | Null | Key | Default |
Extra |
+-----------------------+---------------+------+-------+-------------------+-------+
| TIMEKEY | DATE | Yes | true | NULL |
|
| CATEGORY | VARCHAR(32) | Yes | true | NULL |
|
| DISPLAY_NAME | VARCHAR(32) | Yes | true | NULL |
|
| DEVICE | VARCHAR(32) | Yes | true | NULL |
|
| BELONG_TO | VARCHAR(32) | Yes | true | NULL |
|
| belong_to_id_db | VARCHAR(64) | Yes | false | NULL |
NONE |
| belong_to_id_api | VARCHAR(64) | Yes | false | NULL |
NONE |
| LOCATION | VARCHAR(32) | Yes | false | NULL |
NONE |
| dt | DATETIME | Yes | false | CURRENT_TIMESTAMP |
NONE |
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
