org.h2.command.dml.Query.getPlanSQL()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(5.0k)|赞(0)|评价(0)|浏览(120)

本文整理了Java中org.h2.command.dml.Query.getPlanSQL方法的一些代码示例,展示了Query.getPlanSQL的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.getPlanSQL方法的具体详情如下:
包路径:org.h2.command.dml.Query
类名称:Query
方法名:getPlanSQL

Query.getPlanSQL介绍

暂无

代码示例

代码示例来源:origin: com.h2database/h2

@Override
public String getPlanSQL() {
  return query == null ? null : query.getPlanSQL();
}

代码示例来源:origin: com.h2database/h2

@Override
public String getSQL() {
  return "(" + query.getPlanSQL() + ")";
}

代码示例来源:origin: com.h2database/h2

@Override
public String getSQL() {
  return "EXISTS(\n" + StringUtils.indent(query.getPlanSQL(), 4, false) + ")";
}

代码示例来源:origin: com.h2database/h2

@Override
public String getSQL() {
  StringBuilder buff = new StringBuilder();
  buff.append('(').append(left.getSQL()).append(' ');
  if (all) {
    buff.append(Comparison.getCompareOperator(compareType)).
      append(" ALL");
  } else {
    if (compareType == Comparison.EQUAL) {
      buff.append("IN");
    } else {
      buff.append(Comparison.getCompareOperator(compareType)).
        append(" ANY");
    }
  }
  buff.append("(\n").append(StringUtils.indent(query.getPlanSQL(), 4, false)).
    append("))");
  return buff.toString();
}

代码示例来源:origin: com.h2database/h2

@Override
public String getPlanSQL() {
  StringBuilder buff = new StringBuilder();
  buff.append('(').append(left.getPlanSQL()).append(')');
  switch (unionType) {
  case UNION_ALL:
    DbException.throwInternalError("type=" + unionType);
  buff.append('(').append(right.getPlanSQL()).append(')');
  Expression[] exprList = expressions.toArray(new Expression[0]);
  if (sort != null) {

代码示例来源:origin: com.h2database/h2

querySQLOutput[0] = StringUtils.cache(theQuery.getPlanSQL());
ColumnNamer columnNamer = new ColumnNamer(theQuery.getSession());
ArrayList<Expression> withExpressions = theQuery.getExpressions();

代码示例来源:origin: com.h2database/h2

/**
 * Create a temporary view out of the given query.
 *
 * @param session the session
 * @param owner the owner of the query
 * @param name the view name
 * @param query the query
 * @param topQuery the top level query
 * @return the view table
 */
public static TableView createTempView(Session session, User owner,
    String name, Query query, Query topQuery) {
  Schema mainSchema = session.getDatabase().getSchema(Constants.SCHEMA_MAIN);
  String querySQL = query.getPlanSQL();
  TableView v = new TableView(mainSchema, 0, name,
      querySQL, query.getParameters(), null /* column templates */, session,
      false/* allow recursive */, true /* literals have already been checked when parsing original query */,
      false /* is table expression */, false/* is persistent*/);
  if (v.createException != null) {
    throw v.createException;
  }
  v.setTopQuery(topQuery);
  v.setOwner(owner);
  v.setTemporary(true);
  return v;
}

代码示例来源:origin: com.h2database/h2

String sql = q.getPlanSQL();
q = prepareSubQuery(sql, session, masks, filters, filter, sortOrder);
return q;

代码示例来源:origin: com.h2database/h2

buff.append(query.getPlanSQL());

代码示例来源:origin: com.h2database/h2

buff.append(query.getPlanSQL());

代码示例来源:origin: com.h2database/h2

try {
  Query compiledQuery = compileViewQuery(session, querySQL, literalsChecked, getName());
  this.querySQL = compiledQuery.getPlanSQL();
  tables = new ArrayList<>(compiledQuery.getTables());
  ArrayList<Expression> expressions = compiledQuery.getExpressions();

代码示例来源:origin: com.h2database/h2

throw DbException.getUnsupportedException("parameters in views");
querySQL = select.getPlanSQL();

代码示例来源:origin: com.h2database/h2

buff.append(query.getPlanSQL());

代码示例来源:origin: com.h2database/h2

buff.append(query.getPlanSQL());

代码示例来源:origin: com.h2database/h2

case Comparison.IN_QUERY:
  buff.append(" IN(");
  buff.append(expressionQuery.getPlanSQL());
  buff.append(')');
  break;

代码示例来源:origin: org.wowtools/h2

@Override
public String getPlanSQL() {
  return query == null ? null : query.getPlanSQL();
}

代码示例来源:origin: com.h2database/com.springsource.org.h2

public String getSQL() {
  StringBuffer buff = new StringBuffer();
  buff.append("EXISTS(");
  buff.append(query.getPlanSQL());
  buff.append(")");
  return buff.toString();
}

代码示例来源:origin: com.h2database/com.springsource.org.h2

public String getSQL() {
  StringBuffer buff = new StringBuffer("(");
  buff.append(left.getSQL());
  buff.append(" IN(");
  buff.append(query.getPlanSQL());
  buff.append("))");
  return buff.toString();
}

代码示例来源:origin: com.h2database/com.springsource.org.h2

public ViewIndex(TableView view, ViewIndex index, Session session, int[] masks) throws SQLException {
  initBaseIndex(view, 0, null, null, IndexType.createNonUnique(false));
  this.querySQL = index.querySQL;
  this.originalParameters = index.originalParameters;
  this.recursive = index.recursive;
  this.masks = masks;
  this.session = session;
  columns = new Column[0];
  query = getQuery(session, masks);
  planSQL =  query.getPlanSQL();
}

代码示例来源:origin: com.h2database/com.springsource.org.h2

public static TableView createTempView(Session s, User owner, Query query) throws SQLException {
  String tempViewName = s.getNextTempViewName();
  Schema mainSchema = s.getDatabase().getSchema(Constants.SCHEMA_MAIN);
  String querySQL = query.getPlanSQL();
  TableView v = new TableView(mainSchema, 0, tempViewName, querySQL, query.getParameters(), null, s,
      false);
  if (v.createException != null) {
    throw v.createException;
  }
  v.setOwner(owner);
  v.setTemporary(true);
  return v;
}

相关文章