From: Andreas Seltenreich <seltenreich@gmx.de>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>,
  Chapman Flack <chap@anastigmatix.net>,
  PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: [HACKERS] MERGE SQL Statement for PG11
References: 
 <CANP8+jLdJoqjzkEdfqy_Rw43gUk08btunpJVV7Yiw=UqtOtePw@mail.gmail.com>
	<CANP8+jJgS_KoN6DDteb_9-fUzfnp7Ytm9O5VE83dGpWp1pszkg@mail.gmail.com>
	<CAH2-WznpEqdzL_sgWOHfmb9jz6612JLkhdN5YcdmdW3qX3g4Uw@mail.gmail.com>
	<CANP8+jKTuZ5NDCLkqXBm9kMeaT-jNxxhkMg+FOpLni=pwOQ=BA@mail.gmail.com>
	<CANP8+jKJee2Luip7tv4KrK8R_EP5PbOvDD+vfUpp9uBFmfK9yg@mail.gmail.com>
	<CANP8+jK8YRSCrg8m8XiRMmoy9DfvL=hUQ1SpS=+y=920evbTvg@mail.gmail.com>
	<CAFj8pRCUbOsyD5ny1UvoZciEbk3Q1YJj+gjEta=1X8dGb1cjSA@mail.gmail.com>
	<CANP8+jL86yJU0cx09DCWZVT=ZAo4JK1oqS_0s0t=WUN-FP9iaQ@mail.gmail.com>
	<CAFj8pRApqwbS9ZBf38=vg38rU90dotukx22xxV+Oe8fiCv=3Kg@mail.gmail.com>
	<CANP8+jKoE=AXPz+gMdxXgod7UO_C8OGwJ6aD+A4b5nfxLOzQrA@mail.gmail.com>
	<20180129154457.GC11613@momjian.us>
	<CANP8+jLDtMxYXJ95ffA3PYqAVfTkh3V42W9TYWAJH6PsAgOocg@mail.gmail.com>
	<495e24a5-d5bf-3ef2-ccdd-dd112c1c3a15@anastigmatix.net>
	<CANP8+j+icDb4=+zVUiRN60TAf9s9WT+6dOoWQqDu+B90xATRHA@mail.gmail.com>
	<CAFj8pRA7=C9yPJW_iG2Es-qBkZt-hSUFmF+cqZGoHU5SAPj_kw@mail.gmail.com>
	<CANP8+j+YDPtO9KsMX2ztXLxHjpmjef3ytfmhRfvK48db0o4btg@mail.gmail.com>
	<87k1vtdexn.fsf@ansel.ydns.eu>
	<CANP8+jLQ81X0dR2k2i6eOwg4226GGoTbRS6_e=6oDdmBRXwXYQ@mail.gmail.com>
Date: Sun, 04 Feb 2018 13:15:44 +0100
In-Reply-To: 
 <CANP8+jLQ81X0dR2k2i6eOwg4226GGoTbRS6_e=6oDdmBRXwXYQ@mail.gmail.com>
	(Simon Riggs's message of "Sat, 3 Feb 2018 22:18:03 +0000")
Message-ID: <87a7wpc5n3.fsf@ansel.ydns.eu>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.0.50 (gnu/linux)
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="
Precedence: bulk

--=-=-=
Content-Type: text/plain

Simon Riggs writes:

> It will likely take some time to work through these and the current
> work items but will fix.
>
> Do you have the DDL so we can recreate these easily?

Attached are testcases that trigger the assertions when run against an
empty database instead of the one left behind by make installcheck.  The
"unrecognized node type" one appears to be a known issue according to
the wiki, so I didn't bother doing the work for this one as well.

regards,
Andreas

--=-=-=
Content-Type: application/x-sql
Content-Disposition: attachment;
 filename=TRAP-node-type-T_SubLink-prepunion.sql
Content-Transfer-Encoding: base64

LS0gVFJBUDogRmFpbGVkQXNzZXJ0aW9uKCIhKCEoKCgoY29uc3QgTm9kZSopKG5vZGUpKS0+dHlw
ZSkgPT0gVF9TdWJMaW5rKSkiLCBGaWxlOiAicHJlcHVuaW9uLmMiLCBMaW5lOiAyMjQ2KQoKYmVn
aW47CkNSRUFURSBUQUJMRSBwcnQxICgKICAgIGEgaW50ZWdlciwKICAgIGIgaW50ZWdlciwKICAg
IGMgY2hhcmFjdGVyIHZhcnlpbmcKKQpQQVJUSVRJT04gQlkgUkFOR0UgKGEpOwoKQ1JFQVRFIFRB
QkxFIHBydDFfcDEgUEFSVElUSU9OIE9GIHBydDEKRk9SIFZBTFVFUyBGUk9NICgwKSBUTyAoMjUw
KTsKQ1JFQVRFIFRBQkxFIHBydDFfcDIgUEFSVElUSU9OIE9GIHBydDEKRk9SIFZBTFVFUyBGUk9N
ICgyNTApIFRPICg1MDApOwpDUkVBVEUgVEFCTEUgcHJ0MV9wMyBQQVJUSVRJT04gT0YgcHJ0MQpG
T1IgVkFMVUVTIEZST00gKDUwMCkgVE8gKDYwMCk7CgpDUkVBVEUgVEFCTEUgdGVuazEgKHN0cmlu
Z3UxIG5hbWUpOwpDUkVBVEUgVEFCTEUgb25lazIgKGxpa2UgdGVuazEpOwoKZXhwbGFpbiBNRVJH
RSBJTlRPIHB1YmxpYy5vbmVrMiBhcyB0YXJnZXRfMApVU0lORyBwdWJsaWMucHJ0MSBhcyByZWZf
MAogIGlubmVyIGpvaW4gcHVibGljLnRlbmsxIGFzIHJlZl8xCiAgb24gKChzZWxlY3QgMTo6dGV4
dCBpcyBub3QgbnVsbCkpCk9OIHRhcmdldF8wLnN0cmluZ3UxID0gcmVmXzEuc3RyaW5ndTEKV0hF
TiBOT1QgTUFUQ0hFRCBUSEVOIERPIE5PVEhJTkc7Cgpyb2xsYmFjazsK
--=-=-=
Content-Type: application/x-sql
Content-Disposition: attachment;
 filename=TRAP-node-type-T_SubLink-clauses.sql
Content-Transfer-Encoding: base64

LS0gVFJBUDogRmFpbGVkQXNzZXJ0aW9uKCIhKCEoKCgoY29uc3QgTm9kZSopKG5vZGUpKS0+dHlw
ZSkgPT0gVF9TdWJMaW5rKSkiLCBGaWxlOiAiY2xhdXNlcy5jIiwgTGluZTogNDQwKQpiZWdpbjsK
CkNSRUFURSBUQUJMRSB0YXJnZXQgKHRpZCBpbnRlZ2VyLCBiYWxhbmNlIGludGVnZXIpOwpJTlNF
UlQgSU5UTyB0YXJnZXQgVkFMVUVTICgxLCAxMCk7CklOU0VSVCBJTlRPIHRhcmdldCBWQUxVRVMg
KDIsIDIwKTsKSU5TRVJUIElOVE8gdGFyZ2V0IFZBTFVFUyAoMywgMzApOwpBTFRFUiBUQUJMRSB0
YXJnZXQgQUREIFBSSU1BUlkgS0VZICh0aWQpOwoKQ1JFQVRFIFRBQkxFIHNvdXJjZSAoc2lkIGlu
dGVnZXIsIGRlbHRhIGludGVnZXIpOwpJTlNFUlQgSU5UTyBzb3VyY2UgVkFMVUVTICg0LCA0MCk7
CklOU0VSVCBJTlRPIHNvdXJjZSBWQUxVRVMgKDIsIDUpOwpJTlNFUlQgSU5UTyBzb3VyY2UgVkFM
VUVTICgzLCAyMCk7CgpNRVJHRSBJTlRPIHB1YmxpYy50YXJnZXQgYXMgdGFyZ2V0XzAKVVNJTkcg
cHVibGljLnRhcmdldCBhcyBzYW1wbGVfMAogIGxlZnQgam9pbiBwdWJsaWMudGFyZ2V0IGFzIHJl
Zl8wCiAgb24gKHBnX2NhdGFsb2cuanNvbmJfYnVpbGRfb2JqZWN0KCkgPSAoc2VsZWN0IHBnX2Nh
dGFsb2cuanNvbmJfYWdnKHRpZCkgZnJvbSBwdWJsaWMudGFyZ2V0KQogICAgICAgICkKT04gdGFy
Z2V0XzAuYmFsYW5jZSA9IHNhbXBsZV8wLnRpZCAKV0hFTiBNQVRDSEVEIEFORCAoY2FzdChudWxs
IGFzIGNpcmNsZSkgfiBjYXN0KG51bGwgYXMgY2lyY2xlKSkgCiAgICBhbmQgKGNhc3QobnVsbCBh
cyBmbG9hdDQpID0gY2FzdChudWxsIGFzIGZsb2F0OCkpCiAgIFRIRU4gVVBEQVRFICBzZXQgCiAg
ICBiYWxhbmNlID0gdGFyZ2V0XzAudGlkOwoKcm9sbGJhY2s7Cg==
--=-=-=
Content-Type: application/x-sql
Content-Disposition: attachment; filename=TRAP-node-type-T_Query.sql
Content-Transfer-Encoding: base64

LS0gVFJBUDogRmFpbGVkQXNzZXJ0aW9uKCIhKCEoKCgoY29uc3QgTm9kZSopKG5vZGUpKS0+dHlw
ZSkgPT0gVF9RdWVyeSkpIiwgRmlsZTogInZhci5jIiwgTGluZTogMjQ4KQpiZWdpbjsKQ1JFQVRF
IFRBQkxFIHRhcmdldCAodGlkIGludGVnZXIsIGJhbGFuY2UgaW50ZWdlcik7CklOU0VSVCBJTlRP
IHRhcmdldCBWQUxVRVMgKDEsIDEwKTsKSU5TRVJUIElOVE8gdGFyZ2V0IFZBTFVFUyAoMiwgMjAp
OwpJTlNFUlQgSU5UTyB0YXJnZXQgVkFMVUVTICgzLCAzMCk7CkFMVEVSIFRBQkxFIHRhcmdldCBB
REQgUFJJTUFSWSBLRVkgKHRpZCk7CgpDUkVBVEUgVEFCTEUgc291cmNlIChzaWQgaW50ZWdlciwg
ZGVsdGEgaW50ZWdlcik7CklOU0VSVCBJTlRPIHNvdXJjZSBWQUxVRVMgKDQsIDQwKTsKSU5TRVJU
IElOVE8gc291cmNlIFZBTFVFUyAoMiwgNSk7CklOU0VSVCBJTlRPIHNvdXJjZSBWQUxVRVMgKDMs
IDIwKTsKCk1FUkdFIElOVE8gcHVibGljLnNvdXJjZSBhcyB0YXJnZXRfMApVU0lORyBwdWJsaWMu
c291cmNlIGFzIHNhbXBsZV8wCiAgaW5uZXIgam9pbiAoc2VsZWN0ICAKICAgICAgICByZWZfMC50
aWQgYXMgYzAKICAgICAgZnJvbSAKICAgICAgICBwdWJsaWMudGFyZ2V0IGFzIHJlZl8wCiAgICAg
IHdoZXJlIHJlZl8wLnRpZCBpcyBOVUxMCiAgICAgIGxpbWl0IDExNykgYXMgc3VicV8wCiAgb24g
KCgoc2VsZWN0IHNpZCBmcm9tIHB1YmxpYy5zb3VyY2UgbGltaXQgMSBvZmZzZXQgMSkKICAgICAg
ICAgICBpcyBub3QgTlVMTCkgCiAgICAgIG9yIChzdWJxXzAuYzAgaXMgTlVMTCkpCk9OIHRhcmdl
dF8wLnNpZCA9IHNhbXBsZV8wLnNpZCAKV0hFTiBOT1QgTUFUQ0hFRAogIEFORCBjYXN0KG51bGwg
YXMgbmFtZSkgfn4gY2FzdChudWxsIGFzIHRleHQpCiAgIFRIRU4gRE8gTk9USElORzsKCnJvbGxi
YWNrOwo=
--=-=-=--