odbtools/odbctest/mql/aaa/22syntax/12case_sensitive.mql

-- ============================================================
-- Field Case Sensitive 测试
-- ============================================================

-- 1. 查询时使用正确大小写
select s_name, s_Value from /test/aaa/test_syntax where s_name='syntax_001'
/**
output()
match("s_Value","100")
**/
;

-- 2. 查询带不同大小写字段
select s_name, S_EXTRA from /test/aaa/test_syntax where s_name='syntax_001'
/**
output()
match("S_EXTRA","extra data")
**/
;

-- 3. 查询时使用混合大小写
select s_name, s_data from /test/aaa/test_syntax where s_name='syntax_002'
/**
output()
match("s_data","case sensitive data")
**/
;

-- 4. 更新大小写字段
update /test/aaa/test_syntax set S_EXTRA='UPDATED EXTRA' where s_name='syntax_001'
;

select S_EXTRA from /test/aaa/test_syntax where s_name='syntax_001'
/**
output()
match("S_EXTRA","UPDATED EXTRA")
**/
;