Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.sql.execute.LastIndexKeyResultSet

Modifier and Type	Field and Description
public boolean	coarserLock
protected long	conglomId
protected Qualifier[][]	qualifiers
public boolean	returnedRow
protected boolean	runTimeStatisticsOn
protected int	startSearchOperator
public String	stopPositionString
protected int	stopSearchOperator
public String	userSuppliedOptimizerOverrides

Constructor Summary

Access	Constructor and Description
public	LastIndexKeyResultSet(Activation the activation for this result set, which provides the context for the row allocation operation. activation, int The resultSetNumber for the ResultSet resultSetNumber, int The saved item for result row template resultRowTemplate, long the conglomerate of the table to be scanned. conglomId, String The full name of the table tableName, String Overrides specified by the user on the sql userSuppliedOptimizerOverrides, String The name of the index, if one used to access table. indexName, int An saved item for a bitSet of columns that are referenced in the underlying table. -1 if no item. colRefItem, int The lock granularity to use (see TransactionController in access) lockMode, boolean Whether or not the table is marked as using table locking (in sys.systables) tableLocked, int Isolation level (specified or not) to use on scans isolationLevel, double Estimated total # of rows by optimizer optimizerEstimatedRowCount, double Estimated total cost by optimizer optimizerEstimatedCost) A last index key result set returns the last row from the index in question.

Access

Constructor and Description

public

LastIndexKeyResultSet(Activation

the activation for this result set, which provides the context for the row allocation operation.

activation, int

The resultSetNumber for the ResultSet

resultSetNumber, int

The saved item for result row template

resultRowTemplate, long

the conglomerate of the table to be scanned.

conglomId, String

The full name of the table

tableName, String

Overrides specified by the user on the sql

userSuppliedOptimizerOverrides, String

The name of the index, if one used to access table.

indexName, int

An saved item for a bitSet of columns that are referenced in the underlying table. -1 if no item.

colRefItem, int

The lock granularity to use (see TransactionController in access)

lockMode, boolean

Whether or not the table is marked as using table locking (in sys.systables)

tableLocked, int

Isolation level (specified or not) to use on scans

isolationLevel, double

Estimated total # of rows by optimizer

optimizerEstimatedRowCount, double

Estimated total cost by optimizer

optimizerEstimatedCost)

A last index key result set returns the last row from the index in question.

Method Summary

Modifier and Type	Method and Description
pack-priv boolean	canGetInstantaneousLocks() Implements abstract org.apache.derby.impl.sql.execute.ScanResultSet.canGetInstantaneousLocks. Can we get instantaneous locks when getting share row locks at READ COMMITTED.
public void	close() Overrides org.apache.derby.impl.sql.execute.ScanResultSet.close. Implements org.apache.derby.iapi.sql.ResultSet.close. If the result set has been opened, close the open scan.
public ExecRow	Returns: the last row returned; getCurrentRow() This result set has its row from the last fetch done.
public ExecRow	getNextRowCore() Implements abstract org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRowCore. Implements org.apache.derby.iapi.sql.execute.NoPutResultSet.getNextRowCore. Return the next row (if any) from the scan (if open).
public long	Returns: long The total amount of time spent (in milliseconds). getTimeSpent(int CURRENT_RESULTSET_ONLY - time spent only in this ResultSet ENTIRE_RESULTSET_TREE - time spent in this ResultSet and below. type) Implements org.apache.derby.iapi.sql.ResultSet.getTimeSpent. Return the total amount of time spent in this ResultSet
public void	openCore() Implements org.apache.derby.iapi.sql.execute.NoPutResultSet.openCore. open a scan on the table.

Inherited from org.apache.derby.impl.sql.execute.ScanResultSet:: getScanIsolationLevel initIsolationLevel setRowLocationsState toXML

Field Detail

coarserLock	back to summary
public boolean coarserLock

conglomId	back to summary
protected long conglomId

qualifiers	back to summary
protected Qualifier[][] qualifiers

returnedRow	back to summary
public boolean returnedRow

runTimeStatisticsOn	back to summary
protected boolean runTimeStatisticsOn

startSearchOperator	back to summary
protected int startSearchOperator

stopPositionString	back to summary
public String stopPositionString

stopSearchOperator	back to summary
protected int stopSearchOperator

userSuppliedOptimizerOverrides	back to summary
public String userSuppliedOptimizerOverrides

Constructor Detail

LastIndexKeyResultSet	back to summary
public LastIndexKeyResultSet(Activation activation, int resultSetNumber, int resultRowTemplate, long conglomId, String tableName, String userSuppliedOptimizerOverrides, String indexName, int colRefItem, int lockMode, boolean tableLocked, int isolationLevel, double optimizerEstimatedRowCount, double optimizerEstimatedCost) throws StandardException A last index key result set returns the last row from the index in question. It is used as an ajunct to max(). Parameters activation:Activation the activation for this result set, which provides the context for the row allocation operation. resultSetNumber:int The resultSetNumber for the ResultSet resultRowTemplate:int The saved item for result row template conglomId:long the conglomerate of the table to be scanned. tableName:String The full name of the table userSuppliedOptimizerOverrides:String Overrides specified by the user on the sql indexName:String The name of the index, if one used to access table. colRefItem:int An saved item for a bitSet of columns that are referenced in the underlying table. -1 if no item. lockMode:int The lock granularity to use (see TransactionController in access) tableLocked:boolean Whether or not the table is marked as using table locking (in sys.systables) isolationLevel:int Isolation level (specified or not) to use on scans optimizerEstimatedRowCount:double Estimated total # of rows by optimizer optimizerEstimatedCost:double Estimated total cost by optimizer Exceptions StandardException: thrown when unable to create the result set

LastIndexKeyResultSet

back to summary

public LastIndexKeyResultSet(Activation activation, int resultSetNumber, int resultRowTemplate, long conglomId, String tableName, String userSuppliedOptimizerOverrides, String indexName, int colRefItem, int lockMode, boolean tableLocked, int isolationLevel, double optimizerEstimatedRowCount, double optimizerEstimatedCost) throws StandardException

A last index key result set returns the last row from the index in question. It is used as an ajunct to max().

Parameters

activation:Activation: the activation for this result set, which provides the context for the row allocation operation.
resultSetNumber:int: The resultSetNumber for the ResultSet
resultRowTemplate:int: The saved item for result row template
conglomId:long: the conglomerate of the table to be scanned.
tableName:String: The full name of the table
userSuppliedOptimizerOverrides:String: Overrides specified by the user on the sql
indexName:String: The name of the index, if one used to access table.
colRefItem:int: An saved item for a bitSet of columns that are referenced in the underlying table. -1 if no item.
lockMode:int: The lock granularity to use (see TransactionController in access)
tableLocked:boolean: Whether or not the table is marked as using table locking (in sys.systables)
isolationLevel:int: Isolation level (specified or not) to use on scans
optimizerEstimatedRowCount:double: Estimated total # of rows by optimizer
optimizerEstimatedCost:double: Estimated total cost by optimizer

Exceptions

StandardException:: thrown when unable to create the result set

Method Detail

canGetInstantaneousLocks	back to summary
pack-priv boolean canGetInstantaneousLocks() Implements abstract org.apache.derby.impl.sql.execute.ScanResultSet.canGetInstantaneousLocks. Can we get instantaneous locks when getting share row locks at READ COMMITTED.

canGetInstantaneousLocks

back to summary

pack-priv boolean canGetInstantaneousLocks()

Implements abstract org.apache.derby.impl.sql.execute.ScanResultSet.canGetInstantaneousLocks.

Can we get instantaneous locks when getting share row locks at READ COMMITTED.

close	back to summary
public void close() throws StandardException Overrides org.apache.derby.impl.sql.execute.ScanResultSet.close. Implements org.apache.derby.iapi.sql.ResultSet.close. If the result set has been opened, close the open scan. Exceptions StandardException: thrown on failure to close

back to summary

public void close() throws StandardException

Overrides org.apache.derby.impl.sql.execute.ScanResultSet.close.

Implements org.apache.derby.iapi.sql.ResultSet.close.

If the result set has been opened, close the open scan.

Exceptions

StandardException:: thrown on failure to close

getCurrentRow back to summary

getCurrentRow	back to summary
public ExecRow getCurrentRow() throws StandardException This result set has its row from the last fetch done. If the cursor is closed, a null is returned. Returns:ExecRow the last row returned; Exceptions StandardException: thrown on failure. See Also `org.apache.derby.iapi.sql.execute.CursorResultSet`

public ExecRow getCurrentRow() throws StandardException

This result set has its row from the last fetch done. If the cursor is closed, a null is returned.

Returns:ExecRow

the last row returned;

Exceptions

StandardException:: thrown on failure.

getNextRowCore	back to summary
public ExecRow getNextRowCore() throws StandardException Implements abstract org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRowCore. Implements org.apache.derby.iapi.sql.execute.NoPutResultSet.getNextRowCore. Return the next row (if any) from the scan (if open). Returns:ExecRow Doc from org.apache.derby.iapi.sql.execute.NoPutResultSet.getNextRowCore. the next row in the result Exceptions StandardException: thrown on failure to get next row

getNextRowCore

back to summary

public ExecRow getNextRowCore() throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRowCore.

Implements org.apache.derby.iapi.sql.execute.NoPutResultSet.getNextRowCore.

Return the next row (if any) from the scan (if open).

Returns:ExecRow

Doc from org.apache.derby.iapi.sql.execute.NoPutResultSet.getNextRowCore.

the next row in the result

Exceptions

StandardException:: thrown on failure to get next row

getTimeSpent	back to summary
public long getTimeSpent(int type) Implements org.apache.derby.iapi.sql.ResultSet.getTimeSpent. Return the total amount of time spent in this ResultSet Parameters type:int CURRENT_RESULTSET_ONLY - time spent only in this ResultSet ENTIRE_RESULTSET_TREE - time spent in this ResultSet and below. Returns:long long The total amount of time spent (in milliseconds).

getTimeSpent

back to summary

public long getTimeSpent(int type)

Implements org.apache.derby.iapi.sql.ResultSet.getTimeSpent.

Return the total amount of time spent in this ResultSet

Parameters

type:int: CURRENT_RESULTSET_ONLY - time spent only in this ResultSet ENTIRE_RESULTSET_TREE - time spent in this ResultSet and below.

Returns:long

long The total amount of time spent (in milliseconds).

openCore	back to summary
public void openCore() throws StandardException Implements org.apache.derby.iapi.sql.execute.NoPutResultSet.openCore. open a scan on the table. scan parameters are evaluated at each open, so there is probably some way of altering their values... Exceptions StandardException: thrown on failure to open

openCore

back to summary

public void openCore() throws StandardException

Implements org.apache.derby.iapi.sql.execute.NoPutResultSet.openCore.

open a scan on the table. scan parameters are evaluated at each open, so there is probably some way of altering their values...

Exceptions

StandardException:: thrown on failure to open

pack-priv Class LastIndexKeyResultSet

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail