Bit hash calling the lack of an automatic transformation from LEFT to LIKE a bug!

Are you sure it is a provably safe transformation in absolutely all cases?