Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. 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.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 3.1.19
    • 3.2.2
    • General
    • 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

          Activity

            People

              Lawrin Lawrin Novitsky
              edot06 Emmanuel KARTMANN
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.