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

.