-
Notifications
You must be signed in to change notification settings - Fork 6.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
using database encryption and decryption to fill in Oracle pagination SQL fields resulted in invalid 'ROWNUM' identifier #32800
Comments
Can you try to the lasted version? |
It seems that the Oracle 5.21 version does not support ROWNUM parsing, but the latest version does |
use 5.4.1 or 5.5.0 error occurred 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 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 msgCause: java.sql.SQLException: Unsupported SQL operation: Can not support encrypt shorthand expand with subquery statement. |
I use 5.4.1 can't do it. |
5.4.1 does it not support storing plaintext fields ? I need a data transition phase for my transformation. 5.2.1 support plaintext |
use version
configuration
Problem occurred
1.Logic SQL
2.Actual SQL
result
as the boss encountered this problem?
The text was updated successfully, but these errors were encountered: