[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                            |       Owner:
     Type:  defect (bug)                         |  wonderboymusic
 Priority:  normal                               |      Status:  accepted
Component:  Query                                |   Milestone:  Future
 Severity:  normal                               |  Release
 Keywords:  has-patch needs-unit-tests needs-    |     Version:
  refresh                                        |  Resolution:
-------------------------------------------------+-------------------------

Comment (by nacin):

 What happens when I do `DECIMAL(a)`, `DECIMAL( 10, 5 )`, `DECIMAL(a, b)`,
 etc? Ideally some basic tests beyond "ANYTHING ELSE" can somewhat
 demonstrate that this regex works as desired.

 Finally, the patches can/should be combined — that way `src/` and `tests/`
 can be applied and committed together.

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