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 tree / graph
 
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:

Attachments
Embedded Firebird, no Macros (62.29 KB, application/vnd.oasis.opendocument.database)
2022-10-04 16:00 UTC, Andreas Säger 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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"