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 Codota
}

@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

Reactive rest calls using spring rest template
scheduleAtFixedRate (ScheduledExecutorService)
requestLocationUpdates (LocationManager)
getResourceAsStream (ClassLoader)
Returns a stream for the resource with the specified name. See #getResource(String) for a descriptio
Proxy (java.net)
This class represents proxy server settings. A created instance of Proxy stores a type and an addres
Socket (java.net)
Provides a client-side TCP socket.
DecimalFormat (java.text)
DecimalFormat is a concrete subclass ofNumberFormat that formats decimal numbers. It has a variety o
Arrays (java.util)
This class contains various methods for manipulating arrays (such as sorting and searching). This cl
GregorianCalendar (java.util)
GregorianCalendar is a concrete subclass of Calendarand provides the standard calendar used by most
Options (org.apache.commons.cli)
Main entry-point into the library. Options represents a collection of Option objects, which describ

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