[DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)"

[AmineDE]

Hi All,

i got the error below using a compute instance with any of the runtime but not with sql warehouse xsmall. How could we explain it ?

Runtime Error in model sics_business_recon_unpivoted (models\Engineering\Business\sics_business_recon_unpivoted.sql)
[DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)" due to data type mismatch: Input to `coalesce` should all be the same type, but it's ("STRING" or "BOOLEAN"). SQLSTATE: 09; line 1346 pos 21

[SparkJun]

can you try to run this on DBSQL and see if that errors out: coalesce(CAST(VALUE AS BOOLEAN), false)? 
What's the DBR version for your cluster? 

[AmineDE]

• on db sql coalesce(CAST(VALUE AS BOOLEAN), false) is working without errors
• DBR tested are 13.3 to 16, for any of them it is not working.