Consider the following statements:

SELECT "1gbnn" IN (1) – expected: 0, actual: 1
SELECT '1' IN (1) – expected: 0, actual: 1
SELECT "a" IN (0); – expected: 0, actual: 1
SELECT 1 IN('1'); – expected: 0, actual: 1

for keyword IN, We expect that strings should not be converted to numeric values. however, in actual execution, string is converted to a numeric type.

database version: 10.9.4-MariaDB-1:10.9.4+maria~ubu2204