[GitHub] [incubator-shardingsphere] yanyzy opened a new issue #3309: Encryption rules do not support uppercase fields

[GitBox]

yanyzy opened a new issue #3309:  Encryption rules do not support uppercase 
fields
URL: https://github.com/apache/incubator-shardingsphere/issues/3309
 
 
   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   4.0.0-RC3-SNAPSHOT
   
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   Sharding-JDBC
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   
   Sql:
   ```
    <insert id="saveSysUser" parameterType="com.mlt.demo.entity.SysUser">
                insert into SYS_USER (ID,
                 NAME,
                 AGE)
                values (#{id,jdbcType=VARCHAR},
                   #{name,jdbcType=VARCHAR},
                   #{age,jdbcType=VARCHAR}
                )
        </insert>
   ```
   
   Config:
   
   ```
   spring:
     shardingsphere:
       datasource:
       ···
       
       encrypt:
         encryptors:
           encryptor_aes:
             type: aes
             props:
               aes.key.value: aes-dg
           encryptor_md5:
             type: md5
         tables:
           SYS_USER:
             columns:
               AGE:
                 plainColumn: AGE
                 cipherColumn: AGE_CIPHER
                 encryptor: encryptor_aes
   ```
   
   error:
   
   ```Caused by: java.lang.ArrayIndexOutOfBoundsException: -1
        at java.util.ArrayList.elementData(ArrayList.java:422)
        at java.util.ArrayList.get(ArrayList.java:435)
        at 
org.apache.shardingsphere.core.preprocessor.segment.insert.InsertValueContext.getValue(InsertValueContext.java:86)
        at 
org.apache.shardingsphere.core.rewrite.feature.encrypt.parameter.impl.EncryptInsertValueParameterRewriter.encryptInsertValues(EncryptInsertValueParameterRewriter.java:75)
        at 
org.apache.shardingsphere.core.rewrite.feature.encrypt.parameter.impl.EncryptInsertValueParameterRewriter.rewrite(EncryptInsertValueParameterRewriter.java:63)
        at 
org.apache.shardingsphere.core.rewrite.feature.encrypt.context.EncryptSQLRewriteContextDecorator.decorate(EncryptSQLRewriteContextDecorator.java:43)
        at 
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptPreparedStatement.getSQLUnit(EncryptPreparedStatement.java:157)
        at 
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptPreparedStatement.execute(EncryptPreparedStatement.java:127)
        at 
org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
        at 
org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
        at 
org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
        at 
org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
        at 
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
        ... 52 more
   ```
   
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services