WangSenkai commented on issue #28904:
URL:
https://github.com/apache/shardingsphere/issues/28904#issuecomment-1788334294
dataSources:
unique_ds:
dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
driverClassName: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@192.168.0.1:1521:xxxx
username: xxxx
password: xxxx
rules:
- !ENCRYPT
tables:
user_info:
columns:
name:
cipher:
name: name_encrypt
encryptorName: i_encryptor
likeQuery:
name: name_like
encryptorName: like_encryptor
# 加密算法配置
encryptors:
i_encryptor:
type: IZ
props: # 加解密算法属性配置
sm4-key: f6ea011b68a74b379d178e6b3147078a
sm4-iv: b3da78e63b814ad18c8c99633edb7a4c
like_encryptor:
type: CHAR_DIGEST_LIKE
props:
sql-show: true
--------------------------------------------------------------------------------------------------------------------------
SELECT
*
FROM
(
SELECT
TMP_PAGE.*,
ROWNUM ROW_ID
FROM
(
SELECT
a.id,
a.name,
a.email,
b.username,
c.group_name
FROM
user_info a
LEFT JOIN s_user b ON a.agent_id = b.id
LEFT JOIN a_group c ON a.group_id = c.group_id
WHERE a.client_id IN ( '123' )
ORDER BY
last_update_time DESC
) TMP_PAGE
)
WHERE
ROW_ID <= 3
AND ROW_ID > 1
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
