https://community.databricks.com/t5/data-engineering/why-is-this-simple-numerical-operation-not-precise/m-p/33334#M24348 <P>I was experimenting with beginner tutorial and saw this strange output ...</P><P></P><P>Why is this so ? And why is the behavior not consistent for ALL rows updated by the same statement?</P><PRE><CODE>8.8 - 1 = 7.800000000000001</CODE></PRE><P>See screenshot ...</P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1563i252C03C5C49F3F6F/image-size/large?v=v2&amp;px=999" role="button" title="20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers" alt="20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers" /></span></P> Sat, 27 Aug 2022 12:49:56 GMT al_joe 2022-08-27T12:49:56Z https://community.databricks.com/t5/data-engineering/why-is-this-simple-numerical-operation-not-precise/m-p/33334#M24348 <P>I was experimenting with beginner tutorial and saw this strange output ...</P><P></P><P>Why is this so ? And why is the behavior not consistent for ALL rows updated by the same statement?</P><PRE><CODE>8.8 - 1 = 7.800000000000001</CODE></PRE><P>See screenshot ...</P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1563i252C03C5C49F3F6F/image-size/large?v=v2&amp;px=999" role="button" title="20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers" alt="20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers" /></span></P> Sat, 27 Aug 2022 12:49:56 GMT https://community.databricks.com/t5/data-engineering/why-is-this-simple-numerical-operation-not-precise/m-p/33334#M24348 al_joe 2022-08-27T12:49:56Z