-- ============================================================
-- 基本子查询测试
-- ============================================================

-- 1. IN 子查询
select * from /test/aaa/test_subquery where s_name in (select s_name from /test/aaa/test_subquery where s_type='type_x')
/**
output()
match("subq_001")
match("subq_002")
**/
;

-- 2. NOT IN 子查询
select * from /test/aaa/test_subquery where s_name not in (select s_name from /test/aaa/test_subquery where s_type='type_x')
/**
output()
match("subq_003")
match("subq_004")
match("subq_005")
**/
;

-- 3. 子查询作为条件值
select * from /test/aaa/test_subquery where s_value > (select avg(s_value) from /test/aaa/test_subquery where s_type='type_x')
/**
output()
**/
;

-- 4. 子查询等于比较
select * from /test/aaa/test_subquery where s_value = (select max(s_value) from /test/aaa/test_subquery)
/**
output()
match("subq_005")
**/
;

-- 5. 多重子查询条件
select * from /test/aaa/test_subquery where s_value in (select s_value from /test/aaa/test_subquery where s_type='type_x' or s_type='type_y')
/**
output()
**/
;