Commitbea18b1

committed

Strengthen tests for5ef34a8

The test query in5ef34a8 is running over the empty emp1 table giving thesame (empty) return both with and without the fix. Add one row to that tableto make not just the test query plan, but also the test query result different.Reported-by: Richard GuoBug: #18261Discussion:https://postgr.es/m/CAMbWs49igjcszLgicb4D1N21_5iNDoxheJ7KFmAcs_z%3DLx6jhg%40mail.gmail.com

1 parent9034a2d commitbea18b1Copy full SHA for bea18b1

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -6881,6 +6881,7 @@ WHERE t1.id = emp1.id RETURNING emp1.id, emp1.code;`
`6881`	`6881`	`(3 rows)`
`6882`	`6882`
`6883`	`6883`	`-- Check that SJE does not mistakenly omit qual clauses (bug #18187)`
	`6884`	`+insert into emp1 values (1, 1);`
`6884`	`6885`	`explain (costs off)`
`6885`	`6886`	`select 1 from emp1 full join`
`6886`	`6887`	`(select * from emp1 t1 join`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2623,6 +2623,7 @@ UPDATE emp1 SET code = t1.code + 1 FROM t1`
`2623`	`2623`	`WHEREt1.id=emp1.id RETURNINGemp1.id,emp1.code;`
`2624`	`2624`
`2625`	`2625`	`-- Check that SJE does not mistakenly omit qual clauses (bug #18187)`
	`2626`	`+insert into emp1values (1,1);`
`2626`	`2627`	`explain (costs off)`
`2627`	`2628`	`select1from emp1 fulljoin`
`2628`	`2629`	`(select*from emp1 t1join`

Comments

(0)