Accessing a view hangs forever (oracle bug?)

In both Oracle 7.3.4 and Oracle 8.0, we had the following problem.

Create two simple tables and insert rows in them.

    create table a (num integer);
    create table b (num integer);
    insert into a values (5); insert into b values (7);

After this, the following work as expected:

(1) select * from a union all select * from b;

(2) select --+RULE

• from a union all select --+RULE
• from b;

The above (1) and (2) should be equivalent; (2) has just a couple of optimizer hints thrown in.

(3) create view ab as

    select * from a union all select * from b;

(4) create view ab2 as

    select --+RULE

• from a union all select --+RULE
• from b;

The above (3) and (4) should be equivalent. They are the above select (1) and (2) wrapped as a view. And selecting from the first view works as exiected:

(5) select * from ab;

However, the following hangs forever:

(6) select * from ab2;
Received on Wed Feb 17 1999 - 17:11:26 CST