gojumprope opened a new issue, #15098: URL: https://github.com/apache/doris/issues/15098
### 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 1.2.0 ### What's Wrong? If condition is not met when left join a view, some of the view columns still return value instead of null ### What You Expected? If left join condition not met, all of the columns of the right table should be null ### How to Reproduce? create view public_holiday_view as select rp.publicholidaydatetime, rp.publicholidayname, rp.companyid, rs.branchid, 1 IsPublicHoliday from publicholidayconfigurations rp inner join publicholidaylinks rp2 on rp.id = rp2.publicholidayid left join sitegrouplinks rs on rs.sitegroupid = rp2.granularityid select sd.__time, ph.* from store_data sd LEFT JOIN public_holiday_view ph on ph.companyid = sd.companyid and ph.publicholidaydatetime = date(sd.__time) __time |publicholidaydatetime|publicholidayname|companyid|branchid|IsPublicHoliday| -------------------+---------------------+-----------------+---------+--------+---------------+ 2022-01-28 00:00:00| 2022-01-28 00:00:00|test1 | 123| 456| 1| 2022-01-29 00:00:00| | | | | 1| IsPublicHoliday column in 2022-01-29 00:00:00 should be null instead of 1 ### 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) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
