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

Wrong precision is returned for NUMERIC columns - 2 greater than it should be.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.5.2
    • 1.5.3
    • Other
    • None

    Description

      Wrong precision is returned for NUMERIC columns. The returned precision is 2 greater than it should be (see the attached java repro)

      execute CREATE TABLE TESTNUM (N9X2 NUMERIC(9,2), N20X4 NUMERIC (20,4))

      execute SELECT N9X2, N20X4 FROM TESTNUM

      get resultset metadata

      N9X2 precision is 11
      N9X2 scale is 2

      N20X4 precision is 22
      N20X4 scale is 4

      Attachments

        1. env_java
          0.4 kB
          Yekaterina
        2. repro2.class
          4 kB
          Yekaterina
        3. repro2.java
          6 kB
          Yekaterina
        4. repro2.log
          0.5 kB
          Yekaterina

        Activity

          Ascending order - Click to sort in descending order
          diego dupin Diego Dupin added a comment - - edited

          confirmed.

          The problem concern DECIMAL type. Signed will have +2 precision, unsigned +1.

          diego dupin Diego Dupin added a comment - - edited confirmed. The problem concern DECIMAL type. Signed will have +2 precision, unsigned +1.
          diego dupin Diego Dupin added a comment -

          fixed in https://github.com/MariaDB/mariadb-connector-j/commit/26ed0fd511fdfafa0233e074f04fdd4ed81518e8

          diego dupin Diego Dupin added a comment - fixed in https://github.com/MariaDB/mariadb-connector-j/commit/26ed0fd511fdfafa0233e074f04fdd4ed81518e8

          People

            diego dupin Diego Dupin
            Gofman Yekaterina
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.