[ https://issues.apache.org/jira/browse/IGNITE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17035240#comment-17035240 ]
Ivan Pavlukhin commented on IGNITE-12590: ----------------------------------------- [~tledkov-gridgain], I added a couple of comments on [GitHub|https://github.com/apache/ignite/pull/7321], everything else looks good. > MERGE INTO query is failing on Ignite client node > ------------------------------------------------- > > Key: IGNITE-12590 > URL: https://issues.apache.org/jira/browse/IGNITE-12590 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 2.7 > Reporter: Taras Ledkov > Assignee: Taras Ledkov > Priority: Major > Fix For: 2.9 > > Time Spent: 0.5h > Remaining Estimate: 0h > > Precondition: server nodes (any amount), webconsole is running. > 1. Create the table as following: > CREATE TABLE USERPUBSTATICDATA (BOOK VARCHAR, DESK VARCHAR, TRADERS VARCHAR, > REGION VARCHAR, LOB VARCHAR, EXCLUDE VARCHAR, TRANSIT VARCHAR, > MAPBOOKTOTHISBOOK VARCHAR, CONSTRAINT USERPUBSTATICDATA_PK PRIMARY KEY > (BOOK,DESK)) WITH "template=replicated" > 2. Execute merge into query: > MERGE INTO USERPUBSTATICDATA(BOOK, DESK, TRADERS, REGION, LOB, EXCLUDE, > TRANSIT, MAPBOOKTOTHISBOOK) VALUES('CADOIS', 'FRT TOR', 'Robin Das/Dave > Carlson', 'Toronto', 'FRT', null, null, 'CADOIS'); > Step 2 is successfull on Web Console and called on IgniteCache from the > server node, but fails when called from the Ignite client node with exception: > {code} > javax.cache.CacheException: Invalid column name in KEYS clause of MERGE - it > may include only key and/or affinity columns: BOOK > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)