NocoBase Bug: Filtered Bulk Updates Ignore Conditions, Risk Data Corruption
A code-level investigation into NocoBase 2.2.7 has revealed that bulk update operations do not carry filter conditions into the final SQL UPDATE statement. Instead, the platform first selects matching rows using the filter, then updates those rows by primary key alone — meaning rows that no longer meet the original condition at write time still get updated. The flaw was first reported on the official NocoBase forum on September 4th, with staff acknowledging they were investigating but no fix issued since. Testing on PostgreSQL 16 confirmed the behavior, with SQL logs showing the WHERE clause in the UPDATE containing only primary keys rather than the original filter. The vulnerability is rooted in the repository.ts update method, affects both available code paths, and poses a concurrency risk where stale or changed rows can be incorrectly overwritten.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in