'Invalid data conversion' error when multiplying columns with same data type (4239598)

'Invalid data conversion' error when multiplying columns with same data type

If you multiply two columns with the same data type (for example, both are integer) the following error appears in Toad: 'Invalid data conversion'.
Running the same in another tool (IQ Client) works without any errors.

steps to replicate:

create table #test (
                    ID integer,
                    Param1 Numeric(28,6),
                    Param2 Numeric(28,6),
                    Param3 Numeric(28,6)
                    )
;
--this works
insert into #test
select 1, 4000000.000000, 4000000.000000, 4000000.000000

--this gives an error
insert into #test
select 2, 20795230.206513, 21412111,650000, 158667.000000

select ID, Param1, Param2,Param3, Param3*(Param1/Param2) from #test ;

The bug is in the SAP client

WORKAROUND:
Use Toad Data Point and connect with ODBC

STATUS:
SAP issue. In IQ Server 10.6.208.49, the issue no longer occurs

QAT-9417

From Dev: The bug is in the SAP client. We have opened a ticket with them but need to wait for a fix from them. We created task on SAP portal: 442063 / 2016