Str_to_date() returns binary instead of DATETIME

For some reason str_to_date() function returns a BINARY column instead of DATETIME. See screenshot below

If I explicitly convert the function’s result to DATETIME - it correctly returns DATETIME. See screenshot below

Could anyone please explain this behaviour, maybe I’m missing something?

Hello, MemSQL employee here. This has been tentatively identified as a bug in MemSQL. It will be fixed in the upcoming 7.0 release. Thanks for reporting!