Bug 147513 - PostgreSQL direct connection: string_agg will show wrong result with comma as delimiter
Summary: PostgreSQL direct connection: string_agg will show wrong result with comma as...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-18 11:29 UTC by Robert Großkopf
Modified: 2022-03-05 03:35 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 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.