DELETE returns ROW_NUMBER=1 for every row upon ER_TRUNCATED_WRONG_VALUE

create or replace table t (a varchar(8));

insert into t values ('val1'),('val2'),('100'),('val4');

delete from t where a = 100;

show warnings;

get diagnostics condition 3 @n = row_number;

select @n;

+---------+------+------------------------------------------+

| Level   | Code | Message                                  |

+---------+------+------------------------------------------+

| Warning | 1292 | Truncated incorrect DOUBLE value: 'val1' |

| Warning | 1292 | Truncated incorrect DOUBLE value: 'val2' |

| Warning | 1292 | Truncated incorrect DOUBLE value: 'val4' |

+---------+------+------------------------------------------+

3 rows in set (0.000 sec)

MariaDB [test]> get diagnostics condition 3 @n = row_number;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> select @n;

+------+

| @n   |

+------+

|    1 |

+------+

1 row in set (0.000 sec)

MariaDB [test]> delete from t where a = 100 order by a;

Query OK, 0 rows affected, 3 warnings (0.001 sec)

MariaDB [test]> get diagnostics condition 3 @n = row_number;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> select @n;

+------+

| @n   |

+------+

|    0 |

+------+

1 row in set (0.001 sec)