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 19:17:56 GMT
>>>>>>>>>>>> Satheesh Bandaram wrote (2005-04-12 11:35:01):
> My understanding was that it was mostly complete, so do file a JIRA entry with
> a test case. 

I will do so.

> If you are interested in addressing the bug, I could provide some
> ideas ... :-)

Well, 
> 
> Satheesh
> 
> Bernt M. Johnsen wrote:
>                                                                  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