MySQL 8.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.4.3

CREATE TABLE apple (weight numeric(4, 1));
INSERT INTO apple (weight) VALUES ('1.01');
SHOW WARNINGS;

Level
Code
Message

Note
1265
Data truncated for column 'weight' at row 1

SELECT * FROM apple;

weight

1.0

SELECT * FROM apple WHERE weight = '1.0';

weight

1.0