[
https://issues.apache.org/jira/browse/IGNITE-26404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18023758#comment-18023758
]
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
(4)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
4|https://ci2.ignite.apache.org/viewLog.html?buildId=8620201]]
* {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=true, isFullyFetched=false, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testNoScanCountSuffixForUNION[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=false, isPerfStatsEnabled=true] -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8620286&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: 40m
> 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
> An example is given below.
> Before:
>
> {noformat}
> SELECT
> u.id,
> u.name
> FROM users u
> WHERE u.active = true
> /* scanCount: 1 */
> UNION ALL
> SELECT
> c.id,
> c.contact_name
> FROM customers c
> WHERE c.status = 'VIP';
> /++ scanCount: 3 ++/
> {noformat}
> After:
> {noformat}
> SELECT
> u.id,
> u.name
> FROM users u
> WHERE u.active = true
> UNION ALL
> SELECT
> c.id,
> c.contact_name
> FROM customers c
> WHERE c.status = 'VIP';
> {noformat}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
