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 1ieecc-0004vP-OO for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Dec 2019 12:28:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ieecb-0003kW-Af for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Dec 2019 12:28:09 +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 1ieecb-0003kP-2S for pgsql-bugs@lists.postgresql.org; Tue, 10 Dec 2019 12:28:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ieecX-0006i2-3c for pgsql-bugs@lists.postgresql.org; Tue, 10 Dec 2019 12:28:08 +0000 Content-Type: multipart/mixed; boundary="===============3168656976713095999==" MIME-Version: 1.0 Subject: BUG #16158: Check constraints using SQL functions work incorrectly To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: pjander2@gmail.com Reply-To: pjander2@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 10 Dec 2019 12:27:13 +0000 Message-ID: <16158-7ccf2f74b3d655db@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3168656976713095999== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE1OApMb2dnZWQgYnk6ICAgICAgICAgIFBpb3RyIEphbmRlcgpFbWFp bCBhZGRyZXNzOiAgICAgIHBqYW5kZXIyQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjUKT3BlcmF0aW5nIHN5c3RlbTogICB4ODZfNjQgR05VL0xpbnV4CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpTdW1tYXJ5OiBJIGRlZmluZWQgYSBjaGVjayBjb25zdHJhaW50IGBwcm9qZWN0X2xpbWl0 c2AgdXNpbmcNCltTUUwgZnVuY3Rpb25zXShodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2Nz LzkuMS94ZnVuYy1zcWwuaHRtbCkuDQpUaGUgY29uc3RyYWludCBjYW4gYmUgZW5mb3JjZWQgdXNp bmcgdGhlIGNvbW1hbmRzDQoNCmBgYA0KYWx0ZXIgdGFibGUgInByb2plY3RzIiBhZGQgY29uc3Ry YWludCBwcm9qZWN0X2xpbWl0cyBjaGVjayguLi4pIG5vdCB2YWxpZDsNCmFsdGVyIHRhYmxlICJw cm9qZWN0cyIgdmFsaWRhdGUgY29uc3RyYWludCBwcm9qZWN0X2xpbWl0czsNCmBgYA0KDQpIb3dl dmVyLCBpdCBpcyBub3QgZW5mb3JjZWQgb24gaW5zZXJ0cy4gQ29uc2VxdWVudGx5LCB0aGUgZGF0 YWJhc2UgY2FuIGdldAppbnRvIA0KYW4gaW52YWxpZCBzdGF0ZSwgYXMgZGVtb25zdHJhdGVkIGJl bG93Lg0KDQpUaGUgc2VxdWVuY2Ugb2YgY29tbWFuZHMgYmVsb3cgaXMgY29tcGxldGUgYW5kIHNl bGYtY29udGFpbmVkLg0KDQpHaXZlbiBQb3N0Z3JlU1FMIDExLjU6DQoNCmBgYA0KcHJvamVjdF9t YW5hZ2VyPT4gU0VMRUNUIHZlcnNpb24oKTsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDExLjUgb24geDg2XzY0LXBjLWxpbnV4 LWdudSwgY29tcGlsZWQgYnkgZ2NjIChEZWJpYW4KNi4zLjAtMTgrZGViOXUxKSA2LjMuMCAyMDE3 MDUxNiwgNjQtYml0DQooMSByb3cpDQpgYGANCg0KV2UgY3JlYXRlIHRhYmxlcyBgb3JnYW5pemF0 aW9uc2AgYW5kIGBwcm9qZWN0c2A6DQoNCmBgYA0KcHJvamVjdF9tYW5hZ2VyPT4gY3JlYXRlIHRh YmxlICJvcmdhbml6YXRpb25zIiAoImlkIiBTRVJJQUwgTk9UIE5VTEwgUFJJTUFSWQpLRVksImxp bWl0IiBJTlRFR0VSIE5PVCBOVUxMKTsNCkNSRUFURSBUQUJMRQ0KcHJvamVjdF9tYW5hZ2VyPT4g Y3JlYXRlIHRhYmxlICJwcm9qZWN0cyIgKCJpZCIgU0VSSUFMIE5PVCBOVUxMIFBSSU1BUlkKS0VZ LCJvcmdhbml6YXRpb25faWQiIElOVEVHRVIgTk9UIE5VTEwpOw0KQ1JFQVRFIFRBQkxFDQpwcm9q ZWN0X21hbmFnZXI9PiBhbHRlciB0YWJsZSAicHJvamVjdHMiIGFkZCBjb25zdHJhaW50ICJvcmdh bml6YXRpb25zIgpmb3JlaWduIGtleSgib3JnYW5pemF0aW9uX2lkIikgcmVmZXJlbmNlcyAib3Jn YW5pemF0aW9ucyIoImlkIik7DQpBTFRFUiBUQUJMRQ0KYGBgDQoNCldlIGRlZmluZSBTUUwgZnVu Y3Rpb25zIGBvcmdfbGltaXRgIGFuZCBgcHJvamVjdF9jb3VudGAgd2hpY2ggd2lsbCBiZSB1c2Vk CmluDQp0aGUgY2hlY2sgY29uc3RyYWludDoNCg0KYGBgDQpwcm9qZWN0X21hbmFnZXI9PiBjcmVh dGUgb3IgcmVwbGFjZSBmdW5jdGlvbiBvcmdfbGltaXQob3JnX2lkIGludGVnZXIpCnJldHVybnMg aW50ZWdlciBhcyAnc2VsZWN0ICJsaW1pdCIgZnJvbSAib3JnYW5pemF0aW9ucyIgd2hlcmUgImlk IiA9IG9yZ19pZCcKbGFuZ3VhZ2Ugc3FsOw0KQ1JFQVRFIEZVTkNUSU9ODQpwcm9qZWN0X21hbmFn ZXI9PiBjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlvbiBwcm9qZWN0X2NvdW50KG9yZ19pZCBpbnRl Z2VyKQpyZXR1cm5zIGJpZ2ludCBhcyAnc2VsZWN0IGNvdW50KCopIGZyb20gInByb2plY3RzIiB3 aGVyZSAib3JnYW5pemF0aW9uX2lkIiA9Cm9yZ19pZCcgbGFuZ3VhZ2Ugc3FsOw0KQ1JFQVRFIEZV TkNUSU9ODQpgYGANCg0KVGhlIGludGVuZGVkIGNvbnN0cmFpbnQgaXMgdGhhdCB0aGVyZSBzaG91 bGQgbmV2ZXIgYmUgbW9yZSBwcm9qZWN0cyBpbiBhbg0Kb3JnYW5pemF0aW9ucyB0aGF0IHRoZSBv cmdhbml6YXRpb24ncyBsaW1pdC4gQmVmb3JlIGFjdHVhbGx5IGFkZGluZyB0aGUKY2hlY2sNCmNv bnN0cmFpbnQsIGxldCB1cyBhcnJpdmUgYXQgYSBzdGF0ZSB3aGljaCB3b3VsZCB2aW9sYXRlIHRo aXMgY29uc3RyYWludAoodHdvDQpwcm9qZWN0cyBpbiBhbiBvcmdhbml6YXRpb24gd2hpY2ggaGFz IGEgbGltaXQgb2YgMSk6DQoNCmBgYA0KcHJvamVjdF9tYW5hZ2VyPT4gaW5zZXJ0IGludG8gIm9y Z2FuaXphdGlvbnMiICgibGltaXQiKSB2YWx1ZXMgKDEpOw0KSU5TRVJUIDAgMQ0KcHJvamVjdF9t YW5hZ2VyPT4gc2VsZWN0ICogZnJvbSAib3JnYW5pemF0aW9ucyI7DQogaWQgfCBsaW1pdA0KLS0t LSstLS0tLS0tDQogIDEgfCAgICAgMQ0KKDEgcm93KQ0KDQpwcm9qZWN0X21hbmFnZXI9PiBpbnNl cnQgaW50byAicHJvamVjdHMiICgib3JnYW5pemF0aW9uX2lkIikgdmFsdWVzICgxKTsNCklOU0VS VCAwIDENCnByb2plY3RfbWFuYWdlcj0+IGluc2VydCBpbnRvICJwcm9qZWN0cyIgKCJvcmdhbml6 YXRpb25faWQiKSB2YWx1ZXMgKDEpOw0KSU5TRVJUIDAgMQ0KcHJvamVjdF9tYW5hZ2VyPT4gc2Vs ZWN0ICogZnJvbSAicHJvamVjdHMiOw0KIGlkIHwgb3JnYW5pemF0aW9uX2lkDQotLS0tKy0tLS0t LS0tLS0tLS0tLS0tDQogIDEgfCAgICAgICAgICAgICAgIDENCiAgMiB8ICAgICAgICAgICAgICAg MQ0KKDIgcm93cykNCmBgYA0KDQpOb3cgd2UgZmluYWxseSBhZGQgdGhlIGNvbnRyYWludCAoZmly c3QgYXMgbm90IHZhbGlkIGFuZCB0aGVuIHdlIGF0dGVtcHQKdG8NCnZhbGlkYXRlIGl0KToNCg0K YGBgDQpwcm9qZWN0X21hbmFnZXI9PiBhbHRlciB0YWJsZSAicHJvamVjdHMiIGFkZCBjb25zdHJh aW50IHByb2plY3RfbGltaXRzCmNoZWNrKHByb2plY3RfY291bnQob3JnYW5pemF0aW9uX2lkKSA8 PSBvcmdfbGltaXQob3JnYW5pemF0aW9uX2lkKSkgbm90CnZhbGlkOw0KQUxURVIgVEFCTEUNCnBy b2plY3RfbWFuYWdlcj0+IGFsdGVyIHRhYmxlICJwcm9qZWN0cyIgdmFsaWRhdGUgY29uc3RyYWlu dApwcm9qZWN0X2xpbWl0czsNCkVSUk9SOiAgY2hlY2sgY29uc3RyYWludCAicHJvamVjdF9saW1p dHMiIGlzIHZpb2xhdGVkIGJ5IHNvbWUgcm93DQpgYGANCg0KSW5kZWVkLCB3ZSBjYW4gbWFudWFs bHkgdmVyaWZ5IHRoYXQgdGhlIGNvbnN0cmFpbnQgaXMgdmlvbGF0ZWQ6DQoNCmBgYA0KcHJvamVj dF9tYW5hZ2VyPT4gc2VsZWN0IHByb2plY3RfY291bnQoMSk7DQogcHJvamVjdF9jb3VudA0KLS0t LS0tLS0tLS0tLS0tDQogICAgICAgICAgICAgMg0KKDEgcm93KQ0KDQpwcm9qZWN0X21hbmFnZXI9 PiBzZWxlY3Qgb3JnX2xpbWl0KDEpOw0KIG9yZ19saW1pdA0KLS0tLS0tLS0tLS0NCiAgICAgICAg IDENCigxIHJvdykNCmBgYA0KDQpBZnRlciB3ZSBkZWxldGUgb25lIG9mIHRoZSB0d28gcHJvamVj dHMsIHdlIGNhbiBzdWNjZXNzZnVsbHkgdmFsaWRhdGUgdGhlDQpjb25zdHJhaW50Og0KDQpgYGAN CnByb2plY3RfbWFuYWdlcj0+IGRlbGV0ZSBmcm9tICJwcm9qZWN0cyIgd2hlcmUgImlkIiA9IDI7 DQpERUxFVEUgMQ0KcHJvamVjdF9tYW5hZ2VyPT4gc2VsZWN0ICogZnJvbSAicHJvamVjdHMiOw0K IGlkIHwgb3JnYW5pemF0aW9uX2lkDQotLS0tKy0tLS0tLS0tLS0tLS0tLS0tDQogIDEgfCAgICAg ICAgICAgICAgIDENCigxIHJvdykNCg0KcHJvamVjdF9tYW5hZ2VyPT4gYWx0ZXIgdGFibGUgInBy b2plY3RzIiB2YWxpZGF0ZSBjb25zdHJhaW50CnByb2plY3RfbGltaXRzOw0KQUxURVIgVEFCTEUN CmBgYA0KDQpCZWZvcmUgd2UgYXR0ZW1wdCB0byB2aW9sYXRlIHRoZSBjb25zdHJhaW50IGFnYWlu LCB3ZSBjb25maXJtIHRoYXQgdGhlDQpjb25zdHJhaW50IGlzIGFkZGVkIHRvIHRoZSB0YWJsZToN Cg0KYGBgDQpwcm9qZWN0X21hbmFnZXI9PiBcZCAicHJvamVjdHMiOw0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5wcm9qZWN0cyINCiAgICAgQ29sdW1uICAg ICAgfCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAgICAgICAgICAgICAgIERlZmF1 bHQNCi0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogaWQgICAgICAgICAgICAgIHwg aW50ZWdlciB8ICAgICAgICAgICB8IG5vdCBudWxsIHwKbmV4dHZhbCgncHJvamVjdHNfaWRfc2Vx Jzo6cmVnY2xhc3MpDQogb3JnYW5pemF0aW9uX2lkIHwgaW50ZWdlciB8ICAgICAgICAgICB8IG5v dCBudWxsIHwNCkluZGV4ZXM6DQogICAgInByb2plY3RzX3BrZXkiIFBSSU1BUlkgS0VZLCBidHJl ZSAoaWQpDQpDaGVjayBjb25zdHJhaW50czoNCiAgICAicHJvamVjdF9saW1pdHMiIENIRUNLIChw cm9qZWN0X2NvdW50KG9yZ2FuaXphdGlvbl9pZCkgPD0Kb3JnX2xpbWl0KG9yZ2FuaXphdGlvbl9p ZCkpDQpGb3JlaWduLWtleSBjb25zdHJhaW50czoNCiAgICAib3JnYW5pemF0aW9ucyIgRk9SRUlH TiBLRVkgKG9yZ2FuaXphdGlvbl9pZCkgUkVGRVJFTkNFUwpvcmdhbml6YXRpb25zKGlkKQ0KYGBg DQoNCkJVRzogV2UgY2FuIHZpb2xhdGUgdGhlIGNvbnN0cmFpbnQgYnkgaW5zZXJ0IGFub3RoZXIg cHJvamVjdC4NCg0KYGBgDQpwcm9qZWN0X21hbmFnZXI9PiBpbnNlcnQgaW50byAicHJvamVjdHMi ICgib3JnYW5pemF0aW9uX2lkIikgdmFsdWVzICgxKTsNCklOU0VSVCAwIDENCmBgYA0KDQpBdCB0 aGlzIHBvaW50LCB0aGUgYHZhbGlkYXRlIGNvbnN0cmFpbnRgIGNvbW1hbmQgZG9lc24ndCBjYXRj aCB0aGUKdmlvbGF0aW9uDQplaXRoZXIuDQoNCmBgYA0KcHJvamVjdF9tYW5hZ2VyPT4gYWx0ZXIg dGFibGUgInByb2plY3RzIiB2YWxpZGF0ZSBjb25zdHJhaW50CnByb2plY3RfbGltaXRzOw0KQUxU RVIgVEFCTEUNCmBgYA0KDQpBZ2Fpbiwgd2UgbWFudWFsbHkgdmVyaWZ5IHRoYXQgdGhlIGNvbnN0 cmFpbnQgaXMgdmlvbGF0ZWQ6DQoNCmBgYA0KcHJvamVjdF9tYW5hZ2VyPT4gc2VsZWN0IHByb2pl Y3RfY291bnQoMSk7DQogcHJvamVjdF9jb3VudA0KLS0tLS0tLS0tLS0tLS0tDQogICAgICAgICAg ICAgMg0KKDEgcm93KQ0KDQpwcm9qZWN0X21hbmFnZXI9PiBzZWxlY3Qgb3JnX2xpbWl0KDEpOw0K IG9yZ19saW1pdA0KLS0tLS0tLS0tLS0NCiAgICAgICAgIDENCigxIHJvdykNCmBgYA0KDQpUbyBj YXRjaCB0aGUgdmlvbGF0aW9uLCB3ZSBuZWVkIHRvIGRyb3AgdGhlIGNvbnN0cmFpbnQsIGFkZCBp dCBhZ2FpbiwgYW5kDQp2YWxpZGF0ZToNCg0KYGBgDQpwcm9qZWN0X21hbmFnZXI9PiBhbHRlciB0 YWJsZSAicHJvamVjdHMiIGRyb3AgY29uc3RyYWludCBwcm9qZWN0X2xpbWl0czsNCkFMVEVSIFRB QkxFDQpwcm9qZWN0X21hbmFnZXI9PiBhbHRlciB0YWJsZSAicHJvamVjdHMiIGFkZCBjb25zdHJh aW50IHByb2plY3RfbGltaXRzCmNoZWNrKHByb2plY3RfY291bnQob3JnYW5pemF0aW9uX2lkKSA8 PSBvcmdfbGltaXQob3JnYW5pemF0aW9uX2lkKSkgbm90CnZhbGlkOw0KQUxURVIgVEFCTEUNCnBy b2plY3RfbWFuYWdlcj0+IGFsdGVyIHRhYmxlICJwcm9qZWN0cyIgdmFsaWRhdGUgY29uc3RyYWlu dApwcm9qZWN0X2xpbWl0czsNCkVSUk9SOiAgY2hlY2sgY29uc3RyYWludCAicHJvamVjdF9saW1p dHMiIGlzIHZpb2xhdGVkIGJ5IHNvbWUgcm93DQpgYGANCg0KTXkgY29uamVjdHVyZSBpcyB0aGF0 IHRoZSBidWcgaXMgZHVlIHRvIHRoZSB1c2Ugb2YgU1FMIGZ1bmN0aW9ucyBpbiB0aGUKY2hlY2su DQpIb3dldmVyLCB0aGUKW2RvY3NdKGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS40 L2RkbC1jb25zdHJhaW50cy5odG1sKQ0Kb24gY29uc3RyYWludHMgZG8gbm90IG1lbnRpb24gYW55 IGxpbWl0YXRpb25zIG9uIHVzaW5nIHN1Y2ggU1FMIGZ1bmN0aW9ucwppbg0KY2hlY2tzLiBJZiBz dWNoIGxpbWl0YXRpb25zIGV4aXN0LCB0aGV5IHNob3VsZCBiZSBtZW50aW9uZWQgaW4gdGhlIGRv Y3MuCgo= --===============3168656976713095999==--