[infinispan-issues] [JBoss JIRA] (ISPN-9766) Ickle query return unexpected (many) results for an optional numeric field in inner object if checked for "is null"

[Wolf-Dieter Fink (Jira)]

    [ https://issues.jboss.org/browse/ISPN-9766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13665546#comment-13665546 ] 

Wolf-Dieter Fink commented on ISPN-9766:
----------------------------------------

Same happen if I use 
    runIckleQuery(qf, "from playground.Company c where c.employee is not empty and c.employee.age is null");

   runIckleQuery(qf, "from playground.Company c where c.employee is empty");
Will find also all companies which have employees

> Ickle query return unexpected (many) results for an optional numeric field in inner object if checked for "is null"
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: ISPN-9766
>                 URL: https://issues.jboss.org/browse/ISPN-9766
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Embedded Querying, Remote Querying
>    Affects Versions: 9.4.2.Final
>         Environment: Follow the README of https://github.com/wfink/infinispan.playground.ickle
> and use CompanyQueryHotRodClient
>            Reporter: Wolf-Dieter Fink
>            Priority: Major
>              Labels: Query
>
> If an object is declared like this:
> https://github.com/wfink/infinispan.playground.ickle/blob/master/HotRodClient/src/main/resources/playground/company.proto
> and the query is the following (in the linked project)
>   runIckleQuery(qf, "from playground.Company c where c.employee.age is null");
> the result return with Company object which does not have any Employee.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)