airborne12 opened a new pull request, #23105:
URL: https://github.com/apache/doris/pull/23105
## Proposed changes
Issue Number: close #xxx
When SQL query like this:
```
SELECT
t1.web_name,
COUNT(t1.web_name) AS count
FROM
web_site t1
LEFT JOIN
web_sales t2 ON t1.web_site_sk = t2.ws_web_site_sk
WHERE
t1.web_name MATCH 'site_0'
OR t2.ws_item_sk > 17934
GROUP BY
t1.web_name
ORDER BY
t1.web_name;
```
match predicate can not push down to scan node, it stays in hash join node,
in nereids planner, when visitHashJoinNode, olap table schema can not be got
from the slotRef, which is intermediate, which caused inverted index context
can not get correctly.
In this PR, we push olap table to intermediate slotRef's tableIf, so match
predicate can get the right inverted index context.
## Further comments
If this is a relatively large or complex change, kick off the discussion at
[[email protected]](mailto:[email protected]) by explaining why you
chose the solution you did and what alternatives you considered, etc...
--
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]
