SQLDataSource: datetime field extra OR condition in where clause

[claudiobosticco]

SmartClient Version: v12.1p_2020-09-18/Enterprise Deployment (built 2020-09-18)
Oracle 12c

Hello, I've got a question about the generation of the where clause when I've got a criteria regarding a datetime field, ie:

        DSRequest req = new DSRequest("JPC_LISTINI", "fetch", rpcManager);
        req.setAdvancedCriteria(new AdvancedCriteria(
                DefaultOperators.And,
                new SimpleCriterion("DATA_INIZIO", DefaultOperators.LessThan, new Date()))
        );
        req.execute();

That criteria produces this condition in the where clause:

(JPC_LISTINI.DATA_INIZIO < TO_DATE('2020-09-23 11:00:29','YYYY-MM-DD HH24:MI:SS') OR JPC_LISTINI.DATA_INIZIO IS NULL)

My doubt is: why the 'OR field IS NULL' condition ?
Actually I have to add and extra NotNullCriterion to circumvent it.

[Blama]

Hi claudiobosticco,

see these threads, it's on purpose. I had the same question.

1. https://forums.smartclient.com/forum...eater_or_equal
2. https://forums.smartclient.com/forum...equal-operator

Best regards
Blama

[claudiobosticco]

Thanks Blama !