Upcoming Changes to SuiteAnalytics Connect Return Values and String Types

Upcoming Changes to SuiteAnalytics Connect Return Values and String Types

  

On August 9[SUP]th[/SUP] 2018, a software version upgrade will occur on all SuiteAnalytics Connect servers. The upgrade will occur for sandbox and production accounts, and no user intervention will be required. Be aware that the upgrade will change the data types, precision, and display sizes for the return values of some functions and columns with string types used in SuiteAnalytics Connect. Changes resulting from the upgrade include the following: [LIST] [*]All numeric functions that now return INTEGER values, after the upgrade will return BIGINT values. This change will increase the display size of the return values from 11 to 20, and the precision from 10 to 19. Affected functions include count(), abs(), pow(), ceil(), floor(), etc. [*]The return values for all string functions such as substring() and right() will have display sizes and precision equal to the resulting string size, instead of the original column size. For example, substring(col, 1, 30) will return a value with a precision and display size