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);
HEX(a)
8000000000000000
8000000000000001
8000000000000002
8000000000000300
8000000000000400
8000000000000401
SELECT HEX(a) FROM t2 WHERE a IN
(0x8000000000000000,
0x8000000000000400,
0x8000000000000401,
0x000000000000002A);
HEX(a)
8000000000000000
8000000000000400
8000000000000401
SELECT HEX(a) FROM t2 WHERE a IN
( CAST(0x8000000000000000 AS UNSIGNED),
CAST(0x8000000000000400 AS UNSIGNED),
CAST(0x8000000000000401 AS UNSIGNED),
42);
HEX(a)
8000000000000000
8000000000000400
8000000000000401
SELECT HEX(a) FROM t2 WHERE HEX(a) IN
('8000000000000000',
'8000000000000400',
'8000000000000401',
'000000000000002A');
HEX(a)
8000000000000000
8000000000000400
8000000000000401