925
925
#select ROW(1, 1, 'a') IN (select a,b,c from t1 where c='b' or c='a');
926
926
#select ROW(1, 2, 'a') IN (select a,b,c from t1 where c='b' or c='a');
927
927
#select ROW(1, 1, 'a') IN (select b,a,c from t1 where c='b' or c='a');
929
929
#select ROW(1, 1, 'a') IN (select b,a,c from t1 limit 2);
931
931
#test of uncacheable subqueries