On Mon, 2005-09-19 at 16:06 -0400, Kervin L. Pierre wrote: > D. Richard Hipp wrote: > > Hence, the result set contains no rows. A COUNT() of a empty result > > set gives NULL. > > I thought per the last discussion on "Sum and NULL" > that the count of an empty set would return zero. >
You're right. I was thinking of sum. The count should be zero. BTW, I'm beginning to doubt my previous analysis of the problem and am thinking perhaps that SQLite does LEFT JOINs wrong if on the ON constraints refers only to the left table of the LEFT JOIN. -- D. Richard Hipp <[EMAIL PROTECTED]>
