Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1174

ConnectorJ gives precision of 20 for signed bigint

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.7.10
    • 2.7.13, 3.4.0
    • MySQL compatibility
    • 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

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            johnwphillips John W. Phillips
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.