Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lAVL0-0006wp-Eg for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Feb 2021 10:06:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lAVKS-0004qt-9x for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Feb 2021 10:05:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lAOT9-0007Xe-Jw for pgsql-bugs@lists.postgresql.org; Fri, 12 Feb 2021 02:46:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lAOT7-0001G2-Le for pgsql-bugs@lists.postgresql.org; Fri, 12 Feb 2021 02:46:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=VF89Op0ofSkZW73GLVl3sPxmgniy7Z7N771Ycagc5qU=; b=1m1HN6nSgdeiWDKAyfN0J4GtR/ FtEnpp6/ndRMLiWVFTbMFtCij6weuuIfpOxvK3tb2sckFLO/osIpkB+oXkF3sQ+rBUihYPkbuJBAe mplzhyVr7Ole9cSOWZqbU4PgDMGI5tqqRr+9RVotHM4yN5zu2wFkZLlN3QzveyCDwXn7ypL0ZxaY7 yZfl8MkUIGQQoKYpiGhQyAw9z7m/fp/uHramPAeU27/rjthu4huyKf1gfJj0ay39IhudACwSU4Pmb ErCN2BrxMBrs6FJKwAXX4ADDRUm4N0WZiIOBCnLIZPc/QA9vGq/BUm+BufwtAZ7lNpdeuGZKVKSvb KzTfdefQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lAOT7-0004O6-6X for pgsql-bugs@lists.postgresql.org; Fri, 12 Feb 2021 02:46:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lAOT4-0003sH-KD for pgsql-bugs@lists.postgresql.org; Fri, 12 Feb 2021 02:46:02 +0000 Content-Type: multipart/mixed; boundary="===============7875911911445858975==" MIME-Version: 1.0 Subject: BUG #16862: Unexpected result of checking for null "IS NOT NULL" in function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: firstdismay@gmail.com Reply-To: firstdismay@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 12 Feb 2021 02:45:36 +0000 Message-ID: <16862-c10a7401d2973a9b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7875911911445858975== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjg2MgpMb2dnZWQgYnk6ICAgICAgICAgINCU0LzQuNGC0YDQuNC5INCY 0LLQsNC90L7QsgpFbWFpbCBhZGRyZXNzOiAgICAgIGZpcnN0ZGlzbWF5QGdtYWlsLmNvbQpQb3N0 Z3JlU1FMIHZlcnNpb246IDEyLjUKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2Ny aXB0aW9uOiAgICAgICAgCgpHb29kIGRheSENCjEuIENyZWF0ZSBUQUJMRTogImJwZCIuImdyb3Vw IiBBTkQgdmlldw0KMi4gQ3JlYXRlIEZVTkNUSU9OOg0KICAgIERFQ0xBUkU6IGVncm91cFYgImJw ZCIuInZncm91cCIlUk9XVFlQRTsgdmlldw0KICAgIERFQ0xBUkU6IGVncm91cFQgImJwZCIuImdy b3VwIiVST1dUWVBFOyB0YWJsZQ0KMy4gUmV0cmlldmluZyBkYXRhIGNoZWNraW5nIHRoZSByZXN1 bHQgaW4gZnVuY3Rpb246DQogICAgIFNFTEVDVCAqIElOVE8gZWdyb3VwViBGUk9NICJicGQiLiJ2 Z3JvdXAiIFdIRVJFIGlkID0gaWlkOw0KICAgICBTRUxFQ1QgKiBJTlRPIGVncm91cFQgRlJPTSAi YnBkIi4iZ3JvdXAiIFdIRVJFIGlkID0gaWlkOw0KICAgICAgICBJRiAoZWdyb3VwViBJUyBOT1Qg TlVMTCkgVEhFTiA9PiBzdGF0ZSBPSw0KICAgICAgICBJRiAoZWdyb3VwVCBJUyBOT1QgTlVMTCkg VEhFTiA9PiBzdGF0ZSBPSw0KICAgICAgICBJRiBOT1QoZWdyb3VwViBJUyBOVUxMKSBUSEVOID0+ IHN0YXRlIE9LDQogICAgICAgIElGIE5PVChlZ3JvdXBUIElTIE5VTEwpIFRIRU4gPT4gc3RhdGUg T0sNCjQuIEFMVEVSIFRBQkxFICJicGQiLiJncm91cCIgQUREIENPTFVNTg0KNS4gUmV0cmlldmlu ZyBkYXRhIGNoZWNraW5nIHRoZSByZXN1bHQgaW4gZnVuY3Rpb246DQogICAgIFNFTEVDVCAqIElO VE8gZWdyb3VwIEZST00gImJwZCIuInZncm91cCIgV0hFUkUgaWQgPSBpaWQ7DQogICAgIFNFTEVD VCAqIElOVE8gZWdyb3VwVCBGUk9NICJicGQiLiJncm91cCIgV0hFUkUgaWQgPSBpaWQ7DQogICAg ICAgIElGIChlZ3JvdXBWIElTIE5PVCBOVUxMKSBUSEVOID0+IHN0YXRlIE9LDQogICAgICAgIElG IChlZ3JvdXBUIElTIE5PVCBOVUxMKSBUSEVOID0+IHN0YXRlIE5PVCBXT1JLPz8/Pz8/Pz8/Pz8N CiAgICAgICAgSUYgTk9UKGVncm91cFYgSVMgTlVMTCkgVEhFTiA9PiBzdGF0ZSBPSw0KICAgICAg ICBJRiBOT1QoZWdyb3VwVCBJUyBOVUxMKSBUSEVOID0+IHN0YXRlIE9LCgo= --===============7875911911445858975==--