[buddypress-trac] [BuddyPress Trac] #5874: BP_Groups_Group::get() returns incorrect results when using meta_query with multiple meta_values and OR relationship

[buddypress-trac]

#5874: BP_Groups_Group::get() returns incorrect results when using meta_query with
multiple meta_values and OR relationship
--------------------------+------------------
 Reporter:  richtelford   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  2.2
Component:  Groups        |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |
--------------------------+------------------

Comment (by boonebgorges):

 In [changeset:"9082"]:
 {{{
 #!CommitTicketReference repository="" revision="9082"
 Fix group meta query SQL manipulation.

 The wildcard operators were acting too greedily, preventing some JOIN
 clauses
 from being recognized and resulting in invalid SQL syntax. This problem
 had
 previously been masked by ideosyncracies of WP's WP_Meta_Query SQL syntax,
 which changed in [WP29887].

 This change should be considered a band-aid fix for what is already a
 band-aid
 fix. The proper resolution for this issue is to migrate away from the
 comma
 syntax for JOINs used in BP_Groups_Group. See #5874, #5451.
 }}}

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5874#comment:21>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac