BUG #18634: Wrong varnullingrels with merge ... when not matched by source
The Post Office <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: exclusion@gmail.com
Date: 2024-09-26T18:00:01Z
Lists: pgsql-bugs
The following bug has been logged on the website: Bug reference: 18634 Logged by: Alexander Lakhin Email address: exclusion@gmail.com PostgreSQL version: 17.0 Operating system: Ubuntu 22.04 Description: The following script: CREATE TABLE t (a int); INSERT INTO t VALUES(1), (2); CREATE VIEW v AS SELECT a FROM t WHERE EXISTS (SELECT 1 FROM t); MERGE INTO v USING (SELECT * FROM generate_series(1,1)) AS s(a) ON s.a = v.a WHEN NOT MATCHED BY SOURCE THEN DELETE; produces: ERROR: XX000: wrong varnullingrels (b) (expected (b 4)) for Var 5/1 LOCATION: search_indexed_tlist_for_var, setrefs.c:2847 At the same time, MERGE INTO v USING (SELECT * FROM generate_series(1,1)) AS s(a) ON s.a = v.a WHEN MATCHED THEN DELETE; planned and executed with no error.
Commits
-
Fix wrong varnullingrels error for MERGE WHEN NOT MATCHED BY SOURCE.
- 259a0a99fe3d 18.0 landed
- 34ae54af92e0 17.1 landed
-
Fix incorrect non-strict join recheck in MERGE WHEN NOT MATCHED BY SOURCE.
- dddb5640c6d3 18.0 landed
- d7d297f84496 17.1 landed