Bug in data base aliases?

[mac1929]

Hi there,

We're using EA Corporate 4.51, and are having some problems when using Aliases on database tables.

We have two tables:
Contexto_Ventana, alias CTXVENT
Elemento_de_contexto, alias ELEMENTO_CTXVENT
The latter has a foreing key to the former.

When we build the Oracle DDL of the second table checking "use alias if available" we get a wrong DDL.
The foreing key constraint does not referece the alias of the first table, it references its full name. That seems to be a bug.

This is the DDL generated:

CREATE TABLE ELEMENTO_CTXVENT (
..
..
)

ALTER TABLE ELEMENTO_CTXVENT ADD CONSTRAINT FK_ELEMENTO_CTXVENT_CTXVENT
FOREIGN KEY (ID_CTXVENT) REFERENCES Contexto_Ventana (ID_CTXVENT)
;

ALTER TABLE ELEMENTO_CTXVENT ADD CONSTRAINT FK_Elemento_de_c_Contexto_Vent
FOREIGN KEY (ID_CTXVENT_ANI) REFERENCES Contexto_Ventana (ID_CTXVENT)
;

this sentence should be:
FOREIGN KEY (ID_CTXVENT_ANI) REFERENCES CTXVENT (ID_CTXVENT)
;

cheers!

[hd]

Current build 749 does not have this problem.  

[mac1929]

I've just upgraded to 749 and the problem is still there...  

Should I post this on the bug tracking system for registered users?

[hd]

Yes thank you - with details of the tables and aliases.

[mac1929]

Thanks Henk, I've just posted this issue on the bug track system.