It's actually kind of rare that cops lose their jobs for not upholding the law. Check out the front page of reddit.com/r/bad_cop_no_dounut, and you'll get a sampling of how cops regularly brutalize the law and the people they're meant to serve.