| Modifier and Type | Class and Description |
|---|---|
| private class | ConditionalNode.
A visitor that replaces all occurrences of the |
| Modifier and Type | Field and Description |
|---|---|
| private CachedValueNode | caseOperand
The case operand if this is a simple case expression. |
| private ValueNodeList | testConditions
The list of test conditions in the WHEN clauses. |
| private ValueNodeList | thenElseList
The list of corresponding THEN expressions to the test conditions in
|
| Access | Constructor and Description |
|---|---|
| pack-priv | ConditionalNode(CachedValueNode
The case operand if this is a simple case
expression, or caseOperand, ValueNodeList null otherwiseThe boolean test conditions testConditions, ValueNodeList ValueNodeList with then and else expressions thenElseList, ContextManager The context manager cm)Constructor for a ConditionalNode |
| Modifier and Type | Method and Description |
|---|---|
| pack-priv void | acceptChildren(Visitor
the visitor v)Overrides org. Accept the visitor for all visitable children of this node. |
| private ValueNodeList | Returns: a list of dummy parameter nodes that have been inserted into the tree instead of the case operand, if such a replacement has happened; otherwise,null is returnedBind the case operand, if there is one, and check that it doesn't contain anything that's illegal in a case operand (such as calls to routines that are non-deterministic or modify SQL). |
| pack-priv ValueNode | Returns: The new top of the expression tree.The FROM list for the query this
expression is in, for binding columns. fromList, SubqueryList The subquery list being built as we find SubqueryNodes subqueryList, List<AggregateNode> The aggregate list being built as we find AggregateNodes aggregates)Overrides org. Bind this expression. |
| pack-priv boolean | Returns: boolean Whether or not source.expression is a ColumnReference or a VirtualColumnNode.JBitSet with bit map of referenced FromTables referencedTabs, boolean Whether or not to consider method
calls, field references and conditional nodes
when building bit map simplePredsOnly)Overrides org. Categorize this predicate. |
| pack-priv boolean | constantExpression(PredicateList whereClause)
Overrides org. Return whether or not this expression tree represents a constant value. |
| pack-priv ValueNode | Returns: The modified expressionWhether or not we are under a NotNode. underNotNode)Overrides org. Eliminate NotNodes in the current query block. |
| pack-priv void | generateExpression(ExpressionClassBuilder
The ExpressionClassBuilder for the class we're generating acb, MethodBuilder The method the expression will go into mb)Overrides org. Do code generation for this conditional expression. |
| pack-priv boolean | Returns: Whether or not this expression tree represents a constant expression.Overrides org. Return whether or not this expression tree represents a constant expression. |
| pack-priv boolean | isEquivalent(ValueNode
the node to compare this ValueNode against. o)Implements abstract org. Tests if this node is equivalent to the specified ValueNode. |
| pack-priv ValueNode | Returns: The modified expressionNumber of tables in the DML Statement numTables, FromList FromList from outer query block outerFromList, SubqueryList SubqueryList from outer query block outerSubqueryList, PredicateList PredicateList from outer query block outerPredicateList)Overrides org. Preprocess an expression tree. |
| pack-priv void | printSubNodes(int
The depth of this node in the tree depth)Overrides org. Prints the sub-nodes of this object. |
| private void | recastNullNodes(DataTypeDescriptor
The type to cast SQL parsed NULL's too. castType, FromList FromList to pass on to bindExpression if recast is performed fromList, SubqueryList SubqueryList to pass on to bindExpression if recast is performed subqueryList, List<AggregateNode> List of aggregates to pass on to bindExpression if recast is performed aggregates)This method makes sure any SQL NULLs will be cast to the correct type. |
| pack-priv ValueNode | Returns: ValueNode The remapped expression tree.Overrides org. Remap all ColumnReferences in this tree to be clones of the underlying expression. |
| caseOperand | back to summary |
|---|---|
| private CachedValueNode caseOperand The case operand if this is a simple case expression. Otherwise, it
is | |
| testConditions | back to summary |
|---|---|
| private ValueNodeList testConditions The list of test conditions in the WHEN clauses. | |
| thenElseList | back to summary |
|---|---|
| private ValueNodeList thenElseList The list of corresponding THEN expressions to the test conditions in
| |
| ConditionalNode | back to summary |
|---|---|
| pack-priv ConditionalNode(CachedValueNode caseOperand, ValueNodeList testConditions, ValueNodeList thenElseList, ContextManager cm) Constructor for a ConditionalNode
| |
| acceptChildren | back to summary |
|---|---|
| pack-priv void acceptChildren(Visitor v) throws StandardException Overrides org. Accept the visitor for all visitable children of this node.
| |
| bindCaseOperand | back to summary |
|---|---|
| private ValueNodeList bindCaseOperand(CompilerContext cc, FromList fromList, SubqueryList subqueryList, List<AggregateNode> aggregates) throws StandardException Bind the case operand, if there is one, and check that it doesn't contain anything that's illegal in a case operand (such as calls to routines that are non-deterministic or modify SQL).
Also, if the type of the case operand needs to be inferred, insert
dummy parameter nodes into
| |
| bindExpression | back to summary |
|---|---|
| pack-priv ValueNode bindExpression(FromList fromList, SubqueryList subqueryList, List<AggregateNode> aggregates) throws StandardException Overrides org. Bind this expression. This means binding the sub-expressions, as well as figuring out what the return type is for this expression.
| |
| categorize | back to summary |
|---|---|
| pack-priv boolean categorize(JBitSet referencedTabs, boolean simplePredsOnly) throws StandardException Overrides org. Categorize this predicate. Initially, this means building a bit map of the referenced tables for each predicate. If the source of this ColumnReference (at the next underlying level) is not a ColumnReference or a VirtualColumnNode then this predicate will not be pushed down. For example, in: select * from (select 1 from s) a (x) where x = 1 we will not push down x = 1. Note It would be easy to handle the case of a constant, but if the inner SELECT returns an arbitrary expression, then we would have to copy that tree into the pushed predicate, and that tree could contain subqueries and method calls. RESOLVE - revisit this issue once we have views.
| |
| constantExpression | back to summary |
|---|---|
| pack-priv boolean constantExpression(PredicateList whereClause) Overrides org. Doc from org. Return whether or not this expression tree represents a constant value. In this case, "constant" means that it will always evaluate to the same thing, even if it includes columns. A column is constant if it is compared to a constant expression.
| |
| eliminateNots | back to summary |
|---|---|
| pack-priv ValueNode eliminateNots(boolean underNotNode) throws StandardException Overrides org. Eliminate NotNodes in the current query block. We traverse the tree, inverting ANDs and ORs and eliminating NOTs as we go. We stop at ComparisonOperators and boolean expressions. We invert ComparisonOperators and replace boolean expressions with boolean expression = false. Note Since we do not recurse under ComparisonOperators, there still could be NotNodes left in the tree.
| |
| generateExpression | back to summary |
|---|---|
| pack-priv void generateExpression(ExpressionClassBuilder acb, MethodBuilder mb) throws StandardException Overrides org. Do code generation for this conditional expression.
| |
| isConstantExpression | back to summary |
|---|---|
| pack-priv boolean isConstantExpression() Overrides org. Return whether or not this expression tree represents a constant expression.
| |
| isEquivalent | back to summary |
|---|---|
| pack-priv boolean isEquivalent(ValueNode o) throws StandardException Implements abstract org. Doc from org. Tests if this node is equivalent to the specified ValueNode. Two ValueNodes are considered equivalent if they will evaluate to the same value during query execution. This method provides basic expression matching facility for the derived class of ValueNode and it is used by the language layer to compare the node structural form of the two expressions for equivalence at bind phase. Note that it is not comparing the actual row values at runtime to produce a result; hence, when comparing SQL NULLs, they are considered to be equivalent and not unknown. One usage case of this method in this context is to compare the select column expression against the group by expression to check if they are equivalent. e.g.: SELECT c1+c2 FROM t1 GROUP BY c1+c2 In general, node equivalence is determined by the derived class of ValueNode. But they generally abide to the rules below:
| |
| preprocess | back to summary |
|---|---|
| pack-priv ValueNode preprocess(int numTables, FromList outerFromList, SubqueryList outerSubqueryList, PredicateList outerPredicateList) throws StandardException Overrides org. Preprocess an expression tree. We do a number of transformations here (including subqueries, IN lists, LIKE and BETWEEN) plus subquery flattening. Note This is done before the outer ResultSetNode is preprocessed.
| |
| printSubNodes | back to summary |
|---|---|
| pack-priv void printSubNodes(int depth) Overrides org. Prints the sub-nodes of this object. See QueryTreeNode.java for how tree printing is supposed to work.
| |
| recastNullNodes | back to summary |
|---|---|
| private void recastNullNodes(DataTypeDescriptor castType, FromList fromList, SubqueryList subqueryList, List<AggregateNode> aggregates) throws StandardException This method makes sure any SQL NULLs will be cast to the correct type.
| |
| remapColumnReferencesToExpressions | back to summary |
|---|---|
| pack-priv ValueNode remapColumnReferencesToExpressions() throws StandardException Overrides org. Remap all ColumnReferences in this tree to be clones of the underlying expression.
| |
caseOperand node
in a tree with dummy parameter nodes. It also fills a supplied list
with the parameter nodes that have been inserted into the tree.
| Modifier and Type | Field and Description |
|---|---|
| private final ValueNodeList |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public boolean | skipChildren(Visitable
the node to process node)Implements org. Method that is called to indicate whether we should skip all nodes below this node for traversal. |
| public boolean | stopTraversal()
Implements org. Method that is called to see if query tree traversal should be stopped before visiting all nodes. |
| public Visitable | visit(Visitable
the node to process node)Implements org. This is the default visit operation on a QueryTreeNode. |
| public boolean | visitChildrenFirst(Visitable
the top node of a sub-tree about to be visited node)Implements org. Method that is called to see if |
| replacements | back to summary |
|---|---|
| private final ValueNodeList replacements | |
| ReplaceCaseOperandVisitor | back to summary |
|---|---|
| private ReplaceCaseOperandVisitor(ValueNodeList replacements) | |
| skipChildren | back to summary |
|---|---|
| public boolean skipChildren(Visitable node) throws StandardException Implements org. Doc from org. Method that is called to indicate whether we should skip all nodes below this node for traversal. Useful if we want to effectively ignore/prune all branches under a particular node. Differs from stopTraversal() in that it only affects subtrees, rather than the entire traversal. | |
| stopTraversal | back to summary |
|---|---|
| public boolean stopTraversal() Implements org. Doc from org. Method that is called to see if query tree traversal should be stopped before visiting all nodes. Useful for short circuiting traversal if we already know we are done.
| |
| visit | back to summary |
|---|---|
| public Visitable visit(Visitable node) throws StandardException Implements org. Doc from org. This is the default visit operation on a QueryTreeNode. It just returns the node. This will typically suffice as the default visit operation for most visitors unless the visitor needs to count the number of nodes visited or something like that. Visitors will overload this method by implementing a version with a signature that matches a specific type of node. For example, if I want to do something special with aggregate nodes, then that Visitor will implement a visit(AggregateNode node) method which does the aggregate specific processing.
| |
| visitChildrenFirst | back to summary |
|---|---|
| public boolean visitChildrenFirst(Visitable node) Implements org. Doc from org. Method that is called to see if | |