[
https://issues.apache.org/jira/browse/IGNITE-7793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16669830#comment-16669830
]
Ignite TC Bot commented on IGNITE-7793:
---------------------------------------
{panel:title=No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
[TeamCity Run All
Results|http://ci.ignite.apache.org/viewLog.html?buildId=2192122&buildTypeId=IgniteTests24Java8_RunAll]
> SQL does not work if value has sql field 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
> Assignee: Maxim Pudov
> Priority: Major
> Fix For: 2.8
>
>
> 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)
