Bug #1146

Sequence name length problem

Details

Submitted	2004-04-06 11:07 UTC
From	vincent dot dupont at ausy dot be
Status	Wont fix
Package	MDB
PHP Version	4.3.4
OS	Win2000
Roadmaps	(Not assigned)

Comments

[2004-04-06 11:07 UTC] vincent dot dupont at ausy dot be

Description:
------------
I found a problem with sequences generated by MDB.
In Mysql, I generate the sequence named "seq_content_role_mapping_id". This comes into a table named "seq_content_role_mapping_id_seq". Ok

When turning to Oracle 9i, the sequence created should be
"seq_content_role_mapping_id_seq" However, I have an error message from Oracle saying that the name of the sequence is too long.

I suggest we should keep in one common place of MDB one max length f sequence names

Expected result:
----------------
create a sequence named "seq_content_role_mapping_id_seq" in oracle

Actual result:
--------------
I changed my sequence name from
"seq_content_role_mapping_id"
to
"seq_content_role_map_id"