[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):

 Replying to [comment:17 ericlewis]:
 > Replying to [comment:16 nacin]:
 > > What happens when I do `DECIMAL(a)`, `DECIMAL( 10, 5 )`, `DECIMAL(a,
 b)`, etc?
 >
 > How loose of a syntax should we allow for spacing here? Any amount of
 spaces? `DECIMAL(     10       ,     5     )`?

 I don't care if `DECIMAL( 10, 5 )` or `DECIMAL(10,5)` is valid or not, I
 just wanted a unit test demonstrating them one way or the other. :-)

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