Re: BUG #10527: TRAP when joining local table with view on tds_fdw foreign table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #10527: TRAP when joining local table with view on tds_fdw foreign table
Date
Msg-id 22474.1401899750@sss.pgh.pa.us
Whole thread Raw
In response to BUG #10527: TRAP when joining local table with view on tds_fdw foreign table  (gunnar.bluth@pro-open.de)
Responses Re: BUG #10527: TRAP when joining local table with view on tds_fdw foreign table  ("Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>)
List pgsql-bugs
gunnar.bluth@pro-open.de writes:
> Not sure if this might be a 9.4 regression or if the FDW interface has
> changed and tds_fdw needs some tweaking, however:

> When I join a local table with a view on a foreign table (tds_fdw), I get

> TRAP: FailedAssertion("!(outer_rel->rows > 0)", File: "indxpath.c", Line:
> 1861)

This looks like tds_fdw is neglecting its responsibility to deliver a
positive rowcount estimate for the foreign relation.  (Most places in the
core code use clamp_row_est(), which forces the value to be more than zero
along with rounding it to nearest integer.)  You'll need to report it to
the author of tds_fdw.

            regards, tom lane

pgsql-bugs by date:

Previous
From: gunnar.bluth@pro-open.de
Date:
Subject: BUG #10527: TRAP when joining local table with view on tds_fdw foreign table
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby