🐛DATETIME from MySQL not returned as TIMESTAMP on postgres. It returns as text

[dl-lim]

Expected Behavior

Tell us what should happen.
DATETIME from MySQL should end up as TIMESTAMP on postgres

Current Behavior

Tell us what happens instead of the expected behavior.
DATETIME from MySQL should end up as VARCHAR on postgres

Logs

If applicable, please upload the logs from the failing operation. For sync jobs, you can download the full logs from the UI by going to the sync attempt page and clicking the download logs button at the top right of the logs display window.
N/A

Steps to Reproduce

1. Have DATETIME data on a mysql source
2. Push to a Postgres dest
3. Postgres data shows up as text, not date :(

Severity of the bug for you

High

Airbyte Version

Found in the .env file in the root of the project.
0.24.5

Connector Version (if applicable)

Found in the admin page in the UI in the respective Source or Destination tab.
mysql 0.3.3
postgres 0.3.2

Additional context

Environment, version, integration...
#3562
┆Issue is synchronized with this Asana task by Unito

[Morpheus1999]

Dears

I just found that this issue was caused by class JsonSchemaPrimitive do not have corresponging timestamp enum item and this class was used to generated stream of catalog.

[BenoitFayolle]

Still an issue in connector version 0.5.1
Would love for this to be resolved!
Happy to test things out if someone knows how to resolve.

[Morpheus1999]

Dears

I have created on merge request for fixing this issue.
Please kindly reviewing it.
#9891
Thanks

[tuliren]

This is probably fixed by #15504. Need to verify.

[tuliren]

Hey team! Please add your planning poker estimate with ZenHub @edgao @rodireich @ryankfu @subodh1810

[tuliren]

Actually we already have unit tests for this. This is fixed by #15504.