Hibernate Returns Wrong List From Cache Even Expected List is Different Than the Cached One

In the code below if I don't clear current session, just the number of girls is returned from the method even if I want to return number of all children of this parent.

It's clearly seen that parent with id 1 has three children (2 girls and 1 boy), but just the girls are returned because of the previous retrieve method which returns parents with girls only. When I clear the session to avoid returning from cache, it returns 3 as expected. Can anybody help me understand why it is like this and how can I avoid this without clearing current session?

@Service
public class ExampleServiceImpl implements ExampleService {

    @Autowired
    private ExampleRepository exampleRepository;

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    @Transactional(readOnly = true)
    public int getNumberOfChildren() {
        List<Parent> parentList = exampleRepository.retrieveParentsWithGirls();

        //sessionFactory.getCurrentSession().clear();
        Parent parent = exampleRepository.retrieveParentWithId(1);

        System.out.println(parent.getChildSet().size());
        return parent.getChildSet().size();
    }
}

Let me share all the code I have as well as database scripts to make it more clear.

Repository:

@Repository
public class ExampleRepositoryImpl implements ExampleRepository {

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    public List<Parent> retrieveParentsWithGirls() {
        CriteriaBuilder builder = sessionFactory.getCriteriaBuilder();
        CriteriaQuery<Parent> criteria = builder.createQuery(Parent.class);
        Root<Parent> parentRoot = criteria.from(Parent.class);
        Fetch<Parent, Child> fetchChildren = parentRoot.fetch("childSet", JoinType.LEFT);
        Join<Parent, Child> joinChildren = (Join<Parent, Child>) fetchChildren;
        criteria.where(builder.equal(joinChildren.get("sex"), "girl"));
        criteria.distinct(true);

        return sessionFactory.getCurrentSession().createQuery(criteria).getResultList();
    }

    @Override
    public Parent retrieveParentWithId(int id) {
        CriteriaBuilder builder = sessionFactory.getCriteriaBuilder();
        CriteriaQuery<Parent> criteria = builder.createQuery(Parent.class);
        Root<Parent> parentRoot = criteria.from(Parent.class);
        parentRoot.fetch("childSet", JoinType.LEFT);
        criteria.where(builder.equal(parentRoot.get("id"), id));

        return sessionFactory.getCurrentSession().createQuery(criteria).getSingleResult();
    }
}

Entities:

@Entity
@Table(name = "child")
public class Child {

    @Id
    @Column(name = "id", unique = true, nullable = false)
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private int id;

    @Column(name = "sex")
    private String sex;

    @JoinColumn(name = "parent_id", referencedColumnName = "id")
    @ManyToOne(fetch = FetchType.LAZY)
    private Parent parent;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Parent getParent() {
        return parent;
    }

    public void setParent(Parent parent) {
        this.parent = parent;
    }
}

@Entity
@Table(name = "parent")
public class Parent {

    @Id
    @Column(name = "id", unique = true, nullable = false)
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private int id;

    @OneToMany(fetch = FetchType.LAZY, mappedBy = "parent")
    private Set<Child> childSet;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public Set<Child> getChildSet() {
        return childSet;
    }

    public void setChildSet(Set<Child> childSet) {
        this.childSet = childSet;
    }
}

DatabaseConfiguration:

@EnableTransactionManagement
@Configuration
@Conditional(DatabaseRequiredCondition.class)
public class DatabaseConfiguration {
    @Value("${jdbc.driverClassName}")
    private String DB_DRIVER;

    @Value("${jdbc.pwd}")
    private String DB_PASSWORD;

    @Value("${jdbc.url}")
    private String DB_URL;

    @Value("${jdbc.username}")
    private String DB_USERNAME;

    @Value("${hibernate.dialect}")
    private String HIBERNATE_DIALECT;

    @Value("${hibernate.showSql}")
    private String HIBERNATE_SHOW_SQL;

    @Value("${hibernate.packagesScan}")
    private String ENTITYMANAGER_PACKAGES_TO_SCAN;

    @Value("${hibernate.tx_timeout}")
    private Integer TIMEOUT_AS_SECONDS;

    @Bean
    @Primary
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(DB_DRIVER);
        dataSource.setUrl(DB_URL);
        dataSource.setUsername(DB_USERNAME);
        dataSource.setPassword(DB_PASSWORD);

        return dataSource;
    }

    @Bean
    @Primary
    public LocalSessionFactoryBean sessionFactory() throws IOException {
        LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean();
        sessionFactoryBean.setDataSource(dataSource());
        sessionFactoryBean.setPackagesToScan(ENTITYMANAGER_PACKAGES_TO_SCAN);

        Properties hibernateProperties = new Properties();
        hibernateProperties.put("hibernate.dialect", HIBERNATE_DIALECT);
        hibernateProperties.put("hibernate.show_sql", HIBERNATE_SHOW_SQL);
        hibernateProperties.put("hibernate.format_sql", true);

        sessionFactoryBean.setHibernateProperties(hibernateProperties);

        return sessionFactoryBean;
    }


    @Bean(name="transactionManager")
    @Primary
    public HibernateTransactionManager transactionManager() throws IOException {
        HibernateTransactionManager transactionManager =
                new HibernateTransactionManager(sessionFactory().getObject());
        transactionManager.setDefaultTimeout(TIMEOUT_AS_SECONDS);
        return transactionManager;
    }
}

Scripts:

create table parent (id serial);
create table child (id serial, parent_id integer not null, sex character varying(10));
	
INSERT INTO public.parent values(default); 
INSERT INTO public.parent values(default); 
	
INSERT INTO public.child
(parent_id, sex)
VALUES(1, 'girl');

INSERT INTO public.child
(parent_id, sex)
VALUES(1, 'girl');

INSERT INTO public.child
(parent_id, sex)
VALUES(1, 'boy');

Generated Scripts When I run the code:

Hibernate: 
    select
        parent0_.id as id1_23_0_,
        childset1_.id as id1_5_1_,
        childset1_.parent_id as parent_i3_5_1_,
        childset1_.sex as sex2_5_1_,
        childset1_.parent_id as parent_i3_5_0__,
        childset1_.id as id1_5_0__ 
    from
        parent parent0_ 
    left outer join
        child childset1_ 
            on parent0_.id=childset1_.parent_id 
    where
        childset1_.sex=?
Hibernate: 
    select
        parent0_.id as id1_23_0_,
        childset1_.id as id1_5_1_,
        childset1_.parent_id as parent_i3_5_1_,
        childset1_.sex as sex2_5_1_,
        childset1_.parent_id as parent_i3_5_0__,
        childset1_.id as id1_5_0__ 
    from
        parent parent0_ 
    left outer join
        child childset1_ 
            on parent0_.id=childset1_.parent_id 
    where
        parent0_.id=1

Hibernate version: 5.4.5.Final