[Tables] deleteOne deletes multiple rows if passing inequality on clustering column

[hemidactylus]

Table:

CREATE TABLE default_keyspace.x (
    a int,
    b int,
    PRIMARY KEY (a, b)
) WITH CLUSTERING ORDER BY (b ASC)

Before deleteOne:

$> select * from x;

 a  | b
----+---
 10 | 1
 10 | 2
 10 | 3
 10 | 4

(4 rows)

deleteOne:

{
    "deleteOne": {
        "filter": {
            "a": 10,
            "b": {"$gt": 1}
        }
    }
}

After deleteOne:

$> select * from x;

 a  | b
----+---
 10 | 1

(1 rows)

Suggestion: restrict the filters to prevent any kind of condition that is not an equality on the whole primary key.

[amorton]

similar to #1758
as in there, i think we should retest after #1729

[Yuqi-Du]

This one has been fixed,
now in order to avoid impacting multiple rows for deleteOne and updateOne commands, we set the $eq as a restriction in filter.

{
    "errors": [
        {
            "message": "The Filtering using the non `$eq` filter operations can select more than one row, and so cannot be used with the `updateOne` and `deleteOne` commands as they can only modify one row.\n\nThe command used an invalid filter on the columns: b.\n\nResend the command only using `$eq` filters.",
            "scope": "FILTER",
            "errorCode": "UNSUPPORTED_FILTER_FOR_UPDATE_ONE_DELETE_ONE",
            "id": "583dd66e-be6b-496a-8de3-c4194344c7c8",
            "family": "REQUEST",
            "title": "updateOne and deleteOne commands only support filtering using $eq"
        }
    ]
}