You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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,
CREATETABLEtest (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');
[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.
In MySQL it is possible to create tables with
DATETIME
values under year 1000. When creating a MySQL table withDATETIME
column and inserting values with years1-99
these values are not converted to minimal DateTime64 value in ClickHouse.For example.
In MySQL,
in ClickHouse we get,
If in MySQL we insert values above 100 the result is as expected,
In ClickHouse,
Expected result:
These values should be automatically converted to
DateTime64
minimal value which is1900-01-01 00:00:00
The text was updated successfully, but these errors were encountered: