odbtools/odbctest/mql/aaa/20subquery/11basic.mql

-- ============================================================
-- 基本子查询测试（跳过：服务器 parser 不支持子查询）
-- ============================================================

-- 1. IN 子查询（服务器不支持 IN (select ...)）
select * from /test/aaa/test_subquery where s_name in (select s_name from /test/aaa/test_subquery where s_type='type_x')
/**
onerror(continue,"After '... ere s_name in ('")
output()
**/
;

-- 2. NOT IN 子查询（服务器不支持 NOT IN (select ...)）
select * from /test/aaa/test_subquery where s_name not in (select s_name from /test/aaa/test_subquery where s_type='type_x')
/**
onerror(continue,"After '","s_name not in ('")
output()
**/
;

-- 3. 子查询作为条件值（服务器可能不支持）
select * from /test/aaa/test_subquery where s_value > (select avg(s_value) from /test/aaa/test_subquery where s_type='type_x')
/**
onerror(continue,"After '","(select")
output()
**/
;

-- 4. 子查询等于比较（服务器可能不支持）
select * from /test/aaa/test_subquery where s_value = (select max(s_value) from /test/aaa/test_subquery)
/**
onerror(continue,"After '","(select")
output()
**/
;

-- 5. 多重子查询条件（服务器不支持 IN (select ...)）
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')
/**
onerror(continue,"After '","s_value in ('")
output()
**/
;