shardingsphere icon indicating copy to clipboard operation
shardingsphere copied to clipboard

SQL parsing bug for alias

Open daiyueyu opened this issue 6 months ago • 2 comments

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

daiyueyu avatar May 16 '25 05:05 daiyueyu

Hi, I'd like to investigate and try to fix this bug. I'll start working on it.

Flink-ddd avatar Jun 05 '25 06:06 Flink-ddd

@Flink-ddd Welcome, and you can investigate this exception on master branch.

strongduanmu avatar Jun 05 '25 06:06 strongduanmu