Integer to string during list function

[Szilu]

Could you please help me with this behavior:

When I query a many to many table (031_FF_Roll) with the command

SELECT "Tube_ID", LIST( "Roll_ID", ' / ' ) FROM "031_FF_Roll" GROUP BY "Tube_ID"

I got the following result

Linking these “Roll_ID”-s to other Integers (combined with strings):

Where are these strange characters coming from? It looks like to me empty spaces upto the maximal length.
LibreOffice Base 6.1.1.2 (x64) / JavaSE 10.0.2 (x64) or Java 1.8.0_181 (x64) / Windows 10

(This error (?) is not exist with the same configuration under Windows7.)

Thank you for your help in advance.

Bug #120129

[Ratslinger]

Hello,

Have tried this on Mint 18.3 using LO v6.1.0.3 & 6.2.x (dev version) with Java 10 without a problem:

Also tested with Firebird 3.1 server & got same results.

Have LO v6.1.1.2 (PPA) on Ubuntu 18.04 but that seems to have various other problems which leads me to avoid that version.

You should file a Bug report on your problem - Bugzilla. It would be helpful if, after reporting, you posted the Bug # for reference.

[Szilu]

Thank you for your effort and answer.
I see this problem only in windows10. It doesn’t come from the int/string conversion, the same happens with varchar fields.
I have tried to play with some settings without any success.

[Szilu]

Link of Bug report is added to the end of the main post.