本文整理了Java中org.h2.command.dml.Query.getPlanSQL
方法的一些代码示例,展示了Query.getPlanSQL
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.getPlanSQL
方法的具体详情如下:
包路径:org.h2.command.dml.Query
类名称: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;
}
内容来源于网络,如有侵权,请联系作者删除!