Data Science Wire

Arithmetic Overflow errors coming out of the blue

Reddit r/MicrosoftFabric4w4 min read

I have an update statement that has been running daily for nearly 2 years now, which yesterday started failing with arithmetic overflow. These are NOT data related. The query is of the form: UPDATE src SET src.field1 = isnull(t1.key, -1), src.field2 = isnull(t2.key, -1), src.field3 = isnull(t3.key, -1) ... src.field7 = isnull(t7.key, -1) FROM myTable src left join table1 t1 on src.t1Key = t1.key ... left join table7 t7 on src.t7Key = t7.key This fails with an Arithmetic Overflow error. The thing is, if I comment out ONE of the SET statements (i.e. any one of them, it doesn't matter) the UPDATE

Read the full story at Reddit r/MicrosoftFabric

More in Data Engineering