You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
For a sharded insert query having on duplicate key update, if there is a list argument. It fails the query with missing bind var error from vttablet.
Reproduction Steps
take any sharded database and run a query having list argument in on duplicate key update
e.g. insert into user(name, col) values ('a', 2) on duplicate key update col = if(col in (1, 2), values(col), col)
Binary Version
v18, v19, main
Operating System and Environment details
NA
Log Fragments
No response
The text was updated successfully, but these errors were encountered:
Overview of the Issue
For a sharded insert query having on duplicate key update, if there is a list argument. It fails the query with
missing bind var
error from vttablet.Reproduction Steps
take any sharded database and run a query having list argument in on duplicate key update
e.g.
insert into user(name, col) values ('a', 2) on duplicate key update col = if(col in (1, 2), values(col), col)
Binary Version
Operating System and Environment details
Log Fragments
No response
The text was updated successfully, but these errors were encountered: