Teradata use to have an object name limit of 30 characters. As of 14.10 they extended the length to 128 characters but the older system catalog views are still only storing 30 characters. We need to migrate extraction to utilize the V views in order to extract the full object names.
Changes made so that for versions below 14.10 the older catalog views will still be used. After version 14.10 the [V] views will be used in extraction where possible. This should allow for creating objects with names greater then 30 characters and still been able to extract its full name correctly.
@ivan: when "X" views are enabled, will you be using the VX views?
Reference: https://forums.teradata.com/forum/database/difference-between-x-and-v-views
@ivan: when "X" views are enabled, will you be using the VX views?
Reference: https://forums.teradata.com/forum/database/difference-between-x-and-v-views
yes, the views that will be used are:
TeraData 14.0 and below. Normal views or normal[x] views
TeraData 14.1 and above. Normal views, normal[v] views where possible, normal[v][x] views when [x]views enabled and possible
yes, the views that will be used are:
TeraData 14.0 and below. Normal views or normal[x] views
TeraData 14.1 and above. Normal views, normal[v] views where possible, normal[v][x] views when [x]views enabled and possible
Verified all Teradata v14.1 and above Database Objects in ADS 16.0.5-4 and works correctly.
Alter, Script Generator, ERD etc and other components works fine for Table, Views, Indexes, Datatypes etc
Verified all Teradata v14.1 and above Database Objects in ADS 16.0.5-4 and works correctly.
Alter, Script Generator, ERD etc and other components works fine for Table, Views, Indexes, Datatypes etc
Issue #13288 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v16.0.5-4 |
No time estimate |
2 issue links |
relates to #13298
Issue #13298Behavior of User,when we use 31 character for user name. |
relates to #13297
Issue #13297Drop Trigger option is not working,when we use 31 character for trigger name. |
Changes made so that for versions below 14.10 the older catalog views will still be used. After version 14.10 the [V] views will be used in extraction where possible. This should allow for creating objects with names greater then 30 characters and still been able to extract its full name correctly.