Notifications

75 views

Description

Changing the length of a glommed field impacts all other fields depending on same alias

Steps to Reproduce

On any instance, can be Jakarta, Kinston:
- create a custom varchar(255) field that becomes glommed (shares same alias as other fields)
- create at least one simple/composite index on this field
- try to increase the length of the field to 500. You will get the error:

Error MessageSyntax Error or Access Rule Violation detected by database (BLOB/TEXT column 'a_str_21' used in key specification without a key length)
Error Messagecom.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION 26: ALTER TABLE tmp_t942364460k MODIFY `a_str_21` MEDIUMTEXT , /*Recreated from a_str_21*/ ADD INDEX `a_str_21`(`a_str_21`) /* empspanaite006, gs:629D38513714530095E39C4683990E83, tx:794fb4913714530095e39c4683990e13 */ Syntax Error or Access Rule Violation detected by database (BLOB/TEXT column 'a_str_21' used in key specification without a key length)

- now, drop the index and try to increase the length again. It works but then all fields mapped to same alias will suddenly become mediumtext rather than varchar

Workaround

Please contact Customer Support to fix this issue.


Related Problem: PRB1253927

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-10-20 20:09:23
Published:2018-10-21