Hi @swanandp, I ran into this in my project where I had some buggy duplicate positions. I wondered if we should perhaps detect and fix duplicates within scopes? I think it'd be a good idea.
Do you have any ideas on how to go about it? There doesn't seem to be an easy SQL way to do it. Perhaps this:
[ ] Detect duplicates within scope, preferably with a single SQL call while we're inserting a new record, or perhaps when incrementing/decrementing values?
[ ] Kick off a rebalancing (probably the wrong term)
Hi @swanandp, I ran into this in my project where I had some buggy duplicate positions. I wondered if we should perhaps detect and fix duplicates within scopes? I think it'd be a good idea.
Do you have any ideas on how to go about it? There doesn't seem to be an easy SQL way to do it. Perhaps this: