| Key: |
DERBY-219
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Major
|
| Assignee: |
Unassigned
|
| Reporter: |
Bernt M. Johnsen
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
|
|
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)
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)
|
|
| Resolution Date: |
21/Apr/05 09:28 AM
|
|
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;
.
|
|
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;
. |
Show » |
made changes - 14/Apr/05 12:50 AM
| Field |
Original Value |
New Value |
|
Attachment
|
|
intersect.diff
[ 19623
]
|
Satheesh Bandaram made changes - 21/Apr/05 09:28 AM
|
Status
|
Open
[ 1
]
|
Resolved
[ 5
]
|
|
Fix Version/s
|
|
10.1.0.0
[ 10993
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
Satheesh Bandaram made changes - 21/Apr/05 09:51 AM
|
Status
|
Resolved
[ 5
]
|
Closed
[ 6
]
|
|
EXCEPT/INTERSECT fails in views
