Try the following in SQL shell:
select '\\\\' like '%\\%';
It returned false, which is wrong.
cc: Yin Huai Josh Rosen
A false-negative considered previously:
select '\\\\' rlike '.*\\\\\\\\.*';
It returned true, which is correct if we assume that the pattern is treated as a Java string but not raw string.