1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2008 Sun Microsystems
6
* This program is free software; you can redistribute it and/or modify
7
* it under the terms of the GNU General Public License as published by
8
* the Free Software Foundation; version 2 of the License.
10
* This program is distributed in the hope that it will be useful,
11
* but WITHOUT ANY WARRANTY; without even the implied warranty of
12
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13
* GNU General Public License for more details.
15
* You should have received a copy of the GNU General Public License
16
* along with this program; if not, write to the Free Software
17
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
28
#include "drizzled/function/math/round.h"
30
extern const double log_10[309];
35
void Item_func_round::fix_length_and_dec()
41
unsigned_flag= args[0]->unsigned_flag;
42
if (!args[1]->const_item())
44
max_length= args[0]->max_length;
45
decimals= args[0]->decimals;
46
if (args[0]->result_type() == DECIMAL_RESULT)
49
hybrid_type= DECIMAL_RESULT;
52
hybrid_type= REAL_RESULT;
56
val1= args[1]->val_int();
57
val1_unsigned= args[1]->unsigned_flag;
59
decimals_to_set= val1_unsigned ? INT_MAX : 0;
61
decimals_to_set= (val1 > INT_MAX) ? INT_MAX : (int) val1;
63
if (args[0]->decimals == NOT_FIXED_DEC)
65
max_length= args[0]->max_length;
66
decimals= min(decimals_to_set, (int)NOT_FIXED_DEC);
67
hybrid_type= REAL_RESULT;
71
switch (args[0]->result_type()) {
74
hybrid_type= REAL_RESULT;
75
decimals= min(decimals_to_set, (int)NOT_FIXED_DEC);
76
max_length= float_length(decimals);
79
if ((!decimals_to_set && truncate) || (args[0]->decimal_precision() < DECIMAL_LONGLONG_DIGITS))
81
int length_can_increase= test(!truncate && (val1 < 0) && !val1_unsigned);
82
max_length= args[0]->max_length + length_can_increase;
83
/* Here we can keep INT_RESULT */
84
hybrid_type= INT_RESULT;
91
hybrid_type= DECIMAL_RESULT;
92
decimals_to_set= min(DECIMAL_MAX_SCALE, decimals_to_set);
93
int decimals_delta= args[0]->decimals - decimals_to_set;
94
int precision= args[0]->decimal_precision();
95
int length_increase= ((decimals_delta <= 0) || truncate) ? 0:1;
97
precision-= decimals_delta - length_increase;
98
decimals= min(decimals_to_set, DECIMAL_MAX_SCALE);
99
max_length= my_decimal_precision_to_length(precision, decimals,
104
assert(0); /* This result type isn't handled */
108
double my_double_round(double value, int64_t dec, bool dec_unsigned,
112
bool dec_negative= (dec < 0) && !dec_unsigned;
113
uint64_t abs_dec= dec_negative ? -dec : dec;
115
tmp2 is here to avoid return the value with 80 bit precision
116
This will fix that the test round(0.1,1) = round(0.1,1) is true
120
tmp=(abs_dec < array_elements(log_10) ?
121
log_10[abs_dec] : pow(10.0,(double) abs_dec));
123
double value_times_tmp= value * tmp;
126
NOTE: This is a workaround for a gcc 4.3 bug on Intel x86 32bit
127
See http://gcc.gnu.org/bugzilla/show_bug.cgi?id=39228
128
See http://bugs.mysql.com/bug.php?id=42965
130
This forces the compiler to store/load the value as 64bit and avoids
131
an optimisation that *could* have the infinite check be done on the 80bit
134
if(sizeof(double) < sizeof(double_t))
136
volatile double t= value_times_tmp;
140
double infinity= numeric_limits<double>::infinity();
141
if (dec_negative && (tmp == infinity))
143
else if (!dec_negative && (value_times_tmp == infinity))
148
tmp2= dec < 0 ? floor(value/tmp)*tmp : floor(value*tmp)/tmp;
150
tmp2= dec < 0 ? ceil(value/tmp)*tmp : ceil(value*tmp)/tmp;
153
tmp2=dec < 0 ? rint(value/tmp)*tmp : rint(value*tmp)/tmp;
158
double Item_func_round::real_op()
160
double value= args[0]->val_real();
162
if (!(null_value= args[0]->null_value || args[1]->null_value))
163
return my_double_round(value, args[1]->val_int(), args[1]->unsigned_flag,
170
Rounds a given value to a power of 10 specified as the 'to' argument,
171
avoiding overflows when the value is close to the uint64_t range boundary.
174
static inline uint64_t my_unsigned_round(uint64_t value, uint64_t to)
176
uint64_t tmp= value / to * to;
177
return (value - tmp < (to >> 1)) ? tmp : tmp + to;
181
int64_t Item_func_round::int_op()
183
int64_t value= args[0]->val_int();
184
int64_t dec= args[1]->val_int();
187
if ((null_value= args[0]->null_value || args[1]->null_value))
189
if ((dec >= 0) || args[1]->unsigned_flag)
190
return value; // integer have not digits after point
195
if(abs_dec >= array_elements(log_10_int))
198
tmp= log_10_int[abs_dec];
201
value= (unsigned_flag) ?
202
((uint64_t) value / tmp) * tmp : (value / tmp) * tmp;
204
value= (unsigned_flag || value >= 0) ?
205
my_unsigned_round((uint64_t) value, tmp) :
206
-(int64_t) my_unsigned_round((uint64_t) -value, tmp);
211
my_decimal *Item_func_round::decimal_op(my_decimal *decimal_value)
213
my_decimal val, *value= args[0]->val_decimal(&val);
214
int64_t dec= args[1]->val_int();
216
if (dec >= 0 || args[1]->unsigned_flag)
217
dec= min(dec, (int64_t) decimals);
218
else if (dec < INT_MIN)
221
if (!(null_value= (args[0]->null_value || args[1]->null_value ||
222
my_decimal_round(E_DEC_FATAL_ERROR, value, (int) dec,
223
truncate, decimal_value) > 1)))
225
decimal_value->frac= decimals;
226
return decimal_value;