Hi,
Is the behavior of COUNT(manager) (please see below) specified in SQL?
"SELECT COUNT(manager) FROM Employee"
Thanks,
Craig
Begin forwarded message:
From: Michael Watzek <[EMAIL PROTECTED]>
Date: November 9, 2005 7:12:45 AM PST
To: [email protected]
Subject: COUNT queries
Reply-To: [email protected]
Hi,
does COUNT in JDO consider NULL values? In SQL, NULL values are not
considered by COUNT.
In JDO, does COUNT consider duplicates? In SQL, duplicates are
considered by COUNT.
Our testdata has five employees. Four employees have the same
manager. One employee does not have a manager.
What is the result of the following JDO query: "SELECT COUNT
(manager) FROM Employee"?
Is the result 4?
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/
-------------------------------------------------------------------
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!
