16double.mql 600 B

123456789101112131415161718192021222324252627282930313233343536
  1. select * from /test/prepare where v_double >= 1.1234567890123456
  2. /**
  3. count(3)
  4. **/
  5. ;
  6. select * from /test/prepare where v_smalldouble >= 1.123456
  7. /**
  8. count(3)
  9. **/
  10. ;
  11. select count(*) as count from /test/prepare where v_double > 1
  12. /**
  13. matchcount("count", 3, 1)
  14. **/
  15. ;
  16. select count(*) as count from /test/prepare where v_double = 1.1234567890123456
  17. /**
  18. matchcount("count", 3, 1)
  19. **/
  20. ;
  21. select count(*) as count from /test/prepare where v_double < 2
  22. /**
  23. matchcount("count", 3, 1)
  24. **/
  25. ;
  26. select count(*) as count from /test/prepare where v_double <= 1.1234567890123456
  27. /**
  28. matchcount("count", 3, 1)
  29. **/
  30. ;