[DERBY-219] EXCEPT/INTERSECT fails in views

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.1.1.0
• Component/s: 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)
• Assignee: Unassigned
• Reporter: Bernt Johnsen
• Created: 13/Apr/05 04:47
• Updated: 21/Apr/05 09:51
• Resolved: 21/Apr/05 09:28

Description

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: org.apache.derby.iapi.services.sanity.AssertFailure

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;
.