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

Smart anonymization is not using all seed records #35

Closed
michalbiarda opened this issue Jul 18, 2022 · 0 comments
Closed

Smart anonymization is not using all seed records #35

michalbiarda opened this issue Jul 18, 2022 · 0 comments
Assignees
Labels
Milestone

Comments

@michalbiarda
Copy link
Contributor

Only 13 out of 26 records are used.

See: \Driver\Engines\MySql\Transformation\Anonymize::queryGeneral

Issue:

return "(SELECT ${table}.${type} FROM ${table} WHERE ${table}.id = "
            . "(SELECT 1 + MOD(ORD(MD5(CONCAT(\"${salt}\", ${mainTable}.${columnName}))), ${count})) LIMIT 1)";

ORD(MD5(...)) is producing too little amount of numbers.

@michalbiarda michalbiarda added this to the 4.0.0 milestone Jul 18, 2022
@michalbiarda michalbiarda self-assigned this Jul 18, 2022
@michalbiarda michalbiarda moved this to Todo in Driver Jul 18, 2022
@michalbiarda michalbiarda moved this from Todo to In Progress in Driver Jul 18, 2022
michalbiarda added a commit that referenced this issue Jul 18, 2022
JosephMaxwell pushed a commit that referenced this issue Jul 18, 2022
@michalbiarda michalbiarda moved this from In Progress to Done in Driver Jul 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Done
Development

No branches or pull requests

1 participant