Qserv, alias in select using arithmetic

qserv
Tags: #<Tag:0x00007f61a6aaec68>

(Mike Read) #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


(Vaikunth Thukral) #2

Hi Mike,

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


(K-T Lim) #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.


(Mike Read) #4

Thanks

Mike