[DRILL-3359] Drill should throw and error when window function defined using WINDOW AS uses ROWS UNBOUNDED PRECEDING

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Labels: doc-impacting no_verified_test window_function
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Abdel Hakim Deneche
• Created: 24/Jun/15 20:40
• Updated: 26/Jun/15 17:43
• Resolved: 25/Jun/15 17:31

Description

as part of DRILL-3188, the following query is not supported and Drill displays the proper error message:

0: jdbc:drill:zk=local> select sum(salary) over(partition by position_id order by salary rows unbounded preceding) from cp.`employee.json` limit 20;
Error: UNSUPPORTED_OPERATION ERROR: This type of window frame is currently not supported 
See Apache Drill JIRA: DRILL-3188

But when defining the same window using a WINDOW AS, Drill doesn't throw any error:

0: jdbc:drill:zk=local> select sum(salary) over w from cp.`employee.json` window w as (partition by position_id order by salary rows unbounded preceding) limit 20;
+-----------+
|  EXPR$0   |
+-----------+
| 80000.0   |
| 30000.0   |
| 135000.0  |
| 135000.0  |
| 135000.0  |
| 215000.0  |
| 215000.0  |
| 25000.0   |
| 15000.0   |
| 50000.0   |
| 6700.0    |
| 14700.0   |
| 34700.0   |
| 34700.0   |
| 5000.0    |
| 13500.0   |
| 58500.0   |
| 5000.0    |
| 11700.0   |
| 20000.0   |
+-----------+
20 rows selected (0.348 seconds)

The results are, of course, incorrect