Commita67cf94

Etsuro Fujita

committed

postgres_fdw: Fix test for parameterized foreign scan.

Commite4106b2 should have updated this test, but did not; back-patchto all supported branches.Reviewed by Richard Guo.Discussion:http://postgr.es/m/CAPmGK15nR0NXLSCKQAcqbZbTzrzd5MozowWnTnGfPkayndF43Q%40mail.gmail.com

1 parentf06e171 commita67cf94Copy full SHA for a67cf94

File tree

-5

lines changed

-5

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -723,10 +723,10 @@ EXPLAIN (VERBOSE, COSTS OFF)`
`723`	`723`	`Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE (($1::integer = "C 1"))`
`724`	`724`	`(8 rows)`
`725`	`725`
`726`		`-SELECT * FROMft2a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;`
`727`		`-c1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8 \| c1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8`
`728`		`-----+----+-------+------------------------------+--------------------------+----+------------+-----+----+----+-------+------------------------------+--------------------------+----+------------+-----`
`729`		`- 47 \| 7 \| 00047 \| Tue Feb 17 00:00:00 1970 PST \| Tue Feb 17 00:00:00 1970 \| 7 \| 7 \| foo \| 7 \| 7 \| 00007 \| Thu Jan 08 00:00:00 1970 PST \| Thu Jan 08 00:00:00 1970 \| 7 \| 7 \| foo`
	`726`	`+SELECT * FROM"S 1"."T 1"a, ft2 b WHERE a."C 1" = 47 AND b.c1 = a.c2;`
	`727`	`+C 1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8 \| c1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8`
	`728`	`+-----+----+-------+------------------------------+--------------------------+----+------------+-----+----+----+-------+------------------------------+--------------------------+----+------------+-----`
	`729`	`+47 \| 7 \| 00047 \| Tue Feb 17 00:00:00 1970 PST \| Tue Feb 17 00:00:00 1970 \| 7 \| 7 \| foo \| 7 \| 7 \| 00007 \| Thu Jan 08 00:00:00 1970 PST \| Thu Jan 08 00:00:00 1970 \| 7 \| 7 \| foo`
`730`	`730`	`(1 row)`
`731`	`731`
`732`	`732`	`-- check both safe and unsafe join conditions`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -315,7 +315,7 @@ EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c8 = 'foo'; -- can't be`
`315`	`315`	`-- parameterized remote path for foreign table`
`316`	`316`	`EXPLAIN (VERBOSE, COSTS OFF)`
`317`	`317`	`SELECT*FROM"S 1"."T 1" a, ft2 bWHERE a."C 1"=47ANDb.c1=a.c2;`
`318`		`-SELECT*FROMft2a, ft2 bWHEREa.c1=47ANDb.c1=a.c2;`
	`318`	`+SELECT*FROM"S 1"."T 1"a, ft2 bWHERE a."C 1"=47ANDb.c1=a.c2;`
`319`	`319`
`320`	`320`	`-- check both safe and unsafe join conditions`
`321`	`321`	`EXPLAIN (VERBOSE, COSTS OFF)`

Comments

(0)