WangSenkai commented on issue #28904:
URL:
https://github.com/apache/shardingsphere/issues/28904#issuecomment-1788346938
> Can you show the sql generated by PageHelper framework? And provide your
encrypt config, init sql script.
```
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
FROM
user_info a
LEFT JOIN s_user b ON a.agent_id = b.id
WHERE a.email = '123'
ORDER BY
create_time DESC
) TMP_PAGE
)
WHERE
ROW_ID <= 3
AND ROW_ID > 1
```
```
CREATE TABLE "USER_INFO" (
"ID" VARCHAR(255) NOT NULL,
"NAME" VARCHAR2(255),
"EMAIL" VARCHAR2(255),
"AGENT_ID" VARCHAR2(255),
"CREATE_TIME" TIMESTAMP,
PRIMARY KEY ("ID")
);
CREATE TABLE "S_USER" (
"ID" VARCHAR(255) NOT NULL,
"USERNAME" VARCHAR2(255),
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
