Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2003 @ 15:31:47 GMT

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

It seems your application is highly dependent on an undocumented feature that has been declared a "bug" and exterminated.

Prior to V2R4, Teradata would actually return TRUE for a "NULL=NULL" comparison. But that is incorrect according to the ANSI SQL standard. V2R4 correctly returns UNDEFINED instead of TRUE; and if the final value of the entire conditional expression is UNDEFINED then it is treated as FALSE.

A "standard" SQL expression such as (column = :variable OR (column IS NULL AND :variable IS NULL)) will work OK as a filter in some queries, but it won't give you PI access.

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