>>>>>>>>>>>> Andrew McIntyre wrote (2005-04-12 10:51:40): > On Mar 15, 2005 7:43 AM, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote: > > Running the latest on trunk (svn update today), I get > > NullPointerException when doing EXCEPT and INTERSECT in a view. > > > > If the implementation is supposed to be complete, I'll create an > > issue. > > > > <snip repro and stack trace> > > Hi Bernt, > > Did you create an issue for this?
No, I did not. I was wondering if the implementation was complete or if there was some unfinished work underway. I did not get any answer and forgot about the whole thing. > I couldn't seem to find it in Jira. > Your repro also failed in my sane/debug build, but with a more > informative error message: > > ij> create view view1 as select * from tab1 intersect select * from tab2; > 0 rows inserted/updated/deleted > ij> select * from view1; > ERROR XJ001: Java exception: 'ASSERT FAILED costEstimate is not > expected to be null for org.apache.derby.impl.sql.compile.SelectNode: > org.apache.derby.iapi.services.sanity.AssertFailure'. > ij> exit; > > andrew -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Norway
