Canada, too. Anecdotally, I knew a guy from my reserve unit caught TWICE. Once, sexually touching his friend's 9 year old daughter,then later, while awaiting trial, answered a bogus ad for an underage hooker (it was a police sting).

He did time, appealed and lost. He claimed PTSD from serving in Afghanistan, but he wasn't even there with the military, he went as a civilian airport security guard, watching CCTV cameras for 9 months, never ever had a bullet fired towards him.