Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-308

Various issues with SQL_NUMERIC type conversions

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.11
    • 3.1.12
    • General
    • None

    Description

      There are issues in the conversion in both directions - from SQL_NUMERIC_STRUCT to string, and from string to the struct.
      Mostly that is not detected or incorrectly detected overflow.
      Also, negative scale is incorrectly processed in many cases.
      Current SQL_NUMERIC_STRUCT->string conversion algorithm cannot correctly process >8bytes numbers, but doesn't report the error in this case either.
      If scale is > max supported(38) no warning is returned, and this value is used.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          Lawrin Lawrin Novitsky created issue -
          ralf.gebhardt Ralf Gebhardt made changes -
          Field Original Value New Value
          Fix Version/s 3.1 [ 22900 ]
          Fix Version/s 3.1.12 [ 25307 ]
          Lawrin Lawrin Novitsky made changes -
          Description There are issues in the conversion in both directions - from SQL_NUMERIC_STRUCT to string, and from string to the struct.
          Mostly that is not detected or incorrectly detected overflow.
          Also, negative scale is incorrectly processed in many cases.
          Current SQL_NUMERIC_STRUCT->string conversion algorithm cannot correctly process >8bytes numbers, but doesn't report the error in this case either.           		There are issues in the conversion in both directions - from SQL_NUMERIC_STRUCT to string, and from string to the struct.
          Mostly that is not detected or incorrectly detected overflow.
          Also, negative scale is incorrectly processed in many cases.
          Current SQL_NUMERIC_STRUCT->string conversion algorithm cannot correctly process >8bytes numbers, but doesn't report the error in this case either.
          If scale is > max supported(38) no warning is returned, and this value is used.
          Lawrin Lawrin Novitsky added a comment -

          Commit 5cf7740

          Lawrin Lawrin Novitsky added a comment - Commit 5cf7740
          Lawrin Lawrin Novitsky made changes -
          Fix Version/s 3.1.12 [ 25307 ]
          Fix Version/s 3.1 [ 22900 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          Lawrin Lawrin Novitsky made changes -
          Issue Type Task [ 3 ] Bug [ 1 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 120923 ] MariaDB v4 [ 135559 ]

          People

            Lawrin Lawrin Novitsky
            Lawrin Lawrin Novitsky
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.