[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 richtelford):

 The immediate goal is to figure out why the translation is not working.

 What do you mean by translation?

 I can confirm that using LIKE, "=" or no compare operator reproduces the
 same bug which makes sense considering it's the joining of tables via the
 comma syntax that is causing the problem and not the CASTing of datatypes.
 I'll try with numeric data as well to see if it persists.

  it's not going to be possible to change the comma syntax at the moment

 Assuming that by using the comma syntax, INNER JOINs were desired
 originally and the current mechanism is already faulty, changing to actual
 INNER JOINs wouldn't be such a radical change? I understand there are
 other tickets on the roadmap though so fair enough if this one has to
 wait.

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