md5 function does not recognize binary keyword

[nicktobey]

Steps to reproduce:

# create a random binary file
head -c 100 </dev/urandom >myfile
dolt sql -q "select md5(binary load_file('./myfile'));"

Expected output: the md5 hash of the file
Actual output: invalid string for charset utf8mb4: '[bytes]'

[nicktobey]

I can't compare to MySQL because I can't seem to get load_file to work on my MySQL server.

I believe the binary keyword is necessary in MySQL because md5 expects a string, and this prevents the engine from attempting to convert the file into a string with the default collation (which will likely fail, as we see above.)