odbtools/odbctest/mql/aaa/21cross_ns/12valid.mql

-- ============================================================
-- 跨命名空间操作验证测试
-- ============================================================

-- 1. 跨命名空间查询
select * from /test/bbb/test_cross where x_name='cross_001'
/**
output()
**/
;

-- 2. 跨命名空间插入
insert into /test/bbb/test_cross (x_name, x_value) values ('cross_from_aaa', 999)
;

select * from /test/bbb/test_cross where x_name='cross_from_aaa'
/**
output()
**/
;

-- 3. 跨命名空间更新
update /test/bbb/test_cross set x_value=555 where x_name='cross_001'
;

select x_value from /test/bbb/test_cross where x_name='cross_001'
/**
output()
**/
;

-- 4. 跨命名空间删除
delete from /test/ccc/test_cross_another
/**
onerror(continue,'not exist','not find','not found')
**/
;

drop class if exists /test/ccc/test_cross_another
;

-- 5. 验证不存在的跨命名空间 class
select * from /test/bbb/non_exist_cross
/**
onerror(continue,'not exist','not find','not found')
**/
;