core icon indicating copy to clipboard operation
core copied to clipboard

[Do not merge] Unique constraint for duplicate child shares

Open IljaN opened this issue 1 year ago • 3 comments

For Debugging

CREATE UNIQUE INDEX child_share_unique ON oc_share (share_with, parent) WHERE parent IS NOT NULL AND share_type = 2

IljaN avatar May 07 '24 14:05 IljaN

Thanks for opening this pull request! The maintainers of this repository would appreciate it if you would create a changelog item based on your changes.

update-docs[bot] avatar May 07 '24 14:05 update-docs[bot]

  • [ ] Build equivalent index for MariaDB/MySQL as most of the acceptance tests run with those.

IljaN avatar May 07 '24 16:05 IljaN

  • [x] Analyze if creating an index on the "parent" column makes sense as the unique-index uses a WHERE. Will this improve INSERT performance? Are indexes used by other indexes?

IljaN avatar May 08 '24 12:05 IljaN

cleaning up - I think this is no longer of anybody's interest

DeepDiver1975 avatar Nov 19 '24 07:11 DeepDiver1975