Scheduled Reminder limited by Participant Role fails if any participant has multiple roles
Steps to replicate
- Register someone for the Rainforest Cup. Assign multiple roles.
- Create a scheduled reminder. Limit it by participant role. See screenshot below.
- Trigger the "Send Scheduled Reminders" job.
Expected Result
- Job doesn't crash.
Actual result
[nativecode=1292 ** Truncated incorrect DOUBLE value: '1^A2']"]
This happens because the WHERE clause is using IN
but for multi-valued fields you need REGEXP
or RLIKE
.