Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.7.10
-
None
-
MySQL 8.0.33 server, MariaDB 2.7.10 ConnectorJ
Description
Both signed and unsigned MySQL BIGINT return a precision of 20 using ConnectorJ. Using the MySQL driver the signed BIGINT returns 19.
This is an issue because some software packages interpret a precision of 20 as too large for a 64 bit long, and so convert it to string. Here's an example from Apache NiFi: https://github.com/apache/nifi/blob/b5943941bad009cd146a94b3fc7c14b075e9f542/nifi-nar-bundles/nifi-extension-utils/nifi-database-utils/src/main/java/org/apache/nifi/util/db/JdbcCommon.java#L395