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

Invalid BIT column value from subselect

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.15
    • 3.1.19, 3.2.1
    • General
    • None
    • Windows server 2012 R2

    Description

      ODBC connector returns wrong value of BIT column when it is selected by subselect like:

      CREATE TABLE aaa (x bit);
      INSERT INTO aaa VALUES(0);

      SELECT X, (SELECT x FROM aaa LIMIT 1) FROM aaa;

      result:
      false, true //should be false, false

      Tested via ADODB... Simple test attached...

      Attachments

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              marek.srom Marek Šrom
              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.