[wp-trac] [WordPress Trac] #36169: Incorrect results when combining a NOT EXISTS meta query with a comparison.

WordPress Trac noreply at wordpress.org
Tue Mar 8 11:25:51 UTC 2016


#36169: Incorrect results when combining a NOT EXISTS meta query with a comparison.
--------------------------+------------------------------
 Reporter:  mikejolley    |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Query         |     Version:  4.4.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by mikejolley):

 Scrub this request. Although it could be optimised (by combining the two
 joins), just found it worked for me locally. It was causing this error on
 the user's site:

 `The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE
 and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is
 okay`

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36169#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list