Floating Along

A developer recounts migrating customer document metadata from on-premises SharePoint to SQL Server using PowerShell and SqlBulkCopy. A subtle naming mismatch between .NET's 'float' (single-precision) and SQL Server's 'float' (double-precision) type caused large customer numbers to lose precision during the copy, silently corrupting the last few digits of some records. The bug slipped past testing and was only caught during the full data load, requiring a post-hoc patch of affected numbers.

Source: https://thedailywtf.com/articles/floating-along. 8 Sync News only summarizes and links out; content copyright belongs to the authors and original sources.