Y-sir opened a new issue, #29745: URL: https://github.com/apache/shardingsphere/issues/29745
## Bug Report **For English only**, other languages will not accept. Before report a bug, make sure you have: - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues). - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview). Please pay attention on issues you submitted, because we maybe need more details. If no response anymore and we cannot reproduce it on current information, we will **close it**. Please answer these questions before submitting your issue. Thanks! ### Which version of ShardingSphere did you use? 5.4.1 ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy and postgresql 14.2 ### Expected behavior After encryption, you can use INTERSECT syntax to query ### Actual behavior 结果不可以，报错数据转换异常 ### Reason analyze (If you can) The result is not acceptable and an error message is reported: data conversion exception.  ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. Create table ddl CREATE TABLE student( sno INT not null, sname varchar(50) , ssex varchar(50) , sage INTEGER, sdept varchar(50), primary key(sno) ); INSERT INTO student VALUES (201215121, '张三', '女', 20, 'CS'); INSERT INTO student VALUES (201215122, '刘晨', '女', 19, 'CS'); INSERT INTO student VALUES (201215123, '王敏', '女', 18, 'MA'); INSERT INTO student VALUES (201215124, '李四', '男', 21, 'IS'); INSERT INTO student VALUES (201215125, '张立', '男', 19, 'IS'); INSERT INTO student VALUES (201215126, '李四', '女', 21, 'CS'); INSERT INTO student VALUES (201215127, '张三2', '男', 19, 'CS'); INSERT INTO student VALUES (201215128, '李四2', '男', 21, 'CS'); INSERT INTO student VALUES (201215129, '张三3', '女', 18, 'CS'); Encryption rules are arbitrary ### Example codes for reproduce this issue (such as a github link). -- 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]
