[Rails5] Mysql2::Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'subquery.closed_at'
Note: add
rails5
to a branch name to trigger rails5 specific CI jobs.
https://gitlab.com/gitlab-org/gitlab-ee/-/jobs/82208319
1) GitLab Flavored Markdown for milestones renders title in milestones#show
Failure/Error: render(partial, locals) if lookup_context.exists?(partial, [], true)
ActionView::Template::Error:
Mysql2::Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'subquery.closed_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT closed_at, weight, state FROM (SELECT issues.id, issues.state, issues.weight, e.created_at AS closed_at FROM `issues` LEFT OUTER JOIN events e ON issues.id = e.target_id AND e.target_type = 'Issue' AND e.action = 3 WHERE `issues`.`milestone_id` = 103 AND (state = 'closed' OR (state = 'opened' AND e.action = 3))) subquery GROUP BY id HAVING (closed_at = MIN(closed_at) OR closed_at IS NULL) ORDER BY closed_at ASC
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./ee/app/models/burndown.rb:110:in `milestone_issues'
# ./ee/app/models/burndown.rb:27:in `initialize'
# ./ee/app/helpers/ee/milestones_helper.rb:4:in `new'
# ./ee/app/helpers/ee/milestones_helper.rb:4:in `burndown_chart'
# ./ee/app/views/shared/milestones/_burndown.html.haml:3:in `_ee_app_views_shared_milestones__burndown_html_haml___3394474590331035226_46964481776720'
# ./app/helpers/application_helper.rb:9:in `render_if_exists'
# ./app/views/projects/milestones/show.html.haml:72:in `_app_views_projects_milestones_show_html_haml___3805252264808226447_46964487792440'
# ./lib/gitlab/i18n.rb:51:in `with_locale'
# ./lib/gitlab/i18n.rb:57:in `with_user_locale'
# ./app/controllers/application_controller.rb:380:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:97:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/query_limiting/middleware.rb:17:in `block in call'
# ./lib/gitlab/query_limiting/transaction.rb:37:in `run'
# ./lib/gitlab/query_limiting/middleware.rb:16:in `call'
# ./ee/lib/gitlab/jira/middleware.rb:15:in `call'
# ./lib/gitlab/middleware/go.rb:17:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/middleware/read_only/controller.rb:40:in `call'
# ./lib/gitlab/middleware/read_only.rb:16:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_inspector_middleware.rb:31:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:45:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ./spec/features/markdown/gitlab_flavored_markdown_spec.rb:122:in `block (3 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'subquery.closed_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
# ./config/initializers/connection_fix.rb:20:in `execute'
This MR may help as the problem seems to be similar.