| java.lang.Object
 org.apache.derby.impl.sql.compile.QueryTreeNode
org.apache.derby.impl.sql.compile.ResultSetNode
org.apache.derby.impl.sql.compile.FromTable
org.apache.derby.impl.sql.compile.TableOperatorNode
org.apache.derby.impl.sql.compile.JoinNode
All known Subclasses: org.apache.derby.impl.sql.compile.HalfOuterJoinNode,
| JoinNode | | public class JoinNode extends TableOperatorNode (Code) | | A JoinNode represents a join result set for either of the basic DML
operations: SELECT and INSERT. For INSERT - SELECT, any of the
fields in a JoinNode can be used (the JoinNode represents
the (join) SELECT statement in the INSERT - SELECT). For INSERT,
the resultColumns in the selectList will contain the names of the columns
being inserted into or updated.
author:
Jeff Lichtman |
| Method Summary | |
| public boolean | LOJ_reorderable(int numTables)
Currently we don't reordering any outer join w/ inner joins. | | public JBitSet | LOJgetReferencedTables(int numTables)
| | public Visitable | accept(Visitor v)
Accept a visitor, and call v.visit()
on child nodes as necessary. | | protected int | addOuterJoinArguments(ActivationClassBuilder acb, MethodBuilder mb)
Generate and add any arguments specifict to outer joins. | | protected void | adjustNumberOfRowsReturned(CostEstimate costEstimate)
Some types of joins (e.g. | | public void | bindResultColumns(FromList fromListParam)
Bind the result columns of this ResultSetNode when there is no
base table to bind them to. | | public void | bindResultColumns(TableDescriptor targetTableDescriptor, FromVTI targetVTI, ResultColumnList targetColumnList, DMLStatementNode statement, FromList fromListParam)
Bind the result columns for this ResultSetNode to a base table.
This is useful for INSERT and UPDATE statements, where the
result columns get their types from the table being updated or
inserted into.
If a result column list is specified, then the verification that the
result column list does not contain any duplicates will be done when
binding them by name.
Parameters:
targetTableDescriptor - The TableDescriptor for the table beingupdated or inserted into
Parameters:
targetColumnList - For INSERT statements, the userdoes not have to supply columnnames (for example, "insert into tvalues (1,2,3)". | | public FromList | flatten(ResultColumnList rcl, PredicateList outerPList, SubqueryList sql, GroupByList gbl)
Flatten this JoinNode into the outer query block. | | public void | generate(ActivationClassBuilder acb, MethodBuilder mb)
| | public void | generateCore(ActivationClassBuilder acb, MethodBuilder mb, int joinType)
Generate the code for a qualified join node. | | protected void | generateCore(ActivationClassBuilder acb, MethodBuilder mb, int joinType, ValueNode joinClause, SubqueryList subquerys)
Do the generation work for the join node hierarchy. | | public ResultColumnList | getAllResultColumns(TableName allTableName)
Return a ResultColumnList with all of the columns in this table. | | public CostEstimate | getFinalCostEstimate()
See Also: ResultSetNode.getFinalCostEstimate
See Also: Get the final CostEstimate for this JoinNode. The final CostEstimate for this JoinNode, which is sumthe costs for the inner and outer table. | | protected PredicateList | getLeftPredicateList()
| | ResultSetNode | getLogicalLeftResultSet()
Return the logical left result set for this qualified
join node. | | ResultSetNode | getLogicalRightResultSet()
Return the logical right result set for this qualified
join node. | | public ResultColumn | getMatchingColumn(ColumnReference columnReference)
Try to find a ResultColumn in the table represented by this FromTable
that matches the name in the given ColumnReference. | | protected int | getNumJoinArguments()
Return the number of arguments to the join result set. | | protected PredicateList | getRightPredicateList()
| | public void | init(Object leftResult, Object rightResult, Object onClause, Object usingClause, Object selectList, Object tableProperties, Object joinOrderStrategyProperties)
Initializer for a JoinNode. | | public boolean | isFlattenableJoinNode()
Is this FromTable a JoinNode which can be flattened into
the parents FromList. | | boolean | isOrderedOn(ColumnReference[] crs, boolean permuteOrdering, Vector fbtVector)
Return whether or not the underlying ResultSet tree
is ordered on the specified columns. | | public static String | joinTypeToString(int joinType)
Convert the joinType to a string.
Parameters:
joinType - The joinType as an int. | | public Optimizable | modifyAccessPath(JBitSet outerTables)
| | public void | normExpressions()
| | void | notFlattenableJoin()
Mark this node and its children as not being a flattenable join. | | protected void | oneRowRightSide(ActivationClassBuilder acb, MethodBuilder mb)
| | public CostEstimate | optimizeIt(Optimizer optimizer, OptimizablePredicateList predList, CostEstimate outerCost, RowOrdering rowOrdering)
| | public ResultSetNode | preprocess(int numTables, GroupByList gbl, FromList fromList)
Put a ProjectRestrictNode on top of each FromTable in the FromList.
ColumnReferences must continue to point to the same ResultColumn, so
that ResultColumn must percolate up to the new PRN. | | public void | printSubNodes(int depth)
Prints the sub-nodes of this object. | | void | projectResultColumns()
Find the unreferenced result columns and project them out. | | public void | pushExpressions(PredicateList outerPredicateList)
Push expressions down to the first ResultSetNode which can do expression
evaluation and has the same referenced table map.
RESOLVE - This means only pushing down single table expressions to
DistinctNodes today. | | protected void | pushExpressionsToLeft(PredicateList outerPredicateList)
| | public boolean | pushOptPredicate(OptimizablePredicate optimizablePredicate)
| | void | setAggregateVector(Vector aggregateVector)
| | void | setSubqueryList(SubqueryList subqueryList)
| | public FromTable | transformOuterJoins(ValueNode predicateTree, int numTables)
Transform any Outer Join into an Inner Join where applicable. | | public int | updateTargetLockMode()
Get the lock mode for the target of an update statement
(a delete or update). |
| CROSSJOIN | | final public static int CROSSJOIN(Code) | | |
| FULLOUTERJOIN | | final public static int FULLOUTERJOIN(Code) | | |
| INNERJOIN | | final public static int INNERJOIN(Code) | | |
| LEFTOUTERJOIN | | final public static int LEFTOUTERJOIN(Code) | | |
| RIGHTOUTERJOIN | | final public static int RIGHTOUTERJOIN(Code) | | |
| UNIONJOIN | | final public static int UNIONJOIN(Code) | | |
| flattenableJoin | | protected boolean flattenableJoin(Code) | | |
| joinClauseNormalized | | boolean joinClauseNormalized(Code) | | |
| LOJ_reorderable | | public boolean LOJ_reorderable(int numTables) throws StandardException(Code) | | Currently we don't reordering any outer join w/ inner joins.
|
| addOuterJoinArguments | | protected int addOuterJoinArguments(ActivationClassBuilder acb, MethodBuilder mb) throws StandardException(Code) | | Generate and add any arguments specifict to outer joins.
(Expected to be overriden, where appropriate, in subclasses.)
Parameters:
acb - The ActivationClassBuilder
Parameters:
mb - the method the generated code is to go intoreturn The number of args added
exception:
StandardException - Thrown on error |
| adjustNumberOfRowsReturned | | protected void adjustNumberOfRowsReturned(CostEstimate costEstimate)(Code) | | Some types of joins (e.g. outer joins) will return a different
number of rows than is predicted by optimizeIt() in JoinNode.
So, adjust this value now. This method does nothing for most
join types.
|
| bindResultColumns | | public void bindResultColumns(FromList fromListParam) throws StandardException(Code) | | Bind the result columns of this ResultSetNode when there is no
base table to bind them to. This is useful for SELECT statements,
where the result columns get their types from the expressions that
live under them.
Parameters:
fromListParam - FromList to use/append to.
exception:
StandardException - Thrown on error |
| bindResultColumns | | public void bindResultColumns(TableDescriptor targetTableDescriptor, FromVTI targetVTI, ResultColumnList targetColumnList, DMLStatementNode statement, FromList fromListParam) throws StandardException(Code) | | Bind the result columns for this ResultSetNode to a base table.
This is useful for INSERT and UPDATE statements, where the
result columns get their types from the table being updated or
inserted into.
If a result column list is specified, then the verification that the
result column list does not contain any duplicates will be done when
binding them by name.
Parameters:
targetTableDescriptor - The TableDescriptor for the table beingupdated or inserted into
Parameters:
targetColumnList - For INSERT statements, the userdoes not have to supply columnnames (for example, "insert into tvalues (1,2,3)". When thisparameter is null, it means thatthe user did not supply columnnames, and so the binding shouldbe done based on order. When itis not null, it means do the bindingby name, not position.
Parameters:
statement - Calling DMLStatementNode (Insert or Update)
Parameters:
fromListParam - FromList to use/append to.
exception:
StandardException - Thrown on error |
| flatten | | public FromList flatten(ResultColumnList rcl, PredicateList outerPList, SubqueryList sql, GroupByList gbl) throws StandardException(Code) | | Flatten this JoinNode into the outer query block. The steps in
flattening are:
o Mark all ResultColumns as redundant, so that they are "skipped over"
at generate().
o Append the joinPredicates to the outer list.
o Create a FromList from the tables being joined and return
that list so that the caller will merge the 2 lists
Parameters:
rcl - The RCL from the outer query
Parameters:
outerPList - PredicateList to append wherePredicates to.
Parameters:
sql - The SubqueryList from the outer query
Parameters:
gbl - The group by list, if any FromList The fromList from the underlying SelectNode.
exception:
StandardException - Thrown on error |
| generate | | public void generate(ActivationClassBuilder acb, MethodBuilder mb) throws StandardException(Code) | | For joins, the tree will be (nodes are left out if the clauses
are empty):
ProjectRestrictResultSet -- for the having and the select list
SortResultSet -- for the group by list
ProjectRestrictResultSet -- for the where and the select list (if no group or having)
the result set for the fromList
exception:
StandardException - Thrown on error |
| generateCore | | protected void generateCore(ActivationClassBuilder acb, MethodBuilder mb, int joinType, ValueNode joinClause, SubqueryList subquerys) throws StandardException(Code) | | Do the generation work for the join node hierarchy.
Parameters:
acb - The ActivationClassBuilder
Parameters:
mb - the method the code is to go into
Parameters:
joinType - The join type
Parameters:
joinClause - The join clause, if any
Parameters:
subquerys - The list of subqueries in the join clause, if any
exception:
StandardException - Thrown on error |
| getAllResultColumns | | public ResultColumnList getAllResultColumns(TableName allTableName) throws StandardException(Code) | | Return a ResultColumnList with all of the columns in this table.
(Used in expanding '*'s.)
NOTE: Since this method is for expanding a "*" in the SELECT list,
ResultColumn.expression will be a ColumnReference.
Parameters:
allTableName - The qualifier on the "*" ResultColumnList List of result columns from this table.
exception:
StandardException - Thrown on error |
| getFinalCostEstimate | | public CostEstimate getFinalCostEstimate() throws StandardException(Code) | |
See Also: ResultSetNode.getFinalCostEstimate
See Also: Get the final CostEstimate for this JoinNode. The final CostEstimate for this JoinNode, which is sumthe costs for the inner and outer table. The number of rows,though, is that for the inner table only. |
| getLogicalLeftResultSet | | ResultSetNode getLogicalLeftResultSet()(Code) | | Return the logical left result set for this qualified
join node.
(For RIGHT OUTER JOIN, the left is the right
and the right is the left and the JOIN is the NIOJ).
|
| getLogicalRightResultSet | | ResultSetNode getLogicalRightResultSet()(Code) | | Return the logical right result set for this qualified
join node.
(For RIGHT OUTER JOIN, the left is the right
and the right is the left and the JOIN is the NIOJ).
|
| getMatchingColumn | | public ResultColumn getMatchingColumn(ColumnReference columnReference) throws StandardException(Code) | | Try to find a ResultColumn in the table represented by this FromTable
that matches the name in the given ColumnReference.
Parameters:
columnReference - The columnReference whose name we're lookingfor in the given table. A ResultColumn whose expression is the ColumnNodethat matches the ColumnReference.Returns null if there is no match.
exception:
StandardException - Thrown on error |
| getNumJoinArguments | | protected int getNumJoinArguments()(Code) | | Return the number of arguments to the join result set. This will
be overridden for other types of joins (for example, outer joins).
|
| init | | public void init(Object leftResult, Object rightResult, Object onClause, Object usingClause, Object selectList, Object tableProperties, Object joinOrderStrategyProperties) throws StandardException(Code) | | Initializer for a JoinNode.
Parameters:
leftResult - The ResultSetNode on the left side of this join
Parameters:
rightResult - The ResultSetNode on the right side of this join
Parameters:
onClause - The ON clause
Parameters:
usingClause - The USING clause
Parameters:
selectList - The result column list for the join
Parameters:
tableProperties - Properties list associated with the table
Parameters:
joinOrderStrategyProperties - User provided optimizer overrides
exception:
StandardException - Thrown on error |
| isFlattenableJoinNode | | public boolean isFlattenableJoinNode()(Code) | | Is this FromTable a JoinNode which can be flattened into
the parents FromList.
boolean Whether or not this FromTable can be flattened. |
| isOrderedOn | | boolean isOrderedOn(ColumnReference[] crs, boolean permuteOrdering, Vector fbtVector) throws StandardException(Code) | | Return whether or not the underlying ResultSet tree
is ordered on the specified columns.
RESOLVE - This method currently only considers the outermost table
of the query block.
Parameters:
crs - The specified ColumnReference[]
Parameters:
permuteOrdering - Whether or not the order of the CRs in the array can be permuted
Parameters:
fbtVector - Vector that is to be filled with the FromBaseTable Whether the underlying ResultSet treeis ordered on the specified column.
exception:
StandardException - Thrown on error |
| joinTypeToString | | public static String joinTypeToString(int joinType)(Code) | | Convert the joinType to a string.
Parameters:
joinType - The joinType as an int. String The joinType as a String. |
| notFlattenableJoin | | void notFlattenableJoin()(Code) | | Mark this node and its children as not being a flattenable join.
|
| preprocess | | public ResultSetNode preprocess(int numTables, GroupByList gbl, FromList fromList) throws StandardException(Code) | | Put a ProjectRestrictNode on top of each FromTable in the FromList.
ColumnReferences must continue to point to the same ResultColumn, so
that ResultColumn must percolate up to the new PRN. However,
that ResultColumn will point to a new expression, a VirtualColumnNode,
which points to the FromTable and the ResultColumn that is the source for
the ColumnReference.
(The new PRN will have the original of the ResultColumnList and
the ResultColumns from that list. The FromTable will get shallow copies
of the ResultColumnList and its ResultColumns. ResultColumn.expression
will remain at the FromTable, with the PRN getting a new
VirtualColumnNode for each ResultColumn.expression.)
We then project out the non-referenced columns. If there are no referenced
columns, then the PRN's ResultColumnList will consist of a single ResultColumn
whose expression is 1.
Parameters:
numTables - Number of tables in the DML Statement
Parameters:
gbl - The group by list, if any
Parameters:
fromList - The from list, if any The generated ProjectRestrictNode atop the original FromTable.
exception:
StandardException - Thrown on error |
| printSubNodes | | public void printSubNodes(int depth)(Code) | | Prints the sub-nodes of this object. See QueryTreeNode.java for
how tree printing is supposed to work.
Parameters:
depth - The depth of this node in the tree |
| projectResultColumns | | void projectResultColumns() throws StandardException(Code) | | Find the unreferenced result columns and project them out. This is used in pre-processing joins
that are not flattened into the where clause.
|
| pushExpressions | | public void pushExpressions(PredicateList outerPredicateList) throws StandardException(Code) | | Push expressions down to the first ResultSetNode which can do expression
evaluation and has the same referenced table map.
RESOLVE - This means only pushing down single table expressions to
DistinctNodes today. Once we have a better understanding of how
the optimizer will work, we can push down join clauses.
Parameters:
outerPredicateList - The PredicateList from the outer RS.
exception:
StandardException - Thrown on error |
| setAggregateVector | | void setAggregateVector(Vector aggregateVector)(Code) | | |
| transformOuterJoins | | public FromTable transformOuterJoins(ValueNode predicateTree, int numTables) throws StandardException(Code) | | Transform any Outer Join into an Inner Join where applicable.
(Based on the existence of a null intolerant
predicate on the inner table.)
Parameters:
predicateTree - The predicate tree for the query block The new tree top (OuterJoin or InnerJoin).
exception:
StandardException - Thrown on error |
| updateTargetLockMode | | public int updateTargetLockMode()(Code) | | Get the lock mode for the target of an update statement
(a delete or update). The update mode will always be row for
CurrentOfNodes. It will be table if there is no where clause.
The lock mode |
| Methods inherited from org.apache.derby.impl.sql.compile.TableOperatorNode | public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc)
public void bindExpressions(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindExpressionsWithTables(FromList fromListParam) throws StandardException(Code)(Java Doc)
public ResultSetNode bindNonVTITables(DataDictionary dataDictionary, FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindResultColumns(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindResultColumns(TableDescriptor targetTableDescriptor, FromVTI targetVTI, ResultColumnList targetColumnList, DMLStatementNode statement, FromList fromListParam) throws StandardException(Code)(Java Doc)
public ResultSetNode bindVTITables(FromList fromListParam) throws StandardException(Code)(Java Doc)
void decrementLevel(int decrement)(Code)(Java Doc)
public String getExposedName()(Code)(Java Doc)
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)(Java Doc)
public ResultSetNode getLeftResultSet()(Code)(Java Doc)
public ResultSetNode getLeftmostResultSet()(Code)(Java Doc)
public ResultSetNode getRightResultSet()(Code)(Java Doc)
public void init(Object leftResultSet, Object rightResultSet, Object tableProperties) throws StandardException(Code)(Java Doc)
void markOrderingDependent()(Code)(Java Doc)
public Optimizable modifyAccessPath(JBitSet outerTables) throws StandardException(Code)(Java Doc)
public ResultSetNode modifyAccessPaths() throws StandardException(Code)(Java Doc)
public boolean needsSpecialRCLBinding()(Code)(Java Doc)
public ResultSetNode optimize(DataDictionary dataDictionary, PredicateList predicateList, double outerRows) throws StandardException(Code)(Java Doc)
protected ResultSetNode optimizeSource(Optimizer optimizer, ResultSetNode sourceResultSet, PredicateList predList, CostEstimate outerCost) throws StandardException(Code)(Java Doc)
public ResultSetNode preprocess(int numTables, GroupByList gbl, FromList fromList) throws StandardException(Code)(Java Doc)
public void printSubNodes(int depth)(Code)(Java Doc)
void projectResultColumns() throws StandardException(Code)(Java Doc)
public boolean referencesSessionSchema() throws StandardException(Code)(Java Doc)
public boolean referencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
public void rejectParameters() throws StandardException(Code)(Java Doc)
void replaceDefaults(TableDescriptor ttd, ResultColumnList tcl) throws StandardException(Code)(Java Doc)
public void setLeftmostResultSet(ResultSetNode newLeftResultSet)(Code)(Java Doc)
public void setLevel(int level)(Code)(Java Doc)
public void setNestedInParens(boolean nestedInParens)(Code)(Java Doc)
void setReferencedColumns()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public void updateBestPlanMap(short action, Object planKey) throws StandardException(Code)(Java Doc)
public void verifyProperties(DataDictionary dDictionary) throws StandardException(Code)(Java Doc)
|
| Methods inherited from org.apache.derby.impl.sql.compile.FromTable | public boolean LOJ_reorderable(int numTables) throws StandardException(Code)(Java Doc)
protected void assignCostEstimate(CostEstimate newCostEstimate)(Code)(Java Doc)
protected boolean canBeOrdered()(Code)(Java Doc)
public boolean considerSortAvoidancePath()(Code)(Java Doc)
public int convertAbsoluteToRelativeColumnPosition(int absolutePosition)(Code)(Java Doc)
protected boolean cursorTargetTable()(Code)(Java Doc)
void decrementLevel(int decrement)(Code)(Java Doc)
public CostEstimate estimateCost(OptimizablePredicateList predList, ConglomerateDescriptor cd, CostEstimate outerCost, Optimizer optimizer, RowOrdering rowOrdering) throws StandardException(Code)(Java Doc)
public boolean feasibleJoinStrategy(OptimizablePredicateList predList, Optimizer optimizer) throws StandardException(Code)(Java Doc)
public void fillInReferencedTableMap(JBitSet passedMap)(Code)(Java Doc)
public FromList flatten(ResultColumnList rcl, PredicateList outerPList, SubqueryList sql, GroupByList gbl) throws StandardException(Code)(Java Doc)
public boolean forUpdate()(Code)(Java Doc)
public String getBaseTableName()(Code)(Java Doc)
public AccessPath getBestAccessPath()(Code)(Java Doc)
public AccessPath getBestSortAvoidancePath()(Code)(Java Doc)
public String getCorrelationName()(Code)(Java Doc)
protected CostEstimate getCostEstimate(Optimizer optimizer)(Code)(Java Doc)
public AccessPath getCurrentAccessPath()(Code)(Java Doc)
public String getExposedName() throws StandardException(Code)(Java Doc)
public CostEstimate getFinalCostEstimate() throws StandardException(Code)(Java Doc)
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)(Java Doc)
public int getLevel()(Code)(Java Doc)
public String getName() throws StandardException(Code)(Java Doc)
public int getNumColumnsReturned()(Code)(Java Doc)
public TableName getOrigTableName()(Code)(Java Doc)
public Properties getProperties()(Code)(Java Doc)
public ResultColumnList getResultColumnsForList(TableName allTableName, ResultColumnList inputRcl, TableName tableName) throws StandardException(Code)(Java Doc)
public SchemaDescriptor getSchemaDescriptor() throws StandardException(Code)(Java Doc)
public SchemaDescriptor getSchemaDescriptor(TableName tableName) throws StandardException(Code)(Java Doc)
protected CostEstimate getScratchCostEstimate(Optimizer optimizer)(Code)(Java Doc)
public TableDescriptor getTableDescriptor()(Code)(Java Doc)
public TableName getTableName() throws StandardException(Code)(Java Doc)
public int getTableNumber()(Code)(Java Doc)
public AccessPath getTrulyTheBestAccessPath()(Code)(Java Doc)
String getUserSpecifiedJoinStrategy()(Code)(Java Doc)
public boolean hasTableNumber()(Code)(Java Doc)
public int[] hashKeyColumns()(Code)(Java Doc)
public void init(Object correlationName, Object tableProperties)(Code)(Java Doc)
public void initAccessPaths(Optimizer optimizer)(Code)(Java Doc)
public int initialCapacity()(Code)(Java Doc)
public boolean isBaseTable()(Code)(Java Doc)
public boolean isCoveringIndex(ConglomerateDescriptor cd) throws StandardException(Code)(Java Doc)
public boolean isFlattenableJoinNode()(Code)(Java Doc)
public boolean isMaterializable() throws StandardException(Code)(Java Doc)
public boolean isOneRowScan() throws StandardException(Code)(Java Doc)
public boolean isTargetTable()(Code)(Java Doc)
public boolean legalJoinOrder(JBitSet assignedTableMap)(Code)(Java Doc)
public float loadFactor()(Code)(Java Doc)
protected void markUpdatableByCursor(Vector updateColumns)(Code)(Java Doc)
public int maxCapacity(JoinStrategy joinStrategy, int maxMemoryPerTable) throws StandardException(Code)(Java Doc)
public boolean memoryUsageOK(double rowCount, int maxMemoryPerTable) throws StandardException(Code)(Java Doc)
public Optimizable modifyAccessPath(JBitSet outerTables) throws StandardException(Code)(Java Doc)
public boolean needsSpecialRCLBinding()(Code)(Java Doc)
public boolean nextAccessPath(Optimizer optimizer, OptimizablePredicateList predList, RowOrdering rowOrdering) throws StandardException(Code)(Java Doc)
public CostEstimate optimizeIt(Optimizer optimizer, OptimizablePredicateList predList, CostEstimate outerCost, RowOrdering rowOrdering) throws StandardException(Code)(Java Doc)
void optimizeSubqueries(DataDictionary dd, double rowCount) throws StandardException(Code)(Java Doc)
public void pullOptPredicates(OptimizablePredicateList optimizablePredicates) throws StandardException(Code)(Java Doc)
void pushExpressions(PredicateList predicateList) throws StandardException(Code)(Java Doc)
public boolean pushOptPredicate(OptimizablePredicate optimizablePredicate) throws StandardException(Code)(Java Doc)
public void rememberAsBest(int planType, Optimizer optimizer) throws StandardException(Code)(Java Doc)
public void rememberJoinStrategyAsBest(AccessPath ap)(Code)(Java Doc)
public void rememberSortAvoidancePath()(Code)(Java Doc)
protected void resetJoinStrategies(Optimizer optimizer)(Code)(Java Doc)
protected void setCostEstimate(CostEstimate newCostEstimate)(Code)(Java Doc)
public void setHashKeyColumns(int[] columnNumbers)(Code)(Java Doc)
public void setLevel(int level)(Code)(Java Doc)
public void setOrigTableName(TableName tableName)(Code)(Java Doc)
public void setProperties(Properties tableProperties)(Code)(Java Doc)
public void setTableNumber(int tableNumber)(Code)(Java Doc)
public void startOptimizing(Optimizer optimizer, RowOrdering rowOrdering)(Code)(Java Doc)
public boolean supportsMultipleInstantiations()(Code)(Java Doc)
protected void tellRowOrderingAboutConstantColumns(RowOrdering rowOrdering, OptimizablePredicateList predList)(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public FromTable transformOuterJoins(ValueNode predicateTree, int numTables) throws StandardException(Code)(Java Doc)
public double uniqueJoin(OptimizablePredicateList predList) throws StandardException(Code)(Java Doc)
public void updateBestPlanMap(short action, Object planKey) throws StandardException(Code)(Java Doc)
public void verifyProperties(DataDictionary dDictionary) throws StandardException(Code)(Java Doc)
|
| Methods inherited from org.apache.derby.impl.sql.compile.ResultSetNode | public JBitSet LOJgetReferencedTables(int numTables) throws StandardException(Code)(Java Doc)
public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc)
public ResultSetNode addNewPredicate(Predicate predicate) throws StandardException(Code)(Java Doc)
public void assignResultSetNumber() throws StandardException(Code)(Java Doc)
public void bindExpressions(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindExpressionsWithTables(FromList fromListParam) throws StandardException(Code)(Java Doc)
public ResultSetNode bindNonVTITables(DataDictionary dataDictionary, FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindResultColumns(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindResultColumns(TableDescriptor targetTableDescriptor, FromVTI targetVTI, ResultColumnList targetColumnList, DMLStatementNode statement, FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindTargetExpressions(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindUntypedNullsToResultColumns(ResultColumnList rcl) throws StandardException(Code)(Java Doc)
public ResultSetNode bindVTITables(FromList fromListParam) throws StandardException(Code)(Java Doc)
public ResultSetNode changeAccessPath() throws StandardException(Code)(Java Doc)
boolean columnTypesAndLengthsMatch() throws StandardException(Code)(Java Doc)
public ResultSetNode considerMaterialization(JBitSet outerTables) throws StandardException(Code)(Java Doc)
abstract void decrementLevel(int decrement)(Code)(Java Doc)
public void disablePrivilegeCollection()(Code)(Java Doc)
public ResultSetNode enhanceRCLForInsert(int numTargetColumns, int[] colMap, DataDictionary dataDictionary, TableDescriptor targetTD, FromVTI targetVTI) throws StandardException(Code)(Java Doc)
public ResultSetNode ensurePredicateList(int numTables) throws StandardException(Code)(Java Doc)
public void fillInReferencedTableMap(JBitSet passedMap)(Code)(Java Doc)
public boolean flattenableInFromSubquery(FromList fromList)(Code)(Java Doc)
ResultColumn genNewRCForInsert(TableDescriptor targetTD, FromVTI targetVTI, int columnNumber, DataDictionary dataDictionary) throws StandardException(Code)(Java Doc)
public NormalizeResultSetNode genNormalizeResultSetNode(ResultSetNode normalizeChild, boolean forUpdate) throws StandardException(Code)(Java Doc)
public ResultSetNode genProjectRestrict() throws StandardException(Code)(Java Doc)
protected ResultSetNode genProjectRestrict(int numTables) throws StandardException(Code)(Java Doc)
ResultSetNode genProjectRestrictForReordering() throws StandardException(Code)(Java Doc)
public void generateNormalizationResultSet(ActivationClassBuilder acb, MethodBuilder mb, int resultSetNumber, ResultDescription resultDescription) throws StandardException(Code)(Java Doc)
public void generateResultSet(ExpressionClassBuilder acb, MethodBuilder mb) throws StandardException(Code)(Java Doc)
public ResultColumnList getAllResultColumns(TableName allTableName) throws StandardException(Code)(Java Doc)
public CostEstimate getCostEstimate()(Code)(Java Doc)
FromTable getCursorTargetTable()(Code)(Java Doc)
public CostEstimate getFinalCostEstimate() throws StandardException(Code)(Java Doc)
public FromList getFromList() throws StandardException(Code)(Java Doc)
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)(Java Doc)
public ResultColumn getMatchingColumn(ColumnReference columnReference) throws StandardException(Code)(Java Doc)
protected CostEstimate getNewCostEstimate() throws StandardException(Code)(Java Doc)
protected Optimizer getOptimizer(OptimizableList optList, OptimizablePredicateList predList, DataDictionary dataDictionary, RequiredRowOrdering requiredRowOrdering) throws StandardException(Code)(Java Doc)
protected OptimizerImpl getOptimizerImpl()(Code)(Java Doc)
public JBitSet getReferencedTableMap()(Code)(Java Doc)
public ResultColumnList getResultColumns()(Code)(Java Doc)
public int getResultSetNumber()(Code)(Java Doc)
public boolean isNotExists()(Code)(Java Doc)
public boolean isOneRowResultSet() throws StandardException(Code)(Java Doc)
boolean isOrderedOn(ColumnReference[] crs, boolean permuteOrdering, Vector fbtVector) throws StandardException(Code)(Java Doc)
boolean isPossibleDistinctScan(Set distinctColumns)(Code)(Java Doc)
boolean isUpdatableCursor(DataDictionary dd) throws StandardException(Code)(Java Doc)
public ResultDescription makeResultDescription()(Code)(Java Doc)
ResultColumnDescriptor[] makeResultDescriptors(ExecutionContext ec)(Code)(Java Doc)
public boolean markAsCursorTargetTable()(Code)(Java Doc)
void markForDistinctScan()(Code)(Java Doc)
void markOrderingDependent()(Code)(Java Doc)
public void markStatementResultSet()(Code)(Java Doc)
public ResultSetNode modifyAccessPaths() throws StandardException(Code)(Java Doc)
public ResultSetNode modifyAccessPaths(PredicateList predList) throws StandardException(Code)(Java Doc)
void notCursorTargetTable()(Code)(Java Doc)
void notFlattenableJoin()(Code)(Java Doc)
final protected static int numDistinctAggregates(Vector aggregateVector)(Code)(Java Doc)
public ResultSetNode optimize(DataDictionary dataDictionary, PredicateList predicates, double outerRows) throws StandardException(Code)(Java Doc)
public ValueNode parseDefault(String defaultText) throws StandardException(Code)(Java Doc)
public boolean performMaterialization(JBitSet outerTables) throws StandardException(Code)(Java Doc)
public ResultSetNode preprocess(int numTables, GroupByList gbl, FromList fromList) throws StandardException(Code)(Java Doc)
public void printSubNodes(int depth)(Code)(Java Doc)
void projectResultColumns() throws StandardException(Code)(Java Doc)
void pushOrderByList(OrderByList orderByList)(Code)(Java Doc)
public boolean referencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
public void rejectParameters() throws StandardException(Code)(Java Doc)
public void rejectXMLValues() throws StandardException(Code)(Java Doc)
public void renameGeneratedResultNames() throws StandardException(Code)(Java Doc)
void replaceDefaults(TableDescriptor ttd, ResultColumnList tcl) throws StandardException(Code)(Java Doc)
boolean returnsAtMostOneRow()(Code)(Java Doc)
public void setInsertSource()(Code)(Java Doc)
public void setReferencedTableMap(JBitSet newRTM)(Code)(Java Doc)
public void setResultColumns(ResultColumnList newRCL)(Code)(Java Doc)
public void setResultToBooleanTrueNode(boolean onlyConvertAlls) throws StandardException(Code)(Java Doc)
void setTableConstructorTypes(ResultColumnList typeColumns) throws StandardException(Code)(Java Doc)
boolean subqueryReferencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public int updateTargetLockMode()(Code)(Java Doc)
public void verifySelectStarSubquery(FromList outerFromList, int subqueryType) throws StandardException(Code)(Java Doc)
|
| Methods inherited from org.apache.derby.impl.sql.compile.QueryTreeNode | public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc)
public QueryTreeNode bind() throws StandardException(Code)(Java Doc)
public DataValueDescriptor convertDefaultNode(DataTypeDescriptor typeDescriptor) throws StandardException(Code)(Java Doc)
protected static void debugFlush()(Code)(Java Doc)
public static void debugPrint(String outputString)(Code)(Java Doc)
public void disablePrivilegeCollection()(Code)(Java Doc)
public String executeSchemaName()(Code)(Java Doc)
public String executeStatementName()(Code)(Java Doc)
public static String formatNodeString(String nodeString, int depth)(Code)(Java Doc)
public boolean foundString(String[] list, String search)(Code)(Java Doc)
public GeneratedClass generate(ByteArray ignored) throws StandardException(Code)(Java Doc)
protected void generate(ActivationClassBuilder acb, MethodBuilder mb) throws StandardException(Code)(Java Doc)
void generateAuthorizeCheck(ActivationClassBuilder acb, MethodBuilder mb, int sqlOperation)(Code)(Java Doc)
public int getBeginOffset()(Code)(Java Doc)
final protected ClassFactory getClassFactory()(Code)(Java Doc)
final protected CompilerContext getCompilerContext()(Code)(Java Doc)
final public ContextManager getContextManager()(Code)(Java Doc)
public Object getCursorInfo() throws StandardException(Code)(Java Doc)
final public DataDictionary getDataDictionary()(Code)(Java Doc)
final public DependencyManager getDependencyManager()(Code)(Java Doc)
public int getEndOffset()(Code)(Java Doc)
final public ExecutionFactory getExecutionFactory()(Code)(Java Doc)
final public GenericConstantActionFactory getGenericConstantActionFactory()(Code)(Java Doc)
protected int getIntProperty(String value, String key) throws StandardException(Code)(Java Doc)
final protected LanguageConnectionContext getLanguageConnectionContext()(Code)(Java Doc)
final public NodeFactory getNodeFactory()(Code)(Java Doc)
protected int getNodeType()(Code)(Java Doc)
public ConstantNode getNullNode(TypeId typeId, ContextManager cm) throws StandardException(Code)(Java Doc)
public DataTypeDescriptor[] getParameterTypes() throws StandardException(Code)(Java Doc)
public long getRowEstimate()(Code)(Java Doc)
public String getSPSName()(Code)(Java Doc)
final SchemaDescriptor getSchemaDescriptor(String schemaName) throws StandardException(Code)(Java Doc)
final SchemaDescriptor getSchemaDescriptor(String schemaName, boolean raiseError) throws StandardException(Code)(Java Doc)
protected int getStatementType()(Code)(Java Doc)
final protected TableDescriptor getTableDescriptor(String tableName, SchemaDescriptor schema) throws StandardException(Code)(Java Doc)
final protected TypeCompiler getTypeCompiler(TypeId typeId)(Code)(Java Doc)
public void init(Object arg1) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12, Object arg13) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12, Object arg13, Object arg14) throws StandardException(Code)(Java Doc)
public boolean isAtomic() throws StandardException(Code)(Java Doc)
protected boolean isInstanceOf(int nodeType)(Code)(Java Doc)
public boolean isPrivilegeCollectionRequired()(Code)(Java Doc)
final boolean isSessionSchema(SchemaDescriptor sd)(Code)(Java Doc)
final boolean isSessionSchema(String schemaName)(Code)(Java Doc)
public ConstantAction makeConstantAction() throws StandardException(Code)(Java Doc)
public ResultDescription makeResultDescription() throws StandardException(Code)(Java Doc)
public TableName makeTableName(String schemaName, String flatName) throws StandardException(Code)(Java Doc)
public boolean needsSavepoint()(Code)(Java Doc)
protected String nodeHeader()(Code)(Java Doc)
public QueryTreeNode optimize() throws StandardException(Code)(Java Doc)
public static QueryTreeNode parseQueryText(CompilerContext compilerContext, String queryText, Object[] paramDefaults, LanguageConnectionContext lcc) throws StandardException(Code)(Java Doc)
public void printLabel(int depth, String label)(Code)(Java Doc)
public void printSubNodes(int depth)(Code)(Java Doc)
public boolean referencesSessionSchema() throws StandardException(Code)(Java Doc)
public TableName resolveTableToSynonym(TableName tabName) throws StandardException(Code)(Java Doc)
public void setBeginOffset(int beginOffset)(Code)(Java Doc)
public void setContextManager(ContextManager cm)(Code)(Java Doc)
public void setEndOffset(int endOffset)(Code)(Java Doc)
public void setNodeType(int nodeType)(Code)(Java Doc)
public void setRefActionInfo(long fkIndexConglomId, int[] fkColArray, String parentResultSetId, boolean dependentScan)(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public void treePrint()(Code)(Java Doc)
public void treePrint(int depth)(Code)(Java Doc)
String verifyClassExist(String javaClassName, boolean convertCase) throws StandardException(Code)(Java Doc)
|
|
|