apache / apache/doris

[Bug] Doris View Order by 会过度列裁剪导致列为空

Open
#61,219 4 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.