[wp-trac] [WordPress Trac] #21621: setting meta_type doesn't CAST orderby value

[WordPress Trac]

#21621: setting meta_type doesn't CAST orderby value
----------------------------+-----------------------------
 Reporter:  wonderboymusic  |       Owner:  wonderboymusic
     Type:  enhancement     |      Status:  closed
 Priority:  normal          |   Milestone:  3.7
Component:  Query           |     Version:  3.2
 Severity:  normal          |  Resolution:  fixed
 Keywords:  has-patch       |
----------------------------+-----------------------------
Changes (by wonderboymusic):

 * owner:   => wonderboymusic
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"25255"]:
 {{{
 #!CommitTicketReference repository="" revision="25255"
 When `meta_type` is passed with `orderby => meta_value`, `orderby` must
 also use `CAST()` to avoid scenarios like: `SELECT`ing by `UNSIGNED` and
 then ordering by `CHAR`. Adds unit test.

 Fixes #21621.
 }}}

--
Ticket URL: <http://core.trac.wordpress.org/ticket/21621#comment:11>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software