Commit080a069

Etsuro Fujita

authored and

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 parent89ac275 commit080a069Copy full SHA for 080a069

File tree

-5

lines changed

-5

lines changed

Lines changed: 4 additions & 4 deletions

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

Lines changed: 1 addition & 1 deletion

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

Comments

(0)