2010YOUY01 opened a new issue, #14910:
URL: https://github.com/apache/datafusion/issues/14910

   ### Describe the bug
   
   The following query throws planning error for `DataFusion`, but it runs in 
`DuckDB` and `PostgreSQL`
   
   Run in datafusion-cli (commit hash a28f2834c)
   ```sh
   DataFusion CLI v45.0.0
   > SELECT
     t1.v1,
     SUM(t1.v1) OVER w + 1
   FROM
     generate_series(1, 10000) AS t1(v1)
   WINDOW
     w AS (ORDER BY t1.v1 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW);
   
   Error during planning: Projection references non-aggregate values: 
Expression t1.v1 could not be resolved from available columns: sum(t1.v1)
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _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: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to