Closed
Description
A Delete Query on matching cells.
Query Request:
A delete command with where_clause some like Select SQL syntax without incompatible Flags.
delete where [Columns-Intervals] [Flags(global-scope)];Plus an additional supporting option with select command having a token DELETE_MATCHING in Flags-syntax but without No RETURN_DELETED option.
and
Interval Specifications applied by Specs::Flags::options set with DELETE_MATCHING bit and RETURN_DELETED bit to determine type of response (deleted Cells or only the Count).
Query Response:
returning the Deleted Cells or only the number of Deleted Cells.
The Result:
Instead, the possible option of selecting all and updating, (1)select + (2)apply DELETE flag + (3)send cells for update.
Let the Delete cells Action possible in one client-request.