You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2021/10/02 08:37:00 UTC
[jira] [Commented] (IGNITE-15522) IndexQuery should perform index
scan if no criteria set
[ https://issues.apache.org/jira/browse/IGNITE-15522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17423489#comment-17423489 ]
Ignite TC Bot commented on IGNITE-15522:
----------------------------------------
{panel:title=Branch: [pull/9463/head] Base: [master] : Possible Blockers (20)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Cache 7{color} [[tests 1 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6206082]]
* IgniteCacheTestSuite7: GridCacheDhtPreloadWaitForBackupsWithPersistenceTest.testNodeLeavesRebalanceCompletesTransactionalPartitioned - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Cache 2{color} [[tests 4 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6206077]]
* IgniteCacheTestSuite2: IgniteCacheIncrementTxTest.testIncrementTxTopologyChange0 - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteCacheTestSuite2: IgniteCacheIncrementTxTest.testIncrementTxTopologyChange1 - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteCacheTestSuite2: IgniteCacheIncrementTxTest.testIncrementTxTopologyChange2 - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteCacheTestSuite2: NearCacheSyncUpdateTest.testNearCacheSyncUpdateTx - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Queries 2{color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=6206046]]
* IgniteBinaryCacheQueryTestSuite2: DynamicIndexReplicatedAtomicConcurrentSelfTest.testConcurrentOperationsAndCacheStartStopMultithreaded - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteBinaryCacheQueryTestSuite2: DynamicColumnsConcurrentTransactionalReplicatedSelfTest.testConcurrentOperationsAndNodeStartStopMultithreaded - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Thin client: Node.js{color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6206116]]
{color:#d04437}PDS 4{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6206094]]
* IgnitePdsTestSuite4: IgnitePdsDefragmentationTest.testFailoverRestartWithoutDefragmentation - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Basic 3{color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=6206061]]
* IgniteBasicWithPersistenceTestSuite: IgniteSnapshotManagerSelfTest.testSnapshotCreateLocalCopyPartitionFail - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteBasicWithPersistenceTestSuite: IgniteSnapshotManagerSelfTest.testSnapshotIteratorRandomizedLoader - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Cache 1{color} [[tests 2 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6206076]]
* IgniteBinaryCacheTestSuite: GridCacheJdbcBlobStoreMultithreadedSelfTest.testMultithreadedPutAll - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteBinaryCacheTestSuite: GridCacheJdbcBlobStoreMultithreadedSelfTest.testMultithreadedExplicitTx - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Platform .NET{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6206095]]
* exe: CacheTest.TestCacheWithExpiryPolicyOnCreate - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Platform C++ (Win x64 / Release){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6206059]]
* IgniteThinClientTest: CacheClientTestSuite: CacheClientPartitionsDisabledThreeNodes - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Index Query API{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6206121]]
* IndexQueryTestSuite: MultifieldIndexQueryTest.testCheckBoundaries[nodesCnt=2 qryIdx=TEST_IDX] - Test has low fail rate in base branch 0,0% and is not flaky
{color:#d04437}Thin Client: Java{color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6206042]]
{panel}
{panel:title=Branch: [pull/9463/head] Base: [master] : New Tests (42)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}PDS 2{color} [[tests 30|https://ci.ignite.apache.org/viewLog.html?buildId=6206092]]
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testReReadWhenStateWasNotStored[specificConsistentId=false, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testMultiNodeConsumption[specificConsistentId=false, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testCdcSingleton[specificConsistentId=false, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testMultiNodeConsumption[specificConsistentId=true, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testCdcSingleton[specificConsistentId=true, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testReadAllKeys[specificConsistentId=false, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testReadBeforeGracefulShutdown[specificConsistentId=false, walMode=FSYNC, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testMultiNodeConsumption[specificConsistentId=true, walMode=BACKGROUND, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testCdcSingleton[specificConsistentId=true, walMode=BACKGROUND, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testReadAllKeys[specificConsistentId=false, walMode=BACKGROUND, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
* {color:#013220}IgnitePdsTestSuite2: CdcSelfTest.testReadBeforeGracefulShutdown[specificConsistentId=false, walMode=BACKGROUND, metricExporter=org.apache.ignite.cdc.CdcSelfTest$$Lambda$17/952754390@36327cec] - PASSED{color}
... and 19 new tests
{color:#00008b}Index Query API{color} [[tests 12|https://ci.ignite.apache.org/viewLog.html?buildId=6206121]]
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testNonIndexedFieldFilter[idxName=IDX] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testFilterException[idxName=IDX] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testIndexedFieldFilter[idxName=IDX] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testKeyFilter[idxName=IDX] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testValueFilter[idxName=IDX] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testAllowOrDisallowAll[idxName=IDX] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testIndexedFieldFilter[idxName=null] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testKeyFilter[idxName=null] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testValueFilter[idxName=null] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testAllowOrDisallowAll[idxName=null] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryFilterTest.testNonIndexedFieldFilter[idxName=null] - PASSED{color}
... and 1 new tests
{panel}
[TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6206122&buildTypeId=IgniteTests24Java8_RunAll]
> IndexQuery should perform index scan if no criteria set
> -------------------------------------------------------
>
> Key: IGNITE-15522
> URL: https://issues.apache.org/jira/browse/IGNITE-15522
> Project: Ignite
> Issue Type: New Feature
> Reporter: Maksim Timonin
> Assignee: Maksim Timonin
> Priority: Major
> Labels: IEP-71
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Currently impossible to return full index range with existing IndexQuery criteria. There are workarounds like `lte(Integer.MAX_VALUE)`. But it will be much better enable index scan by default if not criteria set. It's useful by reasons:
> # In some cases IndexQuery is faster then ScanQuery. Then IndexQuery should have same API as ScanQuery for such cases - new IndexQuery(tbl, idxName)
> # IndexQuery criteria performs AND operation. There is no way to set OR. setFilter is only way to specify custom rule non-AND rule for IndexQuery. So we need allow to use only filter without any criteria.
>
> If index name isn't specified then IndexQuery should take PK index of specified table.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)