| * Description : Tests whether an ngram_index is applied to optimize a selection query using the edit-distance-check function on strings. |
| * Tests that the optimizer rule correctly drills through the let clauses. |
| * The index should *not* be applied (see below). |
| drop dataverse test if exists; |
| create type DBLPType as closed { |
| create dataset DBLP(DBLPType) partitioned by key id; |
| using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" |
| (("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; |
| create index ngram_index on DBLP(authors) type ngram(3); |
| write output to nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm"; |
| // This query cannot be optimized with an index, based on the high edit distance. |
| for $o in dataset('DBLP') |
| let $ed := edit-distance-check($o.authors, "Amihay Motro", 5) |