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

Apparent incorrect validation of GROUP BY fields when ONLY_FULL_GROUP_BY sql_mode enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0.12
    • None
    • None
    • None
    • Windows 7 Enterprise, using HeidiSQL

    Description

      After executing set session sql_mode = 'ONLY_FULL_GROUP_BY', running the attached query (query.sql) in the database created by attached database.sql gives "SQL Error (1463): Non-grouping field 'BENEFIT_INDICATOR' is used in HAVING clause", even though the verbatim BENEFIT_INDICATOR field is included in the GROUP BY.

      Related, but not so much a bug, I had to include additional fields in the GROUP BY compared to other DBMS to get it to run without the HAVING clause - the validation appears to have issues field names included in the CONCATs in the GROUP BY.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mburgessza Marc Burgess
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.