odbtools/odbctest/mql/aaa/16partition/12multi.mql

-- ============================================================
-- 多分区测试
-- ============================================================

-- 1. 插入多分区数据
insert into /test/aaa/test_mpartition (m_id, m_name, m_value) values (1, 'cat_a', 100)
;

insert into /test/aaa/test_mpartition (m_id, m_name, m_value) values (1, 'cat_b', 200)
;

insert into /test/aaa/test_mpartition (m_id, m_name, m_value) values (2, 'cat_a', 300)
;

insert into /test/aaa/test_mpartition (m_id, m_name, m_value) values (2, 'cat_b', 400)
;

-- 2. 按第一分区查询
select * from /test/aaa/test_mpartition where m_id=1
/**
output()
**/
;

-- 3. 按多分区联合查询
select * from /test/aaa/test_mpartition where m_id=1 and m_name='cat_a'
/**
output()
**/
;

-- 4. 全表查询
select * from /test/aaa/test_mpartition
/**
output()
**/
;

-- 5. 更新多分区数据
update /test/aaa/test_mpartition set m_value=150 where m_id=1 and m_name='cat_a'
;

select m_value from /test/aaa/test_mpartition where m_id=1 and m_name='cat_a'
/**
output()
**/
;

-- 6. 多分区聚合
select m_id, m_name, count(*) from /test/aaa/test_mpartition group by m_id, m_name
/**
output()
**/
;