[Bug] Case being sensitive when creating a time range table with datatype timestamp #17312

Search before asking

• I had searched in the issues and found no similar issues.

Version

The version I used is: Apache Doris 1.2.2 Release

What's Wrong?

User can not create a table with small letter of timestamp datatype.

What You Expected?

User can create a table with small letter of timestamp datatype, this behavior is not case sensitive in mysql 8, and other Standard SQL syntax.

How to Reproduce?

By simply create a table with datatype timestamp and in format of small letter like use 'year' or 'Year' but not 'YEAR'
create table time_range_table(
id varchar(128),
g_id varchar(128),
time datetimev2(3)
)
engine=olap
duplicate key(id, g_id, time)
partition by range(time)(
from ("2000-01-01") to ("2021-01-01") interval 1 year,
from ("2021-01-01") to ("2022-01-01") interval 1 month,
from ("2022-01-01") to ("2023-01-01") interval 1 week,
from ("2023-01-01") TO ("2023-02-01") interval 1 day
)
distributed by hash(id) buckets 1
properties(
"replication_num"=1,
"light_schema_change"="true",
"compression"="zstd",
"enable_unique_key_merge_on_write" = "true"
);

Anything Else?

Other enumerate class with definition capital letter should also be check.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct