🐛 Bug Report: Relationships don't cascade delete properly with 2 relationships

[Walrusking16]

👟 Reproduction steps

Create three collections

• The first collection has a relationship with collection two using cascade delete and one to many
• The second collection has a relationship with collection three using cascade delete and one to many
• Third collection attributes don't matter

Roadmap

• Categories: Relationship on roadmap
  • Tasks: Relationship on categories

Create some random documents for each of the collections.

Delete a document from the first collection.

👍 Expected behavior

Deleting a document from the first collection will cause categories and tasks to be deleted

👎 Actual Behavior

Only the roadmap and categories are deleted. Tasks remain undeleted.

🎲 Appwrite version

Version 1.3.x

💻 Operating system

Windows

🧱 Your Environment

Node, 1.3.7

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[joeyouss]

Hi
Thank you for reporting this. We have started looking into this and we will keep you updated.

[abnegate]

Hi @Walrusking16 this is fixed and will be released in the next version 👍

[joeyouss]

Adding the PR here: utopia-php/database#269

[abnegate]

Hi @Walrusking16 are you able to confirm if this issue is resolved for you in the latest version 1.4.2?

[abnegate]

Closing as tested fixed in 1.4.2