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 1j5E7n-00066p-CU for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Feb 2020 19:38:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j5E7m-0001Ev-34 for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Feb 2020 19:38:10 +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 1j5E7l-0001En-Qv for pgsql-bugs@lists.postgresql.org; Fri, 21 Feb 2020 19:38:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j5E7h-0002sE-Cf for pgsql-bugs@lists.postgresql.org; Fri, 21 Feb 2020 19:38:09 +0000 Content-Type: multipart/mixed; boundary="===============5278093221332320667==" MIME-Version: 1.0 Subject: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tom@intevation.de Reply-To: tom@intevation.de, pgsql-bugs@lists.postgresql.org Date: Fri, 21 Feb 2020 19:37:55 +0000 Message-ID: <16272-6e32da020e9a9381@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5278093221332320667== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI3MgpMb2dnZWQgYnk6ICAgICAgICAgIFRvbSBHb3R0ZnJpZWQKRW1h aWwgYWRkcmVzczogICAgICB0b21AaW50ZXZhdGlvbi5kZQpQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjcKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTguMDQKRGVzY3JpcHRpb246ICAgICAgICAK CkRlYXIgUG9zdGdyZVNRTCBkZXZlbG9wZXJzLA0KDQpjb25zaWRlciB0aGUgZm9sbG93aW5nIHRv IHJlcHJvZHVjZToNCg0KLyogV29ya3M6ICovDQpDUkVBVEUgVEFCTEUgdGVzdCAoDQogICAgdGVz dHAgdmFyY2hhciwNCiAgICB0ZXN0YyB2YXJjaGFyDQopOw0KQ1JFQVRFIElOREVYIHRlc3RfaWR4 IE9OIHRlc3QNCiAgICAoKENBU1QoKHRlc3RwLCB0ZXN0YykgQVMgdGVzdCkpKTsNCg0KSU5TRVJU IElOVE8gdGVzdCAodGVzdHApIFZBTFVFUyAoJ3Rlc3QnKTsNCg0KQ1JFQVRFIFRBQkxFIHRlc3Rf ZXh0ICgNCiAgICBuZXdjb2wgaW50LA0KICAgIExJS0UgdGVzdCBJTkNMVURJTkcgQUxMDQopOw0K DQpJTlNFUlQgSU5UTyB0ZXN0X2V4dCBTRUxFQ1QgMSwgKiBGUk9NIHRlc3Q7DQoNCg0KLyogRG9l cyBub3Qgd29yazogKi8NClxzZXQgVkVSQk9TSVRZIHZlcmJvc2UNCg0KQ1JFQVRFIFRBQkxFIHRl c3RfcGFyZW50ICgNCiAgICB0ZXN0cCB2YXJjaGFyDQopOw0KDQpDUkVBVEUgVEFCTEUgdGVzdF9j aGlsZCAoDQogICAgdGVzdGMgdmFyY2hhcg0KKSBJTkhFUklUUyAodGVzdF9wYXJlbnQpOw0KQ1JF QVRFIElOREVYIHRlc3RfY2hpbGRfaWR4IE9OIHRlc3RfY2hpbGQNCiAgICAoKENBU1QoKHRlc3Rw LCB0ZXN0YykgQVMgdGVzdF9jaGlsZCkpKTsNCg0KSU5TRVJUIElOVE8gdGVzdF9jaGlsZCAodGVz dHApIFZBTFVFUyAoJ3Rlc3QnKTsNCg0KDQpDUkVBVEUgVEFCTEUgdGVzdF9wYXJlbnRfZXh0ICgN CiAgICBuZXdjb2wgaW50LA0KICAgIExJS0UgdGVzdF9wYXJlbnQNCik7DQoNCkNSRUFURSBUQUJM RSB0ZXN0X2NoaWxkX2V4dCAoTElLRSB0ZXN0X2NoaWxkIElOQ0xVRElORyBJTkRFWEVTKQ0KICAg IElOSEVSSVRTICh0ZXN0X3BhcmVudF9leHQpOw0KLyogPT4gICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICANCiAg Tk9USUNFOiAgMDAwMDA6IG1vdmluZyBhbmQgbWVyZ2luZyBjb2x1bW4gInRlc3RwIiB3aXRoIGlu aGVyaXRlZApkZWZpbml0aW9uICAgDQogIERFVEFJTDogIFVzZXItc3BlY2lmaWVkIGNvbHVtbiBt b3ZlZCB0byB0aGUgcG9zaXRpb24gb2YgdGhlIGluaGVyaXRlZApjb2x1bW4uDQogIExPQ0FUSU9O OiAgTWVyZ2VBdHRyaWJ1dGVzLCB0YWJsZWNtZHMuYzoyMzc4ICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgCiAgIA0KKi8NCg0KSU5TRVJUIElOVE8gdGVzdF9jaGlsZF9leHQgU0VMRUNUIDEs ICogRlJPTSB0ZXN0X2NoaWxkOw0KLyogPT4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICANCiAgRVJST1I6ICA0 MjgwNDogYXR0cmlidXRlIDEgb2YgdHlwZSByZWNvcmQgaGFzIHdyb25nIHR5cGUgICAgICAgICAg ICAgICAgICAKICAgDQogIERFVEFJTDogIFRhYmxlIGhhcyB0eXBlIGludGVnZXIsIGJ1dCBxdWVy eSBleHBlY3RzIGNoYXJhY3RlciB2YXJ5aW5nLiAgICAgCiAgIA0KICBMT0NBVElPTjogIENoZWNr VmFyU2xvdENvbXBhdGliaWxpdHksIGV4ZWNFeHBySW50ZXJwLmM6MTg5OCAgICAgICAgICAgICAg IAogICANCiovDQoNClxkIHRlc3RfY2hpbGRfaWR4DQpcZCB0ZXN0X2NoaWxkX2V4dF9yb3dfaWR4 DQovKiA9PiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgCiAgIA0KICAgICAgICAgICAgICAgIEluZGV4ICJwdWJsaWMu dGVzdF9jaGlsZF9pZHgiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICANCiBDb2x1 bW4gfCAgICBUeXBlICAgIHwgS2V5PyB8ICAgICAgICAgICBEZWZpbml0aW9uICAgICAgICAgICAg ICAgICAgICAgICAgICAKICAgDQotLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSAgICAgICAgICAgICAgCiAgIA0KIHJvdyAgICB8IHRl c3RfY2hpbGQgfCB5ZXMgIHwgKFJPVyh0ZXN0cCwgdGVzdGMpOjp0ZXN0X2NoaWxkKSAgICAgICAg ICAgICAgIAogICANCmJ0cmVlLCBmb3IgdGFibGUgInB1YmxpYy50ZXN0X2NoaWxkIiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg CiAgIA0KICAgICAgICAgICAgIEluZGV4ICJwdWJsaWMudGVzdF9jaGlsZF9leHRfcm93X2lkeCIg ICAgICAgICAgICAgICAgICAgICAgICAgIAogICANCiBDb2x1bW4gfCAgICBUeXBlICAgIHwgS2V5 PyB8ICAgICAgICAgICAgRGVmaW5pdGlvbiAgICAgICAgICAgICAgICAgICAgICAgICAKICAgDQot LS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0gICAgICAgICAgICAgCiAgIA0KIHJvdyAgICB8IHRlc3RfY2hpbGQgfCB5ZXMgIHwgKFJP VyhuZXdjb2wsIHRlc3RwKTo6dGVzdF9jaGlsZCkgICAgICAgICAgICAgIAogICANCmJ0cmVlLCBm b3IgdGFibGUgInB1YmxpYy50ZXN0X2NoaWxkX2V4dCIgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAKICAgDQoqLw0KDQpTRUxFQ1QgdmVyc2lvbigpOyAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiANCi8qID0+ICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAKICAgDQpQb3N0Z3JlU1FMIDExLjcgKFVidW50dSAxMS43LTEucGdkZzE4LjA0KzEp IG9uIHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkCmJ5IGdjYyAoVWJ1bnR1IDcuNC4wLTF1 YnVudHUxfjE4LjA0LjEpIDcuNC4wLCA2NC1iaXQgICAgICAgICAgICAgICAgICAgICAgICAKICAg ICANCiovDQoNClRoZSBpbmRleCBleHByZXNzaW9uIGluIHRoZSBpbmRleCBjcmVhdGVkIHZpYSBM SUtFIC4uLiBJTkNMVURJTkcgSU5ERVhFUwpzdGlsbCByZWZlcnMgdG8gdGhlIGZpcnN0IHR3byBh dHRyaWJ1dGVzIG9mIHRoZSB0YWJsZSwgYWx0aG91Z2ggYW4gYXR0cmlidXRlCmhhcyBiZWVuIHB1 dCBpbiBwbGFjZSBiZWZvcmUgdGhlIGNvbHVtbnMgdGhlIGV4cHJlc3Npb24gcmVmZXJyZWQgdG8g aW4gdGhlCm9yaWdpbmFsIGluZGV4Lg0KDQpJIGV4cGVjdGVkIHRoZSBuZXcgaW5kZXggZXhwcmVz c2lvbiB0byByZWZlciB0byB0aGUgc2FtZSAobm93Cm1lcmdlZC9pbmhlcml0ZWQpIGNvbHVtbnMg YXMgdGhlIG9yaWdpbmFsIGluZGV4IChoZXJlOiB0ZXN0cCwgdGVzdGMpIGFzIGl0CmFjdHVhbGx5 IGRvZXMgaW4gdGhlIGZpcnN0IGV4YW1wbGUgd2l0aG91dCBpbmhlcml0YW5jZS4NCg0KVGhhbmtz IGFuZCBiZXN0IHJlZ2FyZHMsDQpUb20KCg== --===============5278093221332320667==--