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

Columns not named in group by clause should increase warnings in P_S tables

    XMLWordPrintable

Details

    Description

      Non aggregated columns not named in GROUP BY clause are accepted in mysql unless only_full_group_by is set.

      Finding those queries in application code is hard.

      Thus it would be nice when those queries would rise a warning in P_S events_statements_history* tables so they could be found and eliminated before setting sql_mode = 'only_full_group_by'

      select a, b, count from test group by a;
      OK
      select * from performance_schema.events_statements_history where warnings > 0;
      -> query should be listed.

      List those queries in P_S.events_statements_history* tables.

      Attachments

        Activity

          People

            Unassigned Unassigned
            oli Oli Sennhauser
            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.