I am reminded of the time, back deep in the past of MySQL, that someone complained about MySQL not providing locks. The development replies amounted to "But it is FAST!" The reply was "But the results are often wrong" and the developers again "But it is FAST!"
Acceptable software, particularly in the class of databases, is obligated to tell you that it didn't complete your request. This is not an option.