DB2 FOR LUW / DB2FORLUW / B50 - DB2

Inserting DECIMAL minus zero into column organized table leads
to wrong result on PowerPC.

DECIMAL minus zero provided via LOAD, IMPORT or CLI get inserted
correctly.

Repro:

Create file decmin.csv:
ID|DISCOUNT
3|-0.000

create table decmin (id int not null, discount decimal(20,10))
create external table decmin_extern (id int, discount
decimal(20,10)) using (dataobject ('/home/support/decmin.csv')
delimiter '|' escapechar '\' quotedvalue DOUBLE maxerrors 10
encoding utf8 skiprows 1)
insert into decmin select id+10, discount from decmin
select * from decmin

Create output:
ID          DISCOUNT
----------- ----------------------
          3 -1844674407.3709551616

Expected:
ID          DISCOUNT
----------- ----------------------
          0           0.0000000000

See Error Description

Avoid inserting -0.0 into DECIMAL column.

See Error Description

Fix will be included in Db2 v11.5.7.1.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.11.2021
09.11.2021
09.12.2021