|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl
org.apache.derby.impl.sql.execute.NoPutResultSetImpl
org.apache.derby.impl.sql.execute.JoinResultSet
Takes 2 NoPutResultSets and a join filter and returns the join's rows satisfying the filter as a result set.
Fields inherited from interface org.apache.derby.iapi.sql.ResultSet |
CURRENT_RESULTSET_ONLY, ENTIRE_RESULTSET_TREE, ISAFTERLAST, ISBEFOREFIRST, ISFIRST, ISLAST |
Fields inherited from interface org.apache.derby.iapi.sql.execute.NoPutResultSet |
ABSOLUTE, FIRST, LAST, NEXT, PREVIOUS, RELATIVE |
Constructor Summary | |
JoinResultSet(NoPutResultSet leftResultSet,
int leftNumCols,
NoPutResultSet rightResultSet,
int rightNumCols,
Activation activation,
GeneratedMethod restriction,
int resultSetNumber,
boolean oneRowRightSide,
boolean notExistsRightSide,
double optimizerEstimatedRowCount,
double optimizerEstimatedCost,
GeneratedMethod closeCleanup)
|
Method Summary | |
protected void |
addWarning(java.sql.SQLWarning w)
|
protected void |
attachStatementContext()
Attach this result set to the top statement context on the stack. |
boolean |
checkRowPosition(int isType)
Determine if the cursor is before the first row in the result set. |
void |
cleanUp()
Clean up on error |
void |
clearCurrentRow()
Clear the current row |
protected void |
clearOrderableCache(Qualifier[][] qualifiers)
Clear the Orderable cache for each qualifier. |
(package private) void |
clearScanState()
Clear any private state that changes during scans. |
void |
close()
If the result set has been opened, close the open scan. |
protected void |
closeRight()
close the rightResultSet |
void |
closeRowSource()
closeRowSource tells the RowSource that it will no longer need to return any rows and it can release any resource it may have. |
protected java.lang.String |
dumpTimeStats(java.lang.String indent,
java.lang.String subIndent)
Dump out the time information for run time stats. |
void |
finish()
Tells the system that there will be no more access to any database information via this result set; in particular, no more calls to open(). |
protected void |
finishAndRTS()
|
ExecRow |
getAbsoluteRow(int row)
Returns the row at the absolute position from the query, and returns NULL when there is no such position. |
ResultSet |
getAutoGeneratedKeysResultset()
ResultSet for rowss inserted into the table (contains auto-generated keys columns only) |
java.sql.Timestamp |
getBeginExecutionTimestamp()
Get the Timestamp for the beginning of execution. |
protected ExecRow |
getCompactRow(ExecRow candidate,
FormatableBitSet accessedCols,
FormatableBitSet otherCols,
boolean isKeyed)
Get a compacted version of the candidate row according to the columns specified in the bit map. |
ExecRow |
getCurrentRow()
A join is combining rows from two sources, so it should never be used in a positioned update or delete. |
protected long |
getCurrentTimeMillis()
Return the current time in milliseconds, if DEBUG and RunTimeStats is on, else return 0. |
java.lang.String |
getCursorName()
Return my cursor name for JDBC. |
protected long |
getElapsedMillis(long beginTime)
Return the elapsed time in milliseconds, between now and the beginTime, if DEBUG and RunTimeStats is on, else return 0. |
java.sql.Timestamp |
getEndExecutionTimestamp()
Get the Timestamp for the end of execution. |
double |
getEstimatedRowCount()
Get the estimated row count from this result set. |
long |
getExecuteTime()
Get the execution time in milliseconds. |
(package private) ExecutionFactory |
getExecutionFactory()
Get a execution factory |
ExecRow |
getFirstRow()
Returns the first row from the query, and returns NULL when there are no rows. |
protected LanguageConnectionContext |
getLanguageConnectionContext()
Cache the language connection context. |
ExecRow |
getLastRow()
Returns the last row from the query, and returns NULL when there are no rows. |
ExecRow |
getNextRow()
Return the requested values computed from the next row (if any) for which the restriction evaluates to true. |
abstract ExecRow |
getNextRowCore()
Return the requested values computed from the next row (if any) for which the restriction evaluates to true. |
DataValueDescriptor[] |
getNextRowFromRowSource()
Get the next row as an array of column objects. |
int |
getPointOfAttachment()
Return the point of attachment for this subquery. |
ExecRow |
getPreviousRow()
Returns the previous row from the query, and returns NULL when there are no more previous rows. |
ExecRow |
getRelativeRow(int row)
Returns the row at the relative position from the current cursor position, and returns NULL when there is no such position. |
ResultDescription |
getResultDescription()
Returns the description of the table's rows |
RowLocation |
getRowLocation()
A join is combining rows from two sources, so it has no single row location to return; just return a null. |
int |
getRowNumber()
Returns the row number of the current row. |
int |
getScanIsolationLevel()
Return the isolation level of the scan in the result set. |
NoPutResultSet[] |
getSubqueryTrackingArray(int numSubqueries)
Get the subquery ResultSet tracking array from the top ResultSet. |
(package private) TransactionController |
getTransactionController()
Get the current transaction controller. |
FormatableBitSet |
getValidColumns()
getValidColumns describes the DataValueDescriptor[] returned by all calls to the getNextRowFromRowSource() call. |
java.sql.SQLWarning |
getWarnings()
Return the set of warnings generated during the execution of this result set. |
boolean |
isClosed()
Report if closed. |
boolean |
isForUpdate()
Is this ResultSet or it's source result set for update This method will be overriden in the inherited Classes if it is true |
void |
markAsTopResultSet()
Mark the ResultSet as the topmost one in the ResultSet tree. |
int |
modifiedRowCount()
Returns the number of rows affected by the statement. |
boolean |
needsRowLocation()
needsRowLocation returns true iff this the row source expects the drainer of the row source to call rowLocation after getting a row from getNextRowFromRowSource. |
boolean |
needsToClone()
Does the caller of getNextRowFromRowSource() need to clone the row in order to keep a reference to the row past the getNextRowFromRowSource() call which returned the row. |
void |
open()
open a scan on the table. scan parameters are evaluated at each open, so there is probably some way of altering their values... |
void |
openCore()
open a scan on the join. |
protected void |
openRight()
open the rightResultSet. |
static java.lang.String |
printQualifiers(Qualifier[][] qualifiers)
Return a 2-d array of Qualifiers as a String |
void |
reopenCore()
reopen a a join. |
boolean |
requiresRelocking()
Do we need to relock the row when going to the heap. |
int |
resultSetNumber()
Get the number of this ResultSet, which is guaranteed to be unique within a statement. |
boolean |
returnsRows()
Returns true. |
void |
rowLocation(RowLocation rl)
rowLocation is a callback for the drainer of the row source to return the rowLocation of the current row, i.e, the row that is being returned by getNextRowFromRowSource. |
ExecRow |
setAfterLastRow()
Sets the current position to after the last row and returns NULL because there is no current row. |
ExecRow |
setBeforeFirstRow()
Sets the current position to before the first row and returns NULL because there is no current row. |
protected void |
setCheckConstraints(GeneratedMethod checkGM)
Set the GeneratedMethod for enforcing check constraints |
protected ExecRow |
setCompactRow(ExecRow candidateRow,
ExecRow compactRow)
Copy columns from the candidate row from the store to the given compact row. |
protected void |
setCompatRow(ExecRow compactRow,
java.lang.Object[] sourceRow)
|
void |
setCurrentRow(ExecRow row)
Set the current row to the row passed in. |
protected void |
setHeapConglomerate(long heapConglomerate)
Set the heap conglomerate number (used in enforcing check constraints) |
void |
setNeedsRowLocation(boolean needsRowLocation)
Set whether or not the NPRS need the row location when acting as a row source. |
void |
setTargetResultSet(TargetResultSet trs)
Notify a NPRS that it is the source for the specified TargetResultSet. |
protected boolean |
skipRow(ExecRow row)
Return true if we should skip the scan due to nulls in the row when the start or stop positioners on the columns containing null do not implement ordered null semantics. |
protected boolean |
skipScan(ExecIndexRow startPosition,
ExecIndexRow stopPosition)
Return true if we should skip the scan due to nulls in the start or stop position when the predicate on the column(s) in question do not implement ordered null semantics. beetle 4464, we also compact the areNullsOrdered flags into checkNullCols here. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface org.apache.derby.iapi.sql.ResultSet |
checkRowPosition, cleanUp, getAbsoluteRow, getAutoGeneratedKeysResultset, getBeginExecutionTimestamp, getCursorName, getEndExecutionTimestamp, getExecuteTime, getFirstRow, getLastRow, getNextRow, getPreviousRow, getRelativeRow, getResultDescription, getRowNumber, getSubqueryTrackingArray, getTimeSpent, getWarnings, isClosed, modifiedRowCount, open, returnsRows, setAfterLastRow, setBeforeFirstRow |
Field Detail |
public int rowsSeenLeft
public int rowsSeenRight
public int rowsReturned
public long restrictionTime
protected boolean isRightOpen
protected ExecRow leftRow
protected ExecRow rightRow
protected ExecRow mergedRow
public NoPutResultSet leftResultSet
protected int leftNumCols
public NoPutResultSet rightResultSet
protected int rightNumCols
protected GeneratedMethod restriction
protected GeneratedMethod closeCleanup
public boolean oneRowRightSide
public boolean notExistsRightSide
public final int resultSetNumber
protected java.lang.String indent
protected java.lang.String subIndent
protected int sourceDepth
protected ExecRow clonedExecRow
GeneratedMethod checkGM
long heapConglomerate
protected TargetResultSet targetResultSet
protected int[] checkNullCols
protected int cncLen
protected boolean isOpen
protected boolean finished
protected ExecRow currentRow
protected boolean isTopResultSet
protected LanguageConnectionContext lcc
public int numOpens
public int rowsSeen
public int rowsFiltered
protected long startExecutionTime
protected long endExecutionTime
public long beginTime
public long constructorTime
public long openTime
public long nextTime
public long closeTime
public double optimizerEstimatedRowCount
public double optimizerEstimatedCost
public NoPutResultSet[] subqueryTrackingArray
ExecRow compactRow
protected Activation activation
ResultDescription resultDescription
Constructor Detail |
public JoinResultSet(NoPutResultSet leftResultSet, int leftNumCols, NoPutResultSet rightResultSet, int rightNumCols, Activation activation, GeneratedMethod restriction, int resultSetNumber, boolean oneRowRightSide, boolean notExistsRightSide, double optimizerEstimatedRowCount, double optimizerEstimatedCost, GeneratedMethod closeCleanup)
Method Detail |
void clearScanState()
This method is called on open()/close() and reopen()
public void openCore() throws StandardException
openCore
in interface NoPutResultSet
openCore
in class BasicNoPutResultSetImpl
StandardException
- Thrown on errorNoPutResultSet.openCore()
public void reopenCore() throws StandardException
reopenCore
in interface NoPutResultSet
reopenCore
in class BasicNoPutResultSetImpl
StandardException
- thrown if cursor finished.NoPutResultSet.openCore()
public void close() throws StandardException
close
in interface ResultSet
close
in class NoPutResultSetImpl
StandardException
- thrown on errorpublic void finish() throws StandardException
ResultSet
finish
in interface ResultSet
finish
in class BasicNoPutResultSetImpl
StandardException
public RowLocation getRowLocation()
getRowLocation
in interface CursorResultSet
CursorResultSet
public ExecRow getCurrentRow()
getCurrentRow
in interface CursorResultSet
CursorResultSet
protected void openRight() throws StandardException
StandardException
- Thrown on errorprotected void closeRight() throws StandardException
StandardException
- thrown on errorpublic ResultDescription getResultDescription()
getResultDescription
in interface ResultSet
getResultDescription
in class BasicNoPutResultSetImpl
public java.lang.String getCursorName()
public int resultSetNumber()
NoPutResultSet
resultSetNumber
in interface NoPutResultSet
resultSetNumber
in class BasicNoPutResultSetImpl
NoPutResultSet.resultSetNumber()
public void setTargetResultSet(TargetResultSet trs)
NoPutResultSet
trs
- The TargetResultSet.
NoPutResultSet.setTargetResultSet(org.apache.derby.iapi.sql.execute.TargetResultSet)
public void setNeedsRowLocation(boolean needsRowLocation)
NoPutResultSet
NoPutResultSet.setNeedsRowLocation(boolean)
public FormatableBitSet getValidColumns()
RowSource
RowSource.getValidColumns()
public DataValueDescriptor[] getNextRowFromRowSource() throws StandardException
RowSource
A null column can be specified by leaving the object null, or indicated by returning a non-null getValidColumns. On streaming columns, it can be indicated by returning a non-null get FieldStates.
If RowSource.needToClone() is true then the returned row (the DataValueDescriptor[]) is guaranteed not to be modified by drainer of the RowSource (except that the input stream will be read, of course) and drainer will keep no reference to it before making the subsequent nextRow call. So it is safe to return the same DataValueDescriptor[] in subsequent nextRow calls if that is desirable for performance reasons.
If RowSource.needToClone() is false then the returned row (the DataValueDescriptor[]) may be be modified by drainer of the RowSource, and the drainer may keep a reference to it after making the subsequent nextRow call. In this case the client should severe all references to the row after returning it from getNextRowFromRowSource().
StandardException
- on errorRowSource.getNextRowFromRowSource()
public boolean needsToClone()
RowSource
RowSource.needsToClone()
public void closeRowSource()
RowSource
RowSource.closeRowSource()
public boolean needsRowLocation()
RowLocationRetRowSource
RowLocationRetRowSource.needsRowLocation()
public void rowLocation(RowLocation rl) throws StandardException
RowLocationRetRowSource
boolean needsRL = rowSource.needsRowLocation(); DataValueDescriptor[] row; while((row = rowSource.getNextRowFromRowSource()) != null) { RowLocation rl = heapConglomerate.insertRow(row); if (needsRL) rowSource.rowLocation(rl); }
StandardException
- on errorRowLocationRetRowSource.rowLocation(org.apache.derby.iapi.types.RowLocation)
protected void clearOrderableCache(Qualifier[][] qualifiers) throws StandardException
qualifiers
- The Qualifiers to clear
StandardException
protected void setCheckConstraints(GeneratedMethod checkGM)
checkGM
- The GeneratedMethod for enforcing any check constraints.
protected void setHeapConglomerate(long heapConglomerate)
heapConglomerate
- The heap conglomerate number.
public final void setCurrentRow(ExecRow row)
row
- the new current rowpublic final void clearCurrentRow()
public boolean isForUpdate()
isForUpdate
in interface NoPutResultSet
isForUpdate
in class BasicNoPutResultSetImpl
protected boolean skipScan(ExecIndexRow startPosition, ExecIndexRow stopPosition) throws StandardException
startPosition
- An index row for the start positionstopPosition
- An index row for the stop position
StandardException
protected boolean skipRow(ExecRow row) throws StandardException
row
- An index row
StandardException
public static java.lang.String printQualifiers(Qualifier[][] qualifiers)
public abstract ExecRow getNextRowCore() throws StandardException
NoPutResultSet
restriction and projection parameters are evaluated for each row.
getNextRowCore
in interface NoPutResultSet
StandardException
- thrown if cursor finished.NoPutResultSet.getNextRowCore()
public int getPointOfAttachment()
NoPutResultSet
getPointOfAttachment
in interface NoPutResultSet
NoPutResultSet.getPointOfAttachment()
public void markAsTopResultSet()
markAsTopResultSet
in interface NoPutResultSet
public int getScanIsolationLevel()
NoPutResultSet
getScanIsolationLevel
in interface NoPutResultSet
NoPutResultSet.getScanIsolationLevel()
public double getEstimatedRowCount()
NoPutResultSet
getEstimatedRowCount
in interface NoPutResultSet
NoPutResultSet.getEstimatedRowCount()
public boolean requiresRelocking()
NoPutResultSet
requiresRelocking
in interface NoPutResultSet
NoPutResultSet.requiresRelocking()
public final void open() throws StandardException
open
in interface ResultSet
StandardException
- thrown if cursor finished.public ExecRow getAbsoluteRow(int row) throws StandardException
getAbsoluteRow
in interface ResultSet
row
- The position.
StandardException
- Thrown on failureRow
public ExecRow getRelativeRow(int row) throws StandardException
getRelativeRow
in interface ResultSet
row
- The position.
StandardException
- Thrown on failureRow
public ExecRow setBeforeFirstRow() throws StandardException
setBeforeFirstRow
in interface ResultSet
StandardException
- Thrown on failureRow
public boolean checkRowPosition(int isType) throws StandardException
checkRowPosition
in interface ResultSet
StandardException
- Thrown on error.public int getRowNumber()
getRowNumber
in interface ResultSet
public ExecRow getFirstRow() throws StandardException
getFirstRow
in interface ResultSet
StandardException
- Thrown on failureRow
public final ExecRow getNextRow() throws StandardException
restriction and projection parameters are evaluated for each row. NOTE: This method should only be called on the top ResultSet of a ResultSet tree to ensure that the entire ResultSet tree gets closed down on an error. the getNextRowCore() method will be called for all other ResultSets in the tree.
getNextRow
in interface ResultSet
StandardException
- thrown on failure.
StandardException
- ResultSetNotOpen thrown if not yet open.Row
public ExecRow getPreviousRow() throws StandardException
getPreviousRow
in interface ResultSet
StandardException
- Thrown on failureRow
public ExecRow getLastRow() throws StandardException
getLastRow
in interface ResultSet
StandardException
- Thrown on failureRow
public ExecRow setAfterLastRow() throws StandardException
setAfterLastRow
in interface ResultSet
StandardException
- Thrown on failureRow
public boolean returnsRows()
returnsRows
in interface ResultSet
public final int modifiedRowCount()
ResultSet
modifiedRowCount
in interface ResultSet
public void cleanUp() throws StandardException
cleanUp
in interface ResultSet
StandardException
- Thrown on failurepublic boolean isClosed()
isClosed
in interface ResultSet
protected final void finishAndRTS() throws StandardException
StandardException
- on errorpublic long getExecuteTime()
getExecuteTime
in interface ResultSet
public java.sql.Timestamp getBeginExecutionTimestamp()
getBeginExecutionTimestamp
in interface ResultSet
public java.sql.Timestamp getEndExecutionTimestamp()
getEndExecutionTimestamp
in interface ResultSet
public final NoPutResultSet[] getSubqueryTrackingArray(int numSubqueries)
ResultSet
getSubqueryTrackingArray
in interface ResultSet
numSubqueries
- The size of the array (For allocation on demand.)
ResultSet.getSubqueryTrackingArray(int)
protected final long getCurrentTimeMillis()
public ResultSet getAutoGeneratedKeysResultset()
ResultSet
getAutoGeneratedKeysResultset
in interface ResultSet
ResultSet.getAutoGeneratedKeysResultset()
protected final long getElapsedMillis(long beginTime)
protected final java.lang.String dumpTimeStats(java.lang.String indent, java.lang.String subIndent)
protected void attachStatementContext() throws StandardException
StandardException
- thrown if cursor finished.protected final LanguageConnectionContext getLanguageConnectionContext()
final ExecutionFactory getExecutionFactory()
final TransactionController getTransactionController()
protected ExecRow getCompactRow(ExecRow candidate, FormatableBitSet accessedCols, FormatableBitSet otherCols, boolean isKeyed) throws StandardException
candidate
- The row to get the columns fromaccessedCols
- A bit map of the columns that are accessed in
the candidate rowotherCols
- An bit map of other column ids - this is used
in case columns from an index row will be
copied into a heap row - in this case, we
need to be sure there are enough columns in
the compact row. This parameter is null if
columns will not be copied from an index row
to a compact heap row. The column numbers in
the bit map are zero-based.isKeyed
- Tells whether to return a ValueRow or an IndexRow
StandardException
protected ExecRow setCompactRow(ExecRow candidateRow, ExecRow compactRow)
candidateRow
- The candidate row from the storecompactRow
- The compact row to fill in
protected final void setCompatRow(ExecRow compactRow, java.lang.Object[] sourceRow)
protected final void addWarning(java.sql.SQLWarning w)
public final java.sql.SQLWarning getWarnings()
ResultSet
getWarnings
in interface ResultSet
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |