[
https://issues.apache.org/jira/browse/CAY-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856147#comment-17856147
]
Nikita Timofeev commented on CAY-2860:
--------------------------------------
Added tests for this:
https://github.com/apache/cayenne/commit/5afdb92cdd861938444ae0b6508131983adcd09a
> Translate (not)in expression with empty values
> ----------------------------------------------
>
> Key: CAY-2860
> URL: https://issues.apache.org/jira/browse/CAY-2860
> Project: Cayenne
> Issue Type: Improvement
> Components: Database integration
> Reporter: Nikita Timofeev
> Assignee: Nikita Timofeev
> Priority: Minor
> Fix For: 5.0-M1
>
>
> We have optimization in {{ExpressionFactory}} for (not)inExp() methods for
> the empty values that returns just {{ASTFalse}} or {{ASTTrue}}
> But when we create {{ASTIn}} manually we don't have this optimization and
> that results in incorrect SQL like {{t0.ARTIST_NAME IN ()}}.
> We could optimize that on our end, and that would benefit users who work
> directly with raw AST tree.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
