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

Incorrect return values for decimal data type

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 3.0.2
    • 3.0.4, 2.0.17
    • General
    • Windows 2012 R2 64
      MariaDB ODBC 3.0 Driver (MAODBC.DLL, 3.00.02.00)
      MS SQL Server 2008 R2 SP3 X64
      MySQL ODBC 5.3 ANSI Driver (MYODBC5A.DLL, 5.03.07.00)

    Description

      I'm experiencing issues with with DECIMAL data types using the MariaDB ODBC driver (tested using MS SQL Linked Server and MS Vbscript - ADODB.Connection).

      select *
      from openquery( cdr1, 'select cast(1 as decimal(19,4))' )

      Returns "0.0001"

      Using the MySQL ODBC 5.3 Driver running the same query returns "1.0000"

      I'm experiencing the same issue using the MariaDB driver to return a column of datatype DECIMAL(19,4) - if the column contains '1' then it's returned as '0.0001'.

      Having similar issues inserting data into MariaDB using MS SQL Linked Server for columns cast as DECIMAL(19,4).
      If the column's value is '99.0' then the insert fails with "[ma-3.0.2][5.5.56-MariaDB]Numeric value out of range"

      Updating data using the MariaDB connector for the DECIMAL data type returns the following error:
      "Row cannot be located for updating. Some values may have been changed since it was last read."

      Attachments

        1. MAODBC.LOG
          12 kB
          Shiya
        2. odbctrace_MariaDB_SQL.LOG
          50 kB
          Shiya
        3. odbctrace_MySQLDB_SQL.LOG
          47 kB
          Shiya

        Activity

          People

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