[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 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.


Generated at Thu Feb 08 08:40:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.