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 2020/07/22 09:39:00 UTC
[jira] [Commented] (IGNITE-13280) Improper index usage, fields
enumeration not used with pk index creation.
[ https://issues.apache.org/jira/browse/IGNITE-13280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17162645#comment-17162645 ]
Ignite TC Bot commented on IGNITE-13280:
----------------------------------------
{panel:title=Branch: [pull/8067/head] Base: [master] : Possible Blockers (1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}PDS (Indexing){color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=5483698]]
{panel}
{panel:title=Branch: [pull/8067/head] Base: [master] : New Tests (12)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5483700]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexMultinodeTest.testConditionsWithoutIndexes - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexTest.testConditionsWithoutIndexes - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexMultinodeTest.testCheckThreeFieldsInPk - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexTest.testCheckThreeFieldsInPk - PASSED{color}
{color:#00008b}Service Grid (legacy mode){color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5482940]]
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=33e51432-b32d-4ca7-9393-8e55e18383c6, topVer=0, msgTemplate=null, span=null, nodeId8=a0f49b7c, msg=, type=NODE_JOINED, tstamp=1595360276351], val2=AffinityTopologyVersion [topVer=4212389184898639918, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=33e51432-b32d-4ca7-9393-8e55e18383c6, topVer=0, msgTemplate=null, span=null, nodeId8=a0f49b7c, msg=, type=NODE_JOINED, tstamp=1595360276351], val2=AffinityTopologyVersion [topVer=4212389184898639918, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=38fe1e27371-b96ff4ea-5ea5-41b7-9ede-976441be1444, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=5cca31fe-ec84-4eb5-925c-2bba985df1cf, topVer=0, msgTemplate=null, span=null, nodeId8=5cca31fe, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1595360276351]], val2=AffinityTopologyVersion [topVer=8399228418209159273, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=38fe1e27371-b96ff4ea-5ea5-41b7-9ede-976441be1444, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=5cca31fe-ec84-4eb5-925c-2bba985df1cf, topVer=0, msgTemplate=null, span=null, nodeId8=5cca31fe, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1595360276351]], val2=AffinityTopologyVersion [topVer=8399228418209159273, minorTopVer=0]]] - PASSED{color}
{color:#00008b}Service Grid{color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5482939]]
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=51f1051a-25fe-4ae6-8456-53f8dd604e34, topVer=0, msgTemplate=null, span=null, nodeId8=f9b640a2, msg=, type=NODE_JOINED, tstamp=1595360216802], val2=AffinityTopologyVersion [topVer=7972440667466994383, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=51f1051a-25fe-4ae6-8456-53f8dd604e34, topVer=0, msgTemplate=null, span=null, nodeId8=f9b640a2, msg=, type=NODE_JOINED, tstamp=1595360216802], val2=AffinityTopologyVersion [topVer=7972440667466994383, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=6e601e27371-7c60b1e3-e1f2-4f02-b36e-8416688d0e01, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=1bef19f9-6448-40cb-8b35-7af2b7999e61, topVer=0, msgTemplate=null, span=null, nodeId8=1bef19f9, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1595360216802]], val2=AffinityTopologyVersion [topVer=-97273456154309028, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=6e601e27371-7c60b1e3-e1f2-4f02-b36e-8416688d0e01, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=1bef19f9-6448-40cb-8b35-7af2b7999e61, topVer=0, msgTemplate=null, span=null, nodeId8=1bef19f9, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1595360216802]], val2=AffinityTopologyVersion [topVer=-97273456154309028, minorTopVer=0]]] - PASSED{color}
{panel}
[TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=5482962&buildTypeId=IgniteTests24Java8_RunAll]
> Improper index usage, fields enumeration not used with pk index creation.
> -------------------------------------------------------------------------
>
> Key: IGNITE-13280
> URL: https://issues.apache.org/jira/browse/IGNITE-13280
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.8.1
> Reporter: Stanilovsky Evgeny
> Assignee: Stanilovsky Evgeny
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> For example:
> {code:java}
> CREATE TABLE PUBLIC.TEST_TABLE (FIRST_NAME VARCHAR, LAST_NAME VARCHAR, ADDRESS VARCHAR, LANG VARCHAR, CONSTRAINT PK_PERSON PRIMARY KEY (FIRST_NAME, LAST_NAME));
> CREATE INDEX "idx2" ON PUBLIC.TEST_TABLE (LANG, ADDRESS);
> {code}
> and further explain:
> {code:java}
> SELECT
> "__Z0"."FIRST_NAME" AS "__C0_0",
> "__Z0"."LAST_NAME" AS "__C0_1",
> "__Z0"."ADDRESS" AS "__C0_2",
> "__Z0"."LANG" AS "__C0_3"
> FROM "PUBLIC"."TEST_TABLE" "__Z0"
> /* PUBLIC.IDX2: ADDRESS > 0 */
> WHERE "__Z0"."ADDRESS" > 0
> {code}
> this is erroneous to use "idx2" here, because first index field LANG not equals to predicate ADDRESS.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)