Is this a Bug or intended behaviour?

Neither, really. It's inevitable behavior based on the database layout, and would require a lot of work to change. Write it up as a feature request, but it won't be high priority.