comphead opened a new issue, #6207:
URL: https://github.com/apache/arrow-datafusion/issues/6207

   ### Is your feature request related to a problem or challenge?
   
   If the window frame is invalid the error message is wordy and not user 
friendly
   
   ```
   ❯ select row_number() over (rows between -1 preceding and current row) from 
(select 1 a);
   Internal error: Window frame bound cannot be UnaryOp { op: Minus, expr: 
Value(Number("1", false)) }. This was likely caused by a bug in DataFusion's 
code and we would welcome that you file an bug report in our issue tracker
   ❯ 
   ```
   
   
   
   ### Describe the solution you'd like
   
   Handle error messages properly. Good example
   
   ```
   ❯ select row_number() over (rows between 1 following and current row) from 
(select 1 a);
   Error during planning: Invalid window frame: start bound (1 FOLLOWING) 
cannot be larger than end bound (CURRENT ROW)
   ```
   
   ### Describe alternatives you've considered
   
   _No response_
   
   ### Additional context
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to