Queries having the form
select * from t1 where (a+1, b) IN ((1,1),(2,2),(3,3));
where a+1 is a virtual column will now be optimized to use that
virtual column such that the above becomes
select * from t1 where (vcol, b) IN ((1,1),(2,2),(3,3));
In general, vcol substitution will occur when a row itself contains
the matching vcol expression. The optimizer will not only inspect
the left-hand argument to IN for the matching expression, but will
also unpack and inspect the left-hand argument when it is a row.
