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..." />
 
Home Page for the TeradataForum
 

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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016