2011-06-30 17:46:53 +02:00
|
|
|
/* Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
|
2004-10-18 14:06:46 +02:00
|
|
|
|
|
|
|
This program is free software; you can redistribute it and/or modify
|
|
|
|
it under the terms of the GNU General Public License as published by
|
2006-12-23 20:17:15 +01:00
|
|
|
the Free Software Foundation; version 2 of the License.
|
2004-10-18 14:06:46 +02:00
|
|
|
|
|
|
|
This program is distributed in the hope that it will be useful,
|
|
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
|
|
GNU General Public License for more details.
|
|
|
|
|
|
|
|
You should have received a copy of the GNU General Public License
|
|
|
|
along with this program; if not, write to the Free Software
|
2019-05-11 20:29:06 +02:00
|
|
|
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 USA */
|
2004-10-18 14:06:46 +02:00
|
|
|
|
|
|
|
#ifndef _decimal_h
|
|
|
|
#define _decimal_h
|
|
|
|
|
2015-10-23 11:31:18 +02:00
|
|
|
#ifdef __cplusplus
|
|
|
|
extern "C" {
|
|
|
|
#endif
|
|
|
|
|
2005-02-19 17:58:27 +01:00
|
|
|
typedef enum
|
|
|
|
{TRUNCATE=0, HALF_EVEN, HALF_UP, CEILING, FLOOR}
|
|
|
|
decimal_round_mode;
|
2005-03-21 13:58:34 +01:00
|
|
|
typedef int32 decimal_digit_t;
|
2004-10-18 14:06:46 +02:00
|
|
|
|
2011-08-29 11:24:36 +02:00
|
|
|
/**
|
|
|
|
intg is the number of *decimal* digits (NOT number of decimal_digit_t's !)
|
|
|
|
before the point
|
|
|
|
frac is the number of decimal digits after the point
|
|
|
|
len is the length of buf (length of allocated space) in decimal_digit_t's,
|
|
|
|
not in bytes
|
|
|
|
sign false means positive, true means negative
|
|
|
|
buf is an array of decimal_digit_t's
|
|
|
|
*/
|
2005-03-21 13:58:34 +01:00
|
|
|
typedef struct st_decimal_t {
|
2004-10-19 14:38:54 +02:00
|
|
|
int intg, frac, len;
|
2004-10-18 14:06:46 +02:00
|
|
|
my_bool sign;
|
2005-03-21 13:58:34 +01:00
|
|
|
decimal_digit_t *buf;
|
|
|
|
} decimal_t;
|
2004-10-18 14:06:46 +02:00
|
|
|
|
2005-03-21 13:58:34 +01:00
|
|
|
int internal_str2dec(const char *from, decimal_t *to, char **end,
|
|
|
|
my_bool fixed);
|
2011-03-03 15:25:41 +01:00
|
|
|
int decimal2string(const decimal_t *from, char *to, int *to_len,
|
2020-08-27 11:24:32 +02:00
|
|
|
decimal_digits_t fixed_precision,
|
|
|
|
decimal_digits_t fixed_decimals,
|
2005-02-08 23:50:45 +01:00
|
|
|
char filler);
|
Adding support for Dynamic columns (WL#34):
- COLUMN_CREATE(column_nr, value, [column_nr,value]...)
- COLUMN_ADD(blob,column_nr, value, column_nr,value]...)
- COLUMN_DELETE(blob, column_nr, column_nr...)
- COLUMN_EXISTS(blob, column_nr)
- COLUMN_LIST(blob, column_nr)
- COLUMN_GET(string, column_nr AS type)
Added cast(X as DOUBLE) and cast(x as INT)
Better warning and error messages for wrong cast's
Created some sub functions to simplify and reuse code.
Added a lot of conversation functions with error/warnings for what went wrong.
Fixed some issues when casting time to datetime.
Added functions to dynamic strings and Strings to allow one to move a string buffer from dynamic strings to String (to save malloc+ copy)
Added dynamic columns library to libmysqlclient
include/Makefile.am:
Added ma_dyncol.h
include/decimal.h:
Added 'const' to arguments for some functions.
include/my_sys.h:
Added dynstr_reassociate()
include/my_time.h:
Added TIME_SUBSECOND_RANGE
Added double_to_datetime()
Added flag argument to str_to_time()
libmysql/CMakeLists.txt:
Added mysys/ma_dyncol.c
libmysql/Makefile.shared:
Added ma_dyncol
libmysql/libmysql.c:
Added argument to str_to_time()
mysql-test/r/bigint.result:
Better error messages
mysql-test/r/cast.result:
Better warning and error messages
A lot of new cast() tests
mysql-test/r/func_math.result:
Better warning messages
mysql-test/r/func_str.result:
Better warning messages
mysql-test/r/func_time.result:
Better warning messages
mysql-test/r/sp-vars.result:
Better warning messages
mysql-test/r/strict.result:
Better warning messages
New test result
mysql-test/r/type_newdecimal.result:
Better warning messages
mysql-test/r/warnings.result:
Better warning messages
mysql-test/suite/funcs_1/r/innodb_func_view.result:
Updated results after better cast warnings
mysql-test/suite/funcs_1/r/memory_func_view.result:
Updated results after better cast warnings
mysql-test/suite/funcs_1/r/myisam_func_view.result:
Updated results after better cast warnings
mysql-test/suite/optimizer_unfixed_bugs/t/bug43448.test:
Added begin...commit to speed up test.
mysql-test/suite/parts/inc/part_supported_sql_funcs_delete.inc:
Added begin...commit to speed up test.
mysql-test/suite/parts/inc/partition_supported_sql_funcs.inc:
Added begin...commit to speed up test.
mysql-test/suite/parts/r/part_supported_sql_func_innodb.result:
Added begin...commit to speed up test.
mysql-test/suite/parts/r/part_supported_sql_func_myisam.result:
Added begin...commit to speed up test.
mysql-test/suite/parts/r/rpl_partition.result:
Added begin...commit to speed up test.
mysql-test/suite/parts/t/part_supported_sql_func_innodb.test:
Removed duplicated --big_test
mysql-test/suite/parts/t/rpl_partition.test:
Added begin...commit to speed up test.
mysql-test/suite/pbxt/r/cast.result:
Updated results after better cast warnings
mysql-test/suite/pbxt/r/func_str.result:
Updated results after better cast warnings
mysql-test/suite/pbxt/r/type_newdecimal.result:
Updated results after better cast warnings
mysql-test/suite/rpl/r/rpl_innodb_bug28430.result:
Added begin...commit to speed up test.
mysql-test/suite/rpl/t/rpl_innodb_bug28430.test:
Added begin...commit to speed up test.
mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result:
More warnings
mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result:
More warnings
mysql-test/t/cast.test:
A lot of new cast() tests
mysql-test/t/strict.test:
Added new test
mysys/CMakeLists.txt:
Added ma_dyncol.c
mysys/Makefile.am:
Added ma_dyncol.c
mysys/string.c:
Added dynstr_reassociate() to move a buffer from dynamic_strings to some other allocator
sql-common/my_time.c:
Added 'fuzzydate' flag to str_to_time()
Added support for microseconds to my_time_to_str() and my_datetime_to_str()
Reset second_parts in number_to_datetime()
Added double_to_datetime()
sql/field.cc:
Added double_to_longlong() and truncate_double() to simplify and reuse code
sql/field.h:
New prototypes
sql/item.cc:
Changed Item::get_date(MYSQL_TIME *ltime,uint fuzzydate) to be aware of type of argument.
(Needed to make it microsecond safe and get better warnings).
Updated call to str_to_time_with_warn()
sql/item.h:
Added struct st_dyncall_create_def used by dynamic columns
Added virtual bool dynamic_result() to tell if type of argument may change over calls.
sql/item_cmpfunc.cc:
Added Item_func_dyncol_exists()
sql/item_cmpfunc.h:
Added class Item_func_dyncol_exists
sql/item_create.cc:
Added get_length_and_scale() to simplify other functions
Simplified and extended create_func_cast()
Added support for cast(X as double(X,Y))
Added functions to create dynamic column functions.
sql/item_create.h:
Added prototypes
sql/item_func.cc:
Extended cast functions Item_func_signed() and Item_func_unsigned() to work with dynamic types
Added Item_double_typecast()
sql/item_func.h:
Added class Item_double_typecast()
sql/item_strfunc.cc:
Added functions for COLUMN_CREATE(), COLUMN_ADD(), COLUMN_GET() and COLUMN_LIST()
sql/item_strfunc.h:
Added classes for COLUMN_CREATE(), COLUMN_ADD(), COLUMN_GET() and COLUMN_LIST()
sql/item_timefunc.cc:
Added flag argument to str_to_time_with_warn()
Updated Item_char_typecast() to handle result type that may change between calls (for dynamic columns)
Added Item_time_typecast::get_date() to ensure that we cast a datetime to time properly.
sql/item_timefunc.h:
Added get_date() to Item_time_typecast() to allow proper results for casting time to datetime
sql/lex.h:
Added new SQL function names
sql/my_decimal.cc:
Added 'const' to some arguments.
Better error message in case of errors (we now print out the wrong value)
Added my_decimal2int()
sql/my_decimal.h:
Moved some constants to my_decimal_limits.h
Updated prototypes.
Made my_decimal2int() a function as it's rather long (no reason to have it inline)
Added decimal2my_decimal() function.
sql/mysql_priv.h:
Prototypes for new functions
sql/share/errmsg.txt:
New error messages for wrong casts and dynamic columns
sql/sql_acl.cc:
Fixed indentation
sql/sql_base.cc:
Added dynamic_column_error_message()
sql/sql_string.h:
Added reassociate() to move a buffer to be owned by String object.
sql/sql_yacc.yy:
Added syntax for COLUMN_ functions.
sql/time.cc:
Updated str_to_datetime_with_warn() flag argument to same type as other functions
Added conversion flag to str_to_time_with_warn() (Similar to all datetime functions)
Added conversion functions with warnings: double_to_datetime_with_warn() and decimal_to_datetime_with_warn()
strings/decimal.c:
Added 'const' to arguments for some functions.
unittest/mysys/Makefile.am:
Added test for dynamic columns code
2011-05-08 12:24:06 +02:00
|
|
|
int decimal2ulonglong(const decimal_t *from, ulonglong *to);
|
2005-03-21 13:58:34 +01:00
|
|
|
int ulonglong2decimal(ulonglong from, decimal_t *to);
|
Adding support for Dynamic columns (WL#34):
- COLUMN_CREATE(column_nr, value, [column_nr,value]...)
- COLUMN_ADD(blob,column_nr, value, column_nr,value]...)
- COLUMN_DELETE(blob, column_nr, column_nr...)
- COLUMN_EXISTS(blob, column_nr)
- COLUMN_LIST(blob, column_nr)
- COLUMN_GET(string, column_nr AS type)
Added cast(X as DOUBLE) and cast(x as INT)
Better warning and error messages for wrong cast's
Created some sub functions to simplify and reuse code.
Added a lot of conversation functions with error/warnings for what went wrong.
Fixed some issues when casting time to datetime.
Added functions to dynamic strings and Strings to allow one to move a string buffer from dynamic strings to String (to save malloc+ copy)
Added dynamic columns library to libmysqlclient
include/Makefile.am:
Added ma_dyncol.h
include/decimal.h:
Added 'const' to arguments for some functions.
include/my_sys.h:
Added dynstr_reassociate()
include/my_time.h:
Added TIME_SUBSECOND_RANGE
Added double_to_datetime()
Added flag argument to str_to_time()
libmysql/CMakeLists.txt:
Added mysys/ma_dyncol.c
libmysql/Makefile.shared:
Added ma_dyncol
libmysql/libmysql.c:
Added argument to str_to_time()
mysql-test/r/bigint.result:
Better error messages
mysql-test/r/cast.result:
Better warning and error messages
A lot of new cast() tests
mysql-test/r/func_math.result:
Better warning messages
mysql-test/r/func_str.result:
Better warning messages
mysql-test/r/func_time.result:
Better warning messages
mysql-test/r/sp-vars.result:
Better warning messages
mysql-test/r/strict.result:
Better warning messages
New test result
mysql-test/r/type_newdecimal.result:
Better warning messages
mysql-test/r/warnings.result:
Better warning messages
mysql-test/suite/funcs_1/r/innodb_func_view.result:
Updated results after better cast warnings
mysql-test/suite/funcs_1/r/memory_func_view.result:
Updated results after better cast warnings
mysql-test/suite/funcs_1/r/myisam_func_view.result:
Updated results after better cast warnings
mysql-test/suite/optimizer_unfixed_bugs/t/bug43448.test:
Added begin...commit to speed up test.
mysql-test/suite/parts/inc/part_supported_sql_funcs_delete.inc:
Added begin...commit to speed up test.
mysql-test/suite/parts/inc/partition_supported_sql_funcs.inc:
Added begin...commit to speed up test.
mysql-test/suite/parts/r/part_supported_sql_func_innodb.result:
Added begin...commit to speed up test.
mysql-test/suite/parts/r/part_supported_sql_func_myisam.result:
Added begin...commit to speed up test.
mysql-test/suite/parts/r/rpl_partition.result:
Added begin...commit to speed up test.
mysql-test/suite/parts/t/part_supported_sql_func_innodb.test:
Removed duplicated --big_test
mysql-test/suite/parts/t/rpl_partition.test:
Added begin...commit to speed up test.
mysql-test/suite/pbxt/r/cast.result:
Updated results after better cast warnings
mysql-test/suite/pbxt/r/func_str.result:
Updated results after better cast warnings
mysql-test/suite/pbxt/r/type_newdecimal.result:
Updated results after better cast warnings
mysql-test/suite/rpl/r/rpl_innodb_bug28430.result:
Added begin...commit to speed up test.
mysql-test/suite/rpl/t/rpl_innodb_bug28430.test:
Added begin...commit to speed up test.
mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result:
More warnings
mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result:
More warnings
mysql-test/t/cast.test:
A lot of new cast() tests
mysql-test/t/strict.test:
Added new test
mysys/CMakeLists.txt:
Added ma_dyncol.c
mysys/Makefile.am:
Added ma_dyncol.c
mysys/string.c:
Added dynstr_reassociate() to move a buffer from dynamic_strings to some other allocator
sql-common/my_time.c:
Added 'fuzzydate' flag to str_to_time()
Added support for microseconds to my_time_to_str() and my_datetime_to_str()
Reset second_parts in number_to_datetime()
Added double_to_datetime()
sql/field.cc:
Added double_to_longlong() and truncate_double() to simplify and reuse code
sql/field.h:
New prototypes
sql/item.cc:
Changed Item::get_date(MYSQL_TIME *ltime,uint fuzzydate) to be aware of type of argument.
(Needed to make it microsecond safe and get better warnings).
Updated call to str_to_time_with_warn()
sql/item.h:
Added struct st_dyncall_create_def used by dynamic columns
Added virtual bool dynamic_result() to tell if type of argument may change over calls.
sql/item_cmpfunc.cc:
Added Item_func_dyncol_exists()
sql/item_cmpfunc.h:
Added class Item_func_dyncol_exists
sql/item_create.cc:
Added get_length_and_scale() to simplify other functions
Simplified and extended create_func_cast()
Added support for cast(X as double(X,Y))
Added functions to create dynamic column functions.
sql/item_create.h:
Added prototypes
sql/item_func.cc:
Extended cast functions Item_func_signed() and Item_func_unsigned() to work with dynamic types
Added Item_double_typecast()
sql/item_func.h:
Added class Item_double_typecast()
sql/item_strfunc.cc:
Added functions for COLUMN_CREATE(), COLUMN_ADD(), COLUMN_GET() and COLUMN_LIST()
sql/item_strfunc.h:
Added classes for COLUMN_CREATE(), COLUMN_ADD(), COLUMN_GET() and COLUMN_LIST()
sql/item_timefunc.cc:
Added flag argument to str_to_time_with_warn()
Updated Item_char_typecast() to handle result type that may change between calls (for dynamic columns)
Added Item_time_typecast::get_date() to ensure that we cast a datetime to time properly.
sql/item_timefunc.h:
Added get_date() to Item_time_typecast() to allow proper results for casting time to datetime
sql/lex.h:
Added new SQL function names
sql/my_decimal.cc:
Added 'const' to some arguments.
Better error message in case of errors (we now print out the wrong value)
Added my_decimal2int()
sql/my_decimal.h:
Moved some constants to my_decimal_limits.h
Updated prototypes.
Made my_decimal2int() a function as it's rather long (no reason to have it inline)
Added decimal2my_decimal() function.
sql/mysql_priv.h:
Prototypes for new functions
sql/share/errmsg.txt:
New error messages for wrong casts and dynamic columns
sql/sql_acl.cc:
Fixed indentation
sql/sql_base.cc:
Added dynamic_column_error_message()
sql/sql_string.h:
Added reassociate() to move a buffer to be owned by String object.
sql/sql_yacc.yy:
Added syntax for COLUMN_ functions.
sql/time.cc:
Updated str_to_datetime_with_warn() flag argument to same type as other functions
Added conversion flag to str_to_time_with_warn() (Similar to all datetime functions)
Added conversion functions with warnings: double_to_datetime_with_warn() and decimal_to_datetime_with_warn()
strings/decimal.c:
Added 'const' to arguments for some functions.
unittest/mysys/Makefile.am:
Added test for dynamic columns code
2011-05-08 12:24:06 +02:00
|
|
|
int decimal2longlong(const decimal_t *from, longlong *to);
|
2005-03-21 13:58:34 +01:00
|
|
|
int longlong2decimal(longlong from, decimal_t *to);
|
2011-03-03 15:25:41 +01:00
|
|
|
int decimal2double(const decimal_t *from, double *to);
|
2005-03-21 13:58:34 +01:00
|
|
|
int double2decimal(double from, decimal_t *to);
|
2020-08-27 11:24:32 +02:00
|
|
|
decimal_digits_t decimal_actual_fraction(const decimal_t *from);
|
|
|
|
int decimal2bin(const decimal_t *from, uchar *to, decimal_digits_t precision,
|
|
|
|
decimal_digits_t scale);
|
|
|
|
int bin2decimal(const uchar *from, decimal_t *to, decimal_digits_t precision,
|
|
|
|
decimal_digits_t scale);
|
2004-10-19 14:38:54 +02:00
|
|
|
|
2020-08-27 11:24:32 +02:00
|
|
|
uint decimal_size(decimal_digits_t precision, decimal_digits_t scale);
|
|
|
|
uint decimal_bin_size(decimal_digits_t precision, decimal_digits_t scale);
|
|
|
|
uint decimal_result_size(decimal_t *from1, decimal_t *from2, char op,
|
|
|
|
int param);
|
2004-10-18 14:06:46 +02:00
|
|
|
|
2020-08-27 11:24:32 +02:00
|
|
|
decimal_digits_t decimal_intg(const decimal_t *from);
|
2011-03-03 15:25:41 +01:00
|
|
|
int decimal_add(const decimal_t *from1, const decimal_t *from2, decimal_t *to);
|
|
|
|
int decimal_sub(const decimal_t *from1, const decimal_t *from2, decimal_t *to);
|
|
|
|
int decimal_cmp(const decimal_t *from1, const decimal_t *from2);
|
|
|
|
int decimal_mul(const decimal_t *from1, const decimal_t *from2, decimal_t *to);
|
|
|
|
int decimal_div(const decimal_t *from1, const decimal_t *from2, decimal_t *to,
|
2005-03-21 13:58:34 +01:00
|
|
|
int scale_incr);
|
2011-03-03 15:25:41 +01:00
|
|
|
int decimal_mod(const decimal_t *from1, const decimal_t *from2, decimal_t *to);
|
|
|
|
int decimal_round(const decimal_t *from, decimal_t *to, int new_scale,
|
2005-02-19 17:58:27 +01:00
|
|
|
decimal_round_mode mode);
|
2011-03-03 15:25:41 +01:00
|
|
|
int decimal_is_zero(const decimal_t *from);
|
2020-08-27 11:24:32 +02:00
|
|
|
void max_decimal(decimal_digits_t precision, decimal_digits_t frac,
|
|
|
|
decimal_t *to);
|
2004-10-19 14:38:54 +02:00
|
|
|
|
2005-02-19 17:58:27 +01:00
|
|
|
#define string2decimal(A,B,C) internal_str2dec((A), (B), (C), 0)
|
|
|
|
#define string2decimal_fixed(A,B,C) internal_str2dec((A), (B), (C), 1)
|
|
|
|
|
2005-03-21 13:58:34 +01:00
|
|
|
/* set a decimal_t to zero */
|
2004-10-29 00:22:54 +02:00
|
|
|
|
|
|
|
#define decimal_make_zero(dec) do { \
|
|
|
|
(dec)->buf[0]=0; \
|
|
|
|
(dec)->intg=1; \
|
|
|
|
(dec)->frac=0; \
|
|
|
|
(dec)->sign=0; \
|
|
|
|
} while(0)
|
|
|
|
|
|
|
|
/*
|
|
|
|
returns the length of the buffer to hold string representation
|
2004-11-03 22:30:37 +01:00
|
|
|
of the decimal (including decimal dot, possible sign and \0)
|
2004-10-29 00:22:54 +02:00
|
|
|
*/
|
|
|
|
|
2005-02-08 23:50:45 +01:00
|
|
|
#define decimal_string_size(dec) (((dec)->intg ? (dec)->intg : 1) + \
|
|
|
|
(dec)->frac + ((dec)->frac > 0) + 2)
|
2004-10-29 00:22:54 +02:00
|
|
|
|
|
|
|
/* negate a decimal */
|
2004-10-31 12:29:38 +01:00
|
|
|
#define decimal_neg(dec) do { (dec)->sign^=1; } while(0)
|
2004-10-29 00:22:54 +02:00
|
|
|
|
2004-10-18 14:06:46 +02:00
|
|
|
/*
|
|
|
|
conventions:
|
|
|
|
|
|
|
|
decimal_smth() == 0 -- everything's ok
|
2004-10-19 14:38:54 +02:00
|
|
|
decimal_smth() <= 1 -- result is usable, but precision loss is possible
|
|
|
|
decimal_smth() <= 2 -- result can be unusable, most significant digits
|
|
|
|
could've been lost
|
|
|
|
decimal_smth() > 2 -- no result was generated
|
2004-10-18 14:06:46 +02:00
|
|
|
*/
|
|
|
|
|
|
|
|
#define E_DEC_OK 0
|
2004-10-19 14:38:54 +02:00
|
|
|
#define E_DEC_TRUNCATED 1
|
|
|
|
#define E_DEC_OVERFLOW 2
|
2004-11-03 18:43:48 +01:00
|
|
|
#define E_DEC_DIV_ZERO 4
|
|
|
|
#define E_DEC_BAD_NUM 8
|
|
|
|
#define E_DEC_OOM 16
|
|
|
|
|
|
|
|
#define E_DEC_ERROR 31
|
|
|
|
#define E_DEC_FATAL_ERROR 30
|
2004-10-18 14:06:46 +02:00
|
|
|
|
2015-10-23 11:31:18 +02:00
|
|
|
#ifdef __cplusplus
|
|
|
|
}
|
|
|
|
#endif
|
|
|
|
|
2004-10-18 14:06:46 +02:00
|
|
|
#endif
|
|
|
|
|