[IGNITE-7793] SQL does not work if value has sql field which name equals to affinity key name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3
• Fix Version/s: 2.8
• Component/s: sql
• Assignee: Maxim Pudov
• Reporter: Mikhail Cherkasov
• Created: 22/Feb/18 13:19
• Updated: 06/Nov/18 14:10
• Resolved: 06/Nov/18 14:10

Description

SQL does not work if value has index filed which name equals to affinity key name:

public class AKey {
    @AffinityKeyMapped
    int a;
    public AKey(int a) {
        this.a = a;
    }
}

public class AVal {
    @QuerySqlField
    int a;
    public AVal(int a) {
        this.a = a;
    }
}

AKey aKey = new AKey(1);
AVal aVal = new AVal(0);

IgniteCache<Object, Object> cache = ignite.cache("Instrument");
cache.put(aKey, aVal);

SqlFieldsQuery query = new SqlFieldsQuery("select * from \"Instrument\".AVal it where it.a=?");

List<List<?>> res = cache.query(query.setArgs(0)).getAll();

if(res.isEmpty()) {
    System.out.println("!!!!!!!!! FAILED !!!!!!!!!!!");
}

Issue Links

• links to: GitHub Pull Request #4770