mimir
mimir copied to clipboard
CAST behavior inconsistent between Mimir and Spark
The following query behaves differently depending on whether CAST
is evaluated in Mimir or in Spark.
SELECT CAST('.' AS int)
In Mimir it returns NULL
, while in Spark it returns 0
.
- [ ] Short-term fix: Make Mimir cast
'.'
to0
. - [ ] Long-term fix: Switch over to Spark's cast operation directly.