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

Incorrect return values for decimal data type


    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0.2
    • Fix Version/s: 3.0.4, 2.0.17
    • Component/s: General
    • Labels:
    • Environment:
      Windows 2012 R2 64
      MariaDB ODBC 3.0 Driver (MAODBC.DLL,
      MS SQL Server 2008 R2 SP3 X64
      MySQL ODBC 5.3 ANSI Driver (MYODBC5A.DLL,


      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."




            • Assignee:
              Lawrin Lawrin Novitsky
              ilikepandas Shiya
            • Votes:
              1 Vote for this issue
              4 Start watching this issue


              • Created: