[
https://issues.apache.org/jira/browse/IGNITE-13280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17181127#comment-17181127
]
Ignite TC Bot commented on IGNITE-13280:
----------------------------------------
{panel:title=Branch: [pull/8067/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/8067/head] Base: [master] : New Tests
(14)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests
6|https://ci.ignite.apache.org/viewLog.html?buildId=5553674]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
BasicIndexMultinodeTest.testConditionsWithoutIndexes - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
BasicIndexTest.testConditionsWithoutIndexes - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
BasicIndexMultinodeTest.testConditionsWithoutIndexesUseProxy - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
BasicIndexTest.testConditionsWithoutIndexesUseProxy - 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=5553681]]
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple
[val1=DiscoveryEvent [evtNode=64bf00c4-e712-4505-add8-7a6fd95167fa, topVer=0,
msgTemplate=null, span=null, nodeId8=c4750e94, msg=, type=NODE_JOINED,
tstamp=1597851419903], val2=AffinityTopologyVersion [topVer=-65794973751089851,
minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple
[val1=DiscoveryEvent [evtNode=64bf00c4-e712-4505-add8-7a6fd95167fa, topVer=0,
msgTemplate=null, span=null, nodeId8=c4750e94, msg=, type=NODE_JOINED,
tstamp=1597851419903], val2=AffinityTopologyVersion [topVer=-65794973751089851,
minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple
[val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest
[id=7b9b7670471-e45b3f62-1f3c-4ef1-819c-a2d1699ca4de, reqs=SingletonList
[ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent
[evtNode=5ad9fbf2-f260-4add-95c4-6965cf3f78ef, topVer=0, msgTemplate=null,
span=null, nodeId8=5ad9fbf2, msg=null, type=DISCOVERY_CUSTOM_EVT,
tstamp=1597851419903]], val2=AffinityTopologyVersion
[topVer=-2235269353933157706, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple
[val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest
[id=7b9b7670471-e45b3f62-1f3c-4ef1-819c-a2d1699ca4de, reqs=SingletonList
[ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent
[evtNode=5ad9fbf2-f260-4add-95c4-6965cf3f78ef, topVer=0, msgTemplate=null,
span=null, nodeId8=5ad9fbf2, msg=null, type=DISCOVERY_CUSTOM_EVT,
tstamp=1597851419903]], val2=AffinityTopologyVersion
[topVer=-2235269353933157706, minorTopVer=0]]] - PASSED{color}
{color:#00008b}Service Grid{color} [[tests
4|https://ci.ignite.apache.org/viewLog.html?buildId=5553680]]
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple
[val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest
[id=f5ad5670471-cb6ca029-6274-41bf-af9a-4ec0ab642620, reqs=SingletonList
[ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent
[evtNode=76b18b79-ac16-4bde-8267-4b8d7d54b525, topVer=0, msgTemplate=null,
span=null, nodeId8=76b18b79, msg=null, type=DISCOVERY_CUSTOM_EVT,
tstamp=1597851293896]], val2=AffinityTopologyVersion
[topVer=-7957148310194363136, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple
[val1=DiscoveryEvent [evtNode=e24c6d69-cc8d-4e1d-8301-caa00b06d2dd, topVer=0,
msgTemplate=null, span=null, nodeId8=42673d37, msg=, type=NODE_JOINED,
tstamp=1597851293896], val2=AffinityTopologyVersion
[topVer=3906886151728009981, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple
[val1=DiscoveryEvent [evtNode=e24c6d69-cc8d-4e1d-8301-caa00b06d2dd, topVer=0,
msgTemplate=null, span=null, nodeId8=42673d37, msg=, type=NODE_JOINED,
tstamp=1597851293896], val2=AffinityTopologyVersion
[topVer=3906886151728009981, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite:
ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple
[val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest
[id=f5ad5670471-cb6ca029-6274-41bf-af9a-4ec0ab642620, reqs=SingletonList
[ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent
[evtNode=76b18b79-ac16-4bde-8267-4b8d7d54b525, topVer=0, msgTemplate=null,
span=null, nodeId8=76b18b79, msg=null, type=DISCOVERY_CUSTOM_EVT,
tstamp=1597851293896]], val2=AffinityTopologyVersion
[topVer=-7957148310194363136, minorTopVer=0]]] - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci.ignite.apache.org/viewLog.html?buildId=5553703&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.
> Looks like this bug brings this ticket [1]
> [1] https://issues.apache.org/jira/browse/IGNITE-10217
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
