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 1kHOya-0003JL-M6 for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Sep 2020 10:11:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kHOyX-0005p7-6p for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Sep 2020 10:11:13 +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 1kHFtI-0003ia-6L for pgsql-bugs@lists.postgresql.org; Sun, 13 Sep 2020 00:29:12 +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 1kHFtE-0004Gv-Iv for pgsql-bugs@lists.postgresql.org; Sun, 13 Sep 2020 00:29:11 +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=JoytEkCzQCeu+G5Ax6QkcpQ+60jJ7450arSciaalFzQ=; b=A7wn1YB0GYpXmplkDMZO+01IVA 7ji2ptNzxBq1+qaETaaqf2u/+rvgJdNI/yivUVy4xXzF28vohyfG/SrBgddwE8x4Y3LE5zboCMBuV p3499x3oeG8mzvMdkwWak3/8FMcZsD7L51jTD454NW8mv4NaZyrTE6QcWw2gu1AZdB20aNhGxZc+8 noIgj0hn+9GDZKX2Re7Cb2YvR6mxB1/utqncs1lo2HjpCM6MioedLX0dQNHI80qnUi8QadCtGcHcx bL6pbj7DHkrEIUz1vgrmtVy1sLoIuQ3lKSOn4EEhCkNuHVuYqAdZVPW9YQCVQAjhpHD1dOE+cSC47 YzZFXYkQ==; 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 1kHFt9-00010O-Sv for pgsql-bugs@lists.postgresql.org; Sun, 13 Sep 2020 00:29:08 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kHFt8-0006bD-Kg for pgsql-bugs@lists.postgresql.org; Sun, 13 Sep 2020 00:29:02 +0000 Content-Type: multipart/mixed; boundary="===============2612020129967122913==" MIME-Version: 1.0 Subject: BUG #16615: Cannot determine type of Date for "is null" expression To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yuanhang.zheng@qq.com Reply-To: yuanhang.zheng@qq.com, pgsql-bugs@lists.postgresql.org Date: Sun, 13 Sep 2020 00:28:45 +0000 Message-ID: <16615-1f85b569d6a34277@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 --===============2612020129967122913== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYxNQpMb2dnZWQgYnk6ICAgICAgICAgIEhhbmsKRW1haWwgYWRkcmVz czogICAgICB5dWFuaGFuZy56aGVuZ0BxcS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxM2JldGEz Ck9wZXJhdGluZyBzeXN0ZW06ICAgTWFjIE9TIFgKRGVzY3JpcHRpb246ICAgICAgICAKClN0ZXBz IHRvIHJlcHJvZHVjZToNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCkkgYW0gdXNpbmcg UG9zdGdyZXMgSkRCQyBkcml2ZXIgNDIuMi4xNi4NCiAgICAgICAgICAgICAgICBEYXRlIGRhdGUg PSBuZXcKU2ltcGxlRGF0ZUZvcm1hdCgieXl5eS1NTS1kZCIpLnBhcnNlKCIyMDIwLTA5LTA4Iik7 DQogICAgICAgICAgICAgICAgU3RyaW5nIHNxbCA9ICJzZWxlY3QgKiBmcm9tIHRiX3VzZXIgd2hl cmUgKD8gaXMgbnVsbCBvcgpjcmVhdGVkYXQgPiA/KSI7DQogICAgICAgICAgICAgICAgUHJlcGFy ZWRTdGF0ZW1lbnQgc3RhdGVtZW50ID0gY29ubi5wcmVwYXJlU3RhdGVtZW50KHNxbCk7DQogICAg ICAgICAgICAgICAgc3RhdGVtZW50LnNldERhdGUoMSwgbmV3IGphdmEuc3FsLkRhdGUoZGF0ZS5n ZXRUaW1lKCkpKTsNCiAgICAgICAgICAgICAgICBzdGF0ZW1lbnQuc2V0RGF0ZSgyLCBuZXcgamF2 YS5zcWwuRGF0ZShkYXRlLmdldFRpbWUoKSkpOw0KICAgICAgICAgICAgICAgIFJlc3VsdFNldCBy ZXN1bHRTZXQgPSBzdGF0ZW1lbnQuZXhlY3V0ZVF1ZXJ5KCk7DQpFeHBlY3RlZCByZXN1bHQ6DQot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCkNhbiBnZXQgcmVzdWx0IHNldCBzdWNjZXNzZnVsbHkN Cg0KQWN0dWFsIHJlc3VsdDoNCkVSUk9SOiAgY291bGQgbm90IGRldGVybWluZSBkYXRhIHR5cGUg b2YgcGFyYW1ldGVyICQxDQoNCkFmdGVyIHJlYWRpbmcgc29tZSBjb2RlcyBvZiBQb3N0Z3JlcyBK REJDIGRyaXZlciBhbmQgUG9zdGdyZXMgc2VydmVyLCB0aGUKZm9sbG93aW5nIGlzIG15IGZpbmRp bmcuDQoxLiBQb3N0Z3JlcyBKREJDIGRyaXZlciB3aWxsIGFsd2F5cyB1c2UgT2lkIFVOU1BFQ0lG SUVEKDApIGZvciBEYXRlIHR5cGUuClNlZSBQZ1ByZXBhcmVkU3RhdGVtZW50LmphdmEsIGluIHNl dERhdGUgZnVuY3Rpb24uDQoyLiBJbiBQb3N0Z3JlcyBzZXJ2ZXIsIGl0IHdvbid0IGNvZXJjZSB0 aGUgdHlwZSB0byBEYXRlIGV2ZW4gaWYgd2UgcHJvdmlkZQp0aGUgdHlwZS4gU2VlIHBhcnNlX2V4 cHIuYyBpbiB0cmFuc2Zvcm1FeHByUmVjdXJzZSBmdW5jdGlvbi4NCiAgICAgICAgICAgICAgICAg ICBjYXNlIFRfTnVsbFRlc3Q6DQoJCQl7DQoJCQkJTnVsbFRlc3QgICAqbiA9IChOdWxsVGVzdCAq KSBleHByOw0KCQkJCW4tPmFyZyA9IChFeHByICopIHRyYW5zZm9ybUV4cHJSZWN1cnNlKHBzdGF0 ZSwgKE5vZGUgKikgbi0+YXJnKTsNCgkJCQkvKiB0aGUgYXJndW1lbnQgY2FuIGJlIGFueSB0eXBl LCBzbyBkb24ndCBjb2VyY2UgaXQgKi8NCgkJCQluLT5hcmdpc3JvdyA9IHR5cGVfaXNfcm93dHlw ZShleHByVHlwZSgoTm9kZSAqKSBuLT5hcmcpKTsNCgkJCQlyZXN1bHQgPSBleHByOw0KCQkJCWJy ZWFrOw0KCQkJfQoK --===============2612020129967122913==--