Description:
I am using Base on Mac OS  'Catalina' version 10.15.7. Having just upgraded my local LibreOffice instal from version 7.3.3 to v. 7.3.5 I find that one of my Base FORMS with a LIST BOX throws an error when the form is opened. Basically, the listbox allows a client name to be selected using a drop-down and the SQL code for the listbox concatenates the client's last and first names and the client ID (integer) is written to a filter table (to show that client's records in the form.

The listbox code is:
SELECT COALESCE ( "lastname", '' ) || ', ' || COALESCE ( "firstname", '' ), "id_cl" FROM "clients" ORDER BY "lastname" ASC

The above code worked fine with Base in LO 7.3.3 but throws the ERROR message below with LO 7.3.5...

firebird_sdbc error:
*arithmetic exception, numeric overflow, or string truncation
*string right truncation
*expected length 34, actual 69
caused by
'isc_dsql_fetch'

The last name and first name columns of the clients table are both VCHAR(16). If I change them both to VCHAR(50) the error changes also to..
*expected length 102, actual 205

So mathematically the 'actual' value in the error message above seems to be twice expected length+1

.... which does seem little strange!

NOTE: The same error above occurs when I use the above-quoted query code just as a normal query in the Base QUERIES list (i.e. not as a list-box code).

I have also tried simple concatenation of the last name and first name fields which produce the same error.

When I revert back to LO v.7.3.3, the above problem goes away and the query gives the correct concatenation of LASTNAME and FIRSTNAME. I will attach a sample Firebird embedded Base file to demonstrate the problem.

I have posted a description of this problem on ask.libreoffice.org - see LINK BELOW....

https://ask.libreoffice.org/t/form-listbox-firebird-sql-error-base-7-3-5/80265

....and tried all the things suggested there so far. The only thing that works is reverting back to the earlier version of LibreOffice. So this does seem like a bug only affecting the Mac version and versions of LO Base after version 7.3.3.

Steps to Reproduce:
1. Run query to concatenate lastname and firstname (for listbox) - see above in my DESCRIPTION of the problem.

Actual Results:
Error message (see above in my description)

Expected Results:
Concatenation of lastname and firstname (with comma separation)


Reproducible: Always


User Profile Reset: No



Additional Info:
I tried all suggestions given by 'Ask LibreOffice' helpers and nothing worked. I believe the problem might also be present in LO Bose 7.3.4.2 (only tested once and didn't take notes).