Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Bug in function result comparison ?
Mon, Apr 20 2009 6:46 AMPermanent Link

Heiko Knuettel
create function floattostr(in value float)
returns varchar(20)
begin
  return replace('.' with ',' in if(value is null then '' else cast(value as varchar(20))));
end;

select floattostr(0), floattostr(1), if(floattostr(0)<>floattostr(1) then 'correct' else
'error') from table

gives me an 0,1,error

Heiko
Tue, Apr 21 2009 2:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Heiko,

<< gives me an 0,1,error >>

Yes, it's a bug.  Build 12 should be available by this weekend with the fix.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image