zzyReal666 commented on issue #33383:
URL:
https://github.com/apache/shardingsphere/issues/33383#issuecomment-2435404816
> What is the issue details?
In the encryption function, the query that does not contain the encryption
field must be transparently transmitted.But now, even if you don't include
encrypted fields, SSP proxy still do things to SQL that cause a lot of
problems, such as not being able to query across libraries or schemas.
Here is the SQL that went wrong :
`SELECT *
from (select a.*, SUBSTRING_INDEX(SUBSTRING_INDEX(a.rcareafks, ',',
b.help_topic_id), ',', -1) rcareafk
from rollcallrule a
join mysql.help_topic b
where a.`status` = 'P'
and b.help_topic_id <= LENGTH(a.rcareafks) -
LENGTH(REPLACE(a.rcareafks, ',', '')) + 1) t
where rcareafk is not null
and rcareafk <> '';`
This sql does not contain encrypted fields, so the proxy simply forwards the
request to the database and returns the result.But now I get an error like
'federated query not supported'
--
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]
