odbtools/odbctest/mql/problem/basic/36prepare/22valid.mql

select * from /test/mprepare
/**
matchcount(v_varchar, "*abc*", v_text, `hello word 2003 123-456-789 中华人民共和国是中国的唯一合法政府，台湾是中国一部分。  Mercury, Venus2，Earch%。Mars$Uranus CeresAndJupiterOrSaturn #Neptune Pluto_Charon"\""`, 1)
**/
;

select _group from /test/mprepare where v_varchar=='*abc*'
/**
output()
count(1)
matchcount(_group, {
  "_all": [
    "aa",
	"dd"
  ]
}, 1)
**/
;

select vvv._group from /test/mprepare vvv where vvv.v_varchar=='*abc*'
/**
count(1)
matchcount("vvv._group", {
  "_all": [
    "aa",
	"dd"
  ]
}, 1)
**/
;

select order._group from /test/mprepare "order" where order.v_varchar=='*abc*'
/**
count(1)
matchcount("order._group", {
  "_all": [
    "aa",
	"dd"
  ]
}, 1)
**/
;