Source MySQL: unsigned numeric values larger than signed integer size break connector

[sherifnada]

Expected Behavior

I expect Airbyte syncs to succeed when replicating a MySQL table which contains an unsigned int column in which some of the values are larger than 2^32-1.

Slack thread: https://airbytehq.slack.com/archives/C01MFR03D5W/p1622696364083700

Current Behavior

The sync breaks as reported by a user. They sent the following logs:

2021-06-03 05:13:13 ERROR (/tmp/workspace/59/2) LineGobbler(voidCall):69 - Exception in thread "main" java.lang.RuntimeException: java.sql.SQLDataException: Value '4176160650' is outside of valid range for type java.lang.Integer

Suggestions for solution

If we can identify inside the connector if the column is unsigned then we should use Long for unsigned and Integer otherwise.

If we can't identify if the column is unsigned then we should always use long.

Logs

Steps to Reproduce

1. Create a table in a mysql db with column unsigned int
2. insert a row with value 3428724653
3. run a sync from airbyte to any destination
4. 💣

Severity of the bug for you

High -- preventing user from using Airbyte

Airbyte Version

Connector Version (if applicable)

Additional context

┆Issue is synchronized with this Asana task by Unito