Issue description

mpath is not updated correctly if parentId was soft deleted. Query is unable to "find" parentId even though its path is required to update children's path

Expected Behavior

If Parent "1" has children "2" and "3" (mpaths 1.2 and 1.3), but then Parent "1" is soft deleted and these children are now updated to have parentId = "4" (mpaths 4.2 and 4.3 respectively), their mpath should update correctly from 1.2 and 1.3 to 4.2 and 4.3.

Actual Behavior

Since Parent "1" was soft deleted, the queryBuilder that fetches the mpath from the parent is unable to find it, hence, it is unable to update the childrens' mpath accordingly, leading to a missmatch in the mpath column and the real path

Steps to reproduce

Test scenario will be provided within pull request to solve issue

My Environment

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, and I know how to start.