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

ado.addnew/ODBC: Error with Decimal datatype

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0.15
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      MariaDB 10.2.7, Win7, ADO-DB-Layer

      Description

      I am still testing the ODBC Driver for an application migration.

      When trying to add a record with integer and char datatypes, ADO performs without an error. When I add a DECIMAL datatype, ODBC raises an error:

      Valuation and B 2124-1e4c ENTER SQLGetDiagRecW
      SQLSMALLINT 3 <SQL_HANDLE_STMT>
      SQLHANDLE 0x00932AB0
      SQLSMALLINT 1
      SQLWCHAR * 0x0018D590
      SQLINTEGER * 0x0018D188
      SQLWCHAR * 0x0018D190
      SQLSMALLINT 512
      SQLSMALLINT * 0x0018D184

      Valuation and B 2124-1e4c EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
      SQLSMALLINT 3 <SQL_HANDLE_STMT>
      SQLHANDLE 0x00932AB0
      SQLSMALLINT 1
      SQLWCHAR * 0x0018D590 [ 5] "22002"
      SQLINTEGER * 0x0018D188 (0)
      SQLWCHAR * 0x0018D190 [ 71] "[ma-2.0.15][10.2.7-MariaDB]Indicator variable required but not supplied"
      SQLSMALLINT 512
      SQLSMALLINT * 0x0018D184 (71)

      Seems to me the same as the previous .addnew error.

      I will attach the ODBC Tracefile of my test.

        Attachments

        1. ODBC_Test_Datatypes.txt
          3 kB
        2. SQL.LOG
          256 kB
        3. SQL - MariaDB.LOG
          159 kB
        4. SQL - MySQL.LOG
          639 kB

          Issue Links

            Activity

              People

              Assignee:
              Lawrin Lawrin Novitsky
              Reporter:
              baumgaphil Ph. Baumgartner
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: