hqbhoho opened a new issue, #7900:
URL: https://github.com/apache/gravitino/issues/7900

   ### Version
   
   main branch
   
   ### Describe what's wrong
   
   In `MysqlColumnDefaultValueConverter` will use `DATE_TIME_FORMATTER` pasre 
time column default value.
   ```
    case JdbcTypeConverter.TIME:
       return Literals.timeLiteral(LocalTime.parse(columnDefaultValue, 
DATE_TIME_FORMATTER));
   ```
   
   ### Error message and/or stacktrace
   
   N/A
   
   ### How to reproduce
   
   mysql> desc test_default_value_v3;
   +------------+------+------+-----+----------+-------+
   | Field      | Type | Null | Key | Default  | Extra |
   +------------+------+------+-----+----------+-------+
   | time_col_1 | time | YES  |     | 00:00:00 |       |
   +------------+------+------+-----+----------+-------+
   
   trino> show create table mysql_test.test.test_default_value_v3;
   Query 20250802_023854_01074_n5gqj failed: Failed to operate object 
[test_default_value_v3] operation [LOAD] under [test], reason [Text '00:00:00' 
could not be parsed at index 0]
   java.time.format.DateTimeParseException: Text '00:00:00' could not be parsed 
at index 0
        at 
java.base/java.time.format.DateTimeFormatter.parseResolved0(DateTimeFormatter.java:2052)
        at 
java.base/java.time.format.DateTimeFormatter.parse(DateTimeFormatter.java:1954)
        at java.base/java.time.LocalTime.parse(LocalTime.java:465)
        at 
org.apache.gravitino.catalog.mysql.converter.MysqlColumnDefaultValueConverter.toGravitino(MysqlColumnDefaultValueConverter.java:88)
   
   ### Additional context
   
   _No response_


-- 
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]

Reply via email to