Subject: | IN operator breaks WHERE clause |
The "Where Clauses" section on the manpage has examples where arrays
are used for operator and value pairs:
age=>['>',26]
This works for most operatros, but the extremely popular and useful operator 'IN' breaks!
age=>['IN', "(26, 36, 46)" ] fails because the parentheses don't work in the substitution. DBIx::Abstract should check if the 'IN' operator is requested, and provide parentheses around the (?) substitution.
Better yet, it would be nice if
age=>['IN', "val1", "val2", "val3", ... ] was made to work for more flexibility and ease of use.
Thank you,
Alex Manousakis