Author: thomasm
Date: Tue Jul 16 12:14:04 2013
New Revision: 1503678
URL: http://svn.apache.org/r1503678
Log:
OAK-902 Lucene fulltext query: "contains(*, 'x OR y')" not working
Added:
jackrabbit/oak/trunk/oak-jcr/src/test/java/org/apache/jackrabbit/oak/jcr/query/QueryFulltextTest.java
Added:
jackrabbit/oak/trunk/oak-jcr/src/test/java/org/apache/jackrabbit/oak/jcr/query/QueryFulltextTest.java
URL:
http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-jcr/src/test/java/org/apache/jackrabbit/oak/jcr/query/QueryFulltextTest.java?rev=1503678&view=auto
==============================================================================
---
jackrabbit/oak/trunk/oak-jcr/src/test/java/org/apache/jackrabbit/oak/jcr/query/QueryFulltextTest.java
(added)
+++
jackrabbit/oak/trunk/oak-jcr/src/test/java/org/apache/jackrabbit/oak/jcr/query/QueryFulltextTest.java
Tue Jul 16 12:14:04 2013
@@ -0,0 +1,94 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.jackrabbit.oak.jcr.query;
+
+import static org.junit.Assert.assertEquals;
+
+import javax.jcr.Node;
+import javax.jcr.RepositoryException;
+import javax.jcr.Session;
+import javax.jcr.query.Query;
+import javax.jcr.query.QueryManager;
+import javax.jcr.query.QueryResult;
+import javax.jcr.query.RowIterator;
+
+import org.apache.jackrabbit.oak.jcr.AbstractRepositoryTest;
+import org.apache.jackrabbit.oak.jcr.NodeStoreFixture;
+import org.junit.Test;
+
+/**
+ * Tests the fulltext index.
+ */
+public class QueryFulltextTest extends AbstractRepositoryTest {
+
+ public QueryFulltextTest(NodeStoreFixture fixture) {
+ super(fixture);
+ }
+
+ @Test
+ public void fulltext() throws Exception {
+ Session session = getAdminSession();
+ QueryManager qm = session.getWorkspace().getQueryManager();
+ Node testRootNode = session.getRootNode().addNode("testroot");
+ Node n1 = testRootNode.addNode("node1");
+ n1.setProperty("text", "hello");
+ Node n2 = testRootNode.addNode("node2");
+ n2.setProperty("text", "hallo");
+ Node n3 = testRootNode.addNode("node3");
+ n3.setProperty("text", "hello hallo");
+ session.save();
+
+ String sql2 = "select [jcr:path] as [path] from [nt:base] " +
+ "where contains([text], 'hello OR hallo') order by [jcr:path]";
+
+ Query q;
+
+ q = qm.createQuery("explain " + sql2, Query.JCR_SQL2);
+ assertEquals("[nt:base] as [nt:base] /* traverse \"*\" " +
+ "where contains([nt:base].[text], cast('hello OR hallo' as
string)) */",
+ getResult(q.execute(), "plan"));
+
+ // verify the result
+ // uppercase "OR" mean logical "or"
+ q = qm.createQuery(sql2, Query.JCR_SQL2);
+ assertEquals("/testroot/node1, /testroot/node2, /testroot/node3",
+ getResult(q.execute(), "path"));
+
+ // lowercase "or" mean search for the term "or"
+ sql2 = "select [jcr:path] as [path] from [nt:base] " +
+ "where contains([text], 'hello or hallo') order by [jcr:path]";
+ q = qm.createQuery(sql2, Query.JCR_SQL2);
+ assertEquals("",
+ getResult(q.execute(), "path"));
+
+ }
+
+ static String getResult(QueryResult result, String propertyName) throws
RepositoryException {
+ StringBuilder buff = new StringBuilder();
+ RowIterator it = result.getRows();
+ while (it.hasNext()) {
+ if (buff.length() > 0) {
+ buff.append(", ");
+ }
+ buff.append(it.nextRow().getValue(propertyName).getString());
+ }
+ return buff.toString();
+ }
+
+}
