Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1isDlK-0001DP-MG for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Jan 2020 22:37:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1isDlJ-0000Mv-0D for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Jan 2020 22:37:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1isDlI-0000Mo-O2 for pgsql-bugs@lists.postgresql.org; Thu, 16 Jan 2020 22:37:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1isDlA-0004nk-UC for pgsql-bugs@lists.postgresql.org; Thu, 16 Jan 2020 22:37:12 +0000 Content-Type: multipart/mixed; boundary="===============0082176143649660241==" MIME-Version: 1.0 Subject: BUG #16212: subquery block allows to overwrite table alias defined earlier To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: luza.mbox@gmail.com Reply-To: luza.mbox@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 16 Jan 2020 22:36:16 +0000 Message-ID: <16212-cc31996adcf45996@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0082176143649660241== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjIxMgpMb2dnZWQgYnk6ICAgICAgICAgIERlbmlzIEdpcmtvCkVtYWls IGFkZHJlc3M6ICAgICAgbHV6YS5tYm94QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDku Ni4xNgpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpTaG9y dCBleGFtcGxlIHRvIGlsbHVzdHJhdGUgdGhlIGlzc3VlOg0KDQpTRUxFQ1QNCiAgIGEsDQogICBi LnAsDQogICBjLnANCkZST00NCiAgKFZBTFVFUyAoMSkpIGENCiAgSk9JTiBMQVRFUkFMICgNCiAg ICBTRUxFQ1QgcCBGUk9NIChWQUxVRVMgKDIpKSBwDQogICkgYiBPTiBUUlVFDQogIEpPSU4gTEFU RVJBTCAoDQogICAgU0VMRUNUIHAgRlJPTSAoVkFMVUVTICgzKSkgcA0KICApIGMgT04gVFJVRQ0K Ow0KDQpFeHBlY3RlZCByZXN1bHQgKCgxKSwgKDIpLCAoMykpDQpBY3R1YWwgcmVzdWx0ICgoMSks ICgyKSwgKDIpKS4NCigicCIgaW50cm9kdWNlZCBpbiBzZWNvbmQgSk9JTiBvdmVyd3JpdGVzIHRo ZSBvbmUgZGVmaW5lZCBieSBmaXJzdCkNClJlZ3VsYXIgSk9JTiAobm90IExBVEVSQUwpIGlzIG5v dCB0aGUgc3ViamVjdCBvZiBzdWNoIGFuIGlzc3VlLg0KDQoNCkFub3RoZXIgZXhhbXBsZToNClNF TEVDVA0KICAgYSwNCiAgIGIuYQ0KRlJPTQ0KICAoVkFMVUVTICgxKSkgYQ0KICBKT0lOICgNCiAg ICBTRUxFQ1QgYSBGUk9NIChWQUxVRVMgKDIpKSBhDQogICkgYiBPTiBUUlVFDQo7DQoNCkV4cGVj dGVkIHJlc3VsdCAoKDEpLCAoMikpDQpBY3R1YWwgcmVzdWx0ICgoMiksICgyKSkuDQooSk9JTiBv dmVyd3JpdGVzIHRoZSAiYSIgZGVmaW5lZCBiZWZvcmUpDQpCb3RoIHJlZ3VsYXIgYW5kIGxhdGVy YWwgSk9JTiBzaG93IHRoZSBzYW1lIGJlaGF2aW91ci4NCg0KU2NhbGFycyBhbHNvIGNhbiBjYXVz ZSB0aGUgc2FtZSByZXN1bHQ6DQoNClNFTEVDVA0KICAgYSwNCiAgIGIuYQ0KRlJPTQ0KICAoVkFM VUVTICgxKSkgYQ0KICBKT0lOICgNCiAgICBTRUxFQ1QgMiBBUyBhDQogICkgYiBPTiBUUlVFDQo7 DQoNCkV4cGVjdGVkIHJlc3VsdCAoKDEpLCAyKQ0KQWN0dWFsIHJlc3VsdCAoMiwgMikuCgo= --===============0082176143649660241==--