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

Field Summary

Modifier and Type	Field and Description
private final Activation	activation
private ConglomerateController	baseCC
private final FormatableBitSet	baseRowReadMap
private final boolean	deferrable
private BackingStoreHashtable	deferredDuplicates
private ConglomerateController	indexCC
private final long	indexCID
private final DynamicCompiledOpenConglomInfo	indexDCOCI
private final String	indexName
private ScanController	indexSC
private final StaticCompiledOpenConglomInfo	indexSCOCI
private final IndexRowGenerator	irg
private int	isolationLevel
private final LanguageConnectionContext	lcc
private final int	lockMode
private ExecIndexRow	ourIndexRow
private ExecIndexRow	ourUpdatedIndexRow
private boolean	ownIndexSC
private TemporaryRowHolderImpl	rowHolder
private boolean	rowHolderPassedIn
private final TransactionController	tc
private UUID	uniqueConstraintId

Constructor Summary

Access	Constructor and Description
pack-priv	IndexChanger(IndexRowGenerator the IndexRowGenerator for the index. irg, long the conglomerate id for the index. indexCID, StaticCompiledOpenConglomInfo the SCOCI for the indexes. indexSCOCI, DynamicCompiledOpenConglomInfo the DCOCI for the indexes. indexDCOCI, String indexName, ConglomerateController the ConglomerateController for the base table. baseCC, TransactionController The TransactionController tc, int The lock mode (granularity) to use lockMode, FormatableBitSet Map of columns read in. 1 based. baseRowReadMap, int Isolation level to use. isolationLevel, Activation Current activation activation) Create an IndexChanger

Access

Constructor and Description

pack-priv

IndexChanger(IndexRowGenerator

the IndexRowGenerator for the index.

irg, long

the conglomerate id for the index.

indexCID, StaticCompiledOpenConglomInfo

the SCOCI for the indexes.

indexSCOCI, DynamicCompiledOpenConglomInfo

the DCOCI for the indexes.

indexDCOCI, String indexName, ConglomerateController

the ConglomerateController for the base table.

baseCC, TransactionController

The TransactionController

tc, int

The lock mode (granularity) to use

lockMode, FormatableBitSet

Map of columns read in. 1 based.

baseRowReadMap, int

Isolation level to use.

isolationLevel, Activation

Current activation

activation)

Create an IndexChanger

Method Summary

Modifier and Type	Method and Description
pack-priv void	close() Close this IndexChanger.
private void	closeIndexCC() Close our index Conglomerate Controller
private void	closeIndexSC() Close our index ScanController.
pack-priv void	delete(ExecRow the base table row. baseRow, RowLocation the base table row's location. baseRowLocation) Perform index maintenance to support a delete of a base table row.
private void	doDeferredInsert() Insert a row into the temporary conglomerate This opens our deferred ConglomeratController the first time it is called.
private void	doDelete() Delete a row from our index.
private void	doInsert() Insert a row into our indes.
pack-priv void	finish() Finish doing the changes for this index.
private UUID	getUniqueConstraintId()
private boolean	Returns: Nothing. indexRowChanged() Determine whether or not any columns in the current index row are being changed by the update.
pack-priv void	insert(ExecRow the base table row. newRow, RowLocation the base table row's location. baseRowLocation) Perform index maintenance to support an insert of a base table row.
private void	insertAndCheckDups(ExecIndexRow The row to insert row) Insert the given row into the given conglomerate and check for duplicate key error.
pack-priv void	insertForUpdate(ExecRow the base table row. newRow, RowLocation the base table row's location. baseRowLocation) If we're updating a unique index, the inserts have to be deferred.
pack-priv void	open() Open this IndexChanger.
private ConglomerateController	Returns: The ConglomerateController for this index. openIndexCC() Open the ConglomerateController for this index if it isn't open yet.
pack-priv void	setBaseCC(ConglomerateController The heap's ConglomerateController. baseCC) Propagate the heap's ConglomerateController to this index changer.
private void	setOurIndexRow(ExecRow a base table row. baseRow, RowLocation baseRowLoc baseRow's location baseRowLoc) Set the column values for 'ourIndexRow' to refer to a base table row and location provided by the caller.
private void	setOurUpdatedIndexRow(ExecRow a base table row. baseRow, RowLocation baseRowLoc baseRow's location baseRowLoc) Set the column values for 'ourUpdatedIndexRow' to refer to a base table row and location provided by the caller.
pack-priv void	setRowHolder(TemporaryRowHolderImpl the row holder rowHolder) Set the row holder for this changer to use.
private void	setScan() Position our index scan to 'ourIndexRow'.
pack-priv void	update(ExecRow the old image of the base table row. oldBaseRow, ExecRow the new image of the base table row. newBaseRow, RowLocation the base table row's location. baseRowLocation) Perform index maintenance to support an update of a base table row.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

activation	back to summary
private final Activation activation

baseCC	back to summary
private ConglomerateController baseCC

baseRowReadMap	back to summary
private final FormatableBitSet baseRowReadMap

deferrable	back to summary
private final boolean deferrable

deferredDuplicates	back to summary
private BackingStoreHashtable deferredDuplicates

indexCC	back to summary
private ConglomerateController indexCC

indexCID	back to summary
private final long indexCID

indexDCOCI	back to summary
private final DynamicCompiledOpenConglomInfo indexDCOCI

indexName	back to summary
private final String indexName

indexSC	back to summary
private ScanController indexSC

indexSCOCI	back to summary
private final StaticCompiledOpenConglomInfo indexSCOCI

irg	back to summary
private final IndexRowGenerator irg

isolationLevel	back to summary
private int isolationLevel

lcc	back to summary
private final LanguageConnectionContext lcc

lockMode	back to summary
private final int lockMode

ourIndexRow	back to summary
private ExecIndexRow ourIndexRow

ourUpdatedIndexRow	back to summary
private ExecIndexRow ourUpdatedIndexRow

ownIndexSC	back to summary
private boolean ownIndexSC

rowHolder	back to summary
private TemporaryRowHolderImpl rowHolder

rowHolderPassedIn	back to summary
private boolean rowHolderPassedIn

tc	back to summary
private final TransactionController tc

uniqueConstraintId	back to summary
private UUID uniqueConstraintId

Constructor Detail

IndexChanger	back to summary
pack-priv IndexChanger(IndexRowGenerator irg, long indexCID, StaticCompiledOpenConglomInfo indexSCOCI, DynamicCompiledOpenConglomInfo indexDCOCI, String indexName, ConglomerateController baseCC, TransactionController tc, int lockMode, FormatableBitSet baseRowReadMap, int isolationLevel, Activation activation) throws StandardException Create an IndexChanger Parameters irg:IndexRowGenerator the IndexRowGenerator for the index. indexCID:long the conglomerate id for the index. indexSCOCI:StaticCompiledOpenConglomInfo the SCOCI for the indexes. indexDCOCI:DynamicCompiledOpenConglomInfo the DCOCI for the indexes. baseCC:ConglomerateController the ConglomerateController for the base table. tc:TransactionController The TransactionController lockMode:int The lock mode (granularity) to use baseRowReadMap:FormatableBitSet Map of columns read in. 1 based. isolationLevel:int Isolation level to use. activation:Activation Current activation Exceptions StandardException: Thrown on error

IndexChanger

back to summary

pack-priv IndexChanger(IndexRowGenerator irg, long indexCID, StaticCompiledOpenConglomInfo indexSCOCI, DynamicCompiledOpenConglomInfo indexDCOCI, String indexName, ConglomerateController baseCC, TransactionController tc, int lockMode, FormatableBitSet baseRowReadMap, int isolationLevel, Activation activation) throws StandardException

Create an IndexChanger

Parameters

irg:IndexRowGenerator: the IndexRowGenerator for the index.
indexCID:long: the conglomerate id for the index.
indexSCOCI:StaticCompiledOpenConglomInfo: the SCOCI for the indexes.
indexDCOCI:DynamicCompiledOpenConglomInfo: the DCOCI for the indexes.
baseCC:ConglomerateController: the ConglomerateController for the base table.
tc:TransactionController: The TransactionController
lockMode:int: The lock mode (granularity) to use
baseRowReadMap:FormatableBitSet: Map of columns read in. 1 based.
isolationLevel:int: Isolation level to use.
activation:Activation: Current activation

Exceptions

StandardException:: Thrown on error

Method Detail

close	back to summary
pack-priv void close() throws StandardException Close this IndexChanger. Exceptions StandardException: Thrown on error

back to summary

pack-priv void close() throws StandardException

Close this IndexChanger.

Exceptions

StandardException:: Thrown on error

closeIndexCC	back to summary
private void closeIndexCC() throws StandardException Close our index Conglomerate Controller

closeIndexSC	back to summary
private void closeIndexSC() throws StandardException Close our index ScanController.

delete	back to summary
pack-priv void delete(ExecRow baseRow, RowLocation baseRowLocation) throws StandardException Perform index maintenance to support a delete of a base table row. Parameters baseRow:ExecRow the base table row. baseRowLocation:RowLocation the base table row's location. Exceptions StandardException: Thrown on error

delete

back to summary

pack-priv void delete(ExecRow baseRow, RowLocation baseRowLocation) throws StandardException

Perform index maintenance to support a delete of a base table row.

Parameters

baseRow:ExecRow: the base table row.
baseRowLocation:RowLocation: the base table row's location.

Exceptions

StandardException:: Thrown on error

doDeferredInsert	back to summary
private void doDeferredInsert() throws StandardException Insert a row into the temporary conglomerate This opens our deferred ConglomeratController the first time it is called. Exceptions StandardException: Thrown on error

doDeferredInsert

back to summary

private void doDeferredInsert() throws StandardException

Insert a row into the temporary conglomerate

This opens our deferred ConglomeratController the first time it is called.

Exceptions

StandardException:: Thrown on error

doDelete	back to summary
private void doDelete() throws StandardException Delete a row from our index. This assumes our index ScanController is positioned before the row by setScan if we own the SC, otherwise it is positioned on the row by the underlying index scan. This verifies the row exists and is unique. Exceptions StandardException: Thrown on error

doDelete

back to summary

private void doDelete() throws StandardException

Delete a row from our index. This assumes our index ScanController is positioned before the row by setScan if we own the SC, otherwise it is positioned on the row by the underlying index scan.

This verifies the row exists and is unique.

Exceptions

StandardException:: Thrown on error

doInsert	back to summary
private void doInsert() throws StandardException Insert a row into our indes. This opens our index ConglomeratController the first time it is called. Exceptions StandardException: Thrown on error

doInsert

back to summary

private void doInsert() throws StandardException

Insert a row into our indes.

This opens our index ConglomeratController the first time it is called.

Exceptions

StandardException:: Thrown on error

finish	back to summary
pack-priv void finish() throws StandardException Finish doing the changes for this index. This is intended for deferred inserts for unique indexes. It has no effect unless we are doing an update of a unique index. Exceptions StandardException: Thrown on error

finish

back to summary

pack-priv void finish() throws StandardException

Finish doing the changes for this index. This is intended for deferred inserts for unique indexes. It has no effect unless we are doing an update of a unique index.

Exceptions

StandardException:: Thrown on error

getUniqueConstraintId	back to summary
private UUID getUniqueConstraintId() throws StandardException

indexRowChanged	back to summary
private boolean indexRowChanged() throws StandardException Determine whether or not any columns in the current index row are being changed by the update. No need to update the index if no columns changed. Returns:boolean Nothing. Exceptions StandardException: Thrown on error

indexRowChanged

back to summary

private boolean indexRowChanged() throws StandardException

Determine whether or not any columns in the current index row are being changed by the update. No need to update the index if no columns changed.

Returns:boolean

Nothing.

Exceptions

StandardException:: Thrown on error

insert	back to summary
pack-priv void insert(ExecRow newRow, RowLocation baseRowLocation) throws StandardException Perform index maintenance to support an insert of a base table row. Parameters newRow:ExecRow the base table row. baseRowLocation:RowLocation the base table row's location. Exceptions StandardException: Thrown on error

insert

back to summary

pack-priv void insert(ExecRow newRow, RowLocation baseRowLocation) throws StandardException

Perform index maintenance to support an insert of a base table row.

Parameters

newRow:ExecRow: the base table row.
baseRowLocation:RowLocation: the base table row's location.

Exceptions

StandardException:: Thrown on error

insertAndCheckDups	back to summary
private void insertAndCheckDups(ExecIndexRow row) throws StandardException Insert the given row into the given conglomerate and check for duplicate key error. Parameters row:ExecIndexRow The row to insert Exceptions StandardException: Thrown on duplicate key error unless we have a deferred constraint. In that index rows are saved for checking on commit.

insertAndCheckDups

back to summary

private void insertAndCheckDups(ExecIndexRow row) throws StandardException

Insert the given row into the given conglomerate and check for duplicate key error.

Parameters

row:ExecIndexRow: The row to insert

Exceptions

StandardException:: Thrown on duplicate key error unless we have a deferred constraint. In that index rows are saved for checking on commit.

insertForUpdate	back to summary
pack-priv void insertForUpdate(ExecRow newRow, RowLocation baseRowLocation) throws StandardException If we're updating a unique index, the inserts have to be deferred. This is to avoid uniqueness violations that are only temporary. If we do all the deletes first, only "true" uniqueness violations can happen. We do this here, rather than in open(), because this is the only operation that requires deferred inserts, and we only want to create the conglomerate if necessary. Parameters newRow:ExecRow the base table row. baseRowLocation:RowLocation the base table row's location. Exceptions StandardException: Thrown on error

insertForUpdate

back to summary

pack-priv void insertForUpdate(ExecRow newRow, RowLocation baseRowLocation) throws StandardException

If we're updating a unique index, the inserts have to be deferred. This is to avoid uniqueness violations that are only temporary. If we do all the deletes first, only "true" uniqueness violations can happen. We do this here, rather than in open(), because this is the only operation that requires deferred inserts, and we only want to create the conglomerate if necessary.

Parameters

newRow:ExecRow: the base table row.
baseRowLocation:RowLocation: the base table row's location.

Exceptions

StandardException:: Thrown on error

open	back to summary
pack-priv void open() throws StandardException Open this IndexChanger. Exceptions StandardException: Thrown on error

open

back to summary

pack-priv void open() throws StandardException

Open this IndexChanger.

Exceptions

StandardException:: Thrown on error

openIndexCC	back to summary
private ConglomerateController openIndexCC() throws StandardException Open the ConglomerateController for this index if it isn't open yet. Returns:ConglomerateController The ConglomerateController for this index. Exceptions StandardException: Thrown on duplicate key error

openIndexCC

back to summary

private ConglomerateController openIndexCC() throws StandardException

Open the ConglomerateController for this index if it isn't open yet.

Returns:ConglomerateController

The ConglomerateController for this index.

Exceptions

StandardException:: Thrown on duplicate key error

setBaseCC	back to summary
pack-priv void setBaseCC(ConglomerateController baseCC) Propagate the heap's ConglomerateController to this index changer. Parameters baseCC:ConglomerateController The heap's ConglomerateController.

setBaseCC

back to summary

pack-priv void setBaseCC(ConglomerateController baseCC)

Propagate the heap's ConglomerateController to this index changer.

Parameters

baseCC:ConglomerateController: The heap's ConglomerateController.

setOurIndexRow	back to summary
private void setOurIndexRow(ExecRow baseRow, RowLocation baseRowLoc) throws StandardException Set the column values for 'ourIndexRow' to refer to a base table row and location provided by the caller. The idea here is to Parameters baseRow:ExecRow a base table row. baseRowLoc:RowLocation baseRowLoc baseRow's location Exceptions StandardException: Thrown on error

setOurIndexRow

back to summary

private void setOurIndexRow(ExecRow baseRow, RowLocation baseRowLoc) throws StandardException

Set the column values for 'ourIndexRow' to refer to a base table row and location provided by the caller. The idea here is to

Parameters

baseRow:ExecRow: a base table row.
baseRowLoc:RowLocation: baseRowLoc baseRow's location

Exceptions

StandardException:: Thrown on error

setOurUpdatedIndexRow	back to summary
private void setOurUpdatedIndexRow(ExecRow baseRow, RowLocation baseRowLoc) throws StandardException Set the column values for 'ourUpdatedIndexRow' to refer to a base table row and location provided by the caller. The idea here is to Parameters baseRow:ExecRow a base table row. baseRowLoc:RowLocation baseRowLoc baseRow's location Exceptions StandardException: Thrown on error

setOurUpdatedIndexRow

back to summary

private void setOurUpdatedIndexRow(ExecRow baseRow, RowLocation baseRowLoc) throws StandardException

Set the column values for 'ourUpdatedIndexRow' to refer to a base table row and location provided by the caller. The idea here is to

Parameters

baseRow:ExecRow: a base table row.
baseRowLoc:RowLocation: baseRowLoc baseRow's location

Exceptions

StandardException:: Thrown on error

setRowHolder	back to summary
pack-priv void setRowHolder(TemporaryRowHolderImpl rowHolder) Set the row holder for this changer to use. If the row holder is set, it wont bother saving copies of rows needed for deferred processing. Also, it will never close the passed in rowHolder. Parameters rowHolder:TemporaryRowHolderImpl the row holder

setRowHolder

back to summary

pack-priv void setRowHolder(TemporaryRowHolderImpl rowHolder)

Set the row holder for this changer to use. If the row holder is set, it wont bother saving copies of rows needed for deferred processing. Also, it will never close the passed in rowHolder.

Parameters

rowHolder:TemporaryRowHolderImpl: the row holder

setScan	back to summary
private void setScan() throws StandardException Position our index scan to 'ourIndexRow'. This creates the scan the first time it is called. Exceptions StandardException: Thrown on error

setScan

back to summary

private void setScan() throws StandardException

Position our index scan to 'ourIndexRow'.

This creates the scan the first time it is called.

Exceptions

StandardException:: Thrown on error

update	back to summary
pack-priv void update(ExecRow oldBaseRow, ExecRow newBaseRow, RowLocation baseRowLocation) throws StandardException Perform index maintenance to support an update of a base table row. Parameters oldBaseRow:ExecRow the old image of the base table row. newBaseRow:ExecRow the new image of the base table row. baseRowLocation:RowLocation the base table row's location. Exceptions StandardException: Thrown on error

update

back to summary

pack-priv void update(ExecRow oldBaseRow, ExecRow newBaseRow, RowLocation baseRowLocation) throws StandardException

Perform index maintenance to support an update of a base table row.

Parameters

oldBaseRow:ExecRow: the old image of the base table row.
newBaseRow:ExecRow: the new image of the base table row.
baseRowLocation:RowLocation: the base table row's location.

Exceptions

StandardException:: Thrown on error

pack-priv Class IndexChanger

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail