[wp-trac] [WordPress Trac] #27272: WP meta queries comparing apples to oranges

[WordPress Trac]

#27272: WP meta queries comparing apples to oranges
------------------------------------------+-----------------------------
 Reporter:  Denis-de-Bernardy             |       Owner:
     Type:  defect (bug)                  |      Status:  new
 Priority:  normal                        |   Milestone:  Future Release
Component:  Query                         |     Version:  3.8.1
 Severity:  normal                        |  Resolution:
 Keywords:  needs-patch needs-unit-tests  |     Focuses:
------------------------------------------+-----------------------------

Comment (by gitlost):

 Queries will fail though (depending on system) if you trigger the MySQL
 string to float conversion mentioned in
 https://dev.mysql.com/doc/refman/5.0/en/type-conversion.html by using
 large numbers, see appended updated meta patch and test patch.

 MySQL does do good type-juggling, but it seems frankly silly to invoke it
 unnecessarily. Quoting numerics ain't natural!

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