Bulk Insert Bug

Kevin Feasel



Cody Konior has uncovered a bug in SQL Server 2016 RTM pertaining to bulk insertion:

The bug itself is triggered by a combination of > 2000 lines of data and a lot of fields; I’ve been able to reproduce it with 2189 lines and 130 delimiters as an example which you can download here.

Here’s hoping CU1 will have that fixed.

Related Posts

Love Your Bugs

Allison Kaptur has an appreciation for strange bugs: I love this bug because it shows that bitflips are a real thing that can happen, not just a theoretical concern. In fact, there are some domains where they’re more common than others. One such domain is if you’re getting requests from users with low-end or old […]

Read More

Locale Problems With SSAS

Koen Verbeeck diagnoses an awful Analysis Services error: This really didn’t make any sense. However, in one of the Discover Begin/End events, the same number appeared again: 8192 (this time explicitly marked as locale identifier). Hmmm, I had problems with weird locales before. I dug into my system, and yes, the English (Belgium) locale was lingering around. I removed […]

Read More


June 2016
« May Jul »