REGR_AVGX and REGR_AVGY with timestamps don't throw an exception

Detail name	Value
Changelog Number	19357
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0, Exasol 8.0.0
Fix Versions	Exasol 7.1.26, Exasol 8.26.0
Resolution Date	2024-03-15

Description

Using REGR_AVGX and REGR_AVGY with timestamp and 0 doesn’t throw an exception but returns an interval

Example

create or replace table t(ts timestamp(0));
insert into t values timestamp'2024-01-01 00:00:00';

-- Expected: exception - REGR_AVGX does not support timestamp as argument type
-- Observed: +000000000 00:00:00.000000000
select regr_avgx(ts, 0) from t;

-- Expected: exception - REGR_AVGY does not support timestamp as argument type
-- Observed: +000000000 00:00:00.000000000
select regr_avgy(0, ts) from t;

Fix

The query throws the following syntax exception: REGR_AVGY does not support timestamp as argument type

Changed behavior

Exception message of queries with REGR_AVGX and REGR_AVGY having timestamp as argument has changed to "REGR_AVGX/REGR_AVGY does not support timestamp as argument type"