[GENERAL] Errors from Sub-select Not Showing Up

[Ian Harding]

Has anyone else seen cases where errors from subselects are not being 
raised?  I just had it happen again but can't find a simple case that 
reproduces it.  The query is like this:

insert into ...
select (a bunch of CASE statements specifying a subselect to use if the 
value of the attribute is null)...
from...(a messy JOIN)

in which one of the CASE contains a subselect which has an "Attribute 
not found" error when executed independently.  However, the only way it 
manifests itself is through a NOT NULL constraint not being satisfied in 
the insert.

Should I spend any time trying to reproduce this in a simple case, or is 
there some known stupid way of making this happen?

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend