[Bug] Doris View Order by 会过度列裁剪导致列为空
- Dominant language
- Java
- Stars
- 15.9k
- Forks
- 3.9k
- Avg merge
- 2d 23h
- Merged PRs (30d)
- 520
Description
### Search before asking
- [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
doris 4.0.1
### What's Wrong?
SELECT *
FROM view_name
ORDER BY a ASC, b
LIMIT 100; 视图的列过度裁剪,除order by的a,b列,其余列为空 create view a as SELECT
c1,c2,c3
FROM (
SELECT
*
FLOOR(
TIMESTAMPDIFF(
HOUR,
DATE_SUB(datatime1, INTERVAL 10 DAY),
COALESCE(datatime2, CURRENT_TIMESTAMP())
) / 24
) AS c
FROM table
) t1
### What You Expected?
修正这个bug,
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
Contributor guide
Assessment
This issue has not been assessed yet.