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

select * from /test/prepare
/**
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/prepare where v_varchar=='*abc*' refresh
/**
output()
count(1)
matchcount(_group, {
  "_all": [
    "aa",
	"dd"
  ]
}, 1)
**/
;

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

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

select class from / where id='3991197448023402669'
/**
count(1)
**/
;

select class from /test/ where id='3991197448023402669'
/**
count(1)
**/
;

select class from /test/ where id='3991197448023402669' limit ?
/**
params(10)
count(1)
**/
;