18.int2.mql 446 B

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. select * from /test/basic2 where v_int = 1
  2. /**
  3. count(1)
  4. **/
  5. ;
  6. select * from /test/basic2 where v_int > 0
  7. /**
  8. count(3)
  9. **/
  10. ;
  11. select * from /test/basic2 where v_int < 2
  12. /**
  13. count(1)
  14. **/
  15. ;
  16. select * from /test/basic2 where v_int >= 1
  17. /**
  18. count(3)
  19. **/
  20. ;
  21. select * from /test/basic2 where v_int <= 1
  22. /**
  23. count(1)
  24. **/
  25. ;
  26. select * from /test/basic2 where v_int >= 1.1
  27. /**
  28. count(2)
  29. **/
  30. ;
  31. select * from /test/basic2 where v_int > 1
  32. /**
  33. count(2)
  34. **/
  35. ;