Re: Strange behavior of subquery
From: Hans Mayr <mayr1972_at_gmx.de>
Date: Wed, 27 Feb 2008 04:26:55 -0800 (PST)
Message-ID: <48a4fe7e-4d6e-4cab-9abb-f41a53b87a78@62g2000hsn.googlegroups.com>
Date: Wed, 27 Feb 2008 04:26:55 -0800 (PST)
Message-ID: <48a4fe7e-4d6e-4cab-9abb-f41a53b87a78@62g2000hsn.googlegroups.com>
Well:
I found that the WITH clause caused problems. Did I do something one should not do with WITH? The ugly way of having the same sub select more than once in the code ran without problems. After solving this further problems occurred which I could solve trough OPTIMIZER_FEATURES_ENABLE='10.2.0.2'. I had hoped for a more coherent and more stable environment.
Best,
Hans Received on Wed Feb 27 2008 - 06:26:55 CST