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

Error binding boolean data type to SQL_C_CHAR

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.11
    • 2.0.12
    • General
    • None
    • Windows Server 2012 R2 Standard 6.3.9600 Build 9600
      Both 32 and 64 bit drivers have the same behavior.

    Description

      The attached program accepts 3 parameters:

      1. The ODBC DSN
      2. The database user name
      3. The database password

      It then connects to the database, creates a simple table that has a bool and attempts to bind and populate.
      You will see that the only binding failure is SQL_C_CHAR.
      The exact error message is:
      check_error> SQL_ERROR
      return code = -1 reported from file: bugg.cpp, line: 232
      SQLSTATE: 22001
      Native Error Code: 1406
      buffer: [ma-2.0.11][5.7.12-log]Data too long for column 'x' at row 1

      Attachments

        Activity

          Partial fix for the bug has been pushed and will be part of coming release.
          The patch fixes only SQL_C_CHAR string parameter case, and not SQL_C_WCHAR. Also it is more permissive for parameter values, than specs suggest. i.e. by specs it should be "0" or "1", and errors should be set for other values.

          Lawrin Lawrin Novitsky added a comment - Partial fix for the bug has been pushed and will be part of coming release. The patch fixes only SQL_C_CHAR string parameter case, and not SQL_C_WCHAR. Also it is more permissive for parameter values, than specs suggest. i.e. by specs it should be "0" or "1", and errors should be set for other values.

          The exact reported issue has been fixed, for adjacent (possible) issues the new ticket has been opened(195)

          Lawrin Lawrin Novitsky added a comment - The exact reported issue has been fixed, for adjacent (possible) issues the new ticket has been opened(195)

          People

            Lawrin Lawrin Novitsky
            dcorbit Danniel Corbit
            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.