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)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
Reported: 2022-10-04 16:00 UTC by Andreas Säger
Modified: 2023-04-30 08:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

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

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"
CAST( List( "Things"."Name" ) AS VARCHAR ( 8000 ) ) "Tool"