PFA the patches rebased on the latest sources. There are also fixes for some of the crashes and bugs reported. I haven't yet included the testcase patch in the main patchset.
On Mon, Aug 28, 2017 at 12:44 PM, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com> wrote: > On Mon, Aug 21, 2017 at 12:43 PM, Ashutosh Bapat > <ashutosh.bapat@enterprisedb.com> wrote: >> >> TODOs >> ----------- >> 1. Add tests for advanced partition matching algorithm > > > Hi Ashutosh, > > I have applied all partition-wise-join patches (v26) and tested feature. I > have modified partition_join.sql file and added extra test cases to test > partition matching. > > Attaching WIP test case patch which as of now have some server crashes and a > data corruptions issue which is commented in the file itself and need to be > removed once issue got solved. Also some of queries is not picking or > picking partition-wise-join as per expectation which may need some > adjustment. >
I have applied v27 patches and tested feature. Also tried to reduce regression diff with the
existing partition_join.sql by adding new partition instead of changing original partition bounds.
Attached WIP patch have a server crash and some wrong output which need to be fixed. I have
commented these issue in patch itself, Please take a look and let me know if it need more