|
|||||||||
| Home >> All >> org >> apache >> derby >> iapi >> sql >> [ execute overview ] | PREV CLASS NEXT CLASS | ||||||||
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD |
DETAIL: FIELD | CONSTR | METHOD | ||||||||
org.apache.derby.iapi.sql.execute
Interface ResultSetFactory
- public interface ResultSetFactory
ResultSetFactory provides a wrapper around all of the result sets needed in an execution implementation.
For the activations to avoid searching for this module in their execute methods, the base activation supertype should implement a method that does the lookup and salts away this factory for the activation to use as it needs it.
| Field Summary | |
static java.lang.String |
MODULE
Module name for the monitor's module locating system. |
| Method Summary | |
NoPutResultSet |
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 |
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. |
org.apache.derby.iapi.sql.ResultSet |
getCallStatementResultSet(org.apache.derby.iapi.services.loader.GeneratedMethod methodCall,
org.apache.derby.iapi.sql.Activation activation)
A call statement result set simply reports that it completed. |
NoPutResultSet |
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. |
org.apache.derby.iapi.sql.ResultSet |
getDDLResultSet(org.apache.derby.iapi.sql.Activation activation)
Generic DDL result set creation. |
org.apache.derby.iapi.sql.ResultSet |
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 |
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. |
org.apache.derby.iapi.sql.ResultSet |
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 |
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. |
NoPutResultSet |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
org.apache.derby.iapi.sql.ResultSet |
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 |
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. |
NoPutResultSet |
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 |
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. |
org.apache.derby.iapi.sql.ResultSet |
getMiscResultSet(org.apache.derby.iapi.sql.Activation activation)
Generic Misc result set creation. |
NoPutResultSet |
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 |
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 |
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 |
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 |
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 |
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. |
NoPutResultSet |
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 |
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 |
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 |
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. |
org.apache.derby.iapi.sql.ResultSet |
getSetTransactionResultSet(org.apache.derby.iapi.sql.Activation activation)
|
NoPutResultSet |
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 |
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 |
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. |
org.apache.derby.iapi.sql.ResultSet |
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 |
getUpdateVTIResultSet(NoPutResultSet source,
org.apache.derby.iapi.sql.Activation activation)
|
NoPutResultSet |
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. |
| Field Detail |
MODULE
public static final java.lang.String MODULE
- Module name for the monitor's module locating system.
- See Also:
- Constant Field Values
| Method Detail |
getDDLResultSet
public org.apache.derby.iapi.sql.ResultSet getDDLResultSet(org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- Generic DDL result set creation.
getMiscResultSet
public org.apache.derby.iapi.sql.ResultSet getMiscResultSet(org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- Generic Misc result set creation.
getSetTransactionResultSet
public org.apache.derby.iapi.sql.ResultSet getSetTransactionResultSet(org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
getInsertResultSet
public org.apache.derby.iapi.sql.ResultSet getInsertResultSet(NoPutResultSet source, org.apache.derby.iapi.services.loader.GeneratedMethod checkGM, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- An insert result set simply reports that it completed, and
the number of rows inserted. It does not return rows.
The insert has been completed once the
insert result set is available.
getInsertVTIResultSet
public org.apache.derby.iapi.sql.ResultSet getInsertVTIResultSet(NoPutResultSet source, NoPutResultSet vtiRS, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- An insert VTI result set simply reports that it completed, and
the number of rows inserted. It does not return rows.
The insert has been completed once the
insert result set is available.
getDeleteVTIResultSet
public org.apache.derby.iapi.sql.ResultSet getDeleteVTIResultSet(NoPutResultSet source, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- A delete VTI result set simply reports that it completed, and
the number of rows deleted. It does not return rows.
The delete has been completed once the
delete result set is available.
getDeleteResultSet
public org.apache.derby.iapi.sql.ResultSet getDeleteResultSet(NoPutResultSet source, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- A delete result set simply reports that it completed, and
the number of rows deleted. It does not return rows.
The delete has been completed once the
delete result set is available.
getDeleteCascadeResultSet
public org.apache.derby.iapi.sql.ResultSet getDeleteCascadeResultSet(NoPutResultSet source, org.apache.derby.iapi.sql.Activation activation, int constantActionItem, org.apache.derby.iapi.sql.ResultSet[] dependentResultSets, java.lang.String resultSetId) throws org.apache.derby.iapi.error.StandardException
- A delete Cascade result set simply reports that it completed, and
the number of rows deleted. It does not return rows.
The delete has been completed once the
delete result set is available.
getUpdateResultSet
public org.apache.derby.iapi.sql.ResultSet getUpdateResultSet(NoPutResultSet source, org.apache.derby.iapi.services.loader.GeneratedMethod checkGM, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- An update result set simply reports that it completed, and
the number of rows updated. It does not return rows.
The update has been completed once the
update result set is available.
getUpdateVTIResultSet
public org.apache.derby.iapi.sql.ResultSet getUpdateVTIResultSet(NoPutResultSet source, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
getDeleteCascadeUpdateResultSet
public org.apache.derby.iapi.sql.ResultSet getDeleteCascadeUpdateResultSet(NoPutResultSet source, org.apache.derby.iapi.services.loader.GeneratedMethod checkGM, org.apache.derby.iapi.sql.Activation activation, int constantActionItem, int rsdItem) throws org.apache.derby.iapi.error.StandardException
- An update result set simply reports that it completed, and
the number of rows updated. It does not return rows.
The update has been completed once the
update result set is available.
getCallStatementResultSet
public org.apache.derby.iapi.sql.ResultSet getCallStatementResultSet(org.apache.derby.iapi.services.loader.GeneratedMethod methodCall, org.apache.derby.iapi.sql.Activation activation) throws org.apache.derby.iapi.error.StandardException
- A call statement result set simply reports that it completed.
It does not return rows.
getProjectRestrictResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- 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.
The rows can be constructed as they are requested from the
result set.
getHashTableResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- 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. It then does a look up into
the hash table on a probe.
The rows can be constructed as they are requested from the
result set.
getSortResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A sort result set sorts its source and if requested removes
duplicates. It will generate the entire result when open, and
then return it a row at a time.
If passed aggregates it will do scalar or vector aggregate processing. A list of aggregator information is passed off of the PreparedStatement's savedObjects. Aggregation and SELECT DISTINCT cannot be processed in the same sort.
getScalarAggregateResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A ScalarAggregateResultSet computes non-distinct scalar aggregates.
It will compute the aggregates when open.
getDistinctScalarAggregateResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A DistinctScalarAggregateResultSet computes scalar aggregates when
at least one of them is a distinct aggregate.
It will compute the aggregates when open.
getGroupedAggregateResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A GroupedAggregateResultSet computes non-distinct grouped aggregates.
It will compute the aggregates when open.
getDistinctGroupedAggregateResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A DistinctGroupedAggregateResultSet computes scalar aggregates when
at least one of them is a distinct aggregate.
It will compute the aggregates when open.
getAnyResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- An any result set iterates over its source,
returning a row with all columns set to nulls
if the source returns no rows.
getOnceResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- 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.
getRowResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A row result set forms a result set on a single, known row value.
It is used to turn constant rows into result sets for use in
the result set paradigm.
The row can be constructed when it is requested from the
result set.
getVTIResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A VTI result set wraps a user supplied result set.
getHashScanResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A hash result set forms a result set on a hash table built on a scan
of a table.
The rows are put into the hash table on the 1st open.
getDistinctScanResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A distinct scan result set pushes duplicate elimination into
the scan.
getTableScanResultSet
public NoPutResultSet 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) throws org.apache.derby.iapi.error.StandardException
- A table scan result set forms a result set on a scan
of a table.
The rows can be constructed as they are requested from the
result set.
This form of the table scan operation is simple, and is to be used when there are no predicates to be passed down to the scan to limit its scope on the target table.
getBulkTableScanResultSet
public NoPutResultSet 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,