[
https://issues.apache.org/jira/browse/IGNITE-28331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18069797#comment-18069797
]
Ignite TC Bot commented on IGNITE-28331:
----------------------------------------
{panel:title=Branch: [ignite-28331] Base: [master] : Possible Blockers
(12)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Disk Page Compressions 1{color} [[tests 0 Failure on metric
|https://ci2.ignite.apache.org/viewLog.html?buildId=8961647]]
{color:#d04437}Queries 3 (lazy=true){color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8961624]]
* IgniteBinaryCacheQueryLazyTestSuite3:
StatisticsConfigurationTest.testOrphanDataCleanup[persist=false] - Test has low
fail rate in base branch 0,0% and is not flaky
{color:#d04437}PDS 2{color} [[tests 0 Failure on metric
|https://ci2.ignite.apache.org/viewLog.html?buildId=8961604]]
{color:#d04437}Snapshots 2{color} [[tests 0 Failure on metric
|https://ci2.ignite.apache.org/viewLog.html?buildId=8961650]]
{color:#d04437}Snapshots 1{color} [[tests 0 Failure on metric
|https://ci2.ignite.apache.org/viewLog.html?buildId=8961630]]
{color:#d04437}Cache 6{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8961559]]
* IgniteCacheTestSuite6:
PartitionsExchangeAwareTest.testPartitionsExchangeAware - Test has low fail
rate in base branch 0,0% and is not flaky
{color:#d04437}Disk Page Compressions 2{color} [[tests 0 Failure on metric
|https://ci2.ignite.apache.org/viewLog.html?buildId=8961648]]
{color:#d04437}Continuous Query 4{color} [[tests
2|https://ci2.ignite.apache.org/viewLog.html?buildId=8961584]]
* IgniteCacheQuerySelfTestSuite6:
PerformanceStatisticsQueryTest.testSqlFieldsJoinQuery[pageSize=10,
clientType=CLIENT] - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteCacheQuerySelfTestSuite6:
PerformanceStatisticsQueryTest.testIndexQuery[pageSize=100, clientType=SERVER]
- Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Continuous Query 2{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8961582]]
* IgniteCacheQuerySelfTestSuite4:
CacheContinuousQueryFailoverAtomicReplicatedSelfTest.testUpdatePartitionCounter
- Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Queries 1{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8961619]]
* IgniteBinaryCacheQueryTestSuite:
H2DynamicTableSelfTest.testTableEnabledDynamicallyNotExistsIfCacheDestroyed -
Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Snapshots 3{color} [[tests 0 Failure on metric
|https://ci2.ignite.apache.org/viewLog.html?buildId=8961651]]
{panel}
{panel:title=Branch: [ignite-28331] Base: [master] : New Tests
(7)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
7|https://ci2.ignite.apache.org/viewLog.html?buildId=8961661]]
* {color:#013220}IgniteCalciteTestSuite3: SelectByKeyFieldTest.testSimplePk -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
SelectByKeyFieldTest.testCompositePkWithKeyTypeAndBinaryObject - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3: SelectByKeyFieldTest.testCompositePk
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
SelectByKeyFieldTest.testSimplePkAfterAddColumn - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
SelectByKeyFieldTest.testCompositePkAfterDropColumn - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
SelectByKeyFieldTest.testSimplePkAfterDropColumn - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
SelectByKeyFieldTest.testCompositePkAfterAddColumn - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8961676&buildTypeId=IgniteTests24Java8_RunAll]
> Fix SQL select by _key for a composite pk in Calcite engine
> -----------------------------------------------------------
>
> Key: IGNITE-28331
> URL: https://issues.apache.org/jira/browse/IGNITE-28331
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.17
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
> Labels: ignite-2
> Time Spent: 3.5h
> Remaining Estimate: 0h
>
> I discovered that for a simple pk (consisting of one column), queries like
> "select name from person where _key = ?" use the pk index with a single-value
> lookup.
> However, if the pk is composite, a full scan of the primary key index will be
> used. This is neither obvious nor efficient; this needs to be fixed for the
> Calcite engine.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
