Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
3.1.19
-
None
-
Windows
Description
When using ODBC Connector, values of DECIMAL types cannot be read : reading the recordset's field values causes error "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
Sample SQL code :
SET @testDECIMAL := CAST(1.5 AS DECIMAL(15,2)); |
SELECT @testDECIMAL; |
I attached a sample JSCRIPT to reproduce the bug : run it with CSCRIPT.EXE on a Windows host:
SET MYSQL_PASSWORD=[ROOT_PASSWORD]
|
CSCRIPT.EXE mariadb_decimal_odbc_bug.js
|
It outputs the error when trying to read the @testDECIMAL variable...
E.
Attachments
Issue Links
- is caused by
-
MDEV-34179 Inconsistency in DECIMAL(MYSQL_TYPE_NEWDECIMAL) maximal precision
- Open