FromVTI (Apache Derby V10.1 Engine Documentation)

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.derby.impl.sql.compile
Class FromVTI

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.FromVTI

All Implemented Interfaces:: Optimizable, Visitable, VTIEnvironment

public class FromVTI
extends FromTable
implements VTIEnvironment

A FromVTI represents a VTI in the FROM list of a DML statement.

Author:: Jerry Brenner

Field Summary
`private FormatableHashtable`	`compileTimeConstants`
`private boolean`	`controlsDeferral`
`(package private) JBitSet`	`correlationMap`
`(package private) JBitSet`	`dependencyMap`
`private boolean`	`emptyForUpdate` Was the FOR UPDATE clause empty (no columns specified).
`(package private) double`	`estimatedCost`
`(package private) double`	`estimatedRowCount`
`(package private) TableName`	`exposedName`
`private boolean`	`forUpdatePresent` Was a FOR UPDATE clause specified in a SELECT statement.
`private boolean`	`implementsPushable`
`(package private) boolean`	`implementsVTICosting`
`private boolean`	`isInsensitive`
`(package private) boolean`	`isTarget`
`(package private) boolean`	`materializable`
`private JavaValueNode[]`	`methodParms`
`(package private) NewInvocationNode`	`newInvocation`
`protected int`	`numVTICols`
`(package private) boolean`	`optimized`
`private java.sql.PreparedStatement`	`ps`
`private PredicateList`	`restrictionList`
`private int`	`resultSetType`
`(package private) java.sql.ResultSet`	`rs`
`(package private) SubqueryList`	`subqueryList`
`(package private) boolean`	`supportsMultipleInstantiations`
`protected boolean`	`version2`
`(package private) boolean`	`vtiCosted`

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

bestAccessPath, bestCostEstimate, bestSortAvoidancePath, correlationName, corrTableName, currentAccessPath, hashKeyColumns, initialCapacity, level, loadFactor, maxCapacity, tableNumber, tableProperties, trulyTheBestAccessPath, userSpecifiedJoinStrategy

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

costEstimate, cursorTargetTable, insertSource, optimizer, referencedTableMap, resultColumns, resultSetNumber, scratchCostEstimate, statementResultSet

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

AUTOINCREMENT_INC_INDEX, AUTOINCREMENT_IS_AUTOINCREMENT_INDEX, AUTOINCREMENT_START_INDEX, beginOffset, endOffset

Constructor Summary
`FromVTI()`

Method Summary
`Visitable`	`accept(Visitor v)` Accept a visitor, and call v.visit() on child nodes as necessary.
`void`	`bindExpressions(FromList fromListParam)` Bind the expressions in this VTI.
`ResultSetNode`	`bindNonVTITables(DataDictionary dataDictionary, FromList fromListParam)` Bind the non VTI tables in this ResultSetNode.
`ResultSetNode`	`bindVTITables(FromList fromListParam)` Bind this VTI that appears in the FROM list.
`CostEstimate`	`estimateCost(OptimizablePredicateList predList, ConglomerateDescriptor cd, CostEstimate outerCost, Optimizer optimizer, RowOrdering rowOrdering)` Estimate the cost of scanning this Optimizable using the given predicate list with the given conglomerate.
`void`	`generate(ActivationClassBuilder acb, MethodBuilder mb)` Generation on a FromVTI creates a wrapper around the user's java.sql.ResultSet
`private void`	`generateConstructor(ActivationClassBuilder acb, MethodBuilder mb, boolean reuseablePs)`
`protected ResultSetNode`	`genProjectRestrict(int numTables)` Put a ProjectRestrictNode on top of each FromTable in the FromList.
`private ResultColumnList`	`genResultColList(TableDescriptor td)`
`ResultColumnList`	`getAllResultColumns(TableName allTableName)` Expand a "*" into a ResultColumnList with all of the result columns from the subquery.
`DeferModification`	`getDeferralControl()` Get the DeferModification interface associated with this VTI
`java.lang.String`	`getExposedName()` Get the exposed name for this table, which is the name that can be used to refer to it in the rest of the query.
`TableName`	`getExposedTableName()`
`private int[]`	`getForUpdateColumnList()`
`ResultColumn`	`getMatchingColumn(ColumnReference columnReference)` Try to find a ResultColumn in the table represented by this FromBaseTable that matches the name in the given ColumnReference.
`private java.lang.Object`	`getNewInstance()`
`NewInvocationNode`	`getNewInvocation()` Return the new invocation from this node.
`(package private) java.util.Vector`	`getNodesFromParameters(java.lang.Class nodeClass)` Get all of the nodes of the specified class from the parameters to this VTI.
`java.lang.String`	`getOriginalSQL()` Return the SQL text of the original SQL statement.
`java.sql.ResultSetMetaData`	`getResultSetMetaData()` Get the ResultSetMetaData for the class/object.
`int`	`getResultSetType()`
`private int`	`getScanArguments(ActivationClassBuilder acb, MethodBuilder mb)`
`java.lang.Object`	`getSharedState(java.lang.String key)` Get an an object associated with a key from set of objects maintained with the statement plan.
`private UUID`	`getSpecialTriggerVTITableName(LanguageConnectionContext lcc, java.lang.String className)` Check and see if we have a special trigger VTI.
`int`	`getStatementIsolationLevel()` Get the specific JDBC isolation of the statement.
`(package private) java.lang.String`	`getVTIName()`
`void`	`init(java.lang.Object newInvocation, java.lang.Object correlationName, java.lang.Object derivedRCL, java.lang.Object tableProperties)` Initialize a query tree node.
`void`	`init(java.lang.Object newInvocation, java.lang.Object correlationName, java.lang.Object derivedRCL, java.lang.Object tableProperties, java.lang.Object exposedTableName)` Initialize a query tree node.
`boolean`	`isCompileTime()` Return true if this instance of the VTI has been created for compilation, false if it is for runtime execution.
`boolean`	`isMaterializable()` Tell whether this Optimizable is materializable
`(package private) boolean`	`isUpdatableCursor()`
`boolean`	`legalJoinOrder(JBitSet assignedTableMap)` Can this Optimizable appear at the current location in the join order.
`protected void`	`markUpdatableByCursor(java.util.Vector updateColumns)` Mark as updatable all the columns in the result column list of this FromBaseTable that match the columns in the given update column list.
`Optimizable`	`modifyAccessPath(JBitSet outerTables)` Modify the access path for this Optimizable, as necessary.
`boolean`	`needsSpecialRCLBinding()`
`boolean`	`performMaterialization(JBitSet outerTables)` Return whether or not to materialize this ResultSet tree.
`ResultSetNode`	`preprocess(int numTables, GroupByList gbl, FromList fromList)` Preprocess a ResultSetNode - this currently means: o Generating a referenced table map for each ResultSetNode.
`void`	`printSubNodes(int depth)` Prints the sub-nodes of this object.
`boolean`	`pushOptPredicate(OptimizablePredicate optimizablePredicate)` Push an OptimizablePredicate down, if this node accepts it.
`boolean`	`referencesTarget(java.lang.String name, boolean baseTable)` Search to see if a query references the specifed table name.
`void`	`setSharedState(java.lang.String key, java.io.Serializable value)` Saves an object associated with a key that will be maintained for the lifetime of the statement plan.
`(package private) void`	`setTarget()` Mark this VTI as the target of a delete or update.
`boolean`	`supportsMultipleInstantiations()` Tell whether this Optimizable can be instantiated multiple times
`java.lang.String`	`toString()` Convert this object to a String.

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

areAllColumnsProjected, assignCostEstimate, canBeOrdered, considerSortAvoidancePath, convertAbsoluteToRelativeColumnPosition, cursorTargetTable, decrementLevel, feasibleJoinStrategy, fillInReferencedTableMap, flatten, forUpdate, getBaseTableName, getBestAccessPath, getBestSortAvoidancePath, getCostEstimate, getCurrentAccessPath, getFromTableByName, getLevel, getName, getNumColumnsReturned, getProperties, getResultColumnsForList, getSchemaDescriptor, getSchemaDescriptor, getScratchCostEstimate, getTableDescriptor, getTableName, getTableNumber, getTrulyTheBestAccessPath, getUserSpecifiedJoinStrategy, hashKeyColumns, hasTableNumber, init, initAccessPaths, initialCapacity, isBaseTable, isCoveringIndex, isFlattenableJoinNode, isOneRowScan, isTargetTable, loadFactor, LOJ_reorderable, maxCapacity, memoryUsageOK, nextAccessPath, optimizeIt, optimizeSubqueries, pullOptPredicates, pushExpressions, rememberAsBest, rememberJoinStrategyAsBest, rememberSortAvoidancePath, resetJoinStrategies, setAllColumnsProjected, setCostEstimate, setHashKeyColumns, setLevel, setProperties, setTableNumber, startOptimizing, tellRowOrderingAboutConstantColumns, transformOuterJoins, uniqueJoin, verifyProperties

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

addNewPredicate, assignResultSetNumber, bindExpressionsWithTables, bindResultColumns, bindResultColumns, bindTargetExpressions, bindUntypedNullsToResultColumns, changeAccessPath, closeMethodArgument, columnTypesAndLengthsMatch, considerMaterialization, enhanceRCLForInsert, ensurePredicateList, flattenableInFromSubquery, generateNormalizationResultSet, generateResultSet, genNewRCForInsert, genNormalizeResultSetNode, genProjectRestrict, genProjectRestrictForReordering, getCostEstimate, getCursorTargetTable, getFinalCostEstimate, getFromList, getNewCostEstimate, getOptimizer, getReferencedTableMap, getResultColumns, getResultSetNumber, isNotExists, isOneRowResultSet, isOrderedOn, isPossibleDistinctScan, isUpdatableCursor, LOJgetReferencedTables, makeResultDescription, makeResultDescriptors, markAsCursorTargetTable, markForDistinctScan, markOrderingDependent, markStatementResultSet, modifyAccessPaths, notCursorTargetTable, notFlattenableJoin, numDistinctAggregates, optimize, parseDefault, projectResultColumns, pushOrderByList, rejectParameters, rejectXMLValues, renameGeneratedResultNames, replaceDefaults, returnsAtMostOneRow, setInsertSource, setReferencedTableMap, setResultColumns, setResultToBooleanTrueNode, setTableConstructorTypes, subqueryReferencesTarget, updateTargetLockMode, verifySelectStarSubquery

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

bind, convertDefaultNode, debugFlush, debugPrint, executeSchemaName, executeStatementName, formatNodeString, foundString, generate, generateAuthorizeCheck, getBeginOffset, getClassFactory, getCompilerContext, getContextManager, getCursorInfo, getDataDictionary, getDependencyManager, getEndOffset, getExecutionFactory, getGenericConstantActionFactory, getIntProperty, getLanguageConnectionContext, getNodeFactory, getNodeType, getNullNode, getParameterTypes, getRowEstimate, getSchemaDescriptor, getSchemaDescriptor, getSPSName, getStatementType, getTableDescriptor, getTypeCompiler, init, init, init, init, init, init, init, init, init, init, init, isAtomic, isInstanceOf, isSessionSchema, isSessionSchema, makeConstantAction, makeTableName, needsSavepoint, nodeHeader, optimize, parseQueryText, printLabel, referencesSessionSchema, resolveTableToSynonym, setBeginOffset, setContextManager, setEndOffset, setNodeType, setRefActionInfo, treePrint, treePrint, verifyClassExist

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.apache.derby.iapi.sql.compile.Optimizable

getDataDictionary, getReferencedTableMap, getResultSetNumber

Field Detail

correlationMap

JBitSet correlationMap

dependencyMap

JBitSet dependencyMap

newInvocation

NewInvocationNode newInvocation

exposedName

TableName exposedName

subqueryList

SubqueryList subqueryList

implementsVTICosting

boolean implementsVTICosting

optimized

boolean optimized

materializable

boolean materializable

isTarget

boolean isTarget

rs

java.sql.ResultSet rs

compileTimeConstants

private FormatableHashtable compileTimeConstants

numVTICols

protected int numVTICols

restrictionList

private PredicateList restrictionList

forUpdatePresent

private boolean forUpdatePresent

Was a FOR UPDATE clause specified in a SELECT statement.

emptyForUpdate

private boolean emptyForUpdate

Was the FOR UPDATE clause empty (no columns specified).

estimatedCost

double estimatedCost

estimatedRowCount

double estimatedRowCount

supportsMultipleInstantiations

boolean supportsMultipleInstantiations

vtiCosted

boolean vtiCosted

version2

protected boolean version2

implementsPushable

private boolean implementsPushable

ps

private java.sql.PreparedStatement ps

methodParms

private JavaValueNode[] methodParms

controlsDeferral

private boolean controlsDeferral

isInsensitive

private boolean isInsensitive

resultSetType

private int resultSetType

Constructor Detail

FromVTI

public FromVTI()

Method Detail

init

public void init(java.lang.Object newInvocation,
                 java.lang.Object correlationName,
                 java.lang.Object derivedRCL,
                 java.lang.Object tableProperties)
          throws StandardException

Description copied from class: QueryTreeNode

Initialize a query tree node.

Overrides:: init in class QueryTreeNode

Parameters:: newInvocation - The constructor for the VTI; correlationName - The correlation name; derivedRCL - The derived column list; tableProperties - Properties list associated with the table
Throws:: StandardException - Thrown on error

init

public void init(java.lang.Object newInvocation,
                 java.lang.Object correlationName,
                 java.lang.Object derivedRCL,
                 java.lang.Object tableProperties,
                 java.lang.Object exposedTableName)
          throws StandardException

Description copied from class: QueryTreeNode

Initialize a query tree node.

Overrides:: init in class QueryTreeNode

Parameters:: newInvocation - The constructor for the VTI; correlationName - The correlation name; derivedRCL - The derived column list; tableProperties - Properties list associated with the table; exposedTableName - The table name (TableName class)
Throws:: StandardException - Thrown on error