Database Column definition getting changed in View

We are facing a scenario where data type of view keeps on changing from MediumText and Text depending upon the the data getting hold in view column.

This causes any issue whenever data store is published and CDT column definition does not match the View Column definition.

  Discussion posts and replies are publicly visible

Parents
  • How is your view defined?  Similar issues can occur say if your view is defined with "*" such as "SELECT * FROM TABLE_XYZ", where as the view should be defined with columns specifically identified as "SELECT column1, column2, column3 FROM TABLE XYZ".  Utilizing "*" in your view will also require the view to be republished if columns are added to the table later on.  Just one thought on the issue there. 

Reply
  • How is your view defined?  Similar issues can occur say if your view is defined with "*" such as "SELECT * FROM TABLE_XYZ", where as the view should be defined with columns specifically identified as "SELECT column1, column2, column3 FROM TABLE XYZ".  Utilizing "*" in your view will also require the view to be republished if columns are added to the table later on.  Just one thought on the issue there. 

Children
No Data