21.float.mql 392 B

12345678910111213141516171819202122232425262728293031323334353637
  1. select id,v_float from /test/basic
  2. /**
  3. output()
  4. count(3)
  5. **/
  6. ;
  7. select * from /test/basic where v_float >= 1.1
  8. /**
  9. count(3)
  10. **/
  11. ;
  12. select * from /test/basic where v_float > 1
  13. /**
  14. count(3)
  15. **/
  16. ;
  17. select * from /test/basic where v_float = 1.1
  18. /**
  19. count(3)
  20. **/
  21. ;
  22. select * from /test/basic where v_float < 2
  23. /**
  24. count(3)
  25. **/
  26. ;
  27. select * from /test/basic where v_float <= 1.1
  28. /**
  29. count(3)
  30. **/
  31. ;