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.

Sign up for GitHub

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

Jump to bottom

Remove uses of ON DUPLICATE KEY IGNORE #4288

Open
at055612 opened this issue May 21, 2024 · 0 comments
Open

Remove uses of ON DUPLICATE KEY IGNORE #4288

at055612 opened this issue May 21, 2024 · 0 comments
Labels
bug
Milestone
v7.5

Comments

@at055612
Copy link
Member

ON DEPLICATE KEY IGNORE or onDuplicateKeyIgnore in the SQL makes it ignore all errors. For case where we are happy to ignore duplicate keys change it to use stroom.db.util.JooqUtil#tryCreate() which does it in a less crude way.

There are ~22 uses in the code, so we should remove them and replace them with something better.
@at055612 at055612 added the bug label May 21, 2024
@at055612 at055612 added this to the v7.5 milestone May 21, 2024
@stroomdev10 stroomdev10 changed the title Remove uses of ON DEPLICATE KEY IGNORE Remove uses of ON DUPLICATE KEY IGNORE Jun 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
v7.5
Development

No branches or pull requests
1 participant
@at055612