[ https://issues.apache.org/jira/browse/KYLIN-5521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17717041#comment-17717041 ]
ASF GitHub Bot commented on KYLIN-5521: --------------------------------------- sonarcloud[bot] commented on PR #2116: URL: https://github.com/apache/kylin/pull/2116#issuecomment-1525022845 SonarCloud Quality Gate failed. [![Quality Gate failed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/failed-16px.png 'Quality Gate failed')](https://sonarcloud.io/dashboard?id=apache_kylin&pullRequest=2116) [![Bug](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/bug-16px.png 'Bug')](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=BUG) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=BUG) [0 Bugs](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=BUG) [![Vulnerability](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/vulnerability-16px.png 'Vulnerability')](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=VULNERABILITY) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=VULNERABILITY) [0 Vulnerabilities](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=VULNERABILITY) [![Security Hotspot](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/security_hotspot-16px.png 'Security Hotspot')](https://sonarcloud.io/project/security_hotspots?id=apache_kylin&pullRequest=2116&resolved=false&types=SECURITY_HOTSPOT) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/security_hotspots?id=apache_kylin&pullRequest=2116&resolved=false&types=SECURITY_HOTSPOT) [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_kylin&pullRequest=2116&resolved=false&types=SECURITY_HOTSPOT) [![Code Smell](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/code_smell-16px.png 'Code Smell')](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=CODE_SMELL) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=CODE_SMELL) [14 Code Smells](https://sonarcloud.io/project/issues?id=apache_kylin&pullRequest=2116&resolved=false&types=CODE_SMELL) [![79.4%](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/CoverageChart/60-16px.png '79.4%')](https://sonarcloud.io/component_measures?id=apache_kylin&pullRequest=2116&metric=new_coverage&view=list) [79.4% Coverage](https://sonarcloud.io/component_measures?id=apache_kylin&pullRequest=2116&metric=new_coverage&view=list) [![0.0%](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/Duplications/3-16px.png '0.0%')](https://sonarcloud.io/component_measures?id=apache_kylin&pullRequest=2116&metric=new_duplicated_lines_density&view=list) [0.0% Duplication](https://sonarcloud.io/component_measures?id=apache_kylin&pullRequest=2116&metric=new_duplicated_lines_density&view=list) > JoinsGraph optimization: Query SQL association order change causes the model > to fail to hit > ------------------------------------------------------------------------------------------- > > Key: KYLIN-5521 > URL: https://issues.apache.org/jira/browse/KYLIN-5521 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: 5.0-alpha > Reporter: Yaguang Jia > Assignee: Yaguang Jia > Priority: Major > Fix For: 5.0-beta > > Attachments: (Chinese)KYLIN-5521 JoinsGraph optimization_ Query SQL > association order change causes the model to fail to hit.pdf, > (English)KYLIN-5521 JoinsGraph optimization_ Query SQL association order > change causes the model to fail to hit.pdf > > > In the log, the following two query statements, only the order of the > association of the first 2 tables is changed (the actual logical relationship > has not changed), resulting in the query statement can not be hit by the same > index. When there are only 2 tables after from, the order of the replacement > table association can hit the same index. > > 日志中,以下两条查询语句,只是前面2张表的关联先后顺序换了一下(实际逻辑关系并未改变),导致查询语句不能被同一个索引击中。而当from后面只有2张表时,替换表关联的先后顺序是可以击中同一个索引的。 > -- This message was sent by Atlassian Jira (v8.20.10#820010)