java.lang.Object
- org.apache.derby.impl.sql.compile.QueryTreeNode
- - org.apache.derby.impl.sql.compile.ResultSetNode
  - - org.apache.derby.impl.sql.compile.MaterializeSubqueryNode

All Implemented Interfaces:

Visitable
```
class MaterializeSubqueryNode
extends ResultSetNode
```
A MaterializeSubqueryNode is used to replace the nodes for a subquery, to facilitate code generation for materialization if possible. See beetle 4373 for details.

Nested Class Summary
- Nested classes/interfaces inherited from class org.apache.derby.impl.sql.compile.ResultSetNode
  ResultSetNode.QueryExpressionClauses

Field Summary

Fields
Modifier and Type Field Description

private LocalField lf
- Fields inherited from class org.apache.derby.impl.sql.compile.QueryTreeNode
  AUTOINCREMENT_CREATE_MODIFY, AUTOINCREMENT_CYCLE, AUTOINCREMENT_INC_INDEX, AUTOINCREMENT_IS_AUTOINCREMENT_INDEX, AUTOINCREMENT_START_INDEX

Constructor Summary

Constructors
Constructor Description

MaterializeSubqueryNode(LocalField lf, ContextManager cm)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`(package private) void`	`decrementLevel(int decrement)`	Decrement (query block) level (0-based) for all of the tables in this ResultSet tree.
`(package private) void`	`generate(ActivationClassBuilder acb, MethodBuilder mb)`	Do the code generation for this node.

Methods inherited from class org.apache.derby.impl.sql.compile.ResultSetNode
acceptChildren, addNewPredicate, adjustForSortElimination, adjustForSortElimination, assignResultSetNumber, bindExpressions, bindExpressionsWithTables, bindNonVTITables, bindResultColumns, bindResultColumns, bindTargetExpressions, bindUntypedNullsToResultColumns, bindVTITables, changeAccessPath, columnTypesAndLengthsMatch, considerMaterialization, enhanceRCLForInsert, ensurePredicateList, fillInReferencedTableMap, flattenableInFromSubquery, generateNormalizationResultSet, generateResultSet, genProjectRestrict, genProjectRestrict, genProjectRestrictForReordering, getAllResultColumns, getCandidateFinalCostEstimate, getCostEstimate, getCursorTargetTable, getFinalCostEstimate, getFromList, getFromTableByName, getMatchingColumn, getNewCostEstimate, getOptimizer, getOptimizerImpl, getRCLForInsert, getReferencedTableMap, getResultColumns, getResultSetNumber, getScratchCostEstimate, isCursorTargetTable, isInsertSource, isNotExists, isOneRowResultSet, isOrderedOn, isPossibleDistinctScan, isStatementResultSet, isUpdatableCursor, LOJgetReferencedTables, makeResultDescription, makeResultDescriptors, markAsCursorTargetTable, markForDistinctScan, markStatementResultSet, modifyAccessPaths, modifyAccessPaths, notCursorTargetTable, notFlattenableJoin, numDistinctAggregates, optimize, parseDefault, performMaterialization, preprocess, printQueryExpressionSuffixClauses, printSubNodes, projectResultColumns, pushOffsetFetchFirst, pushOrderByList, pushQueryExpressionSuffix, referencesTarget, rejectParameters, rejectXMLValues, renameGeneratedResultNames, replaceOrForbidDefaults, returnsAtMostOneRow, setCandidateFinalCostEstimate, setCostEstimate, setCursorTargetTable, setInsertSource, setOptimizer, setReferencedTableMap, setResultColumns, setResultSetNumber, setResultToBooleanTrueNode, setScratchCostEstimate, setTableConstructorTypes, subqueryReferencesTarget, toString, updateTargetLockMode, verifySelectStarSubquery

Methods inherited from class org.apache.derby.impl.sql.compile.QueryTreeNode
accept, addTag, addUDTUsagePriv, addUDTUsagePriv, bindOffsetFetch, bindRowMultiSet, bindUserCatalogType, bindUserType, checkReliability, checkReliability, convertDefaultNode, copyTagsFrom, createTypeDependency, debugFlush, debugPrint, disablePrivilegeCollection, formatNodeString, generateAuthorizeCheck, getBeginOffset, getClassFactory, getCompilerContext, getContext, getContextManager, getDataDictionary, getDependencyManager, getEndOffset, getExecutionFactory, getGenericConstantActionFactory, getIntProperty, getLanguageConnectionContext, getLongProperty, getNullNode, getOffsetOrderedNodes, getOptimizerFactory, getOptimizerTracer, getParameterTypes, getSchemaDescriptor, getSchemaDescriptor, getStatementType, getTableDescriptor, getTypeCompiler, getUDTDesc, isAtomic, isPrivilegeCollectionRequired, isSessionSchema, isSessionSchema, makeConstantAction, makeTableName, makeTableName, nodeHeader, optimizerTracingIsOn, orReliability, parseSearchCondition, parseStatement, printLabel, referencesSessionSchema, resolveTableToSynonym, setBeginOffset, setEndOffset, setRefActionInfo, stackPrint, taggedWith, treePrint, treePrint, verifyClassExist

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - lf
```
private LocalField lf
```
- Constructor Detail
  - MaterializeSubqueryNode
```
MaterializeSubqueryNode(LocalField lf,
                        ContextManager cm)
```
- Method Detail
  - generate
```
void generate(ActivationClassBuilder acb,
              MethodBuilder mb)
       throws StandardException
```
    Description copied from class: QueryTreeNode
    
    Do the code generation for this node. This is a place-holder method - it should be over-ridden in the sub-classes.
    
    Overrides:
    
    generate in class QueryTreeNode
    
    Parameters:
    
    acb - The ActivationClassBuilder for the class being built
    
    mb - The method for the generated code to go into
    
    Throws:
    
    StandardException - Thrown on error
  - decrementLevel
```
void decrementLevel(int decrement)
```
    Description copied from class: ResultSetNode
    
    Decrement (query block) level (0-based) for all of the tables in this ResultSet tree. This is useful when flattening a subquery.
    
    Specified by:
    
    decrementLevel in class ResultSetNode
    
    Parameters:
    
    decrement - The amount to decrement by.

Class MaterializeSubqueryNode

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.derby.impl.sql.compile.ResultSetNode

Field Summary

Fields inherited from class org.apache.derby.impl.sql.compile.QueryTreeNode

Constructor Summary

Method Summary

Methods inherited from class org.apache.derby.impl.sql.compile.ResultSetNode

Methods inherited from class org.apache.derby.impl.sql.compile.QueryTreeNode

Methods inherited from class java.lang.Object

Field Detail

lf

Constructor Detail

MaterializeSubqueryNode

Method Detail

generate

decrementLevel