30multilines.mql 921 B

1234567891011121314151617181920212223242526272829303132333435
  1. -- ============================================================
  2. -- multilines begin/end 多行语句测试
  3. -- ============================================================
  4. multilines begin;
  5. insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('multi_001', 1, 'multiline insert 1')
  6. ;
  7. insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('multi_002', 2, 'multiline insert 2')
  8. ;
  9. insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('multi_003', 3, 'multiline insert 3')
  10. ;
  11. insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('multi_004', 4, 'multiline insert 4')
  12. ;
  13. insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('multi_005', 5, 'multiline insert 5')
  14. ;
  15. multilines end;
  16. /**
  17. sleep(500ms)
  18. **/
  19. ;
  20. -- 验证 multilines 插入结果
  21. select e_name, e_value from /test/aaa/test_ext where e_name prefix 'multi'
  22. /**
  23. output()
  24. matchcount("e_name","multi",5)
  25. **/
  26. ;