Firebird 5.0.2 - Error with UPDATE OR INSERT INTO with RETURNING clause of OLD values

[zedalaye]

See the discussion with examples here : #8615

Given this expurged table definition:

CREATE TABLE MAGASINS (
    UID   CHAR(16) CHARACTER SET OCTETS NOT NULL,
    CODE  CHAR(12) NOT NULL
)

This query fails when run more than once:

update or insert into MAGASINS(UID, CODE)
values (x'B961790496A042E9957F03A4D1C86726', 'CODE')
matching (UID) 
returning
  UID,
  OLD.CODE as "OLD.CODE"

The error is:

arithmetic exception, numeric overflow, or string truncation
string right truncation
expected length 1, actual 12
Arithmetic overflow or division by zero has occurred.
GDS Code: 335544321 - SQL Code: -802 - Error Code: 1.

The same query works as expected in Firebird 3.0.9+, this sounds like a regression.

[hvlad]

Firebird 5, isql

SQL> CREATE TABLE MAGASINS (
CON>     UID   CHAR(16) CHARACTER SET OCTETS NOT NULL,
CON>     CODE  CHAR(12) NOT NULL
CON> );
SQL>
SQL> update or insert into MAGASINS(UID, CODE)
CON> values (x'B961790496A042E9957F03A4D1C86726', 'CODE')
CON> matching (UID)
CON> returning
CON>   UID,
CON>   OLD.CODE as "OLD.CODE";

UID                              OLD.CODE
================================ ============
B961790496A042E9957F03A4D1C86726 <null>

SQL>
SQL> update or insert into MAGASINS(UID, CODE)
CON> values (x'B961790496A042E9957F03A4D1C86726', 'CODE')
CON> matching (UID)
CON> returning
CON>   UID,
CON>   OLD.CODE as "OLD.CODE";

UID                              OLD.CODE
================================ ============
B961790496A042E9957F03A4D1C86726 CODE

[mrotteveel]

@hvlad I can reproduce it with Firebird 5.0.2 (Windows 11, 64-bit)

[mrotteveel]

OK, I tested it with a recent snapshot of 5.0.3 (5.0.3.1659), and it seems to be fixed already.

[zedalaye]

Thank you Marc and Vlad for testing. I'll upgrade my Firebird 5 to latest 5.0.3 snapshot.

[asfernandes]

#8508