[ODBC-405] can't read DECIMAL values : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Created: 2023-11-29  Updated: 2023-12-13

Status: Open
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.19
Fix Version/s: 3.2.2

Type: Bug Priority: Major
Reporter: Emmanuel KARTMANN Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Windows

Attachments: File mariadb_decimal_odbc_bug.js    

 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.

 Comments   
Comment by Lawrin Novitsky [ 2023-11-30 ]

Thank you for your report.

It's strange - the trace has no errors or any signs of abnormality. It will take some more time

Comment by Emmanuel KARTMANN [ 2023-12-13 ]

I did additional tests, and here are more info :

Regards,

E.

Generated at Thu Feb 08 03:28:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.