function coalesce

Hello,

we are trying to port our application database to SAPDB and found an 
incompatibility issue to ANSI-92:

The function COALESCE is implemented in the query engine, but does not 
retrieve the correct results. Moreover, it generates an error, when more 
   than one column is SELECTed. However, we found the workaround with 
the VALUE function.

Simple example:

create table test (
c1 char(3),
c2 char(3),
c3 char(3)
)

insert into test (c1, c3)
values ('a', 'c')

select coalesce(c1,c2,c3), 1 from test
//
select value(c1,c2,c3), 1 from test
//

I guess, since COALESCE is not documented, this is a known issue.

Is there any plans to correct the bug with COALESCE in the near future?

Kind Regards

Richard Damoser