I agree with Lieutenant Jean Rasczak: "The only good bug is a dead bug"...
This one was in the PixVillage database engine core and was teasing me for more than one month ! I had not detected it despite the 97% code coverage and the eavy unit tests. Of course it appeared in a tested condition that gave a bad result in a special data case. What can you do against that ?
Hopefully, once this kind of bug is spotted it's already almost dead...
Skup