Re: [HACKERS] MERGE SQL Statement for PG11 - Mailing list pgsql-hackers

From Andreas Seltenreich
Subject Re: [HACKERS] MERGE SQL Statement for PG11
Date
Msg-id 87371yczqk.fsf@ansel.ydns.eu
Whole thread Raw
In response to Re: [HACKERS] MERGE SQL Statement for PG11  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Responses Re: [HACKERS] MERGE SQL Statement for PG11
List pgsql-hackers
Pavan Deolasee writes:

> Thanks for doing those tests. I've just sent v16a version of the patch and
> I think it fixes the issues reported so far. Can you please recheck? Please
> let me know if there are other issues detected by sqlsmith or otherwise.

I re-did the testing with merge_v16a applied to master at 7923118c16
with ad7dbee368a reverted because of conflicts.  I can confirm that the
previous testcases don't fail anymore, but sqlsmith readily triggers the
following assertion:

TRAP: FailedAssertion("!(mergeTargetRelation > 0)", File: "planner.c",
Line: 1496)

Testcase attached.

regards,
Andreas

Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: different results from plpgsql functions related to last changes in master
Next
From: Michail Nikolaev
Date:
Subject: Re: [HACKERS] Can ICU be used for a database's default sort order?