| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Surafel Temesgen <surafel3000(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: New CORRESPONDING clause design |
| Date: | 2017-03-27 08:48:56 |
| Message-ID: | CAFj8pRDfGhY0aNrRsvXLNTpW+aby292OR0HjR4+y1T5eeYqJkA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
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
| Attachment | Content-Type | Size |
|---|---|---|
| corresponding_clause_v9.patch | text/x-patch | 68.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2017-03-27 08:49:03 | Re: Patch: Write Amplification Reduction Method (WARM) |
| Previous Message | Aniruddha Deshpande | 2017-03-27 08:29:51 | Column widening without outage |