diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-08 19:41:58 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-08 19:41:58 +0100 |
| commit | 8b7fd8f577fe3edc84eea54288c7d30775a1559b (patch) | |
| tree | 6d245df86f99894d74eea055dc01800ccc2d7bb4 /mysql-test/r/func_time_hires.result | |
| parent | 2c80662d231414eb98b5cd4cede069d1482ccc20 (diff) | |
| download | mariadb-git-8b7fd8f577fe3edc84eea54288c7d30775a1559b.tar.gz | |
lp:731124 Loss of precision on DISTINCT
many changes:
* NOT_FIXED_DEC now create hires fields, not old ones.
As a result, temp tables preserve microseconds (on DISTINCT, GROUP BY)
* I_S tables force decimals=0 on temporal types (backward compatibility)
* Item_func_coalesce calculates decimals for temporal types
* no precision for TIME/DATETIME in CAST means 0, not NOT_FIXED_DEC
* addtime/timediff calculate decimals from arguments (not NOT_FIXED_DEC)
sql/field.h:
NOT_FIXED_DEC now create hires fields, not old ones
sql/item.h:
force decimals=0 for I_S tables
sql/item_cmpfunc.cc:
Item_func_coalesce calculates decimals for temporal types
sql/item_create.cc:
no precision for TIME/DATETIME in CAST means 0, not NOT_FIXED_DEC
sql/item_timefunc.cc:
addtime calculates decimals from arguments (not NOT_FIXED_DEC)
sql/item_timefunc.h:
timediff calculates decimals from arguments (not NOT_FIXED_DEC)
Diffstat (limited to 'mysql-test/r/func_time_hires.result')
| -rw-r--r-- | mysql-test/r/func_time_hires.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/func_time_hires.result b/mysql-test/r/func_time_hires.result index 06ad9374725..0fe79c65882 100644 --- a/mysql-test/r/func_time_hires.result +++ b/mysql-test/r/func_time_hires.result @@ -37,7 +37,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `sec_to_time(12345)` time DEFAULT NULL, `sec_to_time(12345.6789)` time(4) DEFAULT NULL, - `sec_to_time(1234567e-2)` time DEFAULT NULL, + `sec_to_time(1234567e-2)` time(6) DEFAULT NULL, `now()` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `curtime(0)` time NOT NULL DEFAULT '00:00:00', `utc_timestamp(1)` datetime(1) NOT NULL DEFAULT '0000-00-00 00:00:00.0', @@ -52,7 +52,7 @@ t1 CREATE TABLE `t1` ( select * from t1; sec_to_time(12345) 03:25:45 sec_to_time(12345.6789) 03:25:45.6789 -sec_to_time(1234567e-2) 03:25:45 +sec_to_time(1234567e-2) 03:25:45.670000 now() 2011-01-01 01:01:01 curtime(0) 01:01:01 utc_timestamp(1) 2010-12-31 22:01:01.1 |