Long Identifiers
Identifiers are the names of objects, such as database servers, databases, columns, replicates, replicate sets, and so on, that Ingres and Replicator use.
An identifier is a character string that must start with a letter or an underscore. The remaining characters can be letters, numbers, or underscores. On Ingres, all identifiers, including replicates and replicate sets, can be 128 bytes long. However, if you have any database servers in your replication environment that are an earlier version, you must follow the length restrictions for that version. %RED% This looks like a manual reference but this does not appear to be accurate for the GA product of Ingres 2006r2, 32 is limit as of feb-2008. Also "letters" is misleading, any valid character (there is an internal CM table of what is considered valid for names) in the II_CHARSETxx is allowed, e.g. "tô" or even Chinese glyphs - clach04%ENDCOLOR%
User login IDs can be a maximum of ?? bytes (WE SHOULD USE THE LONGEST OS LIMIT FOR THIS). The owner of a table is derived from a user ID and is thus limited to ?? bytes.
SR 127579 request for User Names in the format of an e-mail address. That should be addressed within the scope of this feature. This may effect how special characters are tolerated in object names.
Could this be something whereby only the DBMS catalogs are modified but the Standard Catalog interface does not fundamentally change - i.e. a small change to STDCATS whereby the info is trucated to only display 32 characters when queried. There would be a requirement that the tablename would be unique up to the first 32 characters which is what I believe other dbs do in this situation. %RED% "other dbs" needs to be defined, in Oracle the limit is 30, you can not have ANY table names over 30 in length. In MySQL there no unique limit length on object names that are shorter than the "visible" name. In Microsoft SQL server they have a 128 (Unicode) character limit - clach04%ENDCOLOR%
If the approve approach isn't workable, then the impact of this change on all needs to be considered.
