odbtools/odbctest/mql/aaa/22syntax/11relaxed.mql

-- ============================================================
-- Relaxed Syntax 测试
-- ============================================================

-- 1. 使用类名不带 namespace（relaxed syntax）
select * from test_syntax where s_name='syntax_001'
/**
output()
count(1)
**/
;

-- 2. 使用完整 namespace
select * from /test/aaa/test_syntax where s_name='syntax_001'
/**
output()
count(1)
**/
;

-- 3. relaxed syntax insert
insert into test_syntax (s_name, s_Value, s_data) values ('syntax_relaxed', 999, 'relaxed insert')
;

select * from test_syntax where s_name='syntax_relaxed'
/**
output()
count(1)
match("s_Value","999")
**/
;

-- 4. relaxed syntax update
update test_syntax set s_data='relaxed updated' where s_name='syntax_relaxed'
;

select s_data from test_syntax where s_name='syntax_relaxed'
/**
output()
match("s_data","relaxed updated")
**/
;

-- 5. relaxed syntax delete
delete from test_syntax where s_name='syntax_relaxed'
;

select * from test_syntax where s_name='syntax_relaxed'
/**
output()
count(0)
**/
;