odbtools/odbctest/mql/aaa/12search/16notin.mql

-- ============================================================
-- Not In 查询测试
-- ============================================================

-- 1. int not in
select * from /test/aaa/test_search where s_int not in (10, 20)
/**
output()
**/
;

-- 2. float not in
select * from /test/aaa/test_search where s_int not in (1, 2, 3)
/**
output()
**/
;

-- 3. string not in
select * from /test/aaa/test_search where s_name not in ('search_int_001', 'search_int_002')
/**
output()
**/
;

-- 4. not in 空集合
select * from /test/aaa/test_search where s_name not in ('')
/**
output()
**/
;

-- 5. not in 全部排除
select * from /test/aaa/test_search where s_name not in ('non_exist_1', 'non_exist_2')
/**
output()
**/
;