public final ParseNode subquery_expression() throws RecognitionException { ParseNode ret = null; SelectStatement s =null; try { // PhoenixSQL.g:724:5: (s= select_node ) // PhoenixSQL.g:724:8: s= select_node { pushFollow(FOLLOW_select_node_in_subquery_expression4459); s=select_node(); state._fsp--; if (state.failed) return ret; if ( state.backtracking==0 ) {ret = factory.subquery(s, false);} } } catch (RecognitionException re) { throw re; } finally { // do for sure before leaving } return ret; } // $ANTLR end "subquery_expression"
if (where == subquery.getWhere()) { // non-correlated comparison subquery, add LIMIT 2, expectSingleRow = true subquery = NODE_FACTORY.select(subquery, NODE_FACTORY.limit(NODE_FACTORY.literal(2))); subqueryNode = NODE_FACTORY.subquery(subquery, true); l = Lists.newArrayList(l.get(0), subqueryNode); node = NODE_FACTORY.comparison(node.getFilterOp(), l.get(0), l.get(1));
if (where == subquery.getWhere()) { // non-correlated EXISTS subquery, add LIMIT 1 subquery = NODE_FACTORY.select(subquery, NODE_FACTORY.limit(NODE_FACTORY.literal(1))); subqueryNode = NODE_FACTORY.subquery(subquery, false); node = NODE_FACTORY.exists(subqueryNode, node.isNegate()); return super.visitLeave(node, Collections.<ParseNode> singletonList(subqueryNode));
ParseNode outerWhere = FACTORY.in(nodes.size() == 1 ? nodes.get(0) : FACTORY.rowValueConstructor(nodes), FACTORY.subquery(innerSelect, false), false, true); ParseNode extractedCondition = whereRewriter.getExtractedCondition(); if (extractedCondition != null) {
public final ParseNode subquery_expression() throws RecognitionException { ParseNode ret = null; SelectStatement s =null; try { // PhoenixSQL.g:724:5: (s= select_node ) // PhoenixSQL.g:724:8: s= select_node { pushFollow(FOLLOW_select_node_in_subquery_expression4459); s=select_node(); state._fsp--; if (state.failed) return ret; if ( state.backtracking==0 ) {ret = factory.subquery(s, false);} } } catch (RecognitionException re) { throw re; } finally { // do for sure before leaving } return ret; } // $ANTLR end "subquery_expression"
public final ParseNode subquery_expression() throws RecognitionException { ParseNode ret = null; SelectStatement s =null; try { // PhoenixSQL.g:724:5: (s= select_node ) // PhoenixSQL.g:724:8: s= select_node { pushFollow(FOLLOW_select_node_in_subquery_expression4459); s=select_node(); state._fsp--; if (state.failed) return ret; if ( state.backtracking==0 ) {ret = factory.subquery(s, false);} } } catch (RecognitionException re) { throw re; } finally { // do for sure before leaving } return ret; } // $ANTLR end "subquery_expression"
if (where == subquery.getWhere()) { // non-correlated comparison subquery, add LIMIT 2, expectSingleRow = true subquery = NODE_FACTORY.select(subquery, NODE_FACTORY.limit(NODE_FACTORY.literal(2))); subqueryNode = NODE_FACTORY.subquery(subquery, true); l = Lists.newArrayList(l.get(0), subqueryNode); node = NODE_FACTORY.comparison(node.getFilterOp(), l.get(0), l.get(1));
if (where == subquery.getWhere()) { // non-correlated comparison subquery, add LIMIT 2, expectSingleRow = true subquery = NODE_FACTORY.select(subquery, NODE_FACTORY.limit(NODE_FACTORY.literal(2))); subqueryNode = NODE_FACTORY.subquery(subquery, true); l = Lists.newArrayList(l.get(0), subqueryNode); node = NODE_FACTORY.comparison(node.getFilterOp(), l.get(0), l.get(1));
if (where == subquery.getWhere()) { // non-correlated EXISTS subquery, add LIMIT 1 subquery = NODE_FACTORY.select(subquery, NODE_FACTORY.limit(NODE_FACTORY.literal(1))); subqueryNode = NODE_FACTORY.subquery(subquery, false); node = NODE_FACTORY.exists(subqueryNode, node.isNegate()); return super.visitLeave(node, Collections.<ParseNode> singletonList(subqueryNode));
if (where == subquery.getWhere()) { // non-correlated EXISTS subquery, add LIMIT 1 subquery = NODE_FACTORY.select(subquery, NODE_FACTORY.limit(NODE_FACTORY.literal(1))); subqueryNode = NODE_FACTORY.subquery(subquery, false); node = NODE_FACTORY.exists(subqueryNode, node.isNegate()); return super.visitLeave(node, Collections.<ParseNode> singletonList(subqueryNode));
ParseNode outerWhere = FACTORY.in(nodes.size() == 1 ? nodes.get(0) : FACTORY.rowValueConstructor(nodes), FACTORY.subquery(innerSelect, false), false, true); ParseNode extractedCondition = whereRewriter.getExtractedCondition(); if (extractedCondition != null) {
ParseNode outerWhere = FACTORY.in(nodes.size() == 1 ? nodes.get(0) : FACTORY.rowValueConstructor(nodes), FACTORY.subquery(innerSelect, false), false, true); ParseNode extractedCondition = whereRewriter.getExtractedCondition(); if (extractedCondition != null) {