viirya opened a new issue, #775: URL: https://github.com/apache/datafusion-comet/issues/775
### Describe the bug Found this bug during fixing Spark SQL failures for #651. `window.sql` in `org.apache.spark.sql.SQLQueryTestSuite` failed: ``` window.sqlESC[0mESC[0m 2024-08-02T22:26:39.9959102Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m Expected "struct<[val:int,cate:string,count(val) OVER (PARTITION BY cate ORDER BY val ASC NULLS FIRST ROWS BETWEEN CURRENT ROW AND CURRENT ROW):bigint ]>", but got "struct<[]>" Schema did not match for query #3ESC[0mESC[0m 2024-08-02T22:26:39.9963875Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m SELECT val, cate, count(val) OVER(PARTITION BY cate ORDER BY val ROWS CURRENT ROW) FROM testDataESC[0mESC[0m 2024-08-02T22:26:39.9966397Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m ORDER BY cate, val: -- !queryESC[0mESC[0m 2024-08-02T22:26:39.9969624Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m SELECT val, cate, count(val) OVER(PARTITION BY cate ORDER BY val ROWS CURRENT ROW) FROM testDataESC[0mESC[0m 2024-08-02T22:26:39.9971356Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m ORDER BY cate, valESC[0mESC[0m 2024-08-02T22:26:39.9972335Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m -- !query schemaESC[0mESC[0m 2024-08-02T22:26:39.9973219Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m struct<>ESC[0mESC[0m 2024-08-02T22:26:39.9974488Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m -- !query outputESC[0mESC[0m 2024-08-02T22:26:39.9975682Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m org.apache.comet.CometNativeExceptionESC[0mESC[0m 2024-08-02T22:26:39.9977303Z ESC[0m[ESC[0mESC[0minfoESC[0m] ESC[0mESC[0mESC[31m Expects PARTITION BY expression to be ordered (SQLQueryTestSuite.scala:491)ESC[0mESC[0m ``` ### Steps 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
