Hello,
However, it could be also possible to create routines that inspect the source code in order to detect bad data manipulations or error-prone statements because, sometimes people can miss some problems or can forget to test. No ?
Not likely. Code to do this would need to even be "smarter" than the compiler. How would "bad data manipulation" be defined?
sometimes people can miss some problems or can forget to test.
Not on a well-managed project. People do not have the chance "to forget". The test plan is formalized detailing every business rule and the ways each will be tested.
(in fact, routines could automate what you do manually)
Large, sophisticated testing
is often automated. This handles both volume and testing consistency.