SQL function changes

Table 4: SQL function changes

SQL function

Description of change

LAG

New function. See “New SQL:2008 OLAP functions”.

LEAD

New function. See “New SQL:2008 OLAP functions”.

ROW_NUMBER

New function. See “New SQL:2008 OLAP functions”.

TS_AUTO_ARIMA

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_OUTLIER

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_AIC

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_AICC

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_BIC

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_FORECAST_VALUE

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_FORECAST_ERROR

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_MODEL_P

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_MODEL_Q

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_MODEL_S

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_MODEL_D

New function. See “New time series and forecasting functions”.

TS_AUTO_ARIMA_RESULT_RESIDUAL_SIGMA

New function. See “New time series and forecasting functions”.

TS_DOUBLE_ARRAY

New function. See “New time series and forecasting functions”.

TS_GARCH

New function. See “New time series and forecasting functions”.

TS_GARCH_RESULT_A

New function. See “New time series and forecasting functions”.

TS_GARCH_RESULT_AIC

New function. See “New time series and forecasting functions”.

TS_GARCH_RESULT_USER

New function. See “New time series and forecasting functions”.

TS_INT_ARRAY

New function. See “New time series and forecasting functions”.