(shardingsphere) branch master updated: Issue with Boolean field return in PG database when accessed via proxy (#37239)

[zhangliang]

This is an automated email from the ASF dual-hosted git repository.

zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 2c36f15664d Issue with Boolean field return in PG database when 
accessed via proxy (#37239)
2c36f15664d is described below

commit 2c36f15664da084655128dedb1544f316ef8a513
Author: WangYjing <120617938+wangyj...@users.noreply.github.com>
AuthorDate: Tue Dec 2 23:57:26 2025 +0800

    Issue with Boolean field return in PG database when accessed via proxy 
(#37239)
    
    * fix: Issue with Boolean field return in PG database when accessed via 
proxy
    
    * fix: Issue with Boolean field return in PG database when accessed via 
proxy
    
    ---------
    
    Co-authored-by: ”wyj408990“ <wyj408...@alibaba-inc.com>
---
 .../postgresql/packet/command/query/PostgreSQLDataRowPacket.java      | 4 ++++
 1 file changed, 4 insertions(+)

diff --git 
a/database/protocol/dialect/postgresql/src/main/java/org/apache/shardingsphere/database/protocol/postgresql/packet/command/query/PostgreSQLDataRowPacket.java
 
b/database/protocol/dialect/postgresql/src/main/java/org/apache/shardingsphere/database/protocol/postgresql/packet/command/query/PostgreSQLDataRowPacket.java
index 181ef35fb22..590a845e92f 100644
--- 
a/database/protocol/dialect/postgresql/src/main/java/org/apache/shardingsphere/database/protocol/postgresql/packet/command/query/PostgreSQLDataRowPacket.java
+++ 
b/database/protocol/dialect/postgresql/src/main/java/org/apache/shardingsphere/database/protocol/postgresql/packet/command/query/PostgreSQLDataRowPacket.java
@@ -71,6 +71,10 @@ public final class PostgreSQLDataRowPacket extends 
PostgreSQLIdentifierPacket {
             payload.writeBytes((byte[]) each);
         } else if (each instanceof SQLXML) {
             writeSQLXMLData(payload, each);
+        } else if (each instanceof Boolean) {
+            byte[] columnData = ((Boolean) each ? "t" : 
"f").getBytes(payload.getCharset());
+            payload.writeInt4(columnData.length);
+            payload.writeBytes(columnData);
         } else {
             byte[] columnData = each.toString().getBytes(payload.getCharset());
             payload.writeInt4(columnData.length);