Qserv, alias in select using arithmetic

Data Management
#1

Hi

Not a problem as works with an alias but wondering if aliases such as below are to be supported.

select cutOn-cutOff as range from Filter;

ERROR 4110 (Proxy): Query processing error: QI=?: Failed to instantiate query: ParseException:Failed to instantiate query: “select cutOn-cutOff as range from Filter”

Cheers
Mike

#2

Hi Mike,

We’ve made a bug report at DM-17770 and plan on looking at this issue potentially in March.

#3

For this particular query, note that RANGE is a MariaDB reserved word, and so most likely won’t be available as a Qserv alias identifier in any case.

#4

Thanks

Mike