db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Is EXCEPT/INTERSECT complete?
Date Tue, 12 Apr 2005 18:35:01 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
My understanding was that it was mostly complete, so do file a JIRA
entry with a test case. If you are interested in addressing the bug, I
could provide some ideas ...<span class="moz-smiley-s1"><span> :-) </span></span><br>
<br>
Satheesh<br>
<br>
Bernt M. Johnsen wrote:<br>
<blockquote cite="mid20050412180302.GE17432@ac30.fr34.2y.net"
 type="cite">
  <blockquote type="cite">
    <blockquote type="cite">
      <blockquote type="cite">
        <blockquote type="cite">
          <blockquote type="cite">
            <blockquote type="cite">
              <blockquote type="cite">
                <blockquote type="cite">
                  <blockquote type="cite">
                    <blockquote type="cite">
                      <blockquote type="cite">
                        <blockquote type="cite">
                          <pre wrap="">Andrew McIntyre wrote (2005-04-12 10:51:40):
                          </pre>
                        </blockquote>
                      </blockquote>
                    </blockquote>
                  </blockquote>
                </blockquote>
              </blockquote>
            </blockquote>
          </blockquote>
        </blockquote>
      </blockquote>
    </blockquote>
    <pre wrap="">On Mar 15, 2005 7:43 AM, Bernt M. Johnsen <a class="moz-txt-link-rfc2396E"
href="mailto:bernt@sun.com">&lt;bernt@sun.com&gt;</a> wrote:
    </pre>
    <blockquote type="cite">
      <pre wrap="">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.

&lt;snip repro and stack trace&gt;
      </pre>
    </blockquote>
    <pre wrap="">Hi Bernt,

Did you create an issue for this? 
    </pre>
  </blockquote>
  <pre wrap=""><!---->
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.

  </pre>
  <blockquote type="cite">
    <pre wrap="">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&gt; create view view1 as select * from tab1 intersect select * from tab2;
0 rows inserted/updated/deleted
ij&gt; 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&gt; exit;

andrew
    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
</body>
</html>


Mime
View raw message