CDT datatype change

Hi,

What are the consequences of changing datatype of one field of CDT .

We are planing to change datatype of one field in table  from INT to VARCHAR.

What will be the behavior of running instances which still points to older version.

Thanks

Namrata

  Discussion posts and replies are publicly visible

  • Hi Namrata,

    Just a suggestion ! Instead of changing the column type, if you add a column and update your new values there, what will happen? I faced the similar issue once and I took this approach.

    Thanks,

    Subhajit

  • What are the consequences of changing datatype of one field of CDT .

      ->>> Another column will be created in the database and the old one will exist too.

    We are planing to change datatype of one field in table  from INT to VARCHAR.

      ->>>  Another column will be created in the database and the old one will exist too.

    What will be the behavior of running instances which still points to older version.

      ->>>  The process take the older version of the CDT and the database specifications, another case is if you delete one field, publish the datastore and in the running instance you try to insert something in the column that you deleted, this will cause an Appian error in the running instance.