[wp-trac] [WordPress Trac] #23033: Decimal and numeric options in meta_query do not produce correct MYSQL for floating point numbers comparisons
WordPress Trac
noreply at wordpress.org
Fri Dec 21 05:02:11 UTC 2012
#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
More information about the wp-trac
mailing list