Commit019c13e

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 parent420c8dc commit019c13eCopy full SHA for 019c13e

File tree

-5

lines changed

-5

lines changed

Lines changed: 4 additions & 4 deletions

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

Lines changed: 1 addition & 1 deletion

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

Comments

(0)