[MDEV-18006] Columns not named in group by clause should increase warnings in P_S tables Created: 2018-12-13 Updated: 2018-12-13 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Oli Sennhauser | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | events_statements_history, only_full_group_by, performance_schema, sql_mode | ||
| 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 List those queries in P_S.events_statements_history* tables. |