Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Incorrect CAST results |
Sun, Mar 11 2007 1:38 PM | Permanent Link |
"Ole Willy Tuv" | -- 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 |
Mon, Mar 12 2007 5:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Mar 12 2007 5:25 PM | Permanent Link |
"Ole Willy Tuv" | Tim,
<< See my reply to Roy regarding the rounding. >> Sure. Enjoy your day. Ole Willy Tuv |
Mon, Mar 19 2007 6:04 AM | Permanent Link |
"Ole Willy Tuv" | Tim,
<< See my reply to Roy regarding the rounding. >> Have you looked at the issue ? Ole Willy Tuv |
Mon, Mar 19 2007 6:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ole,
<< Have you looked at the issue ? > Yes, it's fixed. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Apr 5 2007 9:16 AM | Permanent Link |
"Ole Willy Tuv" | 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |