Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
3.0.2
-
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."