https://bugs.documentfoundation.org/show_bug.cgi?id=147513
Bug ID: 147513
Summary: PostgreSQL direct connection: string_agg will show
wrong result with comma as delimiter
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
