org.h2.expression.Expression.createIndexConditions java code examples

Common ways to obtain Expression

private void myMethod () {
 Expression e =ValueExpression.getNull()
Column column;column.getDefaultExpression()
TableFilter tableFilter;tableFilter.getJoinCondition()
Smart code suggestions by Tabnine
}

@Override
public void createIndexConditions(Session session, TableFilter filter) {
  if (andOrType == AND) {
    left.createIndexConditions(session, filter);
    right.createIndexConditions(session, filter);
  }
}

/**
 * Map the columns and add the join condition.
 *
 * @param on the condition
 */
public void mapAndAddFilter(Expression on) {
  on.mapColumns(this, 0);
  addFilterCondition(on, true);
  on.createIndexConditions(session, this);
  if (nestedJoin != null) {
    on.mapColumns(nestedJoin, 0);
    on.createIndexConditions(session, nestedJoin);
  }
  if (join != null) {
    join.mapAndAddFilter(on);
  }
}

@Override
public void prepare() {
  if (condition != null) {
    condition.mapColumns(targetTableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, targetTableFilter);
  }
  for (Column c : columns) {
    Expression e = expressionMap.get(c);
    e.mapColumns(targetTableFilter, 0);
    if (sourceTableFilter!=null){
      e.mapColumns(sourceTableFilter, 0);
    }
    expressionMap.put(c, e.optimize(session));
  }
  TableFilter[] filters;
  if(sourceTableFilter==null){
    filters = new TableFilter[] { targetTableFilter };
  }
  else{
    filters = new TableFilter[] { targetTableFilter, sourceTableFilter };
  }
  PlanItem item = targetTableFilter.getBestPlanItem(session, filters, 0,
      ExpressionVisitor.allColumnsForTableFilters(filters));
  targetTableFilter.setPlanItem(item);
  targetTableFilter.prepare();
}

@Override
public void prepare() {
  if (condition != null) {
    condition.mapColumns(targetTableFilter, 0);
    if (sourceTableFilter != null) {
      condition.mapColumns(sourceTableFilter, 0);
    }
    condition = condition.optimize(session);
    condition.createIndexConditions(session, targetTableFilter);
  }
  TableFilter[] filters;
  if (sourceTableFilter == null) {
    filters = new TableFilter[] { targetTableFilter };
  } else {
    filters = new TableFilter[] { targetTableFilter, sourceTableFilter };
  }
  PlanItem item = targetTableFilter.getBestPlanItem(session, filters, 0,
      ExpressionVisitor.allColumnsForTableFilters(filters));
  targetTableFilter.setPlanItem(item);
  targetTableFilter.prepare();
}

onCondition.createIndexConditions(session, sourceTableFilter);
onCondition.createIndexConditions(session, targetTableFilter);
targetMatchCondition.mapColumns(sourceTableFilter, 2);
targetMatchCondition = targetMatchCondition.optimize(session);
targetMatchCondition.createIndexConditions(session, sourceTableFilter);
targetMatchQuery.prepare();

condition.createIndexConditions(session, f);

@Override
public void createIndexConditions(Session session, TableFilter filter) {
  if (andOrType == AND) {
    left.createIndexConditions(session, filter);
    right.createIndexConditions(session, filter);
  }
}

public void createIndexConditions(Session session, TableFilter filter) throws SQLException {
  if (andOrType == AND) {
    left.createIndexConditions(session, filter);
    right.createIndexConditions(session, filter);
  }
}

@Override
public void createIndexConditions(Session session, TableFilter filter) {
  if (andOrType == AND) {
    left.createIndexConditions(session, filter);
    right.createIndexConditions(session, filter);
  }
}

/**
 * Map the columns and add the join condition.
 *
 * @param on the condition
 */
public void mapAndAddFilter(Expression on) {
  on.mapColumns(this, 0);
  addFilterCondition(on, true);
  on.createIndexConditions(session, this);
  if (nestedJoin != null) {
    on.mapColumns(nestedJoin, 0);
    on.createIndexConditions(session, nestedJoin);
  }
  if (join != null) {
    join.mapAndAddFilter(on);
  }
}

/**
 * Map the columns and add the join condition.
 *
 * @param on the condition
 */
public void mapAndAddFilter(Expression on) {
  on.mapColumns(this, 0);
  addFilterCondition(on, true);
  on.createIndexConditions(session, this);
  if (nestedJoin != null) {
    on.mapColumns(nestedJoin, 0);
    on.createIndexConditions(session, nestedJoin);
  }
  if (join != null) {
    join.mapAndAddFilter(on);
  }
}

private void mapAndAddFilter(Expression on) throws SQLException {
  on.mapColumns(this, 0);
  addFilterCondition(on, true);
  on.createIndexConditions(session, this);
  if (join != null) {
    join.mapAndAddFilter(on);
  }
}

@Override
public void prepare() {
  if (condition != null) {
    condition.mapColumns(tableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, tableFilter);
  }
  for (int i = 0, size = columns.size(); i < size; i++) {
    Column c = columns.get(i);
    Expression e = expressionMap.get(c);
    e.mapColumns(tableFilter, 0);
    expressionMap.put(c, e.optimize(session));
  }
  TableFilter[] filters = new TableFilter[] { tableFilter };
  PlanItem item = tableFilter.getBestPlanItem(session, filters, 0,
      ExpressionVisitor.allColumnsForTableFilters(filters));
  tableFilter.setPlanItem(item);
  tableFilter.prepare();
}

@Override
public void prepare() {
  if (condition != null) {
    condition.mapColumns(tableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, tableFilter);
  }
  for (int i = 0, size = columns.size(); i < size; i++) {
    Column c = columns.get(i);
    Expression e = expressionMap.get(c);
    e.mapColumns(tableFilter, 0);
    expressionMap.put(c, e.optimize(session));
  }
  TableFilter[] filters = new TableFilter[] { tableFilter };
  PlanItem item = tableFilter.getBestPlanItem(session, filters, 0,
      ExpressionVisitor.allColumnsForTableFilters(filters));
  tableFilter.setPlanItem(item);
  tableFilter.prepare();
}

public void prepare() throws SQLException {
  if (condition != null) {
    condition.mapColumns(tableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, tableFilter);
  }
  PlanItem item = tableFilter.getBestPlanItem(session);
  tableFilter.setPlanItem(item);
  tableFilter.prepare();
}

@Override
public void prepare() {
  if (condition != null) {
    condition.mapColumns(tableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, tableFilter);
  }
  TableFilter[] filters = new TableFilter[] { tableFilter };
  PlanItem item = tableFilter.getBestPlanItem(session, filters, 0,
      ExpressionVisitor.allColumnsForTableFilters(filters));
  tableFilter.setPlanItem(item);
  tableFilter.prepare();
}

@Override
public void prepare() {
  if (condition != null) {
    condition.mapColumns(tableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, tableFilter);
  }
  TableFilter[] filters = new TableFilter[] { tableFilter };
  PlanItem item = tableFilter.getBestPlanItem(session, filters, 0,
      ExpressionVisitor.allColumnsForTableFilters(filters));
  tableFilter.setPlanItem(item);
  tableFilter.prepare();
}

public void prepare() throws SQLException {
  if (condition != null) {
    condition.mapColumns(tableFilter, 0);
    condition = condition.optimize(session);
    condition.createIndexConditions(session, tableFilter);
  }
  for (int i = 0; i < expressions.length; i++) {
    Expression expr = expressions[i];
    if (expr != null) {
      expr.mapColumns(tableFilter, 0);
      expressions[i] = expr.optimize(session);
    }
  }
  PlanItem item = tableFilter.getBestPlanItem(session);
  tableFilter.setPlanItem(item);
  tableFilter.prepare();
}

public Expression optimizeInJoin(Session session, Select select) throws SQLException {
  if (all || compareType != Comparison.EQUAL) {
    return this;
  }
  if (!query.isEverything(ExpressionVisitor.EVALUATABLE)) {
    return this;
  }
  String alias = query.getFirstColumnAlias(session);
  query.setDistinct(true);
  if (alias == null) {
    return this;
  }
  TableView view = TableView.createTempView(session, session.getUser(), query);
  TableFilter filter = new TableFilter(session, view, view.getName(), false, select);
  select.addTableFilter(filter, true);
  ExpressionColumn column = new ExpressionColumn(session.getDatabase(), null, view.getName(), alias);
  Expression on = new Comparison(session, Comparison.EQUAL, left, column);
  on.mapColumns(filter, 0);
  on.createIndexConditions(session, filter);
  filter.addFilterCondition(on, true);
  return ValueExpression.get(ValueBoolean.get(true));
}

condition.createIndexConditions(session, f);

Javadoc

Create index conditions if possible and attach them to the table filter.

Popular methods of Expression

getAlias
Get the alias name of a column or SQL expression if it is not an aliased expression.
getDisplaySize
Get the display size of this expression.
getNonAliasExpression
Returns the main expression, skipping aliases.
getNotIfPossible
If it is possible, return the negated expression. This is used to optimize NOT expressions: NOT ID>1
getPrecision
Get the precision of this expression.
getScale
Get the scale of this expression.
getType
Return the data type. The data type may not be known before the optimization phase.
getValue
Return the resulting value for the current row.
isConstant
Check if this expression will always return the same value.
addFilterConditions
Add conditions to a table filter if they can be evaluated.
getBooleanValue
Get the value in form of a boolean expression. Returns true or false. In this database, everything c
getColumnName
Get the column name or alias name of this expression.

Popular in Java

Making http requests using okhttp
findViewById (Activity)
onCreateOptionsMenu (Activity)
setRequestProperty (URLConnection)
Table (com.google.common.collect)
A collection that associates an ordered pair of keys, called a row key and a column key, with a sing
Color (java.awt)
The Color class is used to encapsulate colors in the default sRGB color space or colors in arbitrary
ByteBuffer (java.nio)
A buffer for bytes. A byte buffer can be created in either one of the following ways: * #allocate
SQLException (java.sql)
An exception that indicates a failed JDBC operation. It provides the following information about pro
JList (javax.swing)
Location (org.springframework.beans.factory.parsing)
Class that models an arbitrary location in a Resource.Typically used to track the location of proble
Sublime Text for Python

How to use createIndexConditionsmethodin org.h2.expression.Expression

Best Java code snippets using org.h2.expression.Expression.createIndexConditions (Showing top 20 results out of 315)

How to use
createIndexConditions
method
in
org.h2.expression.Expression