# Modified (simplified) testcase derived from func_in.test CREATE TABLE t2 (a BIGINT UNSIGNED); insert into t2 values (0x8000000000000000), (0x8000000000000001), (0x8000000000000002), (0x8000000000000300), (0x8000000000000400), (0x8000000000000401), (0x8000000000004001), (0x8000000000040001), (0x8000000000400001), (0x8000000004000001), (0x8000000040000001), (0x8000000400000001), (0x8000004000000001), (0x8000040000000001); SELECT HEX(a) FROM t2 WHERE a IN (0x8000000000000000, 0x8000000000000400, 0x8000000000000401, 42); # Some similar statements for comparison SELECT HEX(a) FROM t2 WHERE a IN (0x8000000000000000, 0x8000000000000400, 0x8000000000000401, 0x000000000000002A); SELECT HEX(a) FROM t2 WHERE a IN ( CAST(0x8000000000000000 AS UNSIGNED), CAST(0x8000000000000400 AS UNSIGNED), CAST(0x8000000000000401 AS UNSIGNED), 42); SELECT HEX(a) FROM t2 WHERE HEX(a) IN ('8000000000000000', '8000000000000400', '8000000000000401', '000000000000002A');