You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/28 06:32:33 UTC

[GitHub] [shardingsphere] zhang-zhipeng commented on issue #21799: mybatis-plus3.5.2、shardingsphere5.1.1(Using encrypt)、oracle,When querying by page,rewirte sql is error, regards the ROWNUM as a real field, but it is not

zhang-zhipeng commented on issue #21799:
URL: https://github.com/apache/shardingsphere/issues/21799#issuecomment-1294523247

   encrypt config:
   rules:
         encrypt:
           encryptors:
             pwd-encryptor:
               type: AES
               props:
                 aes-key-value: 123456abc
           tables:
             T_CIPHER_OLD:
               columns:
                 PWD:
                   cipher-column: PWD_CIPHER
                   encryptor-name: pwd-encryptor
   
   create table sql:
   CREATE TABLE "T_CIPHER_OLD"
   (
   	"ID" VARCHAR2(50) NOT NULL ENABLE,
   	"NAME" VARCHAR2(255),
   	"CREATE_TIME" TIMESTAMP(6),
   	"UPDATE_TIME" TIMESTAMP(6),
   	"MOBILE" VARCHAR2(100),
   	"PWD_CIPHER" VARCHAR2(100),
   	"CUSTOMER_ID" VARCHAR2(100),
   	PRIMARY KEY("ID")
   )


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org