Bug 147513

Summary:	PostgreSQL direct connection: string_agg will show wrong result with comma as delimiter
Product:	LibreOffice	Reporter:	Robert Großkopf <robert>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	normal
Priority:	medium
Version:	7.3.0.3 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:	QA:needsComment
Crash report or crash signature:		Regression By:

Description Robert Großkopf 2022-02-18 11:29:20 UTC

Open a connection to PostgreSQL with direct driver.
Go to queries.
Start Query in SQL view.
Start the following query for a table, field "ID" should contain numeric values, more than 1 row.

table:
ID
1
2
3

SELECT STRING_AGG( CAST( "ID" AS VARCHAR ( 10 ) ), ',' ) "Group_ID" FROM "table"

Only one value would be shown: 1
Expected: 1,2,3

Now set the delimiter from ',' to '|'
Result: 1|2|3 will be shown right.

Query works with connection to PostgreSQL through JDBC as expected.

Tested with LO 7.3.1.1 on OpenSUSE 64bit rpm Linux.