|
I agree with your reply. UPDATE and DELETE should have the same impact.
By the way, I reproduced this case in MySQL, but the result is different from MariaDB. Please see:
mysql> UPDATE t SET c2 = 'test' WHERE c1;
|
Query OK, 0 rows affected (0.00 sec)
|
Rows matched: 0 Changed: 0 Warnings: 0
|
|
mysql> SELECT * FROM t WHERE c1;
|
Empty set (0.00 sec)
|
|
mysql> DELETE FROM t WHERE c1;
|
Query OK, 0 rows affected (0.00 sec)
|
In MySQL, the warning and error do not happen in any statements, which simply do not affect any data.
|