Unusable key notes do not get reported for IN on data types mismatch

SET @@note_verbosity='all';

CREATE OR REPLACE TABLE t1 (f CHAR(8) CHARACTER SET latin1, KEY(f));

INSERT INTO t1 VALUES (''),('');

SELECT * FROM t1 WHERE f IN ('a',3);

SHOW WARNINGS;

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

| Level   | Code | Message                               |

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

| Warning | 1292 | Truncated incorrect DECIMAL value: '' |

| Warning | 1292 | Truncated incorrect DECIMAL value: '' |

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

SELECT * FROM t1 WHERE f IN ('a',_latin1'b' COLLATE latin1_german2_ci);

SHOW WARNINGS;

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

| Level   | Code | Message                                                                                    |

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

| Note    | 1105 | Cannot use key `f` part[0] for lookup: `test`.`t1`.`f` of type `char` >= "3" of type `int` |

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

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

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

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

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