[Bug]: can not recognize the partition key's data type on mysql mode

[yhilmare]

ODC version

4.3.1

OB version

not related

What happened?

1. create a partition table:

create table test_tbl1(
    id bigint,
    CREATE_TIME datetime
) partition by range columns(create_time) (
    partition p202407 values less than('2024-07-25 00:00:00')
);

as you can see the partition key reference a column but the case is different which is valid for mysql mode

2. attempt to start up a partition plan

as you can see, the datatype is wrong for the table.

What did you expect to happen?

recognize the datatype correctly~

How can we reproduce it (as minimally and precisely as possible)?

follow what happened

Anything else we need to know?

No response

[tonghan-gsh]

pass

[tonghan-gsh]

The datetime type is still recognized as varchar