'0000-00-00 00:00:00' Date error in JDBC catalog connection.

[YoadBarok]

Background: When creating a JDBC catalog connection to a MySQL DB, and trying to select rows that have Date values of '0000-00-00 00:00:00' the "error: java.time.DateTimeException: Invalid value for MonthOfYear (valid values 1 - 12): 0" is thrown.

Steps to reproduce the behavior (Required)

INSERT INTO
    my_table (
        id,
        date_column
        )
SELECT
    id,
    date_column
FROM
    ext_catalog.mysql_db.mysql_table;

Expected behavior (Required)

Our table should be populated with the data from the external catalog's table.

Real behavior (Required)

The above mentioned error is thrown

StarRocks version (Required)

• 3.3.0-rc02-be533a8
• 3.1.12-fc2b9c3

Already tried the following:

INSERT INTO
    my_table (
        id,
        date_column
        )
SELECT
    id,
    CASE
    WHEN (
        MONTH(date_column) = 0
        OR YEAR(date_column) = 0
        OR DAY(date_column) = 0
    ) THEN NULL
    ELSE date_column
END AS date_column
FROM
    ext_catalog.mysql_db.mysql_table;

But still receiving the same error.

[MariuszJurowicz]

👍