Re: Is this a bug?

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 Received on Wed Jan 03 2007 - 14:01:03 CST