db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-219) EXCEPT/INTERSECT fails in views
Date Tue, 12 Apr 2005 19:47:20 GMT
EXCEPT/INTERSECT fails in views

         Key: DERBY-219
         URL: http://issues.apache.org/jira/browse/DERBY-219
     Project: Derby
        Type: Bug
  Components: SQL  
 Environment: Linux 2.4.20-31.9
java version "1.4.2_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_02-b03)
Java HotSpot(TM) Client VM (build 1.4.2_02-b03, mixed mode)

    Reporter: Bernt M. Johnsen

EXCEPT or INTERSECT in views give:

ERROR XJ001: Java exception: 'ASSERT FAILED costEstimate is not expected to be null for org.apache.derby.impl.sql.compile.SelectNode:

To recreate, run:

create table tab1 (i integer primary key);
insert into tab1 values (1),(2),(3),(4);
create table tab2 (i integer primary key);
insert into tab2 values (2),(4);
create view view1 as select * from tab1 intersect select * from tab2;
select * from view1;

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

View raw message