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

Looks like a bug to me.

Only way to really know what oracle thinks is to submit a service request which is pretty easy since you have a test case already.

I don't expect it would be fixed at a high priority though. Received on Wed Jan 03 2007 - 13:58:31 CST