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

    • 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

          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.