Field contains a many-to-many link to data of its own table, some data batch deletion returns 400 Error

[emengweb]

Describe the bug
The field contains a many-to-many link to data of its own table, and the option "Create symmetric related fields in the related table" is turned on. Only a single deletion operation can be performed, and batch deletion cannot be performed that the server will returns 400 error:

字段包含一个多对多的link关联到自身表格其他行的数据，且开启选项“在关联表中创建对称的关联字段”，只能进行单个删除操作，无法批量删除。
服务端请求返回400错误：

{
    "message": "Cannot set duplicate recordId: recTXXVd1zIrOXXpzUo in the same cell",
    "status": 400,
    "code": "validation_error"
}

To Reproduce
Steps to reproduce the behavior:

When creating the link field, check the first option "Create symmetric related fields in the related table", and then import about 200 related data through the API. Some fields cannot be deleted in batches, and the server reports an error 400, but some data can It was multi-selected and deleted for unknown reasons.

创建link字段时，勾选第一个选项“在关联表中创建对称的关联字段”，再通过api导入200条左右关联数据，有部分字段无法被批量删除，服务端报错400，但部分数据可以被多选并删除，原因不明。

Expected behavior
Regardless of whether it contains a link type, data can be multi-selected and deleted in batches.

无论是否包含link类型，数据可以被多选并批量删除。

** Client (please complete the following information):**

• OS: Mac
• Browser Chrome
• Version 124.0

Platform (Please tell us which deployment version you are using)
docker-standalone v1.2.0-beta

Additional context
Mitigation measures: Cancel the links between associated items and associated items in batches or manually through API, and then perform batch deletion operations.

缓解措施：通过API批量或手动取消关联项与被关联项的link，之后可以进行批量删除操作。

[tea-artist]

Does "delete" refer to deleting records or clearing cells as you mentioned?
I redid the steps as you described but it didn't happen.

We may need more information to find the problem.
What are the data structures you write to the link field, and what are the call parameters?
Is there only one Link field in the entire table?
Was the relationship of the Link field accurately set at creation, or was it modified later?

[emengweb]

wen i resetting cell values of link cell, try delete multiple data, error wasn't display, and operation could completely. I guess error related with this type option "Create symmetric related fields in the related table", unchecked that option at create link type row, then try with same data and delete operate, error not shows. if you need example data of this, i could send it. Bieber ***@***.***> 于 2024年5月30日周四 23:47写道：

…

Did you get an error when deleting records or when resetting cell values to empty? I redid the steps as you described but it didn't happen. We may need more information to find the problem. What are the data structures you write to the link field, and what are the call parameters? Is there only one Link field in the entire table? Whether the link field was created with the exact relationship specified or modified? — Reply to this email directly, view it on GitHub <#635 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHQDBK7G3V22ZF4M4MKNJ4DZE5C2DAVCNFSM6AAAAABIQG6AT6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBQGAYTIMRWG4> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[tea-artist]

You can send the data and building process to my email([email protected]) and we will check it further

[emengweb]

Already sent. Bieber ***@***.***> 于2024年5月31日周五 10:49写道：

…

You can send the data and building process to my ***@***.***) and we will check it further — Reply to this email directly, view it on GitHub <#635 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHQDBKYQBGUGVDLOGMEEO6LZE7QKPAVCNFSM6AAAAABIQG6AT6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBRGE2DENBRHE> . You are receiving this because you authored the thread.Message ID: ***@***.***>