Re: Strange behavior of subquery

From: Hans Mayr <>
Date: Mon, 25 Feb 2008 10:23:27 -0800 (PST)
Message-ID: <>


I found out that the problem seems to be connected to my V_BASE. It looks fine if you look at its results alone or in simple joins but if it gets more complicated it shows that strange behavior of changing the values in one column. It is highly disturbing for me that I can not rely on a view's results, that it changes it's values when used in another context.

If I solve the problem I will report it. Has anybody ever had a view that was "unreliable" as mine? Either I have done something really bad or something in our server is really mixed up.

Thanks and best,

Hans Received on Mon Feb 25 2008 - 12:23:27 CST

Original text of this message