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.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.2
    • Fix Version/s: 1.5.3
    • Component/s: Other
    • Labels:
      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

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            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.