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

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.12
        • Fix Version/s: 10.0
        • Component/s: None
        • Labels:
          None
        • Environment:
          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.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

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

                    Dates

                    • Created:
                      Updated: