/* | |
* Description : Tests whether an ngram_index is applied to optimize a selection query using the contains function. | |
* The index should be applied. | |
* Success : Yes | |
*/ | |
drop dataverse test if exists; | |
create dataverse test; | |
use dataverse test; | |
create type DBLPType as closed { | |
id: int32, | |
dblpid: string, | |
title: string, | |
authors: string, | |
misc: string | |
} | |
create dataset DBLP(DBLPType) primary key id; | |
create index ngram_index on DBLP(title) type ngram(3); | |
write output to nc1:"rttest/inverted-index-basic_ngram-contains.adm"; | |
for $o in dataset('DBLP') | |
where contains($o.title, "Multimedia") | |
order by $o.id | |
return $o |