Why is this simple numerical operation not precise?

al_joe
Contributor

I was experimenting with beginner tutorial and saw this strange output ...

Why is this so ? And why is the behavior not consistent for ALL rows updated by the same statement?

8.8 - 1 = 7.800000000000001

See screenshot ...

20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers