Top Description Fields Constructors Methods
org.hsqldb

public Class TableDerived

extends Table
Class Inheritance
Known Direct Subclasses
org.hsqldb.View
Imports
org.hsqldb.HsqlNameManager.HsqlName, .ParserDQL.CompileContext, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.ArrayUtil, .OrderedHashMap, org.hsqldb.navigator.RowIterator, .RowSetNavigatorData, .RowSetNavigatorDataTable, org.hsqldb.persist.PersistentStore, org.hsqldb.result.Result, org.hsqldb.types.Type

Table with data derived from a query expression.
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.7.4

Field Summary

Modifier and TypeField and Description
pack-priv boolean
pack-priv Expression
pack-priv int
public static final TableDerived[]
pack-priv QueryExpression
pack-priv String
pack-priv boolean
pack-priv boolean
pack-priv View
Inherited from org.hsqldb.Table:
applicationPeriodcascadingDeleteschangeTimestampcheckConstraintscolDefaultscolGeneratedcolMainFKcolRefFKcolumnListcolUpdatedconstraintListdefaultColumnMapfkConstraintsfkMainConstraintsidentityColumnidentitySequenceisDroppedreferentialActionssystemPeriodsystemPeriodEndColumnsystemPeriodStartColumntableNametriggerListtriggerLists

Constructor Summary

AccessConstructor and Description
public
TableDerived(Database database, HsqlNameManager.HsqlName name, int type)

public
TableDerived(Database database, HsqlNameManager.HsqlName name, int type, HsqlNameManager.HsqlName[] colNames, Type[] colTypes)

For named sunbqueries.

public
TableDerived(Database database, HsqlNameManager.HsqlName name, int type, Type[] columnTypes, OrderedHashMap<String, ColumnSchema> columnList, int[] pkColumns)

public
TableDerived(Database database, HsqlNameManager.HsqlName name, int type, QueryExpression queryExpression, Expression dataExpression, int opType, int depth)

Method Summary

Modifier and TypeMethod and Description
public Table
public int[]
public Expression
public long
getId()

Overrides org.hsqldb.Table.getId.

Used to create row id's

public RowSetNavigatorData
public QueryExpression
public int[]
public Object
getValue(Session session)

public Object[]
getValues(Session session)

pack-priv boolean
pack-priv boolean
public boolean
public boolean
public boolean
public boolean
public boolean
public boolean
public boolean
public boolean
public void
public void
public TableDerived
public void
public void
pack-priv void
pack-priv void
public void
private void
Inherited from org.hsqldb.Table:
addColumnaddColumnNoCheckaddConstraintaddTriggerareColumnsNotNullcheckColumnInCheckConstraintcheckColumnInFKConstraintcheckColumnInFKConstraintcheckDataReadOnlycheckReferentialColumnsMatchcollectFKReadLockscollectFKWriteLockscompareRowscompilecreateIndexForColumnscreatePrimaryKeycreatePrimaryKeycreatePrimaryKeyConstraintenforceRowConstraintsenforceTypeLimitsfindColumnfindColumnIndexesfindIndexForColumnsfireTriggersfireTriggersfireTriggersgenerateAndCheckDatagenerateDefaultForNullgetApplicationPeriodgetBestRowIdentifiersgetCatalogNamegetChangeTimestampgetClusteredIndexgetColumngetColumnCheckListgetColumnDefaultOrGeneratedValuegetColumnIndexgetColumnIndexesgetColumnLabelsgetColumnListSQLgetColumnListWithTypeSQLgetColumnMapgetColumnNamesgetColumnNameSetgetComponentsgetConstraintgetConstraintIndexgetConstraintsgetContainingConstraintsgetContainingIndexNamesgetDefaultRangesgetDeleteRowFromLoggetDependentConstraintsgetDependentConstraintsgetDependentExternalConstraintsgetFKConstraintForColumnsgetFKConstraintsgetFullIndexgetFullIndexForColumnsgetIdentityColumnIndexgetIndexgetIndexForAllColumnsgetIndexForColumngetIndexForColumnsgetIndexForColumnsgetIndexIndexgetIndexRootsArraygetIndexRootsSQLgetNamegetNewColumnMapgetNewRowDatagetNextConstraintIndexgetNotNullConstraintForColumngetOwnergetPrimaryConstraintgetReferencesgetReferencesForDependentsgetReferencesForScriptgetRowStoregetSchemaNamegetSQLgetSQLgetSQLForClusteredgetSQLForReadOnlygetSQLForTableSpacegetSQLForTextSourcegetSystemIndexgetSystemPeriodgetSystemPeriodEndIndexgetSystemPeriodStartIndexgetTableTypeStringgetTriggergetTriggerIndexgetTriggersgetTriggerSQLArraygetTypegetUniqueConstraintForColumnsgetUniqueConstraintForIndexgetUniqueNotNullColumnGroupgetUniqueOrPKConstraintForIndexgetUniquePKConstraintNamesgetUserIndexhasGeneratedColumnhasIdentityColumnhasLobColumnhasTriggerhasUpdatedColumnindexTypeForColumninsertDatainsertFromScriptinsertIntoTableinsertNoCheckFromLoginsertResultinsertSingleRowinsertSysinsertSysinsertSystemVersionHistoryRowisBestRowIdentifiersStrictisCachedisConnectedisDataReadOnlyisDroppedisFileBasedisIndexedisIndexingMutableisReadOnlyisSchemaBaseTableisTempisTextisViewisWithDataSourcemoveDefinitionreleaseTriggersremoveConstraintremoveConstraintremoveTriggerrenameColumnrenameColumnresetDefaultFlagsrowIteratorClusteredrowIteratorForScriptsetColumnStructuressetColumnTypeVarssetDataReadOnlysetForwardConstraintssetGeneratedColumnssetIdentityColumnsetIndexRootssetIndexRootssetNamesetUpdatedColumnssystemSetIdentityColumnsystemUpdateIdentityValueterminateTriggersupdateConstraintListsverifyConstraintsIntegrity

Field Detail

canRecompileback to summary
pack-priv boolean canRecompile
dataExpressionback to summary
pack-priv Expression dataExpression
depthback to summary
pack-priv int depth
emptyArrayback to summary
public static final TableDerived[] emptyArray

Hides org.hsqldb.Table.emptyArray, org.hsqldb.SchemaObject.emptyArray.

queryExpressionback to summary
pack-priv QueryExpression queryExpression
sqlback to summary
pack-priv String sql
uniquePredicateback to summary
pack-priv boolean uniquePredicate
uniqueRowsback to summary
pack-priv boolean uniqueRows
viewback to summary
pack-priv View view

Constructor Detail

TableDerivedback to summary
public TableDerived(Database database, HsqlNameManager.HsqlName name, int type)
TableDerivedback to summary
public TableDerived(Database database, HsqlNameManager.HsqlName name, int type, HsqlNameManager.HsqlName[] colNames, Type[] colTypes)

For named sunbqueries.

TableDerivedback to summary
public TableDerived(Database database, HsqlNameManager.HsqlName name, int type, Type[] columnTypes, OrderedHashMap<String, ColumnSchema> columnList, int[] pkColumns)
TableDerivedback to summary
public TableDerived(Database database, HsqlNameManager.HsqlName name, int type, QueryExpression queryExpression, Expression dataExpression, int opType, int depth)

Method Detail

getBaseTableback to summary
public Table getBaseTable()

Overrides org.hsqldb.Table.getBaseTable.

getBaseTableColumnMapback to summary
public int[] getBaseTableColumnMap()

Overrides org.hsqldb.Table.getBaseTableColumnMap.

getDataExpressionback to summary
public Expression getDataExpression()

Overrides org.hsqldb.Table.getDataExpression.

getIdback to summary
public long getId()

Overrides org.hsqldb.Table.getId.

Doc from org.hsqldb.Table.getId.

Used to create row id's

getNavigatorback to summary
public RowSetNavigatorData getNavigator(Session session)
getQueryExpressionback to summary
public QueryExpression getQueryExpression()

Overrides org.hsqldb.Table.getQueryExpression.

getUpdatableColumnsback to summary
public int[] getUpdatableColumns()

Overrides org.hsqldb.Table.getUpdatableColumns.

getValueback to summary
public Object getValue(Session session)
getValuesback to summary
public Object[] getValues(Session session)
hasUniqueNotNullRowsback to summary
pack-priv boolean hasUniqueNotNullRows(Session session)
isCorrelatedback to summary
pack-priv boolean isCorrelated()
isInsertableback to summary
public boolean isInsertable()

Overrides org.hsqldb.Table.isInsertable.

isQueryBasedback to summary
public boolean isQueryBased()

Overrides org.hsqldb.Table.isQueryBased.

isRecompiledback to summary
public boolean isRecompiled()
isTriggerDeletableback to summary
public boolean isTriggerDeletable()

Overrides org.hsqldb.Table.isTriggerDeletable.

isTriggerInsertableback to summary
public boolean isTriggerInsertable()

Overrides org.hsqldb.Table.isTriggerInsertable.

isTriggerUpdatableback to summary
public boolean isTriggerUpdatable()

Overrides org.hsqldb.Table.isTriggerUpdatable.

isUpdatableback to summary
public boolean isUpdatable()

Overrides org.hsqldb.Table.isUpdatable.

isWritableback to summary
public boolean isWritable()

Overrides org.hsqldb.Table.isWritable.

materialiseback to summary
public void materialise(Session session)

Overrides org.hsqldb.Table.materialise.

materialiseCorrelatedback to summary
public void materialiseCorrelated(Session session)

Overrides org.hsqldb.Table.materialiseCorrelated.

newDerivedTableback to summary
public TableDerived newDerivedTable(Session session, ParserDQL.CompileContext baseContext)
prepareTableback to summary
public void prepareTable(Session session)

Overrides org.hsqldb.Table.prepareTable.

prepareTableback to summary
public void prepareTable(Session session, HsqlNameManager.HsqlName[] columns)
resetToViewback to summary
pack-priv void resetToView()
setCorrelatedback to summary
pack-priv void setCorrelated()
setSQLback to summary
public void setSQL(String sql)
setTableIndexesForSubqueryback to summary
private void setTableIndexesForSubquery(Session session)