ql/src/test/queries/clientpositive/decimal_2.q

--! qt:dataset:src
set hive.fetch.task.conversion=more;

drop table decimal_2_n1;

create table decimal_2_n1 (t decimal(18,9));
alter table decimal_2_n1 set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe';

insert overwrite table decimal_2_n1
  select cast('17.29' as decimal(4,2)) from src tablesample (1 rows);

select cast(t as boolean) from decimal_2_n1;
select cast(t as tinyint) from decimal_2_n1;
select cast(t as smallint) from decimal_2_n1;
select cast(t as int) from decimal_2_n1;
select cast(t as bigint) from decimal_2_n1;
select cast(t as float) from decimal_2_n1;
select cast(t as double) from decimal_2_n1;
select cast(t as string) from decimal_2_n1;

insert overwrite table decimal_2_n1
  select cast('3404045.5044003' as decimal(18,9)) from src tablesample (1 rows);

select cast(t as boolean) from decimal_2_n1;
select cast(t as tinyint) from decimal_2_n1;
select cast(t as smallint) from decimal_2_n1;
select cast(t as int) from decimal_2_n1;
select cast(t as bigint) from decimal_2_n1;
select cast(t as float) from decimal_2_n1;
select cast(t as double) from decimal_2_n1;
select cast(t as string) from decimal_2_n1;

select cast(3.14 as decimal(4,2)) from decimal_2_n1;
select cast(3.14 as decimal(5,4)) from decimal_2_n1;
select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2_n1;
select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2_n1;
select cast(true as decimal) from decimal_2_n1;
select cast(3Y as decimal) from decimal_2_n1;
select cast(3S as decimal) from decimal_2_n1;
select cast(cast(3 as int) as decimal) from decimal_2_n1;
select cast(3L as decimal) from decimal_2_n1;
select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2_n1;
select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2_n1;
drop table decimal_2_n1;