[ https://issues.apache.org/jira/browse/IGNITE-15263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17410700#comment-17410700 ]
Ignite TC Bot commented on IGNITE-15263: ---------------------------------------- {panel:title=Branch: [pull/9338/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel} {panel:title=Branch: [pull/9338/head] Base: [master] : New Tests (37)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1} {color:#00008b}Queries 1{color} [[tests 37|https://ci.ignite.apache.org/viewLog.html?buildId=6167309]] * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinPartitionPruningSelfTest.testSimpleJoin[createWithSql = true] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithAnnotationAffinityKeyMapped[join=JOIN] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithAnnotationAffinityKeyMapped[join=INNER JOIN] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithAnnotationAffinityKeyMapped[join=RIGHT JOIN] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinPartitionPruningSelfTest.testPartitionTransfer[createWithSql = true] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinPartitionPruningSelfTest.testJoinWithReplicated[createWithSql = true] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinPartitionPruningSelfTest.testOuterJoin[createWithSql = true] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinPartitionPruningSelfTest.testExplicitPartitions[createWithSql = true] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithAnnotationAffinityKeyMapped[join=LEFT JOIN] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinQueryEntityPartitionPruningSelfTest.testJoinWithDifferentAffinityFunctions[createWithSql = false] - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: JoinQueryEntityPartitionPruningSelfTest.testPkAliasJoin[createWithSql = false] - PASSED{color} ... and 26 new tests {panel} [TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6167197&buildTypeId=IgniteTests24Java8_RunAll] > Setting name in QuerySqlField on affinity field broke affinity awareness in > sql. > -------------------------------------------------------------------------------- > > Key: IGNITE-15263 > URL: https://issues.apache.org/jira/browse/IGNITE-15263 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 2.10 > Reporter: Ivan Daschinsky > Assignee: Maksim Timonin > Priority: Major > Attachments: AffinityKeyTest.java > > Time Spent: 10m > Remaining Estimate: 0h > > If you set affinity key on sql indexed cache and set aliases to affinity > field, i.e. > {code:java} > public static class PersonKey { > @QuerySqlField > public Integer id; > @QuerySqlField(name = "city_id") > @AffinityKeyMapped > public Integer cityId; > public PersonKey(Integer id, Integer cityId) { > this.id = id; > this.cityId = cityId; > } > } > .... > CacheConfiguration config = new CacheConfiguration<PersonKey, > Person>("person") > .setIndexedTypes(PersonKey.class, Person.class) > .setSqlSchema("PUBLIC") > ); > {code} > {{affinityKeyColumn}} calulation fails in {{GridH2Table}} and simply not > works as expected. > {{org.apache.ignite.internal.processors.query.QueryUtils#typeForQueryEntity}} > should be fixed to take into account > aliases and set properly {{affinityKeyColumn}} in descriptor. > Without aliases all works as expected. > Reproducer of subj is attached. -- This message was sent by Atlassian Jira (v8.3.4#803005)