[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
Wed Sep 18 00:31:47 UTC 2013


#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 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     )`?

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


More information about the wp-trac mailing list