Home > mailing lists

Re: New CORRESPONDING clause design - Mailing list pgsql-hackers

From	Pavel Stehule
Subject	Re: New CORRESPONDING clause design
Date	March 27, 2017 14:48:56
Msg-id	CAFj8pRDfGhY0aNrRsvXLNTpW+aby292OR0HjR4+y1T5eeYqJkA@mail.gmail.com Whole thread Raw
In response to	Re: New CORRESPONDING clause design (Pavel Stehule <pavel.stehule@gmail.com>)
Responses	Re: New CORRESPONDING clause design (Surafel Temesgen <surafel3000@gmail.com>)
List	pgsql-hackers

fresh update - I enhanced Value node by location field as Tom proposal.

Few more regress tests.

But I found significant issue, that needs bigger fix - Surafel, please, can you fix it.

It crash on

SELECT 0 AS x1, 1 AS a, 0 AS x2, 2 AS b, 0 AS x3, -1 AS x3

UNION ALL CORRESPONDING SELECT 4 AS b, 0 AS x4, 3 AS a, 0 AS x6, -1 AS x6

UNION ALL CORRESPONDING SELECT 0 AS x8, 6 AS b, -100 AS x9;

I'll mark this patch as waiting on author

Regards

Pavel

From: Simon Riggs
Date: 27 March 2017, 14:27:05
Subject: Re: Proposal for changes to recovery.conf API

From: Pavan Deolasee
Date: 27 March 2017, 14:49:03
Subject: Re: Patch: Write Amplification Reduction Method (WARM)