ShardingSphere5.3.0 执行Like语句的时候报错

[CarryALin]

相关规则配置
dataSources:
shareen:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.jdbc.Driver
jdbcUrl: jdbc:postgresql://localhost:5432/tz_wg_zx?useUnicode=true&characterEncoding=utf8&autoReconnect=true&stringtype=unspecified
username: postgres
password: 123456
rules:

• !ENCRYPT
  tables:
  test_user:
  columns:
  password:
  cipherColumn: password
  encryptorName: password_encryptor
  likeQueryColumn: password_query
  likeQueryEncryptorName: like_encryptor
  queryWithCipherColumn: true
  encryptors:
  password_encryptor:
  type: AES
  props:
  aes-key-value: 123456abc
  like_encryptor:
  type: CHAR_DIGEST_LIKE
  props:
  sql-show: true
  异常信息如下：
  
  启动时信息：
  

插入语句是可以执行的，且字段可以已经加密

[strongduanmu]

Hi @linhongzhi123, can you translate this discussion to English? Besides, I think you can try the latest 5.4.0, it may be fixed this bug which caused by concat function.

[strongduanmu]

You can refer this issue and pr - #24337. This feature has been supported since 5.3.2.

[CarryALin]

Thanks for the answer, currently I am using version 5.3.2, upgrade to version 5.4.0 as you said, I get the following error

下面是我的yml配置
dataSources:
shareen:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.jdbc.Driver
jdbcUrl: jdbc:postgresql://localhost:5432/tz_wg_zx?useUnicode=true&characterEncoding=utf8&autoReconnect=true&stringtype=unspecified
username: postgres
password: 123456
rules:

• !ENCRYPT
  tables:
  test_user:
  columns:
  password:
  cipherColumn: password
  encryptorName: password_encryptor
  likeQueryColumn: password_query
  likeQueryEncryptorName: like_encryptor
  queryWithCipherColumn: true
  encryptors:
  password_encryptor:
  type: AES
  props:
  aes-key-value: 123456abc
  like_encryptor:
  type: CHAR_DIGEST_LIKE
  props:
  sql-show: true

[CarryALin]

Thank you for the reference solution, but I did not find a solution to this problem, look forward to your answer

[strongduanmu]

You can refer the doc of 5.4.0. Some changes have been made to the encryption API in 5.4.0.