Minimal testcase:
--disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings
CREATE TABLE t1 (a VARCHAR(50));
SELECT a FROM t1 WHERE CAST(a as binary)=x'62736D697468' AND CAST(a AS BINARY)=x'65736D697468';
DROP TABLE t1;
Minimal testcase:
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a VARCHAR(50));
SELECT a FROM t1 WHERE CAST(a as binary) =x'62736D697468 ' AND CAST(a AS BINARY) =x'65736D697468 ';
DROP TABLE t1;