/** {@inheritDoc} */ @Override public String getSQL() { StatementBuilder buff = new StatementBuilder(explain() ? "EXPLAIN \n" : ""); buff.append('(').append(left.getSQL()).append(')'); switch (unionType) { case SelectUnion.UNION_ALL: buff.append("\nUNION ALL\n"); break; case SelectUnion.UNION: buff.append("\nUNION\n"); break; case SelectUnion.INTERSECT: buff.append("\nINTERSECT\n"); break; case SelectUnion.EXCEPT: buff.append("\nEXCEPT\n"); break; default: throw new CacheException("type=" + unionType); } buff.append('(').append(right.getSQL()).append(')'); getSortLimitSQL(buff); return buff.toString(); }
/** @param qry Query. */ private void checkQuery(String qry) throws Exception { Prepared prepared = parse(qry); GridSqlQuery gQry = new GridSqlQueryParser().parse(prepared); String res = gQry.getSQL(); System.out.println(normalizeSql(res)); assertSqlEquals(prepared.getPlanSQL(), res); }
/** {@inheritDoc} */ @Override protected int visibleColumns() { return left.visibleColumns(); }