Thoughts Caused by a bug

Today, we found a bug that has been hidden for a long time. Unfortunately, it was discovered by the customer.

CheckCodeThe SQL query statement is incorrect. The associated table is incorrect. The result is that data can be displayed on the page, but the data is inaccurate under some conditions.

No error is reported for such pages, but data error bugs are not uncommon in development. Especially if the data is correct in some cases and is incorrect in other cases, it is hard to find out if the test cases are not covered enough.

It's just a bit unwilling, because the developers of this Code are very experienced and have enough business knowledge, and they have invested a lot of people and time to perform tests. This bug is still not avoided.

The reason seems to be that the business is complex and the bug is hard to avoid. After further research, check whether the developer's sense of responsibility, development process, and check whether there are sufficient checks (including code review and testing) problems may exist.

Remind yourself that you need to pay attention to the following two points for quality software:

Developers must be responsible and enthusiastic about writing high-quality code.

Spend enough time checking the business logic and corresponding code (white-box testing ).

(Of course, high-quality software is not enough to achieve the above two points)