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.

Nguồn: https://thedailywtf.com/articles/floating-along. 8 Sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.