/*
 * Copyright (C) 2003-2009 eXo Platform SAS.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Affero General Public License
 * as published by the Free Software Foundation; either version 3
 * of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, see<http://www.gnu.org/licenses/>.
 */
package org.exoplatform.services.jcr.impl.core.query;

import org.exoplatform.services.jcr.impl.core.NodeImpl;

import java.io.ByteArrayInputStream;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

import javax.jcr.Node;
import javax.jcr.NodeIterator;
import javax.jcr.RepositoryException;
import javax.jcr.Value;
import javax.jcr.query.InvalidQueryException;
import javax.jcr.query.Query;
import javax.jcr.query.QueryManager;
import javax.jcr.query.QueryResult;
import javax.jcr.query.Row;
import javax.jcr.query.RowIterator;

/**
 * Created by The eXo Platform SAS.
 * 
 * <br/>Date: 
 *
 * @author <a href="karpenko.sergiy@gmail.com">Karpenko Sergiy</a> 
 * @version $Id: TestQueryUsecases.java 111 2008-11-11 11:11:11Z serg $
 */
public class TestQueryUsecases extends BaseQueryTest
{

   /**
    * Get all nodes from repository.
    * 
    * @throws Exception
    */
   public void testSimpleGetAll() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:file");
      NodeImpl cont = (NodeImpl)doc1.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:encoding", "UTF-8");
      cont.setProperty("jcr:data", new ByteArrayInputStream("".getBytes()));

      Node doc2 = root.addNode("document2", "nt:file");
      cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:encoding", "UTF-8");
      cont.setProperty("jcr:data", new ByteArrayInputStream("".getBytes()));

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM nt:base ", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertTrue(3 < sqlsize);

      //make XPath query

      Query xq = qman.createQuery("//element(*,nt:base)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertTrue(3 < xpathsize);

      assertEquals(sqlsize, xpathsize);
   }

   /**
    * Get all files.
    * 
    * @throws Exception
    */
   public void testGetNodesByNodeType() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:file");
      NodeImpl cont = (NodeImpl)doc1.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:encoding", "UTF-8");
      cont.setProperty("jcr:data", new ByteArrayInputStream("".getBytes()));

      Node doc2 = root.addNode("document2", "nt:file");
      cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:encoding", "UTF-8");
      cont.setProperty("jcr:data", new ByteArrayInputStream("".getBytes()));

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM nt:file ", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, doc2});

      //make XPath query

      Query xq = qman.createQuery("//element(*,nt:file)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2});
   }

   public void testGetNodesByMixinType() throws Exception
   {
      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "First document");

      Node doc2 = root.addNode("document1", "nt:file");
      doc2.addMixin("mix:lockable");
      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:encoding", "UTF-8");
      cont.setProperty("jcr:data", new ByteArrayInputStream("".getBytes()));

      Node doc3 = root.addNode("document2", "nt:file");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Second document");
      cont = (NodeImpl)doc3.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:encoding", "UTF-8");
      cont.setProperty("jcr:data", new ByteArrayInputStream("".getBytes()));

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title ", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, doc3});

      //make XPath query

      Query xq = qman.createQuery("//element(*,mix:title)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, doc3});
   }

   /**
    * Get Collumns.
    * 
    * @throws Exception
    */
   public void testGetColumns() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node node2 = root.addNode("document2", "nt:file");
      node2.addMixin("mix:title");
      node2.setProperty("jcr:title", "Prison break");
      node2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)node2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT jcr:title, jcr:description FROM mix:title ", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, node2});
      String[] expectedColumns = new String[]{"jcr:title", "jcr:description"};
      String[][] expectedRows = new String[][]{{"Star wars", "Dart rules!!"}, {"Prison break", "Run, Forest, run ))"}};
      checkColumns(res, expectedColumns, expectedRows, true);
      //make XPath query

      Query xq = qman.createQuery("//element(*,mix:title)/(@jcr:title | @jcr:description)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, node2});
      checkColumns(res, expectedColumns, expectedRows, true);
   }

   /**
    * Find all mix:title nodes with title 'Prison break'.
    * 
    * @throws Exception
    */
   public void testPropertyComparison() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "War and peace");
      doc1.setProperty("jcr:description", "roman");
      doc1.setProperty("jcr:pagecount", 1000);

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Cinderella");
      doc2.setProperty("jcr:description", "fairytale");
      doc2.setProperty("jcr:pagecount", 100);

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Puss in Boots");
      doc3.setProperty("jcr:description", "fairytale");
      doc3.setProperty("jcr:pagecount", 60);

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT jcr:title FROM mix:title WHERE jcr:pagecount < 90", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{doc3});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[@jcr:pagecount < 90]/@jcr:title", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{doc3});
   }

   public void testAndedConstraints() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "War and peace");
      doc1.setProperty("jcr:description", "roman");
      doc1.setProperty("jcr:pagecount", 1000);

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Cinderella");
      doc2.setProperty("jcr:description", "fairytale");
      doc2.setProperty("jcr:pagecount", 100);

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Puss in Boots");
      doc3.setProperty("jcr:description", "fairytale");
      doc3.setProperty("jcr:pagecount", 60);

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q =
         qman.createQuery("SELECT * FROM mix:title WHERE jcr:description = 'fairytale' AND jcr:pagecount > 90",
            Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{doc2});

      //make XPath query
      Query xq =
         qman.createQuery("//element(*,mix:title)[@jcr:description='fairytale' and @jcr:pagecount > 90]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{doc2});
   }

   public void testORedConstraints() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "War and peace");
      doc1.setProperty("jcr:description", "roman");
      doc1.setProperty("jcr:pagecount", 1000);

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Cinderella");
      doc2.setProperty("jcr:description", "fairytale");
      doc2.setProperty("jcr:pagecount", 100);

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Puss in Boots");
      doc3.setProperty("jcr:description", "fairytale");
      doc3.setProperty("jcr:pagecount", 60);

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q =
         qman.createQuery("SELECT * FROM mix:title WHERE jcr:title = 'Cinderella' OR jcr:description = 'roman'",
            Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, doc2});

      //make XPath query
      Query xq =
         qman.createQuery("//element(*,mix:title)[@jcr:title='Cinderella' or @jcr:description = 'roman']", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2});
   }

   /**
    * Find all mix:title nodes which title begins from 'P' symbol.
    * 
    * @throws Exception
    */
   public void testLIKEConstraint() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Panopticum");
      doc3.setProperty("jcr:description", "It's imagine film )");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE jcr:title LIKE 'P%'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc2, doc3});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[jcr:like(@jcr:title, 'P%')]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc2, doc3});
   }

   public void testUPPERConstraint() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "CaseSensitive");

      Node doc2 = root.addNode("document2", "nt:unstructured");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "casesensitive");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "caseSENSITIVE");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE UPPER(jcr:title) = 'CASESENSITIVE'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(3, sqlsize);
      checkResult(res, new Node[]{doc1, doc2, doc3});

      q = qman.createQuery("SELECT * FROM mix:title WHERE LOWER(jcr:title) = 'casesensitive'", Query.SQL);
      res = q.execute();
      sqlsize = res.getNodes().getSize();
      assertEquals(3, sqlsize);
      checkResult(res, new Node[]{doc1, doc2, doc3});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[fn:upper-case(@jcr:title)='CASESENSITIVE']", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2, doc3});

      xq = qman.createQuery("//element(*,mix:title)[fn:lower-case(@jcr:title)='casesensitive']", Query.XPATH);
      xres = xq.execute();
      xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2, doc3});
   }

   /**
    * Find all mix:title nodes which title begins from 'P' symbol.
    * 
    * @throws Exception
    */
   public void testLikeWithEscapeSymbol() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Porison break");//setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "P%rison break");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Panopticum");
      doc3.setProperty("jcr:description", "It's imagine film )");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE jcr:title LIKE 'P#%ri%' ESCAPE '#'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{doc2});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[jcr:like(@jcr:title, 'P\\%ri%')]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{doc2});
   }

   /**
    * Find all mix:title nodes which title not begins from 'P' symbol.
    * 
    * @throws Exception
    */
   public void testNotConstraint() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE NOT jcr:title LIKE 'P%'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{doc1});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[not(jcr:like(@jcr:title, 'P%'))]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{doc1});
   }

   /**
    * Find all documents do not contains description.
    * 
    * @throws Exception
    */
   public void testPropertyNotExist() throws Exception
   {
      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document1", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Titanic");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE jcr:description IS NULL", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{doc3});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[not(@jcr:description)]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{doc3});
   }

   /**
    * Find all documents contains description.
    * 
    * @throws Exception
    */
   public void testPropertyExist() throws Exception
   {
      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Titanic");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE jcr:description IS NOT NULL", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, doc2});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[@jcr:description]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2});
   }

   /**
    * Find all documents contains description.
    * 
    * @throws Exception
    */
   public void testFulltextAllNodes() throws Exception
   {
      Node doc1 = root.addNode("document1", "nt:file");
      NodeImpl cont1 = (NodeImpl)doc1.addNode("jcr:content", "nt:resource");
      cont1.setProperty("jcr:mimeType", "text/plain");
      cont1.setProperty("jcr:lastModified", Calendar.getInstance());
      cont1.setProperty("jcr:data", "The quick brown fox jump over the lazy dog");
      session.save();

      Node doc2 = root.addNode("document2", "nt:file");
      NodeImpl cont2 = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont2.setProperty("jcr:mimeType", "text/plain");
      cont2.setProperty("jcr:lastModified", Calendar.getInstance());
      cont2.setProperty("jcr:data", "Dogs do not like cats.");

      Node doc3 = root.addNode("document3", "nt:file");
      NodeImpl cont3 = (NodeImpl)doc3.addNode("jcr:content", "nt:resource");
      cont3.setProperty("jcr:mimeType", "text/plain");
      cont3.setProperty("jcr:lastModified", Calendar.getInstance());
      cont3.setProperty("jcr:data", "Cats jumping high.");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM nt:resource WHERE CONTAINS(*,'do')", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{cont2});

      //make XPath query
      Query xq = qman.createQuery("//element(*,nt:resource)[jcr:contains(.,'cats')]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{cont2, cont3});
   }

   public void testFulltextAllNodes2() throws Exception
   {
      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break.");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Titanic");
      doc3.setProperty("jcr:description", "The aisberg break ship.");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();
      Query q = qman.createQuery("SELECT * FROM mix:title WHERE CONTAINS(*,'break')", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc2, doc3});

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)[jcr:contains(.,'break')]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc2, doc3});
   }

   public void testFulltextByProperty() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Quick brown fox jumps over the lazy dog.");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Brown fox live in forest.");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Star wars");
      doc3.setProperty("jcr:description", "fox is a nice animal.");

      Node doc4 = root.addNode("document4", "nt:unstructured");
      doc4.setProperty("jcr:title", "Star wars");
      doc4.setProperty("jcr:description", "There is forest word too.");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title WHERE CONTAINS(jcr:description, 'forest')", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{doc2});
      // Check order

      //make XPath query

      Query xq = qman.createQuery("//element(*,mix:title)[jcr:contains(@jcr:description, 'forest')]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{doc2});

   }

   public void testExactPath() throws Exception
   {
      Node r1 = root.addNode("root1");
      Node r2 = r1.addNode("root2");
      Node node1 = r2.addNode("node1", "nt:unstructured");
      r2.addNode("node1", "nt:unstructured");
      r2.addNode("node2", "nt:unstructured");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM nt:unstructured  WHERE jcr:path = '/root1/root2/node1[1]'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(1, sqlsize);
      checkResult(res, new Node[]{node1});

      //make XPath query
      Query xq = qman.createQuery("/jcr:root/root1[1]/root2[1]/element(node1,nt:unstructured)[1]", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(1, xpathsize);
      checkResult(xres, new Node[]{node1});

   }

   public void testFindAllSameName() throws Exception
   {
      Node r1 = root.addNode("root1");
      Node r2 = r1.addNode("root2");
      Node node1 = r2.addNode("node1", "nt:unstructured");
      Node node1_2 = r2.addNode("node1", "nt:unstructured");
      r2.addNode("node2", "nt:unstructured");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q =
         qman.createQuery("SELECT * FROM nt:unstructured  WHERE jcr:path LIKE '/root1/root2/node1[%]'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{node1, node1_2});

      //make XPath query
      Query xq = qman.createQuery("/jcr:root/root1[1]/root2[1]/element(node1,nt:unstructured)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{node1, node1_2});
   }

   public void testChildNodes() throws Exception
   {
      Node r1 = root.addNode("root1", "nt:folder");
      Node r2 = r1.addNode("root2", "nt:folder");
      Node subdir1 = r2.addNode("subdir1", "nt:folder");
      subdir1.addNode("node1", "nt:folder");
      Node node2 = r2.addNode("node2", "nt:folder");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q =
         qman.createQuery(
            "SELECT * FROM nt:folder WHERE jcr:path LIKE '/root1/root2/%' AND NOT jcr:path LIKE '/root1/root2/%/%'",
            Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{subdir1, node2});

      //make XPath query
      Query xq = qman.createQuery("/jcr:root/root1[1]/root2[1]/element(*,nt:folder)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{subdir1, node2});
   }

   public void testDescendantNodes() throws Exception
   {
      Node r1 = root.addNode("root1", "nt:folder");
      Node r2 = r1.addNode("root2", "nt:folder");
      Node subdir1 = r2.addNode("subdir1", "nt:folder");
      Node node1 = subdir1.addNode("node1", "nt:folder");
      Node node2 = r2.addNode("node2", "nt:folder");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM nt:folder WHERE jcr:path LIKE '/root1/root2/%'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(3, sqlsize);
      checkResult(res, new Node[]{subdir1, node1, node2});

      //make XPath query
      Query xq = qman.createQuery("/jcr:root/root1[1]/root2[1]//element(*,nt:folder)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkResult(xres, new Node[]{subdir1, node1, node2});
   }

   /***
    * Descendant or self is unsupported.
    * 
    * @throws Exception
    */
   public void testDescendantOrSelf() throws Exception
   {
      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();
      try
      {
         Query q =
            qman.createQuery(
               "SELECT * FROM nt:folder WHERE jcr:path = '/root1/root2' OR jcr:path LIKE '/root1/root2/%'", Query.SQL);
         q.execute();
         fail("Secendant or self query is unsupported.");
      }
      catch (InvalidQueryException e)
      {
         // thats ok descendant or self is unsupported
      }
   }

   public void testGetAllColumns() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Dart rules!!");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Run, Forest, run ))");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Panopticum");
      doc3.setProperty("jcr:description", "It's imagine film )");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(3, sqlsize);
      checkResult(res, new Node[]{doc1, doc2, doc3});
      String[] expectedColumns = new String[]{"jcr:title", "jcr:description", "jcr:pagecount", "jcr:path"};
      String[][] expectedRows =
         new String[][]{{"Star wars", "Dart rules!!", null, "/document1"},
            {"Prison break", "Run, Forest, run ))", null, "/document2"},
            {"Panopticum", "It's imagine film )", null, "/document3"}};
      checkColumns(res, expectedColumns, expectedRows, true);

      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title)", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2, doc3});
   }

   public void testOrderByScore() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Quick brown fox jumps over the lazy dog.");

      Node doc2 = root.addNode("document2", "nt:file");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Brown fox live in forest.");

      NodeImpl cont = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont.setProperty("jcr:mimeType", "text/plain");
      cont.setProperty("jcr:lastModified", Calendar.getInstance());
      cont.setProperty("jcr:data", "text");

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Star wars");
      doc3.setProperty("jcr:description", "fox is a nice animal.");

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q =
         qman.createQuery(
            "SELECT * FROM mix:title WHERE CONTAINS(*, 'brown OR fox OR jumps') ORDER BY jcr:score() ASC", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(3, sqlsize);
      checkOrder(res, new Node[]{doc3, doc2, doc1});

      //make XPath query
      Query xq =
         qman.createQuery("//element(*,mix:title)[jcr:contains(., 'brown OR fox OR jumps')] order by jcr:score()",
            Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkOrder(res, new Node[]{doc3, doc2, doc1});
   }

   public void testOrderByLongDesc() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Quick brown fox jumps over the lazy dog.");
      doc1.setProperty("jcr:pagecount", 4);

      Node doc2 = root.addNode("document2", "nt:unstructured");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Brown fox live in forest.");
      doc2.setProperty("jcr:pagecount", 7);

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Star wars");
      doc3.setProperty("jcr:description", "fox is a nice animal.");
      doc3.setProperty("jcr:pagecount", 1);

      session.save();

      QueryManager qman = this.workspace.getQueryManager();
      //make XPath query
      Query xq = qman.createQuery("//element(*,mix:title) order by @jcr:pagecount descending", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2, doc3});
      checkOrder(xres, new Node[]{doc2, doc1, doc3});
   }

   public void testOrderByProperty() throws Exception
   {
      root.addNode("simplenode", "nt:unstructured");

      Node doc1 = root.addNode("document1", "nt:unstructured");
      doc1.addMixin("mix:title");
      doc1.setProperty("jcr:title", "Star wars");
      doc1.setProperty("jcr:description", "Quick brown fox jumps over the lazy dog.");
      doc1.setProperty("jcr:pagecount", 4);

      Node doc2 = root.addNode("document2", "nt:unstructured");
      doc2.addMixin("mix:title");
      doc2.setProperty("jcr:title", "Prison break");
      doc2.setProperty("jcr:description", "Brown fox live in forest.");
      doc2.setProperty("jcr:pagecount", 7);

      Node doc3 = root.addNode("document3", "nt:unstructured");
      doc3.addMixin("mix:title");
      doc3.setProperty("jcr:title", "Star wars");
      doc3.setProperty("jcr:description", "fox is a nice animal.");
      doc3.setProperty("jcr:pagecount", 1);

      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM mix:title ORDER BY jcr:pagecount ASC", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(3, sqlsize);
      checkResult(res, new Node[]{doc1, doc2, doc3});
      checkOrder(res, new Node[]{doc3, doc1, doc2});

      //make XPath query

      Query xq = qman.createQuery("//element(*,mix:title) order by @jcr:pagecount ascending", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(3, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2, doc3});
      checkOrder(xres, new Node[]{doc3, doc1, doc2});
   }

   public void testSearchByName() throws Exception
   {
      Node doc1 = root.addNode("document1", "nt:file");
      NodeImpl cont1 = (NodeImpl)doc1.addNode("jcr:content", "nt:resource");
      cont1.setProperty("jcr:mimeType", "text/plain");
      cont1.setProperty("jcr:lastModified", Calendar.getInstance());
      cont1.setProperty("jcr:data", "The quick brown fox jump over the lazy dog");
      session.save();

      Node doc2 = root.addNode("document2", "nt:file");
      NodeImpl cont2 = (NodeImpl)doc2.addNode("jcr:content", "nt:resource");
      cont2.setProperty("jcr:mimeType", "text/plain");
      cont2.setProperty("jcr:lastModified", Calendar.getInstance());
      cont2.setProperty("jcr:data", "Dogs do not like cats.");

      Node doc3 = root.addNode("document1", "nt:file");
      NodeImpl cont3 = (NodeImpl)doc3.addNode("jcr:content", "nt:resource");
      cont3.setProperty("jcr:mimeType", "text/plain");
      cont3.setProperty("jcr:lastModified", Calendar.getInstance());
      cont3.setProperty("jcr:data", "Cats jumping high.");
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q = qman.createQuery("SELECT * FROM nt:file WHERE fn:name() = 'document1'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, doc3});

      //make XPath query
      Query xq = qman.createQuery("//element(*,nt:file)[fn:name() = 'document1']", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, doc3});
   }

   public void testMultivalueProperty() throws Exception
   {
      Node doc1 = root.addNode("node1", "nt:unstructured");
      doc1.setProperty("multiprop", new String[]{"one", "two"});

      Node doc2 = root.addNode("node2", "nt:unstructured");
      doc2.setProperty("multiprop", new String[]{"one", "two", "three"});

      Node doc3 = root.addNode("node3", "nt:unstructured");
      doc3.setProperty("multiprop", new String[]{"one", "five"});
      session.save();

      // make SQL query
      QueryManager qman = this.workspace.getQueryManager();

      Query q =
         qman.createQuery("SELECT * FROM nt:unstructured WHERE multiprop = 'one' AND multiprop = 'two'", Query.SQL);
      QueryResult res = q.execute();
      long sqlsize = res.getNodes().getSize();
      assertEquals(2, sqlsize);
      checkResult(res, new Node[]{doc1, doc2});

      //make XPath query
      Query xq =
         qman.createQuery("//element(*,nt:unstructured)[@multiprop = 'one' and @multiprop = 'two']", Query.XPATH);
      QueryResult xres = xq.execute();
      long xpathsize = xres.getNodes().getSize();
      assertEquals(2, xpathsize);
      checkResult(xres, new Node[]{doc1, doc2});

   }

   /**
    * Checks if the result set contains exactly the <code>nodes</code>.
    * 
    * @param result the query result.
    * @param nodes the expected nodes in the result set.
    */
   protected void checkResult(QueryResult result, Node[] nodes) throws RepositoryException
   {
      // collect paths
      String[][] vals = new String[(int)result.getNodes().getSize()][result.getColumnNames().length];

      RowIterator rit = result.getRows();
      int j = 0;
      while (rit.hasNext())
      {
         Row r = rit.nextRow();
         Value[] v = r.getValues();
         for (int i = 0; i < v.length; i++)
         {
            vals[j][i] = (v[i] != null) ? v[i].getString() : "null";
         }
         j++;
      }

      Set<String> expectedPaths = new HashSet<String>();
      for (int i = 0; i < nodes.length; i++)
      {
         expectedPaths.add(nodes[i].getPath());
      }
      Set<String> resultPaths = new HashSet<String>();
      for (NodeIterator it = result.getNodes(); it.hasNext();)
      {
         resultPaths.add(it.nextNode().getPath());
      }

      comparePaths(expectedPaths, resultPaths, false);
   }

   private void checkOrder(QueryResult res, Node[] expectedNodes) throws RepositoryException
   {
      NodeIterator ni = res.getNodes();

      List<String> list = new ArrayList<String>();

      while (ni.hasNext())
      {
         list.add(ni.nextNode().getPath());
      }

      ni = res.getNodes();
      for (int i = 0; i < expectedNodes.length; i++)
      {
         Node expNode = expectedNodes[i];
         if (!ni.hasNext())
         {
            fail("Result do not contain node " + expNode.getName());
         }
         assertEquals("Node not found or not in expected order " + expNode.getPath(), expNode.getPath(), ni.nextNode()
            .getPath());
      }
      assertFalse("Node has more than expected nodes.", ni.hasNext());

   }

   private void comparePaths(Set<String> expectedPaths, Set<String> resultPaths, boolean canContainMore)
   {
      // check if all expected are in result
      for (Iterator<String> it = expectedPaths.iterator(); it.hasNext();)
      {
         String path = it.next();
         assertTrue(path + " is not part of the result set", resultPaths.contains(path));
      }

      if (!canContainMore)
      {
         // check result does not contain more than expected

         for (Iterator<String> it = resultPaths.iterator(); it.hasNext();)
         {
            String path = it.next();
            assertTrue(path + " is not expected to be part of the result set. " + " Total size:" + resultPaths.size(),
               expectedPaths.contains(path));
         }
      }
   }

   private void checkColumns(QueryResult res, String[] columns, String[][] values, boolean hasMoreColumns)
      throws RepositoryException
   {
      // check column list

      String[] rcol = res.getColumnNames();
      if (!hasMoreColumns)
      {
         assertEquals("Columns count not equal to expected set", rcol.length, columns.length);
      }
      else
      {
         assertTrue(rcol.length >= columns.length);
      }

      for (String colname : columns)
      {
         boolean finded = false;
         for (String rescolname : rcol)
         {
            if (colname.equals(rescolname))
            {
               finded = true;
            }
         }
         assertTrue("Column name not founded : " + colname, finded);
      }

      //check values
      RowIterator rit = res.getRows();
      for (String[] row : values)
      {
         if (!rit.hasNext())
         {
            fail("Expected row not exist.");
         }
         Row resrow = rit.nextRow();
         for (int j = 0; j < columns.length; j++)
         {
            Value val = resrow.getValue(columns[j]);
            assertEquals(row[j], (val != null) ? val.getString() : null);
         }
      }
      assertFalse("There is more rows than expected", rit.hasNext());

   }
}
