|
|||||||||
| Home >> All >> org >> apache >> derby >> iapi >> sql >> [ execute overview ] | PREV NEXT | ||||||||
Uses of Interface
org.apache.derby.iapi.sql.execute.NoPutResultSet
| Uses of NoPutResultSet in org.apache.derby.iapi.sql.execute |
| Methods in org.apache.derby.iapi.sql.execute that return NoPutResultSet | |
NoPutResultSet |
ResultSetFactory.getProjectRestrictResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod restriction,
org.apache.derby.iapi.services.loader.GeneratedMethod projection,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod constantRestriction,
int mapArrayItem,
boolean resuseResult,
boolean doesProjection,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A project restrict result set iterates over its source, evaluating a restriction and when it is satisfied, constructing a row to return in its result set based on its projection. |
NoPutResultSet |
ResultSetFactory.getHashTableResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod singleTableRestriction,
org.apache.derby.iapi.store.access.Qualifier[][] equijoinQualifiers,
org.apache.derby.iapi.services.loader.GeneratedMethod projection,
int resultSetNumber,
int mapRefItem,
boolean reuseResult,
int keyColItem,
boolean removeDuplicates,
long maxInMemoryRowCount,
int initialCapacity,
float loadFactor,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A hash table result set builds a hash table on its source, applying a list of predicates, if any, to the source, when building the hash table. |
NoPutResultSet |
ResultSetFactory.getSortResultSet(NoPutResultSet source,
boolean distinct,
boolean isInSortedOrder,
int orderItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A sort result set sorts its source and if requested removes duplicates. |
NoPutResultSet |
ResultSetFactory.getScalarAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
boolean singleInputRow,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A ScalarAggregateResultSet computes non-distinct scalar aggregates. |
NoPutResultSet |
ResultSetFactory.getDistinctScalarAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
boolean singleInputRow,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A DistinctScalarAggregateResultSet computes scalar aggregates when at least one of them is a distinct aggregate. |
NoPutResultSet |
ResultSetFactory.getGroupedAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A GroupedAggregateResultSet computes non-distinct grouped aggregates. |
NoPutResultSet |
ResultSetFactory.getDistinctGroupedAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A DistinctGroupedAggregateResultSet computes scalar aggregates when at least one of them is a distinct aggregate. |
NoPutResultSet |
ResultSetFactory.getAnyResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
int resultSetNumber,
int subqueryNumber,
int pointOfAttachment,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost)
An any result set iterates over its source, returning a row with all columns set to nulls if the source returns no rows. |
NoPutResultSet |
ResultSetFactory.getOnceResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
int cardinalityCheck,
int resultSetNumber,
int subqueryNumber,
int pointOfAttachment,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost)
A once result set iterates over its source, raising an error if the source returns > 1 row and returning a row with all columns set to nulls if the source returns no rows. |
NoPutResultSet |
ResultSetFactory.getRowResultSet(org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod row,
boolean canCacheRow,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A row result set forms a result set on a single, known row value. |
NoPutResultSet |
ResultSetFactory.getVTIResultSet(org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod row,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod constructor,
java.lang.String javaClassName,
org.apache.derby.iapi.store.access.Qualifier[][] pushedQualifiers,
int erdNumber,
boolean version2,
boolean reuseablePs,
int ctcNumber,
boolean isTarget,
int scanIsolationLevel,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A VTI result set wraps a user supplied result set. |
NoPutResultSet |
ResultSetFactory.getHashScanResultSet(long conglomId,
int scociItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod startKeyGetter,
int startSearchOperator,
org.apache.derby.iapi.services.loader.GeneratedMethod stopKeyGetter,
int stopSearchOperator,
boolean sameStartStopPosition,
org.apache.derby.iapi.store.access.Qualifier[][] scanQualifiers,
org.apache.derby.iapi.store.access.Qualifier[][] nextQualifiers,
int initialCapacity,
float loadFactor,
int maxCapacity,
int hashKeyColumn,
java.lang.String tableName,
java.lang.String indexName,
boolean isConstraint,
boolean forUpdate,
int colRefItem,
int indexColItem,
int lockMode,
boolean tableLocked,
int isolationLevel,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A hash result set forms a result set on a hash table built on a scan of a table. |
NoPutResultSet |
ResultSetFactory.getDistinctScanResultSet(long conglomId,
int scociItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
int hashKeyColumn,
java.lang.String tableName,
java.lang.String indexName,
boolean isConstraint,
int colRefItem,
int lockMode,
boolean tableLocked,
int isolationLevel,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A distinct scan result set pushes duplicate elimination into the scan. |
NoPutResultSet |
ResultSetFactory.getTableScanResultSet(long conglomId,
int scociItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod startKeyGetter,
int startSearchOperator,
org.apache.derby.iapi.services.loader.GeneratedMethod stopKeyGetter,
int stopSearchOperator,
boolean sameStartStopPosition,
org.apache.derby.iapi.store.access.Qualifier[][] qualifiers,
java.lang.String tableName,
java.lang.String indexName,
boolean isConstraint,
boolean forUpdate,
int colRefItem,
int indexColItem,
int lockMode,
boolean tableLocked,
int isolationLevel,
boolean oneRowScan,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A table scan result set forms a result set on a scan of a table. |
NoPutResultSet |
ResultSetFactory.getBulkTableScanResultSet(long conglomId,
int scociItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod startKeyGetter,
int startSearchOperator,
org.apache.derby.iapi.services.loader.GeneratedMethod stopKeyGetter,
int stopSearchOperator,
boolean sameStartStopPosition,
org.apache.derby.iapi.store.access.Qualifier[][] qualifiers,
java.lang.String tableName,
java.lang.String indexName,
boolean isConstraint,
boolean forUpdate,
int colRefItem,
int indexColItem,
int lockMode,
boolean tableLocked,
int isolationLevel,
int rowsPerRead,
boolean oneRowScan,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A table scan result set forms a result set on a scan of a table. |
NoPutResultSet |
ResultSetFactory.getIndexRowToBaseRowResultSet(long conglomId,
int scoci,
org.apache.derby.iapi.sql.Activation a,
NoPutResultSet source,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
java.lang.String indexName,
int heapColRefItem,
int indexColRefItem,
int indexColMapItem,
org.apache.derby.iapi.services.loader.GeneratedMethod restriction,
boolean forUpdate,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
An index row to base row result set gets an index row from its source and uses the RowLocation in its last column to get the row from the base conglomerate. |
NoPutResultSet |
ResultSetFactory.getNestedLoopJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A nested loop left outer join result set forms a result set on top of 2 other result sets. |
NoPutResultSet |
ResultSetFactory.getHashJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A hash join. |
NoPutResultSet |
ResultSetFactory.getNestedLoopLeftOuterJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
boolean wasRightOuterJoin,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A nested loop join result set forms a result set on top of 2 other result sets. |
NoPutResultSet |
ResultSetFactory.getHashLeftOuterJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
boolean wasRightOuterJoin,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A left outer join using a hash join. |
NoPutResultSet |
ResultSetFactory.getMaterializedResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A ResultSet which materializes the underlying ResultSet tree into a temp table on the 1st open. |
NoPutResultSet |
ResultSetFactory.getScrollInsensitiveResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
int sourceRowWidth,
boolean scrollable,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A ResultSet which provides the insensitive scrolling functionality for the underlying result set by materializing the underlying ResultSet tree into a hash table while scrolling forward. |
NoPutResultSet |
ResultSetFactory.getNormalizeResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
int erdNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
boolean forUpdate,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
REMIND: needs more description... |
NoPutResultSet |
ResultSetFactory.getCurrentOfResultSet(java.lang.String cursorName,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
java.lang.String psName)
A current of result set forms a result set on the current row of an open cursor. |
NoPutResultSet |
ResultSetFactory.getUnionResultSet(NoPutResultSet source1,
NoPutResultSet source2,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
The Union interface is used to evaluate the union (all) of two ResultSets. |
NoPutResultSet |
ResultSetFactory.getSetOpResultSet(NoPutResultSet leftSource,
NoPutResultSet rightSource,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
long optimizerEstimatedRowCount,
double optimizerEstimatedCost,
int opType,
boolean all,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup,
int intermediateOrderByColumnsSavedObject,
int intermediateOrderByDirectionSavedObject)
The SetOpResultSet is used to implement an INTERSECT or EXCEPT operation. |
NoPutResultSet |
ResultSetFactory.getLastIndexKeyResultSet(org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
long conglomId,
java.lang.String tableName,
java.lang.String indexName,
int colRefItem,
int lockMode,
boolean tableLocked,
int isolationLevel,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A last index key result set returns the last row from the index in question. |
NoPutResultSet |
ResultSetFactory.getRaDependentTableScanResultSet(long conglomId,
int scociItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod startKeyGetter,
int startSearchOperator,
org.apache.derby.iapi.services.loader.GeneratedMethod stopKeyGetter,
int stopSearchOperator,
boolean sameStartStopPosition,
org.apache.derby.iapi.store.access.Qualifier[][] qualifiers,
java.lang.String tableName,
java.lang.String indexName,
boolean isConstraint,
boolean forUpdate,
int colRefItem,
int indexColItem,
int lockMode,
boolean tableLocked,
int isolationLevel,
boolean oneRowScan,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup,
java.lang.String parentResultSetId,
long fkIndexConglomId,
int fkColArrayItem,
int rltItem)
A Dependent table scan result set forms a result set on a scan of a dependent table for the rows that got materilized on the scan of its parent table and if the row being deleted on parent table has a reference in the dependent table. |
| Methods in org.apache.derby.iapi.sql.execute with parameters of type NoPutResultSet | |
RunTimeStatistics |
ResultSetStatisticsFactory.getRunTimeStatistics(org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.sql.ResultSet rs,
NoPutResultSet[] subqueryTrackingArray)
RunTimeStatistics creation. |
org.apache.derby.impl.sql.execute.rts.ResultSetStatistics |
ResultSetStatisticsFactory.getResultSetStatistics(NoPutResultSet rs)
|
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getInsertResultSet(NoPutResultSet source,
org.apache.derby.iapi.services.loader.GeneratedMethod checkGM,
org.apache.derby.iapi.sql.Activation activation)
An insert result set simply reports that it completed, and the number of rows inserted. |
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getInsertVTIResultSet(NoPutResultSet source,
NoPutResultSet vtiRS,
org.apache.derby.iapi.sql.Activation activation)
An insert VTI result set simply reports that it completed, and the number of rows inserted. |
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getDeleteVTIResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation)
A delete VTI result set simply reports that it completed, and the number of rows deleted. |
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getDeleteResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation)
A delete result set simply reports that it completed, and the number of rows deleted. |
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getDeleteCascadeResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int constantActionItem,
org.apache.derby.iapi.sql.ResultSet[] dependentResultSets,
java.lang.String resultSetId)
A delete Cascade result set simply reports that it completed, and the number of rows deleted. |
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getUpdateResultSet(NoPutResultSet source,
org.apache.derby.iapi.services.loader.GeneratedMethod checkGM,
org.apache.derby.iapi.sql.Activation activation)
An update result set simply reports that it completed, and the number of rows updated. |
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getUpdateVTIResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation)
|
org.apache.derby.iapi.sql.ResultSet |
ResultSetFactory.getDeleteCascadeUpdateResultSet(NoPutResultSet source,
org.apache.derby.iapi.services.loader.GeneratedMethod checkGM,
org.apache.derby.iapi.sql.Activation activation,
int constantActionItem,
int rsdItem)
An update result set simply reports that it completed, and the number of rows updated. |
NoPutResultSet |
ResultSetFactory.getProjectRestrictResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod restriction,
org.apache.derby.iapi.services.loader.GeneratedMethod projection,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod constantRestriction,
int mapArrayItem,
boolean resuseResult,
boolean doesProjection,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A project restrict result set iterates over its source, evaluating a restriction and when it is satisfied, constructing a row to return in its result set based on its projection. |
NoPutResultSet |
ResultSetFactory.getHashTableResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod singleTableRestriction,
org.apache.derby.iapi.store.access.Qualifier[][] equijoinQualifiers,
org.apache.derby.iapi.services.loader.GeneratedMethod projection,
int resultSetNumber,
int mapRefItem,
boolean reuseResult,
int keyColItem,
boolean removeDuplicates,
long maxInMemoryRowCount,
int initialCapacity,
float loadFactor,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A hash table result set builds a hash table on its source, applying a list of predicates, if any, to the source, when building the hash table. |
NoPutResultSet |
ResultSetFactory.getSortResultSet(NoPutResultSet source,
boolean distinct,
boolean isInSortedOrder,
int orderItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A sort result set sorts its source and if requested removes duplicates. |
NoPutResultSet |
ResultSetFactory.getScalarAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
boolean singleInputRow,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A ScalarAggregateResultSet computes non-distinct scalar aggregates. |
NoPutResultSet |
ResultSetFactory.getDistinctScalarAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
boolean singleInputRow,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A DistinctScalarAggregateResultSet computes scalar aggregates when at least one of them is a distinct aggregate. |
NoPutResultSet |
ResultSetFactory.getGroupedAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A GroupedAggregateResultSet computes non-distinct grouped aggregates. |
NoPutResultSet |
ResultSetFactory.getDistinctGroupedAggregateResultSet(NoPutResultSet source,
boolean isInSortedOrder,
int aggregateItem,
int orderingItem,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod rowAllocator,
int rowSize,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A DistinctGroupedAggregateResultSet computes scalar aggregates when at least one of them is a distinct aggregate. |
NoPutResultSet |
ResultSetFactory.getAnyResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
int resultSetNumber,
int subqueryNumber,
int pointOfAttachment,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost)
An any result set iterates over its source, returning a row with all columns set to nulls if the source returns no rows. |
NoPutResultSet |
ResultSetFactory.getOnceResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
int cardinalityCheck,
int resultSetNumber,
int subqueryNumber,
int pointOfAttachment,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost)
A once result set iterates over its source, raising an error if the source returns > 1 row and returning a row with all columns set to nulls if the source returns no rows. |
NoPutResultSet |
ResultSetFactory.getIndexRowToBaseRowResultSet(long conglomId,
int scoci,
org.apache.derby.iapi.sql.Activation a,
NoPutResultSet source,
org.apache.derby.iapi.services.loader.GeneratedMethod resultRowAllocator,
int resultSetNumber,
java.lang.String indexName,
int heapColRefItem,
int indexColRefItem,
int indexColMapItem,
org.apache.derby.iapi.services.loader.GeneratedMethod restriction,
boolean forUpdate,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
An index row to base row result set gets an index row from its source and uses the RowLocation in its last column to get the row from the base conglomerate. |
NoPutResultSet |
ResultSetFactory.getNestedLoopJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A nested loop left outer join result set forms a result set on top of 2 other result sets. |
NoPutResultSet |
ResultSetFactory.getHashJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A hash join. |
NoPutResultSet |
ResultSetFactory.getNestedLoopLeftOuterJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
boolean wasRightOuterJoin,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A nested loop join result set forms a result set on top of 2 other result sets. |
NoPutResultSet |
ResultSetFactory.getHashLeftOuterJoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
org.apache.derby.iapi.sql.Activation activation,
org.apache.derby.iapi.services.loader.GeneratedMethod joinClause,
int resultSetNumber,
org.apache.derby.iapi.services.loader.GeneratedMethod emptyRowFun,
boolean wasRightOuterJoin,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A left outer join using a hash join. |
NoPutResultSet |
ResultSetFactory.getMaterializedResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A ResultSet which materializes the underlying ResultSet tree into a temp table on the 1st open. |
NoPutResultSet |
ResultSetFactory.getScrollInsensitiveResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
int sourceRowWidth,
boolean scrollable,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
A ResultSet which provides the insensitive scrolling functionality for the underlying result set by materializing the underlying ResultSet tree into a hash table while scrolling forward. |
NoPutResultSet |
ResultSetFactory.getNormalizeResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
int erdNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
boolean forUpdate,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
REMIND: needs more description... |
NoPutResultSet |
ResultSetFactory.getUnionResultSet(NoPutResultSet source1,
NoPutResultSet source2,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup)
The Union interface is used to evaluate the union (all) of two ResultSets. |
NoPutResultSet |
ResultSetFactory.getSetOpResultSet(NoPutResultSet leftSource,
NoPutResultSet rightSource,
org.apache.derby.iapi.sql.Activation activation,
int resultSetNumber,
long optimizerEstimatedRowCount,
double optimizerEstimatedCost,
int opType,
boolean all,
org.apache.derby.iapi.services.loader.GeneratedMethod closeCleanup,
int intermediateOrderByColumnsSavedObject,
int intermediateOrderByDirectionSavedObject)
The SetOpResultSet is used to implement an INTERSECT or EXCEPT operation. |
|
|||||||||
| Home >> All >> org >> apache >> derby >> iapi >> sql >> [ execute overview ] | PREV NEXT | ||||||||