odbtools/odbctest/mql/aaa/19extensions/19format_escape.mql

-- ============================================================
-- {%%...,...} 转义、{%s,varname} 格式化测试
-- ============================================================

-- 1. {%s,varname} 字符串格式化
/**
beforerun(set(my_str, 'formatted_string_value'))
**/
;

insert into /test/aaa/test_ext (e_name, e_text) values ('var_str_fmt', {%s,my_str})
;

select e_name, e_text from /test/aaa/test_ext where e_name='var_str_fmt'
/**
output()
match("e_text","formatted_string_value")
**/
;

-- 2. {%%...,...} 转义避免被替换
insert into /test/aaa/test_ext (e_name, e_text) values ('var_escape', '{%%now,now}')
;

select e_name, e_text from /test/aaa/test_ext where e_name='var_escape'
/**
output()
**/
;

-- 3. 多个格式化组合
/**
beforerun(set(fmt_num, 42), set(fmt_str, 'answer'))
**/
;

insert into /test/aaa/test_ext (e_name, e_text) values (concat('var_combo_', {%d,fmt_num}), concat({%s,fmt_str}, ' = ', {%d,fmt_num}))
;

select e_name, e_text from /test/aaa/test_ext where e_name prefix 'var_combo'
/**
output()
**/
;