Examples of com.orientechnologies.orient.core.sql.OIndexSearchResult

Package com.orientechnologies.orient.core.sql

Examples of com.orientechnologies.orient.core.sql.OIndexSearchResult

com.orientechnologies.orient.core.sql.OIndexSearchResult
Presents query subset in form of field1 = "field1 value" AND field2 = "field2 value" ... AND fieldN anyOpetator "fieldN value" Where pairs (field1, value1) ... (fieldn-1, valuen-1) are stored in {@link #fieldValuePairs} map but last pair is stored in{@link #lastField} {@link #lastValue} properties and their operator will be stored in {@link #lastOperator} property.Such data structure is used because from composite index point of view any "field and value" pairs can be reordered to match keys order that is used in index in case all fields and values are related to each other using equals operator, but position of field - value pair that uses non equals operator cannot be changed. Actually only one non-equals operator can be used for composite index search and filed - value pair that uses this index should always be placed at last position.

  public void testOptimizeFullOptimization() throws Exception {
    final OSQLFilter filter = OSQLEngine.getInstance().parseCondition("a = 3", null, "WHERE");


    final OSQLFilterCondition condition = filter.getRootCondition();


    final OIndexSearchResult searchResult = new OIndexSearchResult(condition.getOperator(),
        ((OSQLFilterItemField) condition.getLeft()).getFieldChain(), 3);


    optimizer.optimize(filter, searchResult);


    Assert.assertNull(filter.getRootCondition());

View Full Code Here

  public void testOptimizeFullOptimizationComplex() throws Exception {
    final OSQLFilter filter = OSQLEngine.getInstance().parseCondition("a = 3 and b = 4", null, "WHERE");


    final OSQLFilterCondition condition = filter.getRootCondition();


    final OIndexSearchResult searchResult;
    {


      final OIndexSearchResult searchResult1;
      {
        final OSQLFilterCondition cnd = (OSQLFilterCondition) condition.getLeft();
        searchResult1 = new OIndexSearchResult(cnd.getOperator(), ((OSQLFilterItemField) cnd.getLeft()).getFieldChain(), 3);
      }
      final OIndexSearchResult searchResult2;
      {
        final OSQLFilterCondition cnd = (OSQLFilterCondition) condition.getRight();
        searchResult2 = new OIndexSearchResult(cnd.getOperator(), ((OSQLFilterItemField) cnd.getLeft()).getFieldChain(), 4);
      }
      searchResult = searchResult1.merge(searchResult2);
    }


    optimizer.optimize(filter, searchResult);

View Full Code Here

  public void testOptimizePartialOptimization() throws Exception {
    final OSQLFilter filter = OSQLEngine.getInstance().parseCondition("a = 3 and b > 5", null, "WHERE");


    final OSQLFilterCondition condition = filter.getRootCondition();


    final OIndexSearchResult searchResult = new OIndexSearchResult(((OSQLFilterCondition) condition.getLeft()).getOperator(),
        ((OSQLFilterItemField) ((OSQLFilterCondition) condition.getLeft()).getLeft()).getFieldChain(), 3);


    optimizer.optimize(filter, searchResult);


    Assert.assertEquals(filter.getRootCondition().toString(), "(b > 5)");

View Full Code Here

  public void testOptimizePartialOptimizationMethod() throws Exception {
    final OSQLFilter filter = OSQLEngine.getInstance().parseCondition("a = 3 and b.asFloat() > 3.14", null, "WHERE");


    final OSQLFilterCondition condition = filter.getRootCondition();


    final OIndexSearchResult searchResult = new OIndexSearchResult(((OSQLFilterCondition) condition.getLeft()).getOperator(),
        ((OSQLFilterItemField) ((OSQLFilterCondition) condition.getLeft()).getLeft()).getFieldChain(), 3);


    optimizer.optimize(filter, searchResult);


    Assert.assertEquals(filter.getRootCondition().toString(), "(b.asfloat > 3.14)");

View Full Code Here

TOP

Related Classes of com.orientechnologies.orient.core.sql.OIndexSearchResult

com.orientechnologies.orient.core.sql.filter.OFilterOptimizerTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.