The use case you stated must work and could be an issue in the way you are defining the rule or could be potential product issue. Please do contact technical Support for the next steps.
Alternatively if you could share exact details/screenshots on what you are trying to define; someone could attempt to provide an answer.
As far as the data-model is concerned what is published is the latest. However from your explanation it sounded like you are attempting to create some sort of database triggers or other updates to work around. As a note of caution; do note that such attempts may lead to an unstable system and may not be supported.