I try the following statements on MariaDB-10.8.2:
The DELETE statement deleted the first row, and a warning was generated.
I try a UPDATE statement, which share the same where clause with the above DELETE statement, as follows:
The UPDATE statement failed and generated an error.
I think the data truncation of value 'a' should also cause this DELETE statement errors instead of a warning. Because UPDATE and DELETE are both data-change statements.