When a crooked detective rolled over at a major royal commission into police corruption a decade ago, it sent shockwaves through every police force in the country.