HyperSQL Database 2.7.4 · org.hsqldb.TableBase · APIdia, the JavaDoc alternative

Field Summary

Modifier and Type	Field and Description
pack-priv Index	bestIndex
pack-priv int[]	bestIndexForColumn
pack-priv int[]	bestRowIdentifierCols
pack-priv boolean	bestRowIdentifierStrict
public static final int	CACHED_TABLE
public static final int	CHANGE_SET_TABLE
pack-priv boolean[]	colNotNull
pack-priv Type[]	colTypes
protected int	columnCount
public Database	database
pack-priv boolean[]	emptyColumnCheckList
pack-priv Index	fullIndex
public static final int	FUNCTION_TABLE
pack-priv boolean	hasLobColumn
pack-priv Index[]	indexList
public static final int	INFO_SCHEMA_TABLE
protected boolean	isCached
protected boolean	isLogged
protected boolean	isReadOnly
protected boolean	isSchemaBased
public boolean	isSessionBased
public boolean	isSystemVersioned
protected boolean	isTemp
protected boolean	isText
pack-priv boolean	isView
protected boolean	isWithDataSource
public static final int	MEMORY_TABLE
public static final int	MODULE_TABLE
public long	persistenceId
public int	persistenceScope
public static final int	RESULT_TABLE
public static final int	SCOPE_FULL
public static final int	SCOPE_ROUTINE
public static final int	SCOPE_SESSION
public static final int	SCOPE_STATEMENT
public static final int	SCOPE_TRANSACTION
public PersistentStore	store
public static final int	SYSTEM_SUBQUERY
public static final int	SYSTEM_TABLE
pack-priv int	tableSpace
pack-priv int	tableType
public static final int	TEMP_TABLE
public static final int	TEMP_TEXT_TABLE
public static final int	TEXT_TABLE
public static final int	TRANSITION_TABLE
public static final int	VIEW_TABLE

Constructor Summary

Access	Constructor and Description
pack-priv	TableBase()

Method Summary

Modifier and Type	Method and Description
pack-priv final void	addIndex(Session session, Index index)
pack-priv final void	addIndexStructure(Index index)
public final Index	createAndAddIndexStructure(Session session, HsqlNameManager.HsqlName name, int[] columns, boolean[] descending, boolean[] nullsLast, boolean unique, boolean constraint, boolean forward)
public final Index	createIndex(Session session, HsqlNameManager.HsqlName name, int[] columns, boolean[] descending, boolean[] nullsLast, boolean unique, boolean constraint, boolean forward) Create new memory-resident index.
public final Index	createIndexStructure(HsqlNameManager.HsqlName name, int[] columns, boolean[] descending, boolean[] nullsLast, boolean primaryKey, boolean unique, boolean constraint, boolean forward)
public final void	createPrimaryIndex(int[] pkcols, Type[] pktypes, HsqlNameManager.HsqlName name)
public void	dropIndex(Session session, int todrop) Performs Table structure modification and changes to the index nodes to remove a given index from a MEMORY or TEXT table.
public TableBase	duplicate()
public int	getColumnCount() Returns the count of all visible columns.
public boolean[]	getColumnNotNull()
public final Type[]	getColumnTypes() Returns an array of Type indicating the SQL type of the columns
public final int	getDataColumnCount() Returns the count of all columns.
public Index	getDefaultIndex()
public final boolean[]	getEmptyColumnCheckList()
public final Object[]	getEmptyRowData()
pack-priv long	getId()
public final Index	getIndex(int i) Returns the Index object at the given index
public final int	getIndexCount()
public final Index[]	getIndexList() Returns the indexes
public final boolean[]	getNewColumnCheckList() Returns empty boolean array.
pack-priv static Index[]	getNewIndexArray(Index index, Index[] list)
pack-priv Index	getNewPrimaryIndex(int[] pkcols, Type[] pktypes, HsqlNameManager.HsqlName name)
public long	getPersistenceId()
public final Index	getPrimaryIndex()
public final int[]	getPrimaryKey()
public final Type[]	getPrimaryKeyTypes()
public PersistentStore	getRowStore(Session session)
public int	getSpaceID()
public final int	getTableType()
public final boolean	hasPrimaryKey()
public final boolean	isEmpty(Session session) Returns true if the table has any rows at all.
public boolean	isSystemVersioned()
public final boolean	onCommitPreserve()
private void	resetAccessorKeys(Session session, Index[] indexes)
public final RowIterator	rowIterator(Session session)
public final RowIterator	rowIterator(PersistentStore store)
public final void	setBestRowIdentifiers() This method is called whenever there is a change to table structure and serves two purposes: (a) to reset the best set of columns that identify the rows of the table (b) to reset the best index that can be used to find rows of the table given a column value.
public final void	setIndexes(Index[] indexes)
public void	setSpaceID(int id)
public final void	setTableType(int type) limited type change to info_schema_table

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

Field Detail

bestIndex	back to summary
pack-priv Index bestIndex

bestIndexForColumn	back to summary
pack-priv int[] bestIndexForColumn

bestRowIdentifierCols	back to summary
pack-priv int[] bestRowIdentifierCols

bestRowIdentifierStrict	back to summary
pack-priv boolean bestRowIdentifierStrict

CACHED_TABLE	back to summary
public static final int CACHED_TABLE

CHANGE_SET_TABLE	back to summary
public static final int CHANGE_SET_TABLE

colNotNull	back to summary
pack-priv boolean[] colNotNull

colTypes	back to summary
pack-priv Type[] colTypes

columnCount	back to summary
protected int columnCount

database	back to summary
public Database database

emptyColumnCheckList	back to summary
pack-priv boolean[] emptyColumnCheckList

fullIndex	back to summary
pack-priv Index fullIndex

FUNCTION_TABLE	back to summary
public static final int FUNCTION_TABLE

hasLobColumn	back to summary
pack-priv boolean hasLobColumn

indexList	back to summary
pack-priv Index[] indexList

INFO_SCHEMA_TABLE	back to summary
public static final int INFO_SCHEMA_TABLE

isCached	back to summary
protected boolean isCached

isLogged	back to summary
protected boolean isLogged

isReadOnly	back to summary
protected boolean isReadOnly

isSchemaBased	back to summary
protected boolean isSchemaBased

isSessionBased	back to summary
public boolean isSessionBased

isSystemVersioned	back to summary
public boolean isSystemVersioned

isTemp	back to summary
protected boolean isTemp

isText	back to summary
protected boolean isText

isView	back to summary
pack-priv boolean isView

isWithDataSource	back to summary
protected boolean isWithDataSource

MEMORY_TABLE	back to summary
public static final int MEMORY_TABLE

MODULE_TABLE	back to summary
public static final int MODULE_TABLE

persistenceId	back to summary
public long persistenceId

persistenceScope	back to summary
public int persistenceScope

RESULT_TABLE	back to summary
public static final int RESULT_TABLE

SCOPE_FULL	back to summary
public static final int SCOPE_FULL

SCOPE_ROUTINE	back to summary
public static final int SCOPE_ROUTINE

SCOPE_SESSION	back to summary
public static final int SCOPE_SESSION

SCOPE_STATEMENT	back to summary
public static final int SCOPE_STATEMENT

SCOPE_TRANSACTION	back to summary
public static final int SCOPE_TRANSACTION

store	back to summary
public PersistentStore store

SYSTEM_SUBQUERY	back to summary
public static final int SYSTEM_SUBQUERY

SYSTEM_TABLE	back to summary
public static final int SYSTEM_TABLE

tableSpace	back to summary
pack-priv int tableSpace

tableType	back to summary
pack-priv int tableType

TEMP_TABLE	back to summary
public static final int TEMP_TABLE

TEMP_TEXT_TABLE	back to summary
public static final int TEMP_TEXT_TABLE

TEXT_TABLE	back to summary
public static final int TEXT_TABLE

TRANSITION_TABLE	back to summary
public static final int TRANSITION_TABLE

VIEW_TABLE	back to summary
public static final int VIEW_TABLE

Constructor Detail

TableBase	back to summary
pack-priv TableBase()

Method Detail

addIndex	back to summary
pack-priv final void addIndex(Session session, Index index)

addIndexStructure	back to summary
pack-priv final void addIndexStructure(Index index)

createAndAddIndexStructure	back to summary
public final Index createAndAddIndexStructure(Session session, HsqlNameManager.HsqlName name, int[] columns, boolean[] descending, boolean[] nullsLast, boolean unique, boolean constraint, boolean forward)

createIndex	back to summary
public final Index createIndex(Session session, HsqlNameManager.HsqlName name, int[] columns, boolean[] descending, boolean[] nullsLast, boolean unique, boolean constraint, boolean forward) Create new memory-resident index. For MEMORY and TEXT tables.

createIndexStructure	back to summary
public final Index createIndexStructure(HsqlNameManager.HsqlName name, int[] columns, boolean[] descending, boolean[] nullsLast, boolean primaryKey, boolean unique, boolean constraint, boolean forward)

createPrimaryIndex	back to summary
public final void createPrimaryIndex(int[] pkcols, Type[] pktypes, HsqlNameManager.HsqlName name)

dropIndex	back to summary
public void dropIndex(Session session, int todrop) Performs Table structure modification and changes to the index nodes to remove a given index from a MEMORY or TEXT table. Not for PK index.

duplicate	back to summary
public TableBase duplicate()

getColumnCount	back to summary
public int getColumnCount() Returns the count of all visible columns.

getColumnNotNull	back to summary
public boolean[] getColumnNotNull()

getColumnTypes	back to summary
public final Type[] getColumnTypes() Returns an array of Type indicating the SQL type of the columns

getDataColumnCount	back to summary
public final int getDataColumnCount() Returns the count of all columns.

getDefaultIndex	back to summary
public Index getDefaultIndex()

getEmptyColumnCheckList	back to summary
public final boolean[] getEmptyColumnCheckList()

getEmptyRowData	back to summary
public final Object[] getEmptyRowData()

getId	back to summary
pack-priv long getId()

getIndex	back to summary
public final Index getIndex(int i) Returns the Index object at the given index

getIndexCount	back to summary
public final int getIndexCount()

getIndexList	back to summary
public final Index[] getIndexList() Returns the indexes

getNewColumnCheckList	back to summary
public final boolean[] getNewColumnCheckList() Returns empty boolean array.

getNewIndexArray	back to summary
pack-priv static Index[] getNewIndexArray(Index index, Index[] list)

getNewPrimaryIndex	back to summary
pack-priv Index getNewPrimaryIndex(int[] pkcols, Type[] pktypes, HsqlNameManager.HsqlName name)

getPersistenceId	back to summary
public long getPersistenceId()

getPrimaryIndex	back to summary
public final Index getPrimaryIndex()

getPrimaryKey	back to summary
public final int[] getPrimaryKey()

getPrimaryKeyTypes	back to summary
public final Type[] getPrimaryKeyTypes()

getRowStore	back to summary
public PersistentStore getRowStore(Session session)

getSpaceID	back to summary
public int getSpaceID()

getTableType	back to summary
public final int getTableType()

hasPrimaryKey	back to summary
public final boolean hasPrimaryKey()

isEmpty	back to summary
public final boolean isEmpty(Session session) Returns true if the table has any rows at all.

isSystemVersioned	back to summary
public boolean isSystemVersioned()

onCommitPreserve	back to summary
public final boolean onCommitPreserve()

resetAccessorKeys	back to summary
private void resetAccessorKeys(Session session, Index[] indexes)

rowIterator	back to summary
public final RowIterator rowIterator(Session session)

rowIterator	back to summary
public final RowIterator rowIterator(PersistentStore store)

setBestRowIdentifiers

back to summary

public final void setBestRowIdentifiers()

This method is called whenever there is a change to table structure and serves two purposes: (a) to reset the best set of columns that identify the rows of the table (b) to reset the best index that can be used to find rows of the table given a column value. (a) gives most weight to a primary key index, followed by a unique address with the lowest count of nullable columns. Otherwise there is no best row identifier. (b) finds for each column an index with a corresponding first column. It uses any type of visible index and accepts the one with the largest column count. bestIndex is the user defined, primary key, the first unique index, or the first non-unique index. NULL if there is no user-defined index.

setIndexes	back to summary
public final void setIndexes(Index[] indexes)

setSpaceID	back to summary
public void setSpaceID(int id)