HashLeftOuterJoinResultSet (Apache Derby V10.14 Internals)

java.lang.Object
- org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl
- - org.apache.derby.impl.sql.execute.NoPutResultSetImpl
  - - org.apache.derby.impl.sql.execute.JoinResultSet
    - - org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet
      - org.apache.derby.impl.sql.execute.NestedLoopLeftOuterJoinResultSet
        
        org.apache.derby.impl.sql.execute.HashLeftOuterJoinResultSet

All Implemented Interfaces:

CursorResultSet, NoPutResultSet, ResultSet, RowLocationRetRowSource, RowSource
```
class HashLeftOuterJoinResultSet
extends NestedLoopLeftOuterJoinResultSet
```
Left outer join using hash join of 2 arbitrary result sets. Simple subclass of nested loop left outer join, differentiated to ease RunTimeStatistics output generation.

Nested Class Summary
- Nested classes/interfaces inherited from class org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl
  BasicNoPutResultSetImpl.FieldComparator

Field Summary
- Fields inherited from class org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl
  activation, beginTime, closeTime, compactRow, constructorTime, currentRow, endExecutionTime, finished, isOpen, isTopResultSet, nextTime, numOpens, openTime, optimizerEstimatedCost, optimizerEstimatedRowCount, resultDescription, rowsFiltered, rowsSeen, startExecutionTime, subqueryTrackingArray
- Fields inherited from class org.apache.derby.impl.sql.execute.JoinResultSet
  isRightOpen, leftNumCols, leftResultSet, leftRow, mergedRow, notExistsRightSide, oneRowRightSide, restriction, restrictionTime, rightNumCols, rightResultSet, rightRow, rowsReturned, rowsSeenLeft, rowsSeenRight, userSuppliedOptimizerOverrides
- Fields inherited from class org.apache.derby.impl.sql.execute.NestedLoopLeftOuterJoinResultSet
  emptyRightRowsReturned, emptyRowFun
- Fields inherited from interface org.apache.derby.iapi.sql.execute.NoPutResultSet
  ABSOLUTE, FIRST, LAST, NEXT, PREVIOUS, RELATIVE, TEMPORARY_RESULT_SET_NUMBER
- Fields inherited from class org.apache.derby.impl.sql.execute.NoPutResultSetImpl
  checkNullCols, clonedExecRow, cncLen, resultSetNumber, targetResultSet
- Fields inherited from interface org.apache.derby.iapi.sql.ResultSet
  CURRENT_RESULTSET_ONLY, ENTIRE_RESULTSET_TREE, ISAFTERLAST, ISBEFOREFIRST, ISFIRST, ISLAST

Constructor Summary

Constructors
Constructor	Description
`HashLeftOuterJoinResultSet(NoPutResultSet leftResultSet, int leftNumCols, NoPutResultSet rightResultSet, int rightNumCols, Activation activation, GeneratedMethod restriction, int resultSetNumber, GeneratedMethod emptyRowFun, boolean wasRightOuterJoin, boolean oneRowRightSide, boolean notExistsRightSide, double optimizerEstimatedRowCount, double optimizerEstimatedCost, java.lang.String userSuppliedOptimizerOverrides)`

Method Summary
- Methods inherited from class org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl
  addWarning, attachStatementContext, checkCancellationFlag, checkRowPosition, childrenToXML, cleanUp, dumpTimeStats, finishAndRTS, getAbsoluteRow, getActivation, getAutoGeneratedKeysResultset, getBeginExecutionTimestamp, getCompactRow, getCurrentTimeMillis, getElapsedMillis, getEndExecutionTimestamp, getEstimatedRowCount, getExecuteTime, getExecutionFactory, getFirstRow, getLanguageConnectionContext, getLastRow, getNextRow, getPointOfAttachment, getPreviousRow, getRelativeRow, getRowNumber, getScanIsolationLevel, getSubqueryTrackingArray, getTransactionController, getWarnings, isClosed, isXplainOnlyMode, markAsTopResultSet, modifiedRowCount, open, recordConstructorTime, requiresRelocking, returnsRows, setAfterLastRow, setBeforeFirstRow, setCompactRow, setCompatRow, toXML, toXML
- Methods inherited from class org.apache.derby.impl.sql.execute.JoinResultSet
  closeRight, finish, getCurrentRow, getRowLocation, openCore, openRight, reopenCore
- Methods inherited from class org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet
  close, getTimeSpent
- Methods inherited from class org.apache.derby.impl.sql.execute.NestedLoopLeftOuterJoinResultSet
  clearScanState, getMergedRow, getNextRowCore
- Methods inherited from class org.apache.derby.impl.sql.execute.NoPutResultSetImpl
  clearCurrentRow, clearOrderableCache, closeRowSource, getCursorName, getNextRowFromRowSource, getResultDescription, getValidColumns, isForUpdate, markRowAsDeleted, needsRowLocation, needsRowLocationForDeferredCheckConstraints, needsToClone, offendingRowLocation, positionScanAtRowLocation, printQualifiers, resultSetNumber, rowLocation, setCurrentRow, setHasDeferrableChecks, setNeedsRowLocation, setTargetResultSet, skipRow, skipScan, unpackHashValue, updateRow
- 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
  addWarning, checkRowPosition, cleanUp, clearCurrentRow, getAbsoluteRow, getActivation, getAutoGeneratedKeysResultset, getBeginExecutionTimestamp, getCursorName, getEndExecutionTimestamp, getExecuteTime, getFirstRow, getLastRow, getNextRow, getPreviousRow, getRelativeRow, getResultDescription, getRowNumber, getSubqueryTrackingArray, getWarnings, isClosed, modifiedRowCount, open, returnsRows, setAfterLastRow, setBeforeFirstRow, toXML

Constructor Detail

HashLeftOuterJoinResultSet

HashLeftOuterJoinResultSet(NoPutResultSet leftResultSet,
                           int leftNumCols,
                           NoPutResultSet rightResultSet,
                           int rightNumCols,
                           Activation activation,
                           GeneratedMethod restriction,
                           int resultSetNumber,
                           GeneratedMethod emptyRowFun,
                           boolean wasRightOuterJoin,
                           boolean oneRowRightSide,
                           boolean notExistsRightSide,
                           double optimizerEstimatedRowCount,
                           double optimizerEstimatedCost,
                           java.lang.String userSuppliedOptimizerOverrides)

Class HashLeftOuterJoinResultSet

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl

Field Summary

Fields inherited from class org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl

Fields inherited from class org.apache.derby.impl.sql.execute.JoinResultSet

Fields inherited from class org.apache.derby.impl.sql.execute.NestedLoopLeftOuterJoinResultSet

Fields inherited from interface org.apache.derby.iapi.sql.execute.NoPutResultSet

Fields inherited from class org.apache.derby.impl.sql.execute.NoPutResultSetImpl

Fields inherited from interface org.apache.derby.iapi.sql.ResultSet

Constructor Summary

Method Summary

Methods inherited from class org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl

Methods inherited from class org.apache.derby.impl.sql.execute.JoinResultSet

Methods inherited from class org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet

Methods inherited from class org.apache.derby.impl.sql.execute.NestedLoopLeftOuterJoinResultSet

Methods inherited from class org.apache.derby.impl.sql.execute.NoPutResultSetImpl

Methods inherited from class java.lang.Object

Methods inherited from interface org.apache.derby.iapi.sql.ResultSet

Constructor Detail

HashLeftOuterJoinResultSet