Archives of the TeradataForum
Message Posted: Mon, 12 May 2008 @ 19:42:07 GMT
| Subj: || || Re: View with Default and Null values |
| From: || || Dieter Noeth |
Srikanth Goli wrote:
| ||I am noticing an issue in Teradata, when I do a left join with a view and do a select based on a field in the view being null. This field
has a default value defined.|| |
| ||My problem is why the last SQL does not return any rows. My hypothesis is that since the view has a default defined, it assumes this field
will have default value for all rows in the join, even though this is a left join and NOT ALL rows may have a match. Regardless, I think this is
not ideal. Can the members confirm if this is not an acceptable behavior or a bug? Any workarounds (short of not using defaults in the
AFAIK this is a known bug and has been fixe some time ago.
What's your Teradata version?