[wp-trac] [WordPress Trac] #23033: Decimal and numeric options in meta_query do not produce correct MYSQL for floating point numbers comparisons

[WordPress Trac]

#23033: Decimal and numeric options in meta_query do not produce correct MYSQL for
floating point numbers comparisons
-----------------------------+--------------------------
 Reporter:  ericlewis        |       Type:  defect (bug)
   Status:  new              |   Priority:  normal
Milestone:  Awaiting Review  |  Component:  General
  Version:                   |   Severity:  normal
 Keywords:                   |
-----------------------------+--------------------------
 If you have a custom post type (shoes) that has floating point numbers
 (shoe size) as post meta, querying against this post meta with a specific
 decimal value ( >10.5 ) does not work properly because of the way the
 values are cast out of the database, and will produce surprising results.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/23033>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software