[Bug]: Table partition plan execution failed with to_date function

[tonghan-gsh]

ODC version

ODC 4.3.2

OB version

No related

What happened?

The format of the pre-created SQL statements generated by the partitioning plan does not match.

What did you expect to happen?

Remove Spaces

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

CREATE TABLE test_range_date ( col1 DATE ) PARTITION BY RANGE (col1) ( PARTITION p_2023_01 VALUES LESS THAN (TO_DATE('2023-01-01', 'YYYY-MM-DD')), PARTITION p_2023_02 VALUES LESS THAN (TO_DATE('2023-02-01', 'YYYY-MM-DD')), PARTITION p_2023_03 VALUES LESS THAN (TO_DATE('2023-03-01', 'YYYY-MM-DD')), PARTITION p_2023_04 VALUES LESS THAN (TO_DATE('2023-04-01', 'YYYY-MM-DD')), PARTITION p_2023_05 VALUES LESS THAN (TO_DATE('2023-05-01', 'YYYY-MM-DD')) );

Anything else we need to know?

No response

[guowl3]

fix in the next version