ql/src/test/queries/clientnegative/semijoin4.q

--! qt:dataset:src
-- rhs table is a view and reference the view in where clause
select a.value from src a left semi join (select key , value from src where key > 100) b on a.key = b.key where b.value = 'val_108' ;