| From: | Jaime Casanova <jaime(dot)casanova(at)2ndquadrant(dot)com> |
|---|---|
| To: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: MERGE SQL statement for PG12 |
| Date: | 2018-09-04 06:21:02 |
| Message-ID: | CAJGNTeNuB1Fkfwrfpb9T3t6qjdjTs43uMV_+5B_Vkk=fOdWiHw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 4 Sep 2018 at 00:01, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> wrote:
>
> I've rebased the patch against the current master. The patch hasn't changed much since the last time.
>
Hi Pavan,
I had this crash when running sqlsmith against the previous version of
this patch and just confirmed it still crash with this version (which
makes sense because you said patch hasn't changed much)
To reproduce run this query against regression database:
"""
MERGE INTO public.pagg_tab_ml_p3 as target_0
USING public.prt2_l_p3_p2 as ref_0 ON target_0.a = ref_0.a
WHEN MATCHED AND cast(null as tid) <= cast(null as tid) THEN DELETE;
"""
attached is a backtrace
--
Jaime Casanova www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| crash.txt | text/plain | 3.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2018-09-04 07:14:27 | Re: speeding up planning with partitions |
| Previous Message | Amit Langote | 2018-09-04 06:19:59 | Re: pointless check in RelationBuildPartitionDesc |