Error during Compiling Regular Expression

You are getting this programming error because SAP HANA DATETIME functions cannot be handled correctly while optimize the query, when a comparsion of date with another partial date is performed.

Eg:

drop table t1;
create column table t1 (a datetime);
insert into t1 values ('2016-01-01');

select 1 from t1 where MONTH(a) = MONTH(current_timestamp);

Follwoing datetime functions are affected by this bug:

HOUR, MINUTE, MONTH, DAYOFMONTH, EXTRACT(DAY FROM timestamp), EXTRACT(MONTH FROM timestamp), EXTRACT(HOUR FROM timestamp), EXTRACT(MINUTE FROM timestamp)

This issue will solved soon with the upcoming hana revision, for now you can try to replace the function with SUBSTR().

You can use substr(X, 6, 2) instead of MONTH, for date-format YYYY-MM-DD.