This is the reason I think pleasant lies are always a better option than honesty, which I'm convinced is not the best policy by a long shot. "Ignorance is bliss," as the saying goes. If I'm in a hopeless situation, and my ignorance of the situation I'm in depends on someone lying to me, I very much hope they indulge me and lie to me. On the other hand, I have friends who, upon being asked, "Would you rather believe in a lie and be happy or know the truth and be miserable?" actually answered truth. To me, that seems crazy. For me, happiness is the highest goal at all points, more so than truth. I mean, imagine I was in a loving, committed relationship and my partner cheated on me once, by mistake, and was never going to do it again. Some people would want to know because, they say, a successful relationship must be based on honesty, but I would rather never know. Or, in a more dramatic situation, imagine I was on a sinking ship, and no help was forthcoming. I would rather die believing that help was on its way and that everything would be okay than ever having to accept the truth, that I was about to die.
This is not a debate on which we can come to a conclusion, but it's something to think about.