aillamsun opened a new issue, #32853:
URL: https://github.com/apache/shardingsphere/issues/32853
## Question
5.5.0 jdbc encryption oracle pagination query error.
`java
columns:
VIN:
cipher:
name: VIN_CIPHER
encryptorName: kms_encryptor
assistedQuery:
name: VIN_QUERY_CIPHER
encryptorName: assisted_query_encryptor
PHONE:
cipher:
name: PHONE_CIPHER
encryptorName: kms_encryptor
assistedQuery:
name: PHONE_QUERY_CIPHER
encryptorName: assisted_query_encryptor
VEHICLE_PLATE_NO:
cipher:
name: VEHICLE_PLATE_NO_CIPHER
encryptorName: kms_encryptor
assistedQuery:
name: VEHICLE_PLATE_NO_QUERY_CIPHER
encryptorName: assisted_query_encryptor
`
`SQL
SELECT
*
FROM
(
SELECT
TMP.*,
ROWNUM ROW_ID
FROM
(
SELECT
ID,
TYPE,
USER_ID,
PHONE,
VEHICLE_PLATE_NO,
VIN,
CHANGE_LOG,
CREATE_TIME
FROM
TB_VEHICLE_AUTH_REQUEST_LOGS
ORDER BY
CREATE_TIME DESC
) TMP
WHERE
ROWNUM <= ?
)
WHERE
ROW_ID > ?
`
### error msg
Cause: java.sql.SQLException: Unsupported SQL operation: Can not support
encrypt shorthand expand with subquery statement.
--
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]
