I'm connecting to Ignite via JDBC 10800, and trying to INSERT a row into a table, that has three columns.
- THE_KEY - MY_OTHER_ID - SOME_DATA If I try to insert a second record with the same value for THE_KEY, I get a regular SQL error telling me I'm trying to insert a duplicate. So far so good. But, when I start with an *empty* table, and do this: INSERT INTO MY_TABLE (THE_KEY, MY_OTHER_ID, SOME_DATA) SELECT ?, ?, ? WHERE NOT EXISTS (SELECT 1 from MY_TABLE WHERE MY_OTHER_ID = ?) I get an error that says: OperationError: 50000: Failed to INSERT some keys because they are already in cache [keys=[123]] Some additional facts: - Even though I get the message, it DOES insert the row - This does not happen when I connect to Ignite running on my local machine, only when I connect to one that is running on the cloud Any clues to what might be going on here? Thanks!
