MySQL DATETIME values under year 100 are converted incorrectly to ClickHouse's DateTime64.

[Selfeer]

In MySQL it is possible to create tables with DATETIME values under year 1000. When creating a MySQL table with DATETIME column and inserting values with years1-99 these values are not converted to minimal DateTime64 value in ClickHouse.

For example.

In MySQL,

CREATE TABLE test (date DATETIME(5)) ENGINE = InnoDB;

INSERT INTO test VALUES ('0001-01-01 00:00:00.00000');
INSERT INTO test VALUES ('999-01-01 00:00:00.00000');
INSERT INTO test VALUES ('99-01-01 00:00:00.00000');

in ClickHouse we get,

SELECT * FROM test;

┌─my_row_id─┬──────────────────────date─┬────────────_version─┬─is_deleted─┐
│         1 │ 2001-01-01 00:00:00.00000 │ 1762164353659830355 │          0 │
│         2 │ 1900-01-01 00:00:00.00000 │ 1762164412380086356 │          0 │
│         3 │ 1999-01-01 00:00:00.00000 │ 1762164798256054363 │          0 │
└───────────┴───────────────────────────┴─────────────────────┴────────────┘

If in MySQL we insert values above 100 the result is as expected,

INSERT INTO test VALUES ('100-01-01 00:00:00.00000');

In ClickHouse,

SELECT * FROM test WHERE my_row_id == 4;

┌─my_row_id─┬──────────────────────date─┬────────────_version─┬─is_deleted─┐
│        4  │ 1900-01-01 00:00:00.00000 │ 1762168149504950370 │          0 │
└───────────┴───────────────────────────┴─────────────────────┴────────────┘

Expected result:

These values should be automatically converted to DateTime64 minimal value which is 1900-01-01 00:00:00

[subkanthi]

The value thats returned by debezium is 915148800000000 for 0099-01-01 00:00:00.000000 which is 1999-01-01T00:00:00Z

[subkanthi]

https://stackoverflow.com/questions/73956216/datetime-from-mysql-in-kafka-is-converted-to-wrong-timestamp-for-dates-less-tha

[enable.time.adjuster](https://debezium.io/documentation/reference/stable/connectors/mysql.html#mysql-property-enable-time-adjuster)

true

Boolean value that indicates whether the connector converts a 2-digit year specification to 4 digits. Set to false when conversion is fully delegated to the database.

MySQL allows users to insert year values with either 2-digits or 4-digits. For 2-digit values, the value gets mapped to a year in the range 1970 - 2069. The default behavior is that the connector does the conversion.

[Selfeer]

Using the Debezium parameter "enable.time.adjuster" : "false", seems to resolve the problem.