0 is a known result - no rows. As in all the discussions on this board about comparing a value with null - null signifies unknown. So in all the other databases, returning a value of null is surely misleading - the e..." />

Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2004 @ 09:47:32 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: EXISTS predicate bug?

From:		Sean

I'm probably a bit under-qualified to be saying this, so please bear with me.

The subquery "select max(c1) from n1 where c1 < 0" where all values of c1 being > 0 is a known result - no rows. As in all the discussions on this board about comparing a value with null - null signifies unknown. So in all the other databases, returning a value of null is surely misleading - the empty set is the right answer.

So isn't the bug in all the other databases?

Sean