@Override public String getSQL() { return "(" + query.getPlanSQL() + ")"; }
@Override public String getSQL() { return "EXISTS(\n" + StringUtils.indent(query.getPlanSQL(), 4, false) + ")"; }
@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(); }
@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[expressions.size()]); if (sort != null) {
/** * 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, session, false); if (v.createException != null) { throw v.createException; } v.setTopQuery(topQuery); v.setOwner(owner); v.setTemporary(true); return v; }
String sql = q.getPlanSQL(); q = (Query) session.prepare(sql, true); return q;