Skip to content
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

MySQL sharding encrypt test #2134

Closed
5 tasks done
codefairy08 opened this issue Mar 29, 2019 · 0 comments
Closed
5 tasks done

MySQL sharding encrypt test #2134

codefairy08 opened this issue Mar 29, 2019 · 0 comments
Assignees
Milestone

Comments

@codefairy08
Copy link
Contributor

codefairy08 commented Mar 29, 2019

This issue is for sharding encrypt parsing test. when using encryption for sharding,
it needs SQL parser doing something for encryption, SQL parser need genereate EncryptColumnToken and encrypt Conditions.
the test just check both of them which are expected.
The following is the specific design:

  • add encrypt rule for test, take column 'status' of table 't_order' as encrypt column
  • parse DML statement fill EncryptColumnToken and encrypt Conditions into DMLStatement
  • add ExpectedEncryptColumnToken hold expect value in files ex: delete.xml,update.xml, EncryptColumnToken startIndex and stopIndex are different between placeholder and literal, so there are two couple fields one for placeholder, the other for placeholder
  • add EncryptColumnTokenAssert check EncryptColumnToken in DMLStatement
  • add check for encrypt Conditions
@codefairy08 codefairy08 self-assigned this Mar 29, 2019
@terrymanu terrymanu added this to the 4.0.0.M2 milestone Mar 29, 2019
terrymanu added a commit that referenced this issue Apr 8, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants