RaigorJiang opened a new issue, #35830:
URL: https://github.com/apache/shardingsphere/issues/35830

   `PostgreSQLBinaryProtocolValue` is an interface for handling `Binary` type 
data in the PostgreSQL protocol, and currently has 21 implementation classes.
   
   <img width="555" alt="Image" 
src="https://github.com/user-attachments/assets/feb942b4-dee3-440c-905a-eb6bfe79dfe6";
 />
   
   ---
   
   However, some `write` methods have not been implemented, which needs to be 
improved.
   For example:
   
   ```java
   public final class PostgreSQLBoolBinaryProtocolValue implements 
PostgreSQLBinaryProtocolValue {
       
       @Override
       public int getColumnLength(final Object value) {
           return 1;
       }
       
       @Override
       public Object read(final PostgreSQLPacketPayload payload, final int 
parameterValueLength) {
           return payload.getByteBuf().readBoolean();
       }
       
       @Override
       public void write(final PostgreSQLPacketPayload payload, final Object 
value) {
           throw new 
UnsupportedSQLOperationException("PostgreSQLBoolBinaryProtocolValue.write()");
       }
   }
   ```
   
   
   ### task list
   - [ ] PostgreSQLBoolArrayBinaryProtocolValue
   - [x] PostgreSQLBoolBinaryProtocolValue
   - [ ] PostgreSQLFloat4ArrayBinaryProtocolValue
   - [ ] PostgreSQLFloat8ArrayBinaryProtocolValue
   - [ ] PostgreSQLInt2ArrayBinaryProtocolValue
   - [ ] PostgreSQLInt4ArrayBinaryProtocolValue
   - [ ] PostgreSQLInt8ArrayBinaryProtocolValue
   - [ ] PostgreSQLArrayParameterDecoder
   - [ ] PostgreSQLTextArrayBinaryProtocolValue
   - [ ] PostgreSQLUnspecifiedBinaryProtocolValue
   
   
   ### Note:
   PostgreSQL supports text and binary data transfer. PostgreSQL drivers used 
by different development languages ​​may choose different way.
   These binary write methods may not be triggered by JDBC clients and need to 
be verified using other clients.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to