-- dummy table to use in select tests
create table dummy(col1 integer);
insert into dummy values (null);

select
 cast(2.5555 as smallint) res_smallint,
 cast(2.5555 as integer) res_integer,
 cast(2.5555 as bigint) res_bigint,
 cast(2.5555 as decimal) res_decimal_scale_0,
 cast(2.5555 as decimal(17,1)) res_decimal_scale_1,
 cast(2.5555 as decimal(18,2)) res_decimal_scale_2,
 cast(2.5555 as decimal(19,3)) res_decimal_scale_3,
 cast(2.5555 as decimal(20,4)) res_decimal_scale_4
from dummy

                                                   <-- Correct values -->
Result column               Value       Truncated     Rounded
----------------------------------------------------------
res_smallint                   NULL      2                  3
res_integer                    NULL      2                  3
res_bigint                      NULL      2                  3
res_decimal_scale_0     2.5555     2                  3
res_decimal_scale_1     2.5555     2.5               2.6
res_decimal_scale_2     2.5555     2.55             2.56
res_decimal_scale_3     2.5555     2.555           2.556
res_decimal_scale_4     2.5555     2.5555         2.5555
----------------------------------------------------------

The correct results of the cast expressions would be either the truncated
values or the rounded values, depending on whether ElevateDB uses truncation
or rounding.

Ole Willy Tuv

Ole,

<< The correct results of the cast expressions would be either the truncated
values or the rounded values, depending on whether ElevateDB uses truncation
or rounding. >>

See my reply to Roy regarding the rounding.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< See my reply to Roy regarding the rounding. >>

Sure. Enjoy your day.

Ole Willy Tuv

Tim,

<< See my reply to Roy regarding the rounding. >>

Have you looked at the issue ?

Ole Willy Tuv

Ole,

<< Have you looked at the issue ? >

Yes, it's fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< select
 cast(2.5555 as smallint) res_smallint,
 cast(2.5555 as integer) res_integer,
 cast(2.5555 as bigint) res_bigint,
 cast(2.5555 as decimal) res_decimal_scale_0,
 cast(2.5555 as decimal(17,1)) res_decimal_scale_1,
 cast(2.5555 as decimal(18,2)) res_decimal_scale_2,
 cast(2.5555 as decimal(19,3)) res_decimal_scale_3,
 cast(2.5555 as decimal(20,4)) res_decimal_scale_4
from dummy >>

1.02 build 1 still returns null for the smallint, integer and bigint values.

Ole Willy Tuv