Need a better error message when we use alias for window definition in query that uses window functions. for example, OVER(PARTITION BY columns ORDER BY columns) tmp, and if alias "tmp" is used in the predicate we need a message that says, column "tmp" does not exist, that is how it is in Postgres 9.3
postgres=# select count(*) OVER(partition by type order by id) `tmp` from airports where tmp is not null;
ERROR: column "tmp" does not exist
LINE 1: ...ect count(*) OVER(partition by type order by id) `tmp` from ...
0: jdbc:drill:schema=dfs.tmp> select count(*) OVER(partition by columns order by columns) tmp from `airports.csv` where tmp is not null;
Error: SYSTEM ERROR: java.lang.IllegalArgumentException: Selected column(s) must have name 'columns' or must be plain '*'
[Error Id: 66987b81-fe50-422d-95e4-9ce61c873584 on centos-02.qa.lab:31010] (state=,code=0)