Ask Your Question

Integer to string during list function

asked 2018-09-25 09:33:52 +0100

Szilu gravatar image

updated 2020-07-14 07:11:21 +0100

Alex Kemp gravatar image

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 (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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-25 18:00:05 +0100

Ratslinger gravatar image


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

image description

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.

edit flag offensive delete link more


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 gravatar imageSzilu ( 2018-09-26 08:00:17 +0100 )edit

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

Szilu gravatar imageSzilu ( 2018-09-26 13:51:59 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-25 09:33:52 +0100

Seen: 88 times

Last updated: Sep 26 '18