You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2023/01/03 10:33:50 UTC
[GitHub] [shardingsphere] maziqiang12138 opened a new issue, #23300: When encryption functions exist in SQL report errors No value specified for parameter
maziqiang12138 opened a new issue, #23300:
URL: https://github.com/apache/shardingsphere/issues/23300
shardingjdbc:5.1.1
mybatisplus 1.3.2
sql demo: insert into user(id, name, type, typeEnc) values (#{id}, #{name},#{type}, AES_ENCRYPT(CAST(#{type} AS DECIMAL(16, 2)),#{typeEnc}))
What methods can be used to correctly execute SQL with encryption functions?
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1369648401
Hi @maziqiang12138
Could you try the encryption feature of ShardingSphere? ShardingSphere has supported AES encryption.
https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/encrypt/
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] maziqiang12138 commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
maziqiang12138 commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1370601954
@TeslaCN @tuichenchuxin
I found that it is not the encryption function but the CAST function. I removed the CAST function from the project and it can run normally
example insert into user(id, name, type, typeEnc) values (#{id}, #{name},#{type}, AES_ENCRYPT(CAST(#{type},DECIMAL(16,2)),#{typeEnc}))
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] maziqiang12138 commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
maziqiang12138 commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1369636314
@TeslaCN Thank you I found it
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] maziqiang12138 closed issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
maziqiang12138 closed issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
URL: https://github.com/apache/shardingsphere/issues/23300
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] When encryption functions exist in SQL report errors No value specified for parameter [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-4089111652
I have checked this sql, it has been fixed on master branch. So I will close this issue.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] When encryption functions exist in SQL report errors No value specified for parameter [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
URL: https://github.com/apache/shardingsphere/issues/23300
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] maziqiang12138 commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
maziqiang12138 commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1369656641
thanks but my project need to verify the ciphertext in the update statement
be similar to update xxx set xxx where AES_DECRYPT(cipher_text,#{key}) = text
Is there a corresponding processing method for this method？
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1370611093
Maybe we should parse the parameter in AES_DECRYPT function.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1369633161
The root cause of this issue may be the same as #22407.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] maziqiang12138 commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
maziqiang12138 commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1369643828
@TeslaCN I've seen this. Is there a corresponding solution？
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #23300: When encryption functions exist in SQL report errors No value specified for parameter
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #23300:
URL: https://github.com/apache/shardingsphere/issues/23300#issuecomment-1370596735
> thanks @TeslaCN but my project need to verify the ciphertext in the update statement be similar to update xxx set xxx where AES_DECRYPT(cipher_text,#{key}) = text Is there a corresponding processing method for this method？
Hi @tuichenchuxin
What do you think of this question?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org