| commit | df89fbc8879457b1f24310244f764f9c56c4e9f9 | [log] [tgz] |
|---|---|---|
| author | salsubaiee <salsubaiee@gmail.com> | Sat Dec 21 19:51:42 2013 -0800 |
| committer | salsubaiee <salsubaiee@gmail.com> | Sat Dec 21 19:51:42 2013 -0800 |
| tree | f79feda5d48be251030c5a20ba69a332ad1f4027 | |
| parent | bb167912ccbed4a03149f98ff6496f8d916f0ebf [diff] [blame] |
Moved the skip secondary index search hint closer to the predicates.
diff --git a/asterix-app/src/test/resources/optimizerts/queries/skip-index/dont-skip-primary-index.aql b/asterix-app/src/test/resources/optimizerts/queries/skip-index/dont-skip-primary-index.aql index 114784e..77f9e8e 100644 --- a/asterix-app/src/test/resources/optimizerts/queries/skip-index/dont-skip-primary-index.aql +++ b/asterix-app/src/test/resources/optimizerts/queries/skip-index/dont-skip-primary-index.aql
@@ -19,6 +19,5 @@ create dataset testdst(TestType) primary key fname,lname; for $emp in dataset('testdst') -/*+ skip-index */ -where $emp.fname >= "Craig" and $emp.lname >= "Kevin" and $emp.fname <= "Mary" and $emp.lname <= "Tomes" +where $emp.fname /*+ skip-index */ >= "Craig" and $emp.lname /*+ skip-index */ >= "Kevin" and $emp.fname /*+ skip-index */ <= "Mary" and $emp.lname /*+ skip-index */ <= "Tomes" return $emp