[wp-trac] [WordPress Trac] #54669: Remove ONLY_FULL_GROUP_BY from incompatible wpdb modes

[WordPress Trac]

#54669: Remove ONLY_FULL_GROUP_BY from incompatible wpdb modes
--------------------------+-----------------------------
 Reporter:  malthert      |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  trunk
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 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.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/54669>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform