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

SQLColumns incorrectly returns the values for the NULLABLE and IS_NULLABLE fields for auto_increments

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.0.11
    • None
    • None
    • None
    • Windows

    Description

      I have created a table with a primary key that is auto incrementing.
      I would then call the ODBC function SQLColumns for this new table.

      • For the auto incrementing column, the NULLABLE is set to 1, and the IS_NULLABLE is set to 0.

      For comparison, I used MS SQL Server's identity column, which I think is the equivalent of the auto increment. sp_columns returns 0 for NULLABLE and NO for IS_NULLABLE.

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            MichaelTM Michael M
            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.