ERROR () LineGobbler(voidCall):85 - Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: YEAR

[ayyoubmaulana]

Hi, i try to replicate data using incremental deduped for the first time in table client_order from Mysql to BigQuery but i got this error, can someone explain whats going on ?

i found this in source MySQL

does that is the problem ?

[sherifnada]

@ayyoubmaulana can you share the full log?

[marcosmarxm]

This should be added to the comprehensive data tests in mysql

[ayyoubmaulana]

logs-2974-0.txt

this my full log @sherifnada

[etsybaev]

Might be related to #3931

[ayyoubmaulana]

but it still error for me @etsybaev

[roychri]

I am having a similar problem, even when using zerodatetimebehavior=Converttonull on the source jdbc options.
This is using MySQL -> PostgreSQL.

See my troubleshooting report: https://airbytehq.slack.com/archives/C01MFR03D5W/p1636037752111300

Here are my logs:
logs-65-0.txt

[sherifnada]

cc @tuliren for database reliability issues

[tuliren]

MySQL year is now parsed as a string, instead of a date. See test case here:
https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-mysql/src/test-integration/java/io/airbyte/integrations/source/mysql/MySqlSourceDatatypeTest.java#L320

In the future, we may consider changing a year value to an integer. But currently our internal Json representation only supports number, but not integer. So we cannot store them as integers yet. Follow up issue here: #8722