Skip to Content
0

Error in ver.12

Oct 25, 2016 at 08:57 AM

208

avatar image

Hi, ADS-team.

We found out the problem with ver.12.0

SELECT Convert( ABS(2016), SQL_CHAR ) FROM system.iota returns 46565812772

With ver.11.1 it works properly

SELECT Convert( ABS(2016), SQL_CHAR ) FROM system.iota returns 2016

Please fix this error.

Thanks

10 |10000 characters needed characters left characters exceeded

IMO: ADS is not only growing, but is not supported already :(

Does anybody have any information about future of ADS?

1
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Marcus Herz Oct 25, 2016 at 11:47 AM
1

Hi

I have been reporting this bug on May 2nd, 16. But there was no SP since then or any comment about that issue.

Share
10 |10000 characters needed characters left characters exceeded
Igor Golobrodkiy Nov 14, 2016 at 11:09 AM
0

Hi, ADS-team.

Can anyone tell when this bug will be fixed?

Hakan, give hope for us!

Share
10 |10000 characters needed characters left characters exceeded
Joachim Höhne Dec 07, 2016 at 06:35 PM
0

If you convert the value to float, like in

SELECT Convert( ABS(2016 + 0.0), SQL_CHAR ) FROM system.iota

it works as expected

Show 3 Share
10 |10000 characters needed characters left characters exceeded

I know it but I think it would be very nice if SAP fix this bug in current version :(

0

A rather strange bug anyway... if you simply rename abs() as in:

CREATE FUNCTION ZUPP(value INTEGER)
RETURNS INTEGER
BEGIN
RETURN ABS(VALUE);
END;

then SELECT CONVERT(ZUPP(2016), SQL_CHAR) FROM System.IOTA works as expected.

0

Yes but ADS ver.11.1 works properly without all these manipulations.

That's why I think this is a BUG and insist that SAP is obliged to fix it.

Especially considering the fact that everyone knows about it for half a year :(

0