A bug in Sybase's query parser/ numeric conversion code

joeNOSPAM@BEA.com · *nix forums beginner Joined: 10 Jun 2005 Posts: 15

Hi all. This issue was also raised in a previous post about a convert
oddity:

select convert(numeric(16,2), 5.3299),convert(numeric(16,2), '5.329')

returns

5.32 5.33

The problem is in the truncation/round-down of the first conversion,
compared
to the round-up of the second value that is actually lower. It's
definitely a DBMS
issue and not a client one, because if you select:

select convert(varchar(30), convert(numeric(16,2), 5.3299))

you still get 5.32

if you change the values to 5.999, you get

5.99 and 6.00

Joe Weinstein at BEA Systems

Google