Re: Is this a bug?

From: EscVector <Junk_at_webthere.com>
Date: 3 Jan 2007 14:18:21 -0800
Message-ID: <1167862701.878511.317540@s34g2000cwa.googlegroups.com>

Anurag Varma wrote:
> EscVector wrote:
> > As demonstrated below, a table can be created with data type
> > "timestamp" as a column name.
> >
> > This causes a subsequent issue when creating triggers.
> >
> > Shouldn't the table create throw a "ORA-00904: : invalid identifier"
> > error?
> >
> > create sequence seq;
> >
> > create table test (
> > col1 number,
> > timestamp timestamp
> > )
> > /
> >
> > create or replace trigger trg
> > before insert on test
> > for each row
> > begin
> > select seq.nextval into :new.col1 from dual;
> > end;
> > /
> >
> > alter table test rename column timestamp to ts
> > /
> >
> > create or replace trigger trg
> > before insert on test
> > for each row
> > begin
> > select seq.nextval into :new.col1 from dual;
> > end;
> > /

>

> You are right .. it should be a bug. However, probably not easy
> to fix ...

>

> You might want to read Bug 4703738 where this is discussed.
>
> Anurag

Quote from doc:
This issue is fixed in

• 9.2.0.8 (Server Patch Set)

Well they didn't kill this bug. It is back again in 10.2.0.2 :) Received on Wed Jan 03 2007 - 16:18:21 CST