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
        2. repro2.class
          4 kB
        3. repro2.java
          6 kB
        4. repro2.log
          0.5 kB

        Activity

          Ascending order - Click to sort in descending order
          Gofman Yekaterina created issue -
          diego dupin Diego Dupin made changes -
          Field Original Value New Value
          Fix Version/s 1.5.3 [ 22300 ]
          diego dupin Diego Dupin made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          diego dupin Diego Dupin made changes -
          Component/s Other [ 12201 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 77151 ] MariaDB v4 [ 134907 ]

          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.