Bug: TransactWriteItems DynamoDB - SET & REMOVE moto passes with overlapping document paths. Fails with real operations

[armanjal]

Hey,
I'm having issues with testing integrations with DynamoDb as it was passing locally using moto. I understand the required changes but would be good to see this in moto as well, please?

The error: An error occurred (ValidationException) when calling the TransactWriteItems operation: Invalid UpdateExpression: Two document paths overlap with each other; must remove or rewrite one of these paths; path one: [someExtraThing], path two: [someExtraThing, nested, hello]

Thanks!

moto version == 5.0.28
Python 3.12

[bblommers]

Hi @armanjal, we implemented this recently for the query operation, so it should hopefully not be too much work to also add this to transact_write_items.

PR's are always welcome, if you want to have a stab at this yourself!