-- 20subquery 目录初始化：子查询测试

create class if not exists /test/aaa/test_subquery (
    s_name      varchar,
    s_type      varchar,
    s_value     int,

    indexes(s_name, s_type, s_value),
    keys(s_name)
)
;

-- 插入子查询测试数据
insert into /test/aaa/test_subquery (s_name, s_type, s_value) values ('subq_001', 'type_x', 100)
;

insert into /test/aaa/test_subquery (s_name, s_type, s_value) values ('subq_002', 'type_x', 200)
;

insert into /test/aaa/test_subquery (s_name, s_type, s_value) values ('subq_003', 'type_y', 300)
;

insert into /test/aaa/test_subquery (s_name, s_type, s_value) values ('subq_004', 'type_y', 400)
;

insert into /test/aaa/test_subquery (s_name, s_type, s_value) values ('subq_005', 'type_z', 500)
;