Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14392

CONNECT - Table Type: ODBC - HAVING Clause (Wihtout WHERE and GROUP BY) Has Wrong Results

    XMLWordPrintable

Details

    Description

      When using CONNECT Engine and Table Type ODBC, when using a HAVING clause for filtering data, wrong results are returned if no WHERE and GROUP BY clause is used.

      For example:

      SELECT
           *
      FROM
           MyTable
      HAVING
           MyColumn <> 'MyValue' OR MyColumn IS NULL
      

      Does not perform a correct filtering. I think that the correct MariaDB behaviour with the HAVING clause shall be that a "local" copy of the table is done in MariaDB Server, bringing the table through ODBC connection, and then filter it in the "local" server itself.

      Thank you,
      Juan

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            Juan Juan Telleria
            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.