[wp-trac] [WordPress Trac] #36625: Don't CAST the post meta value to CHAR in meta query

[WordPress Trac]

#36625: Don't CAST the post meta value to CHAR in meta query
-------------------------+---------------------------
 Reporter:  ericlewis    |       Owner:  boonebgorges
     Type:  enhancement  |      Status:  assigned
 Priority:  normal       |   Milestone:  4.6
Component:  Query        |     Version:  3.1
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+---------------------------
Changes (by boonebgorges):

 * owner:   => boonebgorges
 * status:  new => assigned
 * milestone:  Awaiting Review => 4.6


Comment:

 Thanks, @ericlewis. The details about index use are helpful. The question
 of whether WP should add an index to `meta_value` by default is
 complicated, but for the purposes of this ticket, the least we can do is
 stand out of the way of those who choose to add such indexes themselves.
 Let's make the change.

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