Bug Report: opcode MultiEqual not supported for VindexLookup during query

[arthurschreiber]

Overview of the Issue

On sharded tables utilizing lookup vindexes certain queries will fail with:

ERROR 1815 (HY000): opcode MultiEqual not supported for VindexLookup

Reproduction Steps

• issues is a sharded table
• issues.id is a lookup vindex column.
• issues.user_id is a regular column.

SELECT issues.* FROM issues WHERE ((id = 1 AND user_id = 1) OR (id = 2 AND user_id = 2) OR (id = 3 AND user_id = 3));

Empty set (0.00 sec)

SELECT issues.* FROM issues WHERE ((id = 1 AND user_id = 1) OR (id = 2 AND user_id = 2) OR (id = 3 AND user_id = 3) OR (id = 4 AND user_id = 4));

ERROR 1815 (HY000): opcode MultiEqual not supported for VindexLookup

Binary Version

v19

Operating System and Environment details

N/A

Log Fragments

N/A