vinceLin054 opened a new issue #6881:
URL: https://github.com/apache/shardingsphere/issues/6881
**When I execute the insert values containing SQL functions like now() in
front of the mask field, the parameter position error occurs.**
Here is my configuration :
```
tables:
my_users:
columns:
phone_number:
plainColumn: phone_number
cipherColumn: encryptor_phone_number
encryptor: encryptor_aes
given_name:
plainColumn: given_name
cipherColumn: encryptor_given_name
encryptor: encryptor_aes
logicColumn: given_name
```
Logic SQL:
```
INSERT INTO
my_users
(
created_at, updated_at, phone_number, given_name, avatar_url,
password, password_strength
)
VALUES
(
now(), now(), ?, ?, ?, ?, ?
)
```
Actual SQL:
```
INSERT INTO
my_users
(
created_at, updated_at, encryptor_phone_number, phone_number,
encryptor_given_name, given_name, avatar_url, password, pasword_strength
)
VALUES
(now(), now(), ?, ?, ?, ?, ?, ?, ?) ::: [123123123123, tom,
M4RQIlytSdcEMugmk8N9qQ==, 123123123123, chd9v7LIHgzGCFAunDNSGA==, tom, 0]
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
