12
12
You should have received a copy of the GNU General Public License
13
13
along with this program; if not, write to the Free Software
14
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
14
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */
108
108
#include "drizzled/definitions.h"
109
109
#include "drizzled/internal/m_string.h"
110
110
#include "drizzled/charset_info.h"
111
#include "drizzled/type/decimal.h"
111
#include "drizzled/decimal.h"
113
113
#include <plugin/myisam/myisampack.h>
114
114
#include <drizzled/util/test.h>
159
159
case E_DEC_DIV_ZERO:
160
my_error(ER_DIVISION_BY_ZERO, MYF(0));
160
push_warning_printf(current_session, DRIZZLE_ERROR::WARN_LEVEL_ERROR,
161
ER_DIVISION_BY_ZERO, ER(ER_DIVISION_BY_ZERO));
162
163
case E_DEC_BAD_NUM:
163
164
push_warning_printf(current_session, DRIZZLE_ERROR::WARN_LEVEL_ERROR,
194
195
@retval E_DEC_OOM
197
int class_decimal2string(const type::Decimal *d,
198
uint32_t fixed_dec, String *str)
198
int my_decimal2string(uint32_t mask, const my_decimal *d,
199
uint32_t fixed_prec, uint32_t fixed_dec,
200
char filler, String *str)
200
uint32_t mask= E_DEC_FATAL_ERROR;
203
203
Calculate the size of the string: For DECIMAL(a,b), fixed_prec==a
204
204
holds true iff the type is also ZEROFILL, which in turn implies
207
207
one if the user only wanted decimal places, but we force a leading
208
208
zero on them. Because the type is implicitly UNSIGNED, we do not
209
209
need to reserve a character for the sign. For all other cases,
210
fixed_prec will be 0, and class_decimal_string_length() will be called
210
fixed_prec will be 0, and my_decimal_string_length() will be called
211
211
instead to calculate the required size of the buffer.
214
? (uint32_t)(((0 == fixed_dec) ? 1 : 0) + 1)
215
: (uint32_t)d->string_length());
213
int length= (fixed_prec
214
? (fixed_prec + ((fixed_prec == fixed_dec) ? 1 : 0) + 1)
215
: my_decimal_string_length(d));
217
217
if (str->alloc(length))
218
218
return check_result(mask, E_DEC_OOM);
220
219
result= decimal2string((decimal_t*) d, (char*) str->ptr(),
221
&length, (int)0, fixed_dec,
220
&length, (int)fixed_prec, fixed_dec,
223
222
str->length(length);
224
223
return check_result(mask, result);
244
243
@retval E_DEC_OVERFLOW
249
int Decimal::val_binary(uint32_t mask, unsigned char *bin, int prec, int scale) const
246
int my_decimal2binary(uint32_t mask, const my_decimal *d, unsigned char *bin, int prec,
251
249
int err1= E_DEC_OK, err2;
252
type::Decimal rounded;
253
class_decimal2decimal(this, &rounded);
251
my_decimal2decimal(d, &rounded);
254
252
rounded.frac= decimal_actual_fraction(&rounded);
255
253
if (scale < rounded.frac)
291
289
String tmp(buff, sizeof(buff), &my_charset_bin);
292
290
if (charset->mbminlen > 1)
292
uint32_t dummy_errors;
295
293
tmp.copy(from, length, charset, &my_charset_utf8_general_ci, &dummy_errors);
297
295
length= tmp.length();
298
296
charset= &my_charset_bin;
300
298
from_end= end= (char*) from+length;
301
err= string2decimal((char *)from, (decimal_t*) this, &end);
299
err= string2decimal((char *)from, (decimal_t*) decimal_value, &end);
302
300
if (end != from_end && !err)
304
302
/* Give warning if there is something other than end space */
314
check_result_and_overflow(mask, err);
312
check_result_and_overflow(mask, err, decimal_value);
318
void type::Decimal::convert(double &result) const
320
decimal2double(static_cast<const decimal_t*>(this), &result);
323
type::Decimal *date2_class_decimal(type::Time *ltime, type::Decimal *dec)
317
my_decimal *date2my_decimal(DRIZZLE_TIME *ltime, my_decimal *dec)
326
320
date = (ltime->year*100L + ltime->month)*100L + ltime->day;
327
if (ltime->time_type > type::DRIZZLE_TIMESTAMP_DATE)
321
if (ltime->time_type > DRIZZLE_TIMESTAMP_DATE)
328
322
date= ((date*100L + ltime->hour)*100L+ ltime->minute)*100L + ltime->second;
330
if (int2_class_decimal(E_DEC_FATAL_ERROR, date, false, dec))
323
if (int2my_decimal(E_DEC_FATAL_ERROR, date, false, dec))
333
325
if (ltime->second_part)
335
327
dec->buf[(dec->intg-1) / 9 + 1]= ltime->second_part * 1000;
343
void class_decimal_trim(uint32_t *precision, uint32_t *scale)
334
void my_decimal_trim(uint32_t *precision, uint32_t *scale)
345
336
if (!(*precision) && !(*scale))
373
364
#define DIG_MASK 100000000
374
365
#define DIG_BASE 1000000000
375
366
#define DIG_MAX (DIG_BASE-1)
378
inline static T round_up(const T &x)
380
return (x+DIG_PER_DEC1-1)/DIG_PER_DEC1;
367
#define ROUND_UP(X) (((X)+DIG_PER_DEC1-1)/DIG_PER_DEC1)
383
368
static const dec1 powers10[DIG_PER_DEC1+1]={
384
369
1, 10, 100, 1000, 10000, 100000, 1000000, 10000000, 100000000, 1000000000};
385
370
static const int dig2bytes[DIG_PER_DEC1+1]={0, 1, 1, 2, 2, 3, 3, 4, 4, 4};
388
373
999900000, 999990000, 999999000,
389
374
999999900, 999999990 };
392
377
#define sanity(d) assert((d)->len > 0)
394
379
#define sanity(d) assert((d)->len >0 && ((d)->buf[0] | \
395
380
(d)->buf[(d)->len-1] | 1))
398
inline static void fix_intg_frac_error(const int len, int &intg1, int &frac1, int &error)
400
if (unlikely(intg1+frac1 > len))
402
if (unlikely(intg1 > len))
406
error=E_DEC_OVERFLOW;
411
error=E_DEC_TRUNCATED;
418
/* assume carry <= 1 */
419
inline static void add(dec1 &to, const dec1 &from1, const dec1& from2, dec1 &carry)
421
dec1 a=from1+from2+carry;
423
if ((carry= (a >= DIG_BASE))) /* no division here! */
428
inline static void add2(dec1 &to, const dec1 &from1, const dec1 &from2, dec1 &carry)
430
dec2 a=dec2(from1)+from2+carry;
431
if ((carry= (a >= DIG_BASE)))
433
if (unlikely(a >= DIG_BASE))
442
inline static void sub(dec1 &to, const dec1 &from1, const dec1 &from2, dec1 &carry)
444
dec1 a=from1-from2-carry;
445
if ((carry= (a < 0)))
451
inline static void sub2(dec1 &to, const dec1 &from1, const dec1 &from2, dec1 &carry)
453
dec1 a=from1-from2-carry;
454
if ((carry= (a < 0)))
383
#define FIX_INTG_FRAC_ERROR(len, intg1, frac1, error) \
386
if (unlikely(intg1+frac1 > (len))) \
388
if (unlikely(intg1 > (len))) \
392
error=E_DEC_OVERFLOW; \
397
error=E_DEC_TRUNCATED; \
404
#define ADD(to, from1, from2, carry) /* assume carry <= 1 */ \
407
dec1 a=(from1)+(from2)+(carry); \
408
assert((carry) <= 1); \
409
if (((carry)= a >= DIG_BASE)) /* no division here! */ \
414
#define ADD2(to, from1, from2, carry) \
417
dec2 a=((dec2)(from1))+(from2)+(carry); \
418
if (((carry)= a >= DIG_BASE)) \
420
if (unlikely(a >= DIG_BASE)) \
428
#define SUB(to, from1, from2, carry) /* to=from1-from2 */ \
431
dec1 a=(from1)-(from2)-(carry); \
432
if (((carry)= a < 0)) \
437
#define SUB2(to, from1, from2, carry) /* to=from1-from2 */ \
440
dec1 a=(from1)-(from2)-(carry); \
441
if (((carry)= a < 0)) \
443
if (unlikely(a < 0)) \
452
Swap the contents of two variables.
454
#define swap_variables(TYPE, a, b) \
465
465
@brief Get maximum value for given precision and scale
755
755
static void do_mini_left_shift(decimal_t *dec, int shift, int beg, int last)
757
dec1 *from= dec->buf + round_up(beg + 1) - 1;
758
dec1 *end= dec->buf + round_up(last) - 1;
757
dec1 *from= dec->buf + ROUND_UP(beg + 1) - 1;
758
dec1 *end= dec->buf + ROUND_UP(last) - 1;
759
759
int c_shift= DIG_PER_DEC1 - shift;
760
760
assert(from >= dec->buf);
761
761
assert(end < dec->buf + dec->len);
783
783
static void do_mini_right_shift(decimal_t *dec, int shift, int beg, int last)
785
dec1 *from= dec->buf + round_up(last) - 1;
786
dec1 *end= dec->buf + round_up(beg + 1) - 1;
785
dec1 *from= dec->buf + ROUND_UP(last) - 1;
786
dec1 *end= dec->buf + ROUND_UP(beg + 1) - 1;
787
787
int c_shift= DIG_PER_DEC1 - shift;
788
788
assert(from < dec->buf + dec->len);
789
789
assert(end >= dec->buf);
942
941
d_shift= new_front / DIG_PER_DEC1;
943
to= dec->buf + (round_up(beg + 1) - 1 - d_shift);
944
barier= dec->buf + (round_up(end) - 1 - d_shift);
942
to= dec->buf + (ROUND_UP(beg + 1) - 1 - d_shift);
943
barier= dec->buf + (ROUND_UP(end) - 1 - d_shift);
945
944
assert(to >= dec->buf);
946
945
assert(barier + d_shift < dec->buf + dec->len);
947
946
for(; to <= barier; to++)
956
955
d_shift= (1 - new_front) / DIG_PER_DEC1;
957
to= dec->buf + round_up(end) - 1 + d_shift;
958
barier= dec->buf + round_up(beg + 1) - 1 + d_shift;
956
to= dec->buf + ROUND_UP(end) - 1 + d_shift;
957
barier= dec->buf + ROUND_UP(beg + 1) - 1 + d_shift;
959
958
assert(to < dec->buf + dec->len);
960
959
assert(barier - d_shift >= dec->buf);
961
960
for(; to >= barier; to--)
1671
1670
decimal_round(const decimal_t *from, decimal_t *to, int scale,
1672
1671
decimal_round_mode mode)
1674
int frac0=scale>0 ? round_up(scale) : scale/DIG_PER_DEC1,
1675
frac1=round_up(from->frac), round_digit= 0,
1676
intg0=round_up(from->intg), error=E_DEC_OK, len=to->len,
1677
intg1=round_up(from->intg +
1673
int frac0=scale>0 ? ROUND_UP(scale) : scale/DIG_PER_DEC1,
1674
frac1=ROUND_UP(from->frac), round_digit= 0,
1675
intg0=ROUND_UP(from->intg), error=E_DEC_OK, len=to->len,
1676
intg1=ROUND_UP(from->intg +
1678
1677
(((intg0 + frac0)>0) && (from->buf[0] == DIG_MAX)));
1679
1678
dec1 *buf0=from->buf, *buf1=to->buf, x, y, carry=0;
1863
1862
static int do_add(const decimal_t *from1, const decimal_t *from2, decimal_t *to)
1865
int intg1=round_up(from1->intg), intg2=round_up(from2->intg),
1866
frac1=round_up(from1->frac), frac2=round_up(from2->frac),
1864
int intg1=ROUND_UP(from1->intg), intg2=ROUND_UP(from2->intg),
1865
frac1=ROUND_UP(from1->frac), frac2=ROUND_UP(from2->frac),
1867
1866
frac0=max(frac1, frac2), intg0=max(intg1, intg2), error;
1868
1867
dec1 *buf1, *buf2, *buf0, *stop, *stop2, x, carry;
1879
1878
to->buf[0]=0; /* safety */
1882
fix_intg_frac_error(to->len, intg0, frac0, error);
1881
FIX_INTG_FRAC_ERROR(to->len, intg0, frac0, error);
1883
1882
if (unlikely(error == E_DEC_OVERFLOW))
1885
1884
max_decimal(to->len * DIG_PER_DEC1, 0, to);
1944
1943
if to==0, return -1/0/+1 - the result of the comparison */
1945
1944
static int do_sub(const decimal_t *from1, const decimal_t *from2, decimal_t *to)
1947
int intg1=round_up(from1->intg), intg2=round_up(from2->intg),
1948
frac1=round_up(from1->frac), frac2=round_up(from2->frac);
1946
int intg1=ROUND_UP(from1->intg), intg2=ROUND_UP(from2->intg),
1947
frac1=ROUND_UP(from1->frac), frac2=ROUND_UP(from2->frac);
1949
1948
int frac0=max(frac1, frac2), error;
1950
1949
dec1 *buf1, *buf2, *buf0, *stop1, *stop2, *start1, *start2, carry=0;
2013
2010
/* ensure that always from1 > from2 (and intg1 >= intg2) */
2017
swap(start1, start2);
2013
swap_variables(const decimal_t *,from1, from2);
2014
swap_variables(dec1 *,start1, start2);
2015
swap_variables(int,intg1,intg2);
2016
swap_variables(int,frac1,frac2);
2020
2017
to->sign= 1 - to->sign;
2023
fix_intg_frac_error(to->len, intg1, frac0, error);
2020
FIX_INTG_FRAC_ERROR(to->len, intg1, frac0, error);
2024
2021
buf0=to->buf+intg1+frac0;
2026
2023
to->frac=max(from1->frac, from2->frac);
2055
2052
while (buf2 > stop2)
2057
sub(*--buf0, 0, *--buf2, carry);
2054
SUB(*--buf0, 0, *--buf2, carry);
2061
2058
/* part 2 - cmin(frac) ... intg2 */
2062
2059
while (buf2 > start2)
2064
sub(*--buf0, *--buf1, *--buf2, carry);
2061
SUB(*--buf0, *--buf1, *--buf2, carry);
2067
2064
/* part 3 - intg2 ... intg1 */
2068
2065
while (carry && buf1 > start1)
2070
sub(*--buf0, *--buf1, 0, carry);
2067
SUB(*--buf0, *--buf1, 0, carry);
2073
2070
while (buf1 > start1)
2147
2138
int decimal_mul(const decimal_t *from1, const decimal_t *from2, decimal_t *to)
2149
int intg1=round_up(from1->intg), intg2=round_up(from2->intg),
2150
frac1=round_up(from1->frac), frac2=round_up(from2->frac),
2151
intg0=round_up(from1->intg+from2->intg),
2140
int intg1=ROUND_UP(from1->intg), intg2=ROUND_UP(from2->intg),
2141
frac1=ROUND_UP(from1->frac), frac2=ROUND_UP(from2->frac),
2142
intg0=ROUND_UP(from1->intg+from2->intg),
2152
2143
frac0=frac1+frac2, error, i, j, d_to_move;
2153
2144
dec1 *buf1=from1->buf+intg1, *buf2=from2->buf+intg2, *buf0,
2154
2145
*start2, *stop2, *stop1, *start0, carry;
2160
fix_intg_frac_error(to->len, intg0, frac0, error);
2151
FIX_INTG_FRAC_ERROR(to->len, intg0, frac0, error);
2161
2152
to->sign=from1->sign != from2->sign;
2162
2153
to->frac=from1->frac+from2->frac;
2163
2154
to->intg=intg0*DIG_PER_DEC1;
2198
2189
dec2 p= ((dec2)*buf1) * ((dec2)*buf2);
2199
2190
hi=(dec1)(p/DIG_BASE);
2200
2191
lo=(dec1)(p-((dec2)hi)*DIG_BASE);
2201
add2(*buf0, *buf0, lo, carry);
2192
ADD2(*buf0, *buf0, lo, carry);
2206
2197
if (buf0 < to->buf)
2207
2198
return E_DEC_OVERFLOW;
2208
add2(*buf0, *buf0, 0, carry);
2199
ADD2(*buf0, *buf0, 0, carry);
2210
2201
for (buf0--; carry; buf0--)
2212
2203
if (buf0 < to->buf)
2213
2204
return E_DEC_OVERFLOW;
2214
add(*buf0, *buf0, 0, carry);
2205
ADD(*buf0, *buf0, 0, carry);
2264
2255
static int do_div_mod(const decimal_t *from1, const decimal_t *from2,
2265
2256
decimal_t *to, decimal_t *mod, int scale_incr)
2267
int frac1=round_up(from1->frac)*DIG_PER_DEC1, prec1=from1->intg+frac1,
2268
frac2=round_up(from2->frac)*DIG_PER_DEC1, prec2=from2->intg+frac2,
2258
int frac1=ROUND_UP(from1->frac)*DIG_PER_DEC1, prec1=from1->intg+frac1,
2259
frac2=ROUND_UP(from2->frac)*DIG_PER_DEC1, prec2=from2->intg+frac2,
2269
2260
error= 0, i, intg0, frac0, len1, len2, dintg, div_mod=(!mod);
2270
2261
dec1 *buf0, *buf1=from1->buf, *buf2=from2->buf, *tmp1,
2271
2262
*start2, *stop2, *stop1, *stop0, norm2, carry, *start1, dcarry;
2334
2325
N2 is in the buf2, has prec2 digits. Scales are frac1 and
2335
2326
frac2 accordingly.
2336
2327
Thus, the result will have
2337
frac = round_up(frac1+frac2+scale_incr)
2328
frac = ROUND_UP(frac1+frac2+scale_incr)
2339
2330
intg = (prec1-frac1) - (prec2-frac2) + 1
2340
2331
prec = intg+frac
2342
frac0=round_up(frac1+frac2+scale_incr);
2343
fix_intg_frac_error(to->len, intg0, frac0, error);
2333
frac0=ROUND_UP(frac1+frac2+scale_incr);
2334
FIX_INTG_FRAC_ERROR(to->len, intg0, frac0, error);
2344
2335
to->sign=from1->sign != from2->sign;
2345
2336
to->intg=intg0*DIG_PER_DEC1;
2346
2337
to->frac=frac0*DIG_PER_DEC1;
2552
2543
return do_div_mod(from1, from2, 0, to, 0);
2555
std::ostream& operator<<(std::ostream& output, const type::Decimal &dec)
2557
drizzled::String str;
2559
class_decimal2string(&dec, 0, &str);
2561
output << "type::Decimal:(";
2562
output << str.c_ptr();
2565
return output; // for multiple << operators.
2568
2546
} /* namespace drizzled */
2579
2557
printf("/* intg=%d, frac=%d, sign=%d, buf[]={", d->intg, d->frac, d->sign);
2580
for (i=0; i < round_up(d->frac)+round_up(d->intg)-1; i++)
2558
for (i=0; i < ROUND_UP(d->frac)+ROUND_UP(d->intg)-1; i++)
2581
2559
printf("%09d, ", d->buf[i]);
2582
2560
printf("%09d} */ ", d->buf[i]);