Details
-
Improvement
-
Resolution: Unresolved
-
Medium
-
4.7.0
-
None
-
eZ Oracle 2.1
Description
Upgrade check feature returns false errors in the presence of custom named tables/sequences, if these tables include auto_increment fields and the implementer does not name the tables has "ez"something.
In ezoracle/doc/developer-notes.txt is explained that
"The sequences made for oracle start with s_ instead of ez. The reason for this is the 30 character limitation: if _s was appended to the table names the identifier would exceed this value. Instead ez at the start is replaced with s_."
Considering that implementers are encouraged to name their custom tables using a sufix that identifies their company, this limitation should not be hardcoded as such.
Steps to reproduce
- create a ezoracle table, named *mytable*, and include an auto_increment field
- upgrade check feature, in admin portal setup tab, will report that the sequence is missing, no matter what how you name it
Until there's an official solution for this constraint, a viable workaround might be:
- name your custom tables ez<something> and the correspondent sequences s_<something>