ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikhail Cherkasov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-7793) SQL does not work if value has index filed which name equals to affinity key name
Date Thu, 22 Feb 2018 13:20:00 GMT
Mikhail Cherkasov created IGNITE-7793:
-----------------------------------------

             Summary: SQL does not work if value has index filed which name equals to affinity
key name
                 Key: IGNITE-7793
                 URL: https://issues.apache.org/jira/browse/IGNITE-7793
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.3
            Reporter: Mikhail Cherkasov
             Fix For: 2.5


SQL does not work if value has index filed which name equals to affinity key name:
{code:java}
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 !!!!!!!!!!!");
}


{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message