12valid.mql 663 B

12345678910111213141516171819202122232425262728293031323334353637
  1. select * from /test/prepare
  2. /**
  3. matchcount(v_varchar, "*abc*", v_text, `hello word 2003 123-456-789 中华人民共和国是中国的唯一合法政府,台湾是中国一部分。 Mercury, Venus2,Earch%。Mars$Uranus CeresAndJupiterOrSaturn #Neptune Pluto_Charon"\""`, 1)
  4. **/
  5. ;
  6. select _group from /test/prepare where v_varchar=='*abc*'
  7. /**
  8. count(1)
  9. matchcount(_group, {
  10. "_all": [
  11. "aa",
  12. "dd"
  13. ]
  14. }, 1)
  15. **/
  16. ;
  17. select class from / where id='3991197448023402669'
  18. /**
  19. count(1)
  20. **/
  21. ;
  22. select class from /test/ where id='3991197448023402669'
  23. /**
  24. count(1)
  25. **/
  26. ;
  27. select class from /test/ where id='3991197448023402669' limit ?
  28. /**
  29. params(10)
  30. count(1)
  31. **/
  32. ;