About Question com.enthuware.ets.scbcd.v5.2.329 :

[ETS User]

Path expressions that contain NULL values during evaluation return NULL values.


Could you give me an example of something like this. I cannot understand this sentence...

[admin]

For example, while accessing an attribute of Address entity from Customer entity, if address is null, the resulting value will be null.

select a.city from Customer c inner join c.address a where c.id=123

if there is no address associated with the given customer id (i.e. the path c.address is null, the query will return null.

HTH,
Paul.