I don't know if whether I'm doing it wrong or it just doesn't work, but my cannon tube (see attached file) doesn't want to limit the local space. It just limits the world space. I reproduced it with a very simple setup (see second attached file). It seems like the local space wont pass correctly through an constraint. Hope you'll fix it soon.