odbtools/odbctest/mql/basic/99cassdb/222checklucene.mql

-- lucene索引错误验证

-- 直接查cassandra：
cql:
select count(*) from object_test where class='/test/oo/dimension' and int_4>=100 allow filtering
/**
output()
match("count",1)
onerror(continue)
**/
;

-- 通过lucene查：
cql:
select count(*) from object_test where class='/test/oo/dimension' and 
expr(object_test_lucene,'{"filter":{"type":"range","field":"int_4","lower":100,"include_lower":true}}')
/**
output()
match("count",1)
onerror(continue)
**/
;

cql:
select count(*) from object_test where 
expr(object_test_lucene,'{"filter":{"type":"prefix","field":"class","value":"/test/"}}')
/**
output()
match("count",10162)
onerror(continue)
**/
;

-- cql:
-- select class,id,name from object_test where "_tokens" like '/test/%'
-- /**
-- output()
-- **/
-- ;