Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.9.4
-
None
-
mariadb docker
Description
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