insert ... on duplicate key update has some bug

[maxiaoguang64]

sql like that insert into table(id, name) values (1, ?)on duplicate key update name = ?
when parameter after on duplicate key update that has some bug

[terrymanu]

Is any relationship of this issue and #1105? @AIKiller

[maxiaoguang64]

I won't to fix after careful consideration
l don't think it possible that use placeholder in update clause
usually, we use insert ... update like this
1、insert into table (name, version) values (?, ?) on duplicate key update version = version + 1
2、insert into table (name) values (?), (?) on duplicate key update version = values(name)

[victormferrara]

Hi! Just FYI it is possible to use the placeholder in the update clause but as you say the common usage is just to use the values keyword or similar.

Cheers!

[giantoneday]

您好，我也遇到了相同的问题，insert on duplicate key update是一个非常重要的功能，尤其是对于后台的增删改查来说。请看下能否支持？　谢谢。　
Hello, I came across the same problem, "insert on duplicate key update" is an important feature in MySQL, especially for some admin operations. I sincerely hope that sharding-jdbc can support it, thanks very much.

[terrymanu]

For English only, other languages will not accept.