diff options
| author | Robert Haas <rhaas@postgresql.org> | 2016-02-09 15:42:20 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2016-02-09 15:42:20 -0500 |
| commit | bb4df42e6a394ce77801b6952b6dc8b43d91fea7 (patch) | |
| tree | 252a72e11483ff428885804ab60e5e35dc20449d /contrib/postgres_fdw/sql/postgres_fdw.sql | |
| parent | e4106b2528727c4b48639c0e12bf2f70a766b910 (diff) | |
| download | postgresql-bb4df42e6a394ce77801b6952b6dc8b43d91fea7.tar.gz postgresql-bb4df42e6a394ce77801b6952b6dc8b43d91fea7.zip | |
postgres_fdw: Remove unstable regression test.
Per Tom Lane and the buildfarm.
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
| -rw-r--r-- | contrib/postgres_fdw/sql/postgres_fdw.sql | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql index b32e45a3680..885a5fbf5a2 100644 --- a/contrib/postgres_fdw/sql/postgres_fdw.sql +++ b/contrib/postgres_fdw/sql/postgres_fdw.sql @@ -385,7 +385,6 @@ WITH t (c1_1, c1_3, c2_1) AS (SELECT t1.c1, t1.c3, t2.c1 FROM ft1 t1 JOIN ft2 t2 -- ctid with whole-row reference EXPLAIN (COSTS false, VERBOSE) SELECT t1.ctid, t1, t2, t1.c1 FROM ft1 t1 JOIN ft2 t2 ON (t1.c1 = t2.c1) ORDER BY t1.c3, t1.c1 OFFSET 100 LIMIT 10; -SELECT t1.ctid, t1, t2, t1.c1 FROM ft1 t1 JOIN ft2 t2 ON (t1.c1 = t2.c1) ORDER BY t1.c3, t1.c1 OFFSET 100 LIMIT 10; -- SEMI JOIN, not pushed down EXPLAIN (COSTS false, VERBOSE) SELECT t1.c1 FROM ft1 t1 WHERE EXISTS (SELECT 1 FROM ft2 t2 WHERE t1.c1 = t2.c1) ORDER BY t1.c1 OFFSET 100 LIMIT 10; |