db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <be...@sun.com>
Subject Re: Is EXCEPT/INTERSECT complete?
Date Tue, 12 Apr 2005 18:03:02 GMT
>>>>>>>>>>>> Andrew McIntyre wrote (2005-04-12 10:51:40):
> On Mar 15, 2005 7:43 AM, Bernt M. Johnsen <bernt@sun.com> 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

Mime
View raw message