#716 "Truncated incorrect DOUBLE value" with integer and + symbol

[Jacques M]

Hey,
I entered a number followed by "+" by mistake (keypad before pressing enter) as a SELECT filter, in a int field.
The "select" worked like there was no =, maybe it considered it as "number+0"
Anyway, I didn't notice, but when I wanted to edit a field and validate, the WHERE condition in the update used the + and then shouted "Truncated incorrect DOUBLE value".
If think the filed needs to be cleaned if one stupid user (me ;)) enters "12345+" as an int.

see the attached picture

running adminer 4.7.3 on standard debian Buster with mariadb

[Jacques M]

on the picture : you see the selection criteria with a +
on the bottom right, the field Im' trying to edit. When I validate, it shouts the error msg.
The generated UPDATE request contains :
WHERE id_coureur = '179194+'
where id_coureur is a int(11)

[Jakub Vrána]

The error message says exactly what you need to know - that you entered a wrong value.