Qserv, alias in select using arithmetic


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”


Hi Mike,

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

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.