dqkqd commented on PR #17852:
URL: https://github.com/apache/datafusion/pull/17852#issuecomment-3367808528
Thanks.
I disable the rule and the test failed without the change:
```
Completed 355 test files in 16 seconds
External error: 1 errors
in file
/home/dqk/workspace/datafusion/datafusion/sqllogictest/test_files/window.slt
1. query failed: DataFusion error: Optimizer rule
'common_sub_expression_eliminate' failed
caused by
Error during planning: Window has mismatch between number of expressions (1)
and number of fields in schema (0)
[SQL] WITH suppliers AS (
SELECT *
FROM (VALUES (1, 10.0), (1, 20.0)) AS t(nation, acctbal)
)
SELECT
ROW_NUMBER() OVER (PARTITION BY nation ORDER BY acctbal DESC) AS rn
FROM suppliers AS s
WHERE acctbal > (
SELECT AVG(acctbal) FROM suppliers
);
at
/home/dqk/workspace/datafusion/datafusion/sqllogictest/test_files/window.slt:6132
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
