The following bug has been logged on the website:
Bug reference: 18608
Logged by: Alexander Lakhin
Email address: exclusion(at)gmail(dot)com
PostgreSQL version: 17rc1
Operating system: Ubuntu 22.04
Description:
The following script:
CREATE TABLE t (a int);
CREATE VIEW v AS SELECT 1;
CREATE RULE v_ins AS ON INSERT TO v
DO INSTEAD INSERT INTO t
SELECT * FROM (SELECT count(NEW) FROM t);
triggers an assertion failure:
TRAP: failed Assert("pstate->p_lateral_active"), File: "parse_agg.c", Line:
385, PID: 2785906
Without asserts enabled, it fails with:
ERROR: aggregate functions are not allowed in FROM clause of their own
query level
Reproduced on REL_9_3_STABLE .. master.