Commitb8f4644

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 parentd2bd4ba commitb8f4644Copy full SHA for b8f4644

File tree

-5

lines changed

-5

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -738,10 +738,10 @@ EXPLAIN (VERBOSE, COSTS OFF)`
`738`	`738`	`Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE (($1::integer = "C 1"))`
`739`	`739`	`(8 rows)`
`740`	`740`
`741`		`-SELECT * FROMft2a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;`
`742`		`-c1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8 \| c1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8`
`743`		`-----+----+-------+------------------------------+--------------------------+----+------------+-----+----+----+-------+------------------------------+--------------------------+----+------------+-----`
`744`		`- 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`
	`741`	`+SELECT * FROM"S 1"."T 1"a, ft2 b WHERE a."C 1" = 47 AND b.c1 = a.c2;`
	`742`	`+C 1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8 \| c1 \| c2 \| c3 \| c4 \| c5 \| c6 \| c7 \| c8`
	`743`	`+-----+----+-------+------------------------------+--------------------------+----+------------+-----+----+----+-------+------------------------------+--------------------------+----+------------+-----`
	`744`	`+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`
`745`	`745`	`(1 row)`
`746`	`746`
`747`	`747`	`-- check both safe and unsafe join conditions`

Lines changed: 1 addition & 1 deletion

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

Comments

(0)