91.clear.mql 895 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. select count(*) from /oktest/basic
  2. /**
  3. output()
  4. **/
  5. ;
  6. select count(*) from /oktest/basic with version
  7. /**
  8. output()
  9. **/
  10. ;
  11. select count(*) from /oktest/basic where v_int>1000400
  12. /**
  13. output()
  14. **/
  15. ;
  16. delete from /oktest/basic where v_int>1000400
  17. ;
  18. select count(*) from /oktest/basic where v_int>1000400
  19. /**
  20. output()
  21. **/
  22. ;
  23. select count(*) from /oktest/basic where v_int>1000500 with version
  24. /**
  25. output()
  26. **/
  27. ;
  28. delete from /oktest/basic where v_int>1000500 with version
  29. ;
  30. select count(*) from /oktest/basic where v_int>1000500 with version
  31. /**
  32. output()
  33. **/
  34. ;
  35. select count(*) from /oktest/basic
  36. /**
  37. output()
  38. **/
  39. ;
  40. delete from /oktest/basic
  41. ;
  42. select count(*) from /oktest/basic
  43. /**
  44. output()
  45. **/
  46. ;
  47. select count(*) from /oktest/basic with version
  48. /**
  49. output()
  50. **/
  51. ;
  52. delete from /oktest/basic with version
  53. ;
  54. select count(*) from /oktest/basic with version
  55. /**
  56. output()
  57. equal(0,count,0)
  58. **/
  59. ;