vreplication: can't filter using IN or OR

[derekperkins]

Pretty straightforward from the title. With all the recent enhancements vreplication and evalengine (not sure if this is actually used in vrep), I expected to be able to filter vreplication for multiple values, since I can already filter for single values. It seems like overkill to have to specify 3 separate vreplication streams for 3 separate values.

VReplication using IN:

SELECT event_id AS id, workspace_id as keyspace_id, reward_id, event_type 
FROM users_rewards__events 
WHERE event_type IN (3,7,8)

Error:

vttablet: rpc error: code = Unknown desc = comparison operator in not supported

VReplication using OR:

SELECT event_id AS id, workspace_id as keyspace_id, reward_id, event_type 
FROM users_rewards__events 
WHERE event_type event_type=3 OR event_type=7 OR event_type=8

Error:

vttablet: rpc error: code = Unknown desc = unsupported constraint: event_type = 3 or event_type = 7 or event_type = 8

Materialize config:

{
  "workflow": "billing__coupon_syncer__msgs",
  "source_keyspace": "iam",
  "target_keyspace": "workspaces",
  "table_settings": [
    {
      "target_table": "billing__chargebee_coupon_syncer__msgs",
      "source_expression": "SELECT event_id AS id, workspace_id as keyspace_id, reward_id, event_type FROM users_rewards__events WHERE event_type=3 OR event_type=7 OR event_type=8"
    }
  ],
  "tablet_types": "REPLICA"
}

Related Issues:

• materialize: query plan error when referencing same column multiple times #9314
• evalengine: Coercion, LIKE, IN optimization #9286
• evalengine: Support all built-in MySQL functions #9647
• Support for (more advanced) where clause in VReplication #7548

Version: > v13 - pretty close to current main on 2022-04-11