[Libreoffice-bugs] [Bug 144147] New: Strange characters appearing in a LibreOffice Base Query Result (using a Firebird embebbed database)
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Aug 28 17:45:47 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=144147
Bug ID: 144147
Summary: Strange characters appearing in a LibreOffice Base
Query Result (using a Firebird embebbed database)
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: heitorhedler at gmail.com
Description:
I am trying to use the LIST function to produce a list of all rows in a column
of a table called artist. So I made the following query:
SELECT LIST (“artist_name”) FROM “artist”
It returns the concatenated rows but also a lot of strange squares. I've posted
a help request in the community with a screenshot and some more details. Link
to the thread:
https://ask.libreoffice.org/t/trouble-with-the-list-aggregate-function-firebird/67430)
Steps to Reproduce:
1.Created a table called "artist" with a INT primary key and a VARCHAR column
called "artist_name".
2.Tried to query using the command SELECT LIST (“artist_name”) FROM “artist”
Actual Results:
I got the result "Stan Lee□□□□□□□□,□□□□□□□□□□□□□□□Jack
Kirby□□□□□□,□□□□□□□□□□□□□□□Dick Ayers□□□□□□"
Expected Results:
I should have received the result "Stan Lee, Jack Kirby, Dick Ayers"
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (pt_BR); UI: pt-BR
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210828/fbd47087/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list