Gerald Nowitzky wrote:
>
> select sin(sin(52)*sin(2))
>
> should return 0.78154461294988686 in my opinion - and as well
> in the opinion
> of my pocket calculator. SAPDB insists on "?" as result. What
> am I doing
> wrong? I thought it might be necessary to cast the result as
> float, but
> there is no CAST. I've got no idea at the moment.
1. In the code there is a very nervous part: in case a number
has more than 16 non-zero digits and should be handled
with one of a bunch of functions, there is panic and the result
is that '?'.
This will be changed in one of the next releases
2. A workaround for this is
select sin( float(sin(52)*sin(2), 15) )
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
