ERROR 1706 (HY000): Leaf Error (127. 0. 0. 1:3307): Feature INSERT IGNORE … ON DUPLICATE KEY UPDATE is not supported by MemSQL
Issue
When you use the IGNORE
modifier in a INSERT
statement, SingleStore ignores records with duplicate key entries and only inserts records with unique key values.ON DUPLICATE KEY UPDATE
clause, instead of ignoring the insert, performs an update on the row with the duplicate key value.
Solution
Either use the IGNORE
modifier or ON DUPLICATE KEY UPDATE
clause in INSERT
statements, but not both.
Last modified: July 5, 2021