[
https://issues.apache.org/jira/browse/IGNITE-26438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18057970#comment-18057970
]
Ignite TC Bot commented on IGNITE-26438:
----------------------------------------
{panel:title=Branch: [pull/12723/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/12723/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=8855159]]
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testH2AutoAliasInPlanHistory[sqlEngine=h2,
isClient=false loc=false, isFullyFetched=false, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testH2AutoAliasInPlanHistory[sqlEngine=h2,
isClient=false loc=false, isFullyFetched=true, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testH2AutoAliasInPlanHistory[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=false, isPerfStatsEnabled=false] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
SqlPlanHistoryIntegrationTest.testH2AutoAliasInPlanHistory[sqlEngine=h2,
isClient=false loc=true, isFullyFetched=true, isPerfStatsEnabled=false] -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8855244&buildTypeId=IgniteTests24Java8_RunAll]
> Normalize SQL plan: remove H2 system-generated subquery aliases
> ---------------------------------------------------------------
>
> Key: IGNITE-26438
> URL: https://issues.apache.org/jira/browse/IGNITE-26438
> Project: Ignite
> Issue Type: Improvement
> Reporter: Aleksandr Chesnokov
> Assignee: Aleksandr Chesnokov
> Priority: Major
> Labels: IEP-35, ise
> Time Spent: 1h 50m
> Remaining Estimate: 0h
>
> H2 automatically generates system aliases for derived tables in the form
> {{_<number>}} (e.g., {{{}_10045{}}}).
> These aliases have no business meaning but cause logically identical SQL
> plans to be stored as different texts, increasing storage size.
> This has two consequences:
> # The *PerfStat* report becomes heavier than necessary.
> # The *sql.plans.history* system view grows larger, storing redundant
> entries.
> An example is given below.
> Before:
> {noformat}
> SELECT _10045.id, _10045.name
> FROM (
> SELECT id, name
> FROM users
> ) _10045
> WHERE _10045.id = 1;{noformat}
> After:
> {noformat}
> SELECT id, name
> FROM (
> SELECT id, name
> FROM users
> )
> WHERE id = 1;{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
