WordPress.org
Get WordPress

Make WordPress Core

Opened 18 months ago

Last modified 12 months ago

#54669 new enhancement

Remove ONLY_FULL_GROUP_BY from incompatible wpdb modes

Reported by: malthert's profile malthert Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 3.9
Component: Database Keywords: needs-patch needs-unit-tests
Focuses: Cc:

Description

as GROUP BY is non-deterministic otherwise, ONLY_FULL_GROUP_BY ensures this is not the case.
which is why this is enabled by default since MySQL 8

I guess it was disabled originally, as some queries would have to be updated in WP core.

I think however, this should be done now, as otherwise we're accumulating more and more technical debt.

Change History (3)

#1 @johnbillion
18 months ago

  • Keywords needs-patch needs-unit-tests added
  • Type changed from defect (bug) to enhancement
  • Version trunk deleted

#2 @SergeyBiryukov
18 months ago

  • Version set to 3.9

Thanks for the ticket!

Introduced in [27072] / #26847, see comment:2:ticket:26847 for context.

Related: #44586, #48280, #48377, #49344

This ticket was mentioned in ​Slack in #core by abhanonstopnews. ​View the logs.
12 months ago

Note: See TracTickets for help on using tickets.