shardingsphere
shardingsphere copied to clipboard
SQL parsing bug for alias
First question: The latest version of Spring Boot integration I found in the Maven repository is 5.2.1. Is there a newer version available? Where can I download it?
<dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId> <version>5.2.1</version> </dependency>
Second question: During my usage, I found that using aliases causes issues when parsing SQL. This is just a simple example, but there are scenarios in multi-table joins where these aliases are used:
select tu.u_card,tu.u_name from (select NAME u_name,ID_CARD u_card from T_USER) tu where tu.u_card=#{idCard}
This is my configuration:
rules: encrypt: tables: T_USER: columns: ID_CARD: cipherColumn: ID_CARD encryptorName: aes_encryptor assistedQueryColumn: ID_CARD_PREFIX encryptors: aes_encryptor: type: AES props: aes-key-value: 1234567890123456
Hi, I'd like to investigate and try to fix this bug. I'll start working on it.
@Flink-ddd Welcome, and you can investigate this exception on master branch.