odbtools/odbctest/mql/aaa/11data_crud/14delete.mql

-- ============================================================
-- Delete 删除操作测试
-- ============================================================

-- 1. 基本 delete - 条件删除
insert into /test/aaa/test_basic (name, v_text, v_int)
values ('to_delete_001', 'will be deleted', 1)
;

select name from /test/aaa/test_basic where name='to_delete_001'
/**
output()
count(1)
**/
;

delete from /test/aaa/test_basic where name='to_delete_001'
/**
output()
count(1)
**/
;

-- 验证已删除
select name from /test/aaa/test_basic where name='to_delete_001'
/**
output()
count(0)
**/
;

-- 2. 删除不存在的记录
delete from /test/aaa/test_basic where name='non_exist_delete_999'
/**
output()
count(0)
**/
;

-- 3. 多次删除同一记录
insert into /test/aaa/test_basic (name, v_text, v_int)
values ('to_delete_002', 'delete twice test', 2)
;

delete from /test/aaa/test_basic where name='to_delete_002'
;

-- 第二次删除应返回 count(0)
delete from /test/aaa/test_basic where name='to_delete_002'
/**
output()
count(0)
**/
;

-- 4. 删除 version 表数据
insert into /test/aaa/test_basic_ver (name, value) values ('del_ver', 1)
;

delete from /test/aaa/test_basic_ver where name='del_ver'
;

select * from /test/aaa/test_basic_ver where name='del_ver'
/**
output()
count(0)
**/
;

-- 5. 带复合条件的删除
insert into /test/aaa/test_basic (name, v_text, v_int)
values ('to_delete_003', 'complex condition', 100)
;

delete from /test/aaa/test_basic where name='to_delete_003' and v_int=100
;

select * from /test/aaa/test_basic where name='to_delete_003'
/**
output()
count(0)
**/
;

-- 6. with version 删除（清表）
insert into /test/aaa/test_basic (name, v_text, v_int)
values ('to_delete_004', 'with version delete', 4)
;

delete from /test/aaa/test_basic where name='to_delete_004' with version
;

select * from /test/aaa/test_basic where name='to_delete_004'
/**
output()
count(0)
**/
;