daoxincc opened a new issue, #38693:
URL: https://github.com/apache/shardingsphere/issues/38693
## Question
I want to use the same table field for both assistedQuery and likeQuery,I
know it doesn't sound reasonable.
But I want to know if it is possible to remove duplicate field names when
generating the actual SQL, when I set two configurations to have the same fields
## version
```xml
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc</artifactId>
<version>5.5.3</version>
</dependency>
```
## config
```yaml
rules:
- !ENCRYPT
tables:
member:
columns:
val:
cipher:
name: val
encryptorName: aes_encryptor
assistedQuery:
name: assisted_val
encryptorName: like_encryptor
likeQuery:
name: assisted_val
encryptorName: like_encryptor
```
when I use this config, I will got an error
```text
Caused by: java.sql.SQLSyntaxErrorException: Column 'assisted_val' specified
twice
```
--
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]
