Taras Ledkov created IGNITE-12590:
-------------------------------------
Summary: 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
Fix For: 2.9
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)
