ibis/tests/all/test_string.py::test_string[MSSQL-contains] FAILED [ 54%]. ops.Contains is already marked as unsupported
I noticed that the existing Hash ValueOp doesn't match the behavior of other databases like BigQuery (ibis-project/ibis#2310) or Postgres (https://ibis-project.org/docs/user_guide/extending_elementwise_expr.html)
Hash takes any type and outputs an int64, whereas BigQuery and Postgres take string/bytes and output string/bytes
I'm wondering if these should try to be reconciled? Or maybe we could add a HashBytes operator?