Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTK2l-00H9Ff-1b for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Dec 2025 13:15:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTK2k-00BNvS-0D for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Dec 2025 13:15:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTHUO-00AqFz-36 for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 10:32:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTHUN-0047Jf-0z for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 10:32:08 +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=T34YQkI13yBA1xbz8y74nfrtz6/fRdzVva7e5d1oqSw=; b=RJ74Cn2RyFd/SU0QSHJJhOxBBB hX+y+4cJVIDxZixrukgUiG4WYToMFAKS7Cc9QFMo//xt3nnri49m7uqfQuvRXsuIabN8d9c1EmSjf 8deNsLch/wRs1cOF9krbJfR/CK5vtGiLxRLNUJiNyiI/MTxKycTLvhZY+06YC/0mxgbTold4yYRON w9YC5Qj/b3gD9tDWMdrZuKGT3/MyqbYtHJAhaMHR/QxpeJ7MST2OF95tF+FwHrqwpWqErPE/045b2 DjorRR8jfNB7209eA6j9R3JUFRA//lG1mBgRcd1l1T+nvYIlR/TvmBqbbodpJviO78c0aHXrwMIHL LwcrFpHQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTHUK-007sAs-2t for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 10:32:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTHUI-00Az60-1o for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 10:32:03 +0000 Content-Type: multipart/mixed; boundary="===============5657791539202409640==" MIME-Version: 1.0 Subject: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 798604270@qq.com Reply-To: 798604270@qq.com, pgsql-bugs@lists.postgresql.org Date: Wed, 10 Dec 2025 10:31:04 +0000 Message-ID: <19350-aed90efec73c66cc@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5657791539202409640== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM1MApMb2dnZWQgYnk6ICAgICAgICAgIENoaSBaaGFuZwpFbWFpbCBh ZGRyZXNzOiAgICAgIDc5ODYwNDI3MEBxcS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNy42Ck9w ZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1IDI0LjA0IHdpdGggZG9ja2VyCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSwKCkluIHRoZSBmb2xsb3dpbmcgdGVzdCBjYXNlLCBpZiBJIHJ1biBpdCBpbiBK REJDLCB0aGUgcHJlcGFyZWQgc3RhdGVtZW50IHdpbGwKdHJpZ2dlciBhIGRpdmlkZSBieSB6ZXJv IGVycm9yLiBCdXQgaWYgcnVuIGl0IGluIGNvbW1hbmQgbGluZSwgdGhlcmUgd2lsbApub3QgYmUg dGhlIHNhbWUgZXJyb3IuCgpgYGAKU0VUIHBsYW5fY2FjaGVfbW9kZSA9IGZvcmNlX2dlbmVyaWNf cGxhbjsKQ1JFQVRFIFRBQkxFIHQwKGMwIGludDRyYW5nZSk7CklOU0VSVCBJTlRPIHQwKGMwKSBW QUxVRVMoJ1stMTkyMDg0NjMwNSwtMTAxODgzOTY4OSknOjppbnQ0cmFuZ2UpOwpQUkVQQVJFIHBy ZXBhcmVfcXVlcnkgKGludDgsIGludDgpIEFTIFNFTEVDVAooKCgoKCh1cHBlcih0MC5jMCkpKSkv KCQxKSkpKigoJDI6OmludDgpKSkgRlJPTSBPTkxZIHQwOwpFWEVDVVRFIHByZXBhcmVfcXVlcnko MCwgTlVMTCk7ICAgLS0gdHJpZ2dlciBlcnJvciBpbiBKREJDClNFTEVDVCAoKCgoKCh1cHBlcih0 MC5jMCkpKSkvKDA6OmludDgpKSkqKChOVUxMOjppbnQ4KSkpIEZST00gT05MWSB0MDsgICAtLQph bHdheXMgbm8gZXJyb3IKYGBgCgpUaGlzIGlzIHRoZSBKYXZhIHdvcmtsb2FkOgpgYGAKaW1wb3J0 IGphdmEuaW8uKjsKaW1wb3J0IGphdmEuc3FsLio7CmltcG9ydCBqYXZhLnV0aWwuUHJvcGVydGll czsKCnB1YmxpYyBjbGFzcyBQb3N0Z3Jlc0V4ZWN1dG9yIHsKCiAgICBwdWJsaWMgc3RhdGljIHZv aWQgbWFpbihTdHJpbmdbXSBhcmdzKSB7CiAgICAgICAgaWYgKGFyZ3MubGVuZ3RoICE9IDEpIHsK ICAgICAgICAgICAgU3lzdGVtLmVyci5wcmludGxuKCJ1c2FnZTogamF2YSBQb3N0Z3Jlc0V4ZWN1 dG9yIDxzcWwgZmlsZQpwYXRoPiIpOwogICAgICAgICAgICBTeXN0ZW0uZXhpdCgxKTsKICAgICAg ICB9CgogICAgICAgIFN0cmluZyBmaWxlUGF0aCA9IGFyZ3NbMF07CiAgICAgICAgU3RyaW5nIHVy bCA9ICJqZGJjOnBvc3RncmVzcWw6Ly9sb2NhbGhvc3Q6NTQzMy90ZXN0IjsKICAgICAgICBTdHJp bmcgdXNlciA9ICJzcWxhbmNlciI7CiAgICAgICAgU3RyaW5nIHBhc3N3b3JkID0gInNxbGFuY2Vy IjsKCiAgICAgICAgdHJ5IChDb25uZWN0aW9uIGNvbm4gPSBEcml2ZXJNYW5hZ2VyLmdldENvbm5l Y3Rpb24odXJsLCB1c2VyLApwYXNzd29yZCk7CiAgICAgICAgICAgICBCdWZmZXJlZFJlYWRlciBy ZWFkZXIgPSBuZXcgQnVmZmVyZWRSZWFkZXIobmV3CkZpbGVSZWFkZXIoZmlsZVBhdGgpKSkgewoK ICAgICAgICAgICAgU3lzdGVtLm91dC5wcmludGxuKCJTdWNjZXNzZnVsbHkgY29ubmVjdGVkIHRv IFBvc3RncmVzCmRhdGFiYXNlLiIpOwoKICAgICAgICAgICAgU3RyaW5nIGxpbmU7CiAgICAgICAg ICAgIHRyeSAoU3RhdGVtZW50IHN0bXQgPSBjb25uLmNyZWF0ZVN0YXRlbWVudCgpKSB7CiAgICAg ICAgICAgICAgICB3aGlsZSAoKGxpbmUgPSByZWFkZXIucmVhZExpbmUoKSkgIT0gbnVsbCkgewog ICAgICAgICAgICAgICAgICAgIGxpbmUgPSBsaW5lLnRyaW0oKTsKICAgICAgICAgICAgICAgICAg ICBpZiAobGluZS5pc0VtcHR5KCkgfHwgbGluZS5zdGFydHNXaXRoKCItLSIpKSB7CiAgICAgICAg ICAgICAgICAgICAgICAgIGNvbnRpbnVlOwogICAgICAgICAgICAgICAgICAgIH0KCiAgICAgICAg ICAgICAgICAgICAgdHJ5IHsKICAgICAgICAgICAgICAgICAgICAgICAgU3lzdGVtLm91dC5wcmlu dGxuKCJFeGVjdXRpbmcgU1FMOiAiICsgbGluZSk7CiAgICAgICAgICAgICAgICAgICAgICAgIGJv b2xlYW4gaGFzUmVzdWx0ID0gc3RtdC5leGVjdXRlKGxpbmUpOwogICAgICAgICAgICAgICAgICAg ICAgICBpZiAoaGFzUmVzdWx0KSB7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICB0cnkgKFJl c3VsdFNldCBycyA9IHN0bXQuZ2V0UmVzdWx0U2V0KCkpIHsKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBSZXN1bHRTZXRNZXRhRGF0YSBtZXRhID0gcnMuZ2V0TWV0YURhdGEoKTsKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBpbnQgY29sdW1uQ291bnQgPSBtZXRhLmdldENv bHVtbkNvdW50KCk7CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHdoaWxlIChycy5u ZXh0KCkpIHsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZm9yIChpbnQgaSA9 IDE7IGkgPD0gY29sdW1uQ291bnQ7IGkrKykgewogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgU3lzdGVtLm91dC5wcmludChycy5nZXRTdHJpbmcoaSkpOwogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgaWYgKGkgPCBjb2x1bW5Db3VudCkKU3lzdGVt Lm91dC5wcmludCgiXHQiKTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBTeXN0ZW0ub3V0LnByaW50bG4oKTsK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgICAg ICAgICB9CiAgICAgICAgICAgICAgICAgICAgICAgIH0gZWxzZSB7CiAgICAgICAgICAgICAgICAg ICAgICAgICAgICBpbnQgdXBkYXRlQ291bnQgPSBzdG10LmdldFVwZGF0ZUNvdW50KCk7CiAgICAg ICAgICAgICAgICAgICAgICAgICAgICBTeXN0ZW0ub3V0LnByaW50bG4oIkV4ZWN1dGUgc3VjY2Vz c2Z1bGx5OiAiICsKdXBkYXRlQ291bnQgKyAiIHJvd3MgYWZmZWN0ZWQiKTsKICAgICAgICAgICAg ICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgICAgIH0gY2F0Y2ggKFNRTEV4Y2VwdGlvbiBl KSB7CiAgICAgICAgICAgICAgICAgICAgICAgIFN5c3RlbS5lcnIucHJpbnRsbigiRXhlY3V0ZSBl cnJvcjogIiArIGxpbmUpOwogICAgICAgICAgICAgICAgICAgICAgICBlLnByaW50U3RhY2tUcmFj ZSgpOwogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAg fQoKICAgICAgICB9IGNhdGNoIChFeGNlcHRpb24gZSkgewogICAgICAgICAgICBlLnByaW50U3Rh Y2tUcmFjZSgpOwogICAgICAgIH0KICAgIH0KfQoKSSBjYW4gcmVwcm9kdWNlIHRoaXMgd2l0aCBw b3N0Z3Jlc3FsLTQyLjcuOC5qYXIKYGBgCmphdmEgLWNwCi9yb290Ly5tMi9yZXBvc2l0b3J5L29y Zy9wb3N0Z3Jlc3FsL3Bvc3RncmVzcWwvNDIuNy44L3Bvc3RncmVzcWwtNDIuNy44LmphcgpQb3N0 Z3Jlc0V4ZWN1dG9yLmphdmEgdGVzdC5zcWwKCg== --===============5657791539202409640==--