JPA Bug: Metadata not deleting when state updated to DELETED

[dmvolod]

The META record not deleting/updating when STATE is updated to ArtifactState.DELETED via service.updateArtifactState(artifactId, toUpdateState(ArtifactState.DELETED));
In this case, the classic max(version) query implemented in #780 doesn't work
We need to define, that META should be also deleted together with ARTIFACTS table or META can have orphan records and in this case query should be rewritten
@EricWittmann , @alesj wdyt about it? Is this the same behavior for Infinispan/InMemory/Kafka storage?