Hi Craig,

assertion A14.6.9-7 specifies:

"A14.6.9-7 [If the returned value from a query specifying a result is null, this indicates that the expression specified as the result was null.] Note that the semantics of this result are different from the returned value where no instances satisfied the filter."

Is my understanding right that the assertion checks if the result expression evaluates to null? Does it make sense to test 3 queries, one unique query and two non-unique queries, e.g.:

1) SELECT UNIQUE manager FROM Employee WHERE lastname == 'emp2Last'

expected result: null

2) SELECT manager FROM Employee WHERE lastname == 'emp2Last'

expected result: {null}

3) SELECT DISTINCT manager FROM Employee

expected result: {"emp2", null}

Regards,
Michael
--
-------------------------------------------------------------------
Michael Watzek                  [EMAIL PROTECTED] Engineering GmbH
mailto:[EMAIL PROTECTED]        Buelowstr. 66
Tel.:  ++49/30/235 520 36       10783 Berlin - Germany
Fax.:  ++49/30/217 520 12       http://www.spree.de/
-------------------------------------------------------------------

Reply via email to