@Override public void visit( ScalarSubquery obj ) { if (obj.getSubqueryHint().isDepJoin() || obj.getSubqueryHint().isMergeJoin() || obj.getSubqueryHint().isNoUnnest()) { if (this.parts.length() > 0 && this.parts.charAt(this.parts.length()-1) == ' ') { this.parts.setLength(this.parts.length() -1); } addSubqueryHint(obj.getSubqueryHint()); append(SPACE); } append("("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ScalarSubquery obj ) { if (obj.getSubqueryHint().isDepJoin() || obj.getSubqueryHint().isMergeJoin() || obj.getSubqueryHint().isNoUnnest()) { if (this.parts.length() > 0 && this.parts.charAt(this.parts.length()-1) == ' ') { this.parts.setLength(this.parts.length() -1); } addSubqueryHint(obj.getSubqueryHint()); append(SPACE); } append("("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ScalarSubquery obj ) { if (obj.getSubqueryHint().isDepJoin() || obj.getSubqueryHint().isMergeJoin() || obj.getSubqueryHint().isNoUnnest()) { if (this.parts.length() > 0 && this.parts.charAt(this.parts.length()-1) == ' ') { this.parts.setLength(this.parts.length() -1); } addSubqueryHint(obj.getSubqueryHint()); append(SPACE); } append("("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
if (ssc.getSubqueryHint().isNoUnnest()) { return result; if (cc.getRightExpression() instanceof ScalarSubquery) { ScalarSubquery ss = (ScalarSubquery)cc.getRightExpression(); if (ss.getSubqueryHint().isNoUnnest()) { return result; if (ss.getSubqueryHint().isNoUnnest()) { return result; if (scc.getSubqueryHint().isNoUnnest()) { return result; if (exists.getSubqueryHint().isNoUnnest()) { return result;
if (ssc.getSubqueryHint().isNoUnnest()) { return result; if (cc.getRightExpression() instanceof ScalarSubquery) { ScalarSubquery ss = (ScalarSubquery)cc.getRightExpression(); if (ss.getSubqueryHint().isNoUnnest()) { return result; if (scc.getSubqueryHint().isNoUnnest()) { return result; if (exists.getSubqueryHint().isNoUnnest()) { return result;
if (ssc.getSubqueryHint().isNoUnnest()) { return result; if (cc.getRightExpression() instanceof ScalarSubquery) { ScalarSubquery ss = (ScalarSubquery)cc.getRightExpression(); if (ss.getSubqueryHint().isNoUnnest()) { return result; if (ss.getSubqueryHint().isNoUnnest()) { return result; if (scc.getSubqueryHint().isNoUnnest()) { return result; if (exists.getSubqueryHint().isNoUnnest()) { return result;
public void addSubqueryHint(SubqueryHint hint) { if (hint.isNoUnnest()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.NOUNNEST); append(SPACE); append(END_HINT); } else if (hint.isDepJoin()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.DJ); append(SPACE); append(END_HINT); } else if (hint.isMergeJoin()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.MJ); append(SPACE); append(END_HINT); } }
public void addSubqueryHint(SubqueryHint hint) { if (hint.isNoUnnest()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.NOUNNEST); append(SPACE); append(END_HINT); } else if (hint.isDepJoin()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.DJ); append(SPACE); append(END_HINT); } else if (hint.isMergeJoin()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.MJ); append(SPACE); append(END_HINT); } }
public void addSubqueryHint(SubqueryHint hint) { if (hint.isNoUnnest()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.NOUNNEST); append(SPACE); append(END_HINT); } else if (hint.isDepJoin()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.DJ); append(SPACE); append(END_HINT); } else if (hint.isMergeJoin()) { append(SPACE); append(BEGIN_HINT); append(SPACE); append(SubqueryHint.MJ); append(SPACE); append(END_HINT); } }
public PlannedResult findSubquery(Expression expr, boolean unnest, PlannedResult result) { if (expr instanceof ScalarSubquery) { ScalarSubquery scc = (ScalarSubquery)expr; if (scc.getSubqueryHint().isNoUnnest()) { return result; } Query query = (Query)scc.getCommand(); if (!isSingleRow(query)) { return result; } result.type = scc.getClass(); result.mergeJoin = scc.getSubqueryHint().isMergeJoin(); if (!unnest && !result.mergeJoin) { return result; } result.makeInd = scc.getSubqueryHint().isDepJoin(); result.query = query; } return result; }
public PlannedResult findSubquery(Expression expr, boolean unnest, PlannedResult result, boolean requireSingleRow) throws QueryMetadataException, TeiidComponentException { if (expr instanceof ScalarSubquery) { ScalarSubquery scc = (ScalarSubquery)expr; if (scc.getSubqueryHint().isNoUnnest()) { return result; } Query query = (Query)scc.getCommand(); result.multiRow = !isSingleRow(query); result.type = scc.getClass(); result.mergeJoin = scc.getSubqueryHint().isMergeJoin(); if (!unnest && !result.mergeJoin) { return result; } result.makeInd = scc.getSubqueryHint().isDepJoin(); result.query = query; } return result; }
public PlannedResult findSubquery(Expression expr, boolean unnest, PlannedResult result, boolean requireSingleRow) throws QueryMetadataException, TeiidComponentException { if (expr instanceof ScalarSubquery) { ScalarSubquery scc = (ScalarSubquery)expr; if (scc.getSubqueryHint().isNoUnnest()) { return result; } Query query = (Query)scc.getCommand(); result.multiRow = !isSingleRow(query); result.type = scc.getClass(); result.mergeJoin = scc.getSubqueryHint().isMergeJoin(); if (!unnest && !result.mergeJoin) { return result; } result.makeInd = scc.getSubqueryHint().isDepJoin(); result.query = query; } return result; }