blaze-persistence
blaze-persistence copied to clipboard
Simple query with an EXISTS clause and pagination adds an unnecessary inner ID query
A simple query with an EXISTS clause and pagination adds an unnecessary inner ID query:
final CriteriaBuilder<ProductQuestion> criteriaBuilder = this.criteriaBuilderFactory.create(this.entityManager, ProductQuestion.class);
final CriteriaBuilder<ProductQuestion> criteriaBuilder = criteriaBuilder.from(ProductQuestion.class, PRODUCT_QUESTION_ALIAS);
criteriaBuilder
.whereExists()
.from(ProductAnswer.class, PRODUCT_ANSWER_ALIAS)
.select(joinExpressions(PRODUCT_ANSWER_ALIAS, "id"))
.where(joinExpressions(PRODUCT_ANSWER_ALIAS, ProductAnswer_.QUESTION, ProductQuestion_.ID))
.eqExpression(joinExpressions(PRODUCT_QUESTION_ALIAS, ProductQuestion_.ID))
.end();
Is there any way to force Blaze-Persistence not to use an inner ID query? I'm joining with no collection and just using a simple EXISTS query, which has no impact on pagination.
Could you please help me, thanks
Can you please post the generated SQL?