odbtools/odbctest/mql/0/801.memdb.like.mql

select v_varchar, v_text from /test/basic2 where v_varchar='a*'
/**
output()
count(0)
**/
;

select v_varchar, v_text from /test/basic2 where v_varchar='*a'
/**
output()
count(0)
**/
;

select v_varchar, v_text from /test/basic2 where v_varchar='\*a*'
/**
output()
count(1)
**/
;

select v_varchar, v_text from /test/basic2 where v_varchar='*c\*'
/**
output()
count(1)
**/
;

select v_varchar, v_text from /test/basic2 where v_text='hello'
/**
output()
**/
;

-- memdb 不支持分词，直接通配查找
select v_varchar, v_text from /test/basic2 where v_text='e'
/**
output()
**/
;

select v_varchar, v_text from /test/basic2 where v_text='e*'
/**
output()
**/
;

select v_varchar, v_text from /test/basic2 where v_text='*e'
/**
output()
**/
;

select v_varchar, v_text from /test/basic2 where v_text='*e*'
/**
output()
**/
;