[
https://issues.apache.org/jira/browse/IGNITE-26404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18020583#comment-18020583
]
Ignite TC Bot commented on IGNITE-26404:
----------------------------------------
{panel:title=Branch: [pull/12337/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/12337/head] Base: [master] : New Tests
(8)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
8|https://ci2.ignite.apache.org/viewLog.html?buildId=8602796]]
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=true, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=true, isPerfStatsEnabled=true] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=false, isFullyFetched=false, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=false, isFullyFetched=false, isPerfStatsEnabled=true] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=false, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=false, isPerfStatsEnabled=true] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=false, isFullyFetched=true, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=false, isFullyFetched=true, isPerfStatsEnabled=true] -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8602881&buildTypeId=IgniteTests24Java8_RunAll]
> H2QueryInfo#planWithoutScanCount does not consider all cases
> ------------------------------------------------------------
>
> Key: IGNITE-26404
> URL: https://issues.apache.org/jira/browse/IGNITE-26404
> Project: Ignite
> Issue Type: Bug
> Reporter: Aleksandr Chesnokov
> Assignee: Aleksandr Chesnokov
> Priority: Major
> Labels: ise
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {{H2QueryInfo#planWithoutScanCount}} does not consider all cases:
> 1) It deletes only the first occurrence of the {{scanCount}} field, but there
> can be several occurrences (e.g. in {{{}UNION{}}})
> 2) Sometimes {{scanCount}} is located inside {{/++ ... ++/}} comments, not in
> {{/* ... */}}
> As a result, it generates local plans for perfStat that differ only by
> {{{}scanCount{}}}, which makes {{perfStat}} heavier
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
