blob: 8f59bbfa480320ef45d68fe8828cab19589f884f [file] [log] [blame]
alexander.behmc576c602012-07-06 02:41:15 +00001/*
Ian Maxon857dc132015-09-25 17:13:19 -07002 * Licensed to the Apache Software Foundation (ASF) under one
3 * or more contributor license agreements. See the NOTICE file
4 * distributed with this work for additional information
5 * regarding copyright ownership. The ASF licenses this file
6 * to you under the Apache License, Version 2.0 (the
7 * "License"); you may not use this file except in compliance
8 * with the License. You may obtain a copy of the License at
9 *
10 * http://www.apache.org/licenses/LICENSE-2.0
11 *
12 * Unless required by applicable law or agreed to in writing,
13 * software distributed under the License is distributed on an
14 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
15 * KIND, either express or implied. See the License for the
16 * specific language governing permissions and limitations
17 * under the License.
18 */
19/*
alexander.behmc576c602012-07-06 02:41:15 +000020 * Description : Tests whether an ngram_index is applied to optimize a selection query using the edit-distance-check function on strings.
21 * The index should *not* be applied (see below).
22 * Success : Yes
23 */
24
25drop dataverse test if exists;
26create dataverse test;
27use dataverse test;
28
29create type DBLPType as closed {
30 id: int32,
31 dblpid: string,
32 title: string,
33 authors: string,
34 misc: string
35}
36
ramangrover29669d8f62013-02-11 06:03:32 +000037create dataset DBLP(DBLPType) primary key id;
alexander.behmc576c602012-07-06 02:41:15 +000038
alexander.behmc576c602012-07-06 02:41:15 +000039create index ngram_index on DBLP(authors) type ngram(3);
40
41write output to nc1:"rttest/inverted-index-basic_ngram-edit-distance-check-panic.adm";
42
43// This query cannot be optimized with an index, based on the high edit distance.
44for $o in dataset('DBLP')
45let $ed := edit-distance-check($o.authors, "Amihay Motro", 5)
46where $ed[0]
Ian Maxon857dc132015-09-25 17:13:19 -070047return $o