diff options
author | Sergei Golubchik <sergii@pisem.net> | 2011-03-17 11:54:36 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-17 11:54:36 +0100 |
commit | a169ede155937cba04b01ea104d7904d89f87007 (patch) | |
tree | 144a72d6706670d2b116acaf257e385b1709c58e /mysql-test/t/func_time_hires.test | |
parent | 3c6ff364ca31c9b8bc14f5fe583cd60ee5516bfd (diff) | |
download | mariadb-git-a169ede155937cba04b01ea104d7904d89f87007.tar.gz |
lp:736358 Unexpected increased timestamp resolution with UNION
partial fix
Diffstat (limited to 'mysql-test/t/func_time_hires.test')
-rw-r--r-- | mysql-test/t/func_time_hires.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_time_hires.test b/mysql-test/t/func_time_hires.test index 6c0f1085cf2..c651b4aa718 100644 --- a/mysql-test/t/func_time_hires.test +++ b/mysql-test/t/func_time_hires.test @@ -78,3 +78,19 @@ insert t1 values (now(6)); select * from t1; drop table t1; +# +# lp:736358 Unexpected increased timestamp resolution with UNION +# +# timestamp(6) case is fixed: +create table t1 (f1 timestamp(6)); +insert into t1 values ('2002-07-15 21:00:00'); +select time(f1) from t1; +select time(f1) from t1 union all select time(f1) from t1; +#alter table t1 modify f1 timestamp; +#select time(f1) from t1; +#select time(f1) from t1 union all select time(f1) from t1; +# but the effect cannot be eliminated completely: +alter table t1 modify f1 varchar(100); +select time(f1) from t1; +select time(f1) from t1 union all select time(f1) from t1; +drop table t1; |