Hash row validation fails for MySQL on field that is successfully validated with --comparison-fields

[helensilva14]

[Problem externally pointed out by an user]

When I use the --comparison-fields flag on a single date field. The comparison is successful. When I use the --hash flag on the same single field, it fails. I think this is because the big query side of things is doing a format but not doing the same format on the source. Is there a workaround for this?

[helensilva14]

On timestamp columns, we do a strftime() to make sure the formatting between source/target match. I think this isn't registered for MySQL yet.

We'll need to add this to third_party/ibis/ibis_addon/operations.py to register the function:

MySQLExprTranslator._registry[ops.Strftime] = fixed_arity(sa.func.date_format, 2)