Examples of org.apache.derby.impl.sql.compile.SelectNode

Package org.apache.derby.impl.sql.compile

Examples of org.apache.derby.impl.sql.compile.SelectNode

org.apache.derby.impl.sql.compile.SelectNode
A SelectNode represents the result set for any of the basic DML operations: SELECT, INSERT, UPDATE, and DELETE. (A RowResultSetNode will be used for an INSERT with a VALUES clause.) For INSERT - SELECT, any of the fields in a SelectNode can be used (the SelectNode represents the SELECT statement in the INSERT - SELECT). For UPDATE and DELETE, there will be one table in the fromList, and the groupByList fields will be null. For both INSERT and UPDATE, the resultColumns in the selectList will contain the names of the columns being inserted into or updated. @author Jeff Lichtman

                                                                C_NodeTypes.FROM_LIST,
                                                                getContextManager());


                fromList.addFromTable(fromTable);


                SelectNode resultSet = (SelectNode) nodeFactory.getNode(
                                                                                C_NodeTypes.SELECT_NODE,
                                                                                null,
                                                                                null,   /* AGGREGATE list */
                                                                                fromList, /* FROM list */
                                                                                whereClause, /* WHERE clause */

View Full Code Here

                                                                C_NodeTypes.FROM_LIST,
                                                                getContextManager());


                fromList.addFromTable(fromTable);


                SelectNode resultSet = (SelectNode) nodeFactory.getNode(
                                                                                C_NodeTypes.SELECT_NODE,
                                                                                setClause,
                                                                                null,   /* AGGREGATE list */
                                                                                fromList, /* FROM list */
                                                                                whereClause, /* WHERE clause */

View Full Code Here

/*
 * <A NAME="querySpecification">querySpecification</A>
 */
  final public ResultSetNode querySpecification() throws ParseException, StandardException {
        ResultColumnList        selectList;
        SelectNode                      selectNode;
        boolean isDistinct = false;
    jj_consume_token(SELECT);
    if (jj_2_16(1)) {
      isDistinct = setQuantifier();
    } else {
      ;
    }
    selectList = selectList();
    selectNode = tableExpression(selectList);
                if (isDistinct) selectNode.makeDistinct();
                {if (true) return selectNode;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here


/*
 * <A NAME="tableExpression">tableExpression</A>
 */
  final public SelectNode tableExpression(ResultColumnList selectList) throws ParseException, StandardException {
        SelectNode      selectNode;
        FromList        fromList;
        ValueNode       whereClause = null;
        GroupByList     groupByList = null;
        ValueNode       havingClause = null;
        Token           whereToken;

View Full Code Here

                                                                C_NodeTypes.FROM_LIST,
                                                                getContextManager());


                fromList.addFromTable(fromTable);


                SelectNode resultSet = (SelectNode) nodeFactory.getNode(
                                                                                C_NodeTypes.SELECT_NODE,
                                                                                null,
                                                                                null,   /* AGGREGATE list */
                                                                                fromList, /* FROM list */
                                                                                whereClause, /* WHERE clause */

View Full Code Here

                                                                C_NodeTypes.FROM_LIST,
                                                                getContextManager());


                fromList.addFromTable(fromTable);


                SelectNode resultSet = (SelectNode) nodeFactory.getNode(
                                                                                C_NodeTypes.SELECT_NODE,
                                                                                setClause,
                                                                                null,   /* AGGREGATE list */
                                                                                fromList, /* FROM list */
                                                                                whereClause, /* WHERE clause */

View Full Code Here

/*
 * <A NAME="querySpecification">querySpecification</A>
 */
  final public ResultSetNode querySpecification() throws ParseException, StandardException {
        ResultColumnList        selectList;
        SelectNode                      selectNode;
        boolean isDistinct = false;
    jj_consume_token(SELECT);
    if (jj_2_16(1)) {
      isDistinct = setQuantifier();
    } else {
      ;
    }
    selectList = selectList();
    selectNode = tableExpression(selectList);
                if (isDistinct) selectNode.makeDistinct();
                {if (true) return selectNode;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here


/*
 * <A NAME="tableExpression">tableExpression</A>
 */
  final public SelectNode tableExpression(ResultColumnList selectList) throws ParseException, StandardException {
        SelectNode      selectNode;
        FromList        fromList;
        ValueNode       whereClause = null;
        GroupByList     groupByList = null;
        ValueNode       havingClause = null;
        Token           whereToken;

View Full Code Here

                                                                C_NodeTypes.FROM_LIST,
                                                                getContextManager());


                fromList.addFromTable(fromTable);


                SelectNode resultSet = (SelectNode) nodeFactory.getNode(
                                                                                C_NodeTypes.SELECT_NODE,
                                                                                null,
                                                                                null,   /* AGGREGATE list */
                                                                                fromList, /* FROM list */
                                                                                whereClause, /* WHERE clause */

View Full Code Here

                                                                C_NodeTypes.FROM_LIST,
                                                                getContextManager());


                fromList.addFromTable(fromTable);


                SelectNode resultSet = (SelectNode) nodeFactory.getNode(
                                                                                C_NodeTypes.SELECT_NODE,
                                                                                setClause,
                                                                                null,   /* AGGREGATE list */
                                                                                fromList, /* FROM list */
                                                                                whereClause, /* WHERE clause */

View Full Code Here

0 1 2 3

TOP

Related Classes of org.apache.derby.impl.sql.compile.SelectNode

org.apache.derby.iapi.sql.compile.CompilerContext

org.apache.derby.iapi.sql.compile.Optimizer

org.apache.derby.iapi.sql.compile.OptimizerFactory

org.apache.derby.iapi.sql.compile.Visitable

org.apache.derby.iapi.sql.dictionary.TableDescriptor

org.apache.derby.iapi.util.JBitSet

org.apache.derby.impl.sql.compile.SQLParser

java.util.ArrayList

java.util.List

java.util.HashSet

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.