Archives of the TeradataForum
Message Posted: Mon, 12 May 2008 @ 20:45:54 GMT
Please ignore my previous posting. I was again watching TV while posting, and it looks like TV and SQL do not go well together. I should stop posting from the couch.
What you described is indeed a problem! Looks like the last SELECT rewrites the JOIN to
> > left outer join > > VIEW_tbl2 TB2 on > > ( TB1.Column1 = TB2.Column1 > > and TB2.Column2 is NULL );
or something like that.
Could it be the same or very similar "ghost bug" we discussed in
The problem with these bugs is that it is difficult to reproduce them and the OP do not provide more details like their DB version, explain plans, stats collected or not, etc. It would be good to know all these details.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|