pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function
2+ messages / 2 participants
[nested] [flat]
* BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function
@ 2025-03-13 10:32 PG Bug reporting form <noreply@postgresql.org>
2025-03-13 14:43 ` Re: BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2025-03-13 10:32 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: olgaantonova2.0@yandex.ru
The following bug has been logged on the website:
Bug reference: 18843
Logged by: Olga Antonova
Email address: olgaantonova2.0@yandex.ru
PostgreSQL version: 16.7
Operating system: Ubuntu 22.04.3 LTS
Description:
How to reproduce the problem:
1. Generate test data by pgbench with scale_factor 10
pgbench -i -s 10 -U postgres -p 5434 -d test
2. Run query in test database
select bid, array_agg(ROW(aid,abalance)) from pgbench_accounts group by
bid;
Result:
ERROR: 0A000: input of anonymous composite types is not implemented
LOCATION: record_recv, rowtypes.c:508
Query Plan:
QUERY PLAN
-----------------------------------------------------------------------------------------------------------
Finalize GroupAggregate (cost=23644.32..23646.93 rows=10 width=36)
Group Key: bid
-> Gather Merge (cost=23644.32..23646.65 rows=20 width=36)
Workers Planned: 2
-> Sort (cost=22644.29..22644.32 rows=10 width=36)
Sort Key: bid
-> Partial HashAggregate (cost=22644.00..22644.13 rows=10
width=36)
Group Key: bid
-> Parallel Seq Scan on pgbench_accounts
(cost=0.00..20560.67 rows=416667 width=12)
(9 rows)
When the problem does not reproduce:
1. Generate test data by pgbench with default scale_factor:
pgbench -i -U postgres -p 5434 -d test
2. Run the same query in test database:
select bid, array_agg(ROW(aid,abalance)) from pgbench_accounts group by
bid;
Result: The request was processed without errors.
Query Plan:
QUERY PLAN
-------------------------------------------------------------------------------
HashAggregate (cost=3140.00..3140.01 rows=1 width=36)
Group Key: bid
-> Seq Scan on pgbench_accounts (cost=0.00..2640.00 rows=100000
width=12)
(3 rows)
Expected result:
The query has the same behavior for any query plan.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function
2025-03-13 10:32 BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function PG Bug reporting form <noreply@postgresql.org>
@ 2025-03-13 14:43 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2025-03-13 14:43 UTC (permalink / raw)
To: olgaantonova2.0@yandex.ru; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> How to reproduce the problem:
> 1. Generate test data by pgbench with scale_factor 10
> pgbench -i -s 10 -U postgres -p 5434 -d test
> 2. Run query in test database
> select bid, array_agg(ROW(aid,abalance)) from pgbench_accounts group by
> bid;
This is presumably the same issue recently reported at
https://postgr.es/m/flat/atLI5Kce2ie1zcYjU0w_kjtVaxiYbYGTihrkLDmGZQnRDD4pnXukIATaABbnIj9pUnelC4ESvCX...
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-03-13 14:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-03-13 10:32 BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function PG Bug reporting form <noreply@postgresql.org>
2025-03-13 14:43 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox