List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:November 30 2001 2:50pm
Subject:Format of doubles in queries(feature request)
View as plain text  

>>>>> "Roland" == Roland  <roland@stripped> writes:


Roland> Allow an alternate syntax for double types. When the exponent is positive 
Roland> the plus sign may be omitted. That means
Roland> 3.41E+7 == 3.41E7.
Roland> Would that be too hard to implement? I don't think so. But it would save 
Roland> other programmers a lot of work. The way it is now,
Roland> each application programmer has to program his own conversion, or use the 
Roland> single-quotes trick.

Just tested this in MySQL 4.0:

mysql> select 3.41E+7,3.41E7,3.41E+7=3.41E7;
| 3.41E+7  | 3.41E7   | 3.41E+7=3.41E7 |
| 34100000 | 34100000 |              1 |
1 row in set (0.00 sec)

Format of doubles in queries(feature request)Roland29 Nov
  • Re: Format of doubles in queries(feature request)Sinisa Milivojevic30 Nov
  • Format of doubles in queries(feature request)Michael Widenius30 Nov
  • Re: Format of doubles in queries(feature request)Roland30 Nov