odbtools/odbctest/mql/aaa/19extensions/27result_check.mql

-- ============================================================
-- count(N) equal(N,F,V) match(Kn,Mn) matchcount(Kn,Mn,N) 测试
-- ============================================================

-- 1. count(N) - 结果行数检查
select * from /test/aaa/test_ext where e_name prefix 'ext'
/**
count(3)
**/
;

-- 2. count(N) - 精确匹配
select e_name from /test/aaa/test_ext where e_name='ext_001'
/**
count(1)
**/
;

-- 3. match(Kn,Mn) 匹配第一行第一列
select e_name from /test/aaa/test_ext where e_name='ext_001'
/**
output()
match("e_name","ext_001")
**/
;

-- 4. match(Kn,Mn) 匹配第N行第N列
select e_name, e_value from /test/aaa/test_ext where e_name prefix 'ext'
/**
output()
match("ext_001","1")
**/
;

-- 5. matchcount(Kn,Mn,N) 匹配计数
select e_name from /test/aaa/test_ext where e_name prefix 'ext'
/**
output()
matchcount("e_name","ext_",3)
**/
;

-- 6. equal(N,F,V) 第N行第F列等于V
select e_name, e_value from /test/aaa/test_ext where e_name='ext_001'
/**
output()
equal(1,2,1)
**/
;

select e_name, e_value from /test/aaa/test_ext where e_name='ext_002'
/**
output()
equal(1,2,2)
**/
;