error updating table with impossible where clause

[zachmu]

When an update statement has a where clause that is always false, the update statement returns an error "table doesn't support UPDATE"

tablescan_order> desc t1;
+-------+--------+------+-----+---------+-------+
| Field | Type   | Null | Key | Default | Extra |
+-------+--------+------+-----+---------+-------+
| a     | bigint | NO   | PRI | NULL    |       |
| b     | int    | YES  |     | NULL    |       |
+-------+--------+------+-----+---------+-------+
2 rows in set (0.01 sec)

tablescan_order> update t1 set b = b+1 where (a = 100 and 0);
table doesn't support UPDATE
tablescan_order> update t1 set b = b+1 where (a = 100);
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
tablescan_order> update t1 set b = b+1 where (0);
table doesn't support _UPDATE_

Expected behavior: updates zero rows with no error

[jycor]

Fix is merged into main