Bug 151344 - Firebird LIST function (aka GROUP_CONCAT) gives #NA when linked to sheet
Summary: Firebird LIST function (aka GROUP_CONCAT) gives #NA when linked to sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
 
Reported: 2022-10-04 16:00 UTC by Andreas Säger
Modified: 2025-04-30 12:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Embedded Firebird, no Macros (62.29 KB, application/vnd.oasis.opendocument.database)
2022-10-04 16:00 UTC, Andreas Säger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Säger 2022-10-04 16:00:00 UTC
Created attachment 182833 [details]
Embedded Firebird, no Macros

Register the attached database.
Drag queries "qGroup_T_List_P" and "qGroup_P_List_T" into the sheet.
The concatenated field gets #NA! errors instead of strings.
An ordinary aggregation query with Count, Sum, Min, Max etc. works as expected.
Comment 1 Andreas Säger 2022-10-04 16:03:57 UTC
P.S. I get the correct strings into the sheet when I right-click>Copy the top-left corner in the data source window's record set and paste into sheet. However, this gives a copy instead of a link.
Comment 2 Robert Großkopf 2022-10-05 06:26:27 UTC
Could confirm the buggy behavior.

You won't need to register database, only drag from database to Calc-sheet.

One hint: If you change
List( "Things"."Name" ) "Tool"
to
CAST( List( "Things"."Name" ) AS VARCHAR ( 8000 ) ) "Tool"
Comment 3 QA Administrators 2025-04-30 03:10:50 UTC Comment hidden (obsolete)
Comment 4 Andreas Säger 2025-04-30 12:58:03 UTC
Still an issue in
Version: 25.2.3.1 (X86_64) / LibreOffice Community
Build ID: d8d1af5f77df955194e52baabe19324532ac8e8b
CPU threads: 4; OS: Linux 5.15; UI render: Skia/Raster; VCL: x11
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded