summaryrefslogtreecommitdiff
path: root/mysql-test/main/temporal_scale_4283.test
blob: d79ca7caa547971bad3596d7a954bbacf7b2afc1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
#
# MDEV-4283 Assertion `scale <= precision' fails in strings/decimal.c
#
create table t1 (a int);
insert into t1 values (4),(8);
select distinct 100 mod timestampadd( week, a, '2002-05-20' ) from t1;
drop table t1;

create table t1 (i int);
insert into t1 values (2),(4);
select distinct convert_tz( '2001-03-21', 'utc', 'met' ) mod i from t1;
drop table t1;