🐛 Bug: Undefined binding(s) detected when compiling SELECT when Link Records using API

[ramisedhom]

Please confirm if bug report does NOT exist already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

1. Create 2 tables
2. Link the 2 tables with many-to-many relation
3. Use API (Link Records)[https://data-apis-v2.nocodb.com/#tag/Table-Records/operation/db-data-table-row-nested-link] request to link 1 record in table1 to record in table2.

curl --location --request POST '/api/v2/tables/table1/links/linked_field_id/records/1' \
--data-raw '[{"id":1}]'

3. Error:

{
    "msg": "Undefined binding(s) detected when compiling SELECT. Undefined column(s): [nc_os6a___Sheets.id] query: select `nc_os6a___Sheets`.`id`, `nc_os6a___nc_m2m_8_wpfg08ik`.`table1_id` from `nc_os6a___Sheets` left join `nc_os6a___nc_m2m_8_wpfg08ik` on `nc_os6a___nc_m2m_8_wpfg08ik`.`table2_id` = `nc_os6a___Sheets`.`id` and `nc_os6a___nc_m2m_8_wpfg08ik`.`table1_id` = ? where `nc_os6a___Sheets`.`id` in (?)"
}

Desired Behavior

The record in table1 is linked to desired record in table2

Project Details

Node: v20.12.1
Arch: x64
Platform: linux
Docker: true
RootDB: sqlite3
PackageVersion: 0.207.3

Attachments

No response