relationships are very unstable

Hi, im encountering a number of problems especially while deleting the documents.. it keeps throwing server error

appwrite logs

[Error] Timestamp: 2023-11-12T16:24:46+00:00
[Error] Method: DELETE
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: PDOException
[Error] Message: Unknown column 'castType' in 'field list'
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 62

@Jake Can you please take a look here?

Do you know what's the relationship that failed or are you able to replicate the issue by following some steps?

Details including the attributes and what data there is would also help

i have created a demo project in my appwrite cloud

can you access that and check it?

basically when there are nested relations the delete is not working

basically i have three collections

1. demo 3 is two way one to many relationship with demo 2
2. demo 2 is two way many to many relationship with demo 1

Do you have set delete behaviour?

Yes its NULL

no we cannot

and what exact steps are you taking? please, be detailed so we can reproduce

@Steven its just this and create documents in all three collections

and try to delete a document from the demo3 collection

I added your problem here: https://github.com/appwrite/appwrite/issues/5850#issuecomment-1808737829

but when i try to delete it form the web sdk it works...

in my tests, it depends on what's set for the documents and which document you're deleting first