Sometimes query returns duplicated records after commiting a transaction that contains VersionManager.checkin() call when using a real JTA transaction manager

        @Transactional
        public void createMultipleNodes(JCRSessionHolder sessionHolder) throws ItemExistsException, PathNotFoundException, NoSuchNodeTypeException, LockException, VersionException, ConstraintViolationException, RepositoryException {
            for (int i = 0; i < 10; ++i) {
                createNewNode("Test" + i, sessionHolder);
            }
        }

        private void createNewNode(String name, JCRSessionHolder sessionHolder) throws ItemExistsException, PathNotFoundException, NoSuchNodeTypeException, LockException, VersionException, ConstraintViolationException, RepositoryException {
            VersionManager vm = sessionHolder.getSession().getWorkspace().getVersionManager();
            Node node = sessionHolder.getSession().getRootNode()
                    .addNode(name, "pd:product");
            node.addMixin("mix:versionable");
            node.setProperty("name", "lalalal");
            node.setProperty("code", "lalalal");
            
            createChildNode(node);
            
            sessionHolder.getSession().save();
            vm.checkin(node.getPath());
            vm.checkout(node.getPath());
        }
        
        private void createChildNode(Node parentNode) throws ItemExistsException, PathNotFoundException, VersionException, ConstraintViolationException, LockException, RepositoryException {
            doCreateChildNode(parentNode, 1);
        }
        
        private void doCreateChildNode(Node parentNode, int level) throws ItemExistsException, PathNotFoundException, VersionException, ConstraintViolationException, LockException, RepositoryException {
            if (level == 5)
                return;
            
            for (int i = 0; i < 1; ++i) {
                Node child = parentNode.addNode("child-" + level + "-" + i);
                for (int j = 0; j < 10; ++j)
                    child.setProperty("p" + j, "property" + j);
                
                doCreateChildNode(child, level + 1);
            }
        }