[reporter="jpham", created="Fri, 21 Jul 2006 10:09:21 -0500 (GMT-05:00)"]
hi xiaoyang, if you have some time could you look at
this one? as usual, you can also return the bug to us.
create schema s;
set schema 's';
create table adouble (i int primary key, d double);
insert into adouble values (0, 1.9);
select cast (d as bigint) from adouble;
[reporter="jpham", created="Fri, 21 Jul 2006 10:09:21 -0500 (GMT-05:00)"] hi xiaoyang, if you have some time could you look at
this one? as usual, you can also return the bug to us.
create schema s;
set schema 's';
create table adouble (i int primary key, d double);
insert into adouble values (0, 1.9);
select cast (d as bigint) from adouble;
the query casts 1.9 to be 1