Divide by Zero error in Materialized Views in Azure Synapse Dedicated SQL Pool

I have a materialized view in Azure synapse Analytics dedicated sql pool which has a calculate column X / denominator. When **I select the view select * from myview** it does not give me divide by zero error. But when I select Select * from myview where denominator = 0 I get divide by zero error When I use **select * from myview order by denominator** I am not getting divide by zero error. How can this be explained. I know the Arithabort setting but not sure how to check the value set to this in Synapse dedicated SQL Pool. Any help would be appreciated.