org.hsqldb

Class TableDerived

java.lang.Object

org.hsqldb.TableBase

org.hsqldb.Table

org.hsqldb.TableDerived

All Implemented Interfaces:

SchemaObject

Direct Known Subclasses:

View

public class TableDerived
extends Table

Table with data derived from a query expression.

Since:

1.9.0

Nested Class Summary

Nested classes/interfaces inherited from interface org.hsqldb.SchemaObject

SchemaObject.ConstraintTypes, SchemaObject.Deferable, SchemaObject.Nullability, SchemaObject.ParameterModes, SchemaObject.ReferentialAction, SchemaObject.ViewCheckModes

Field Summary

Fields

Modifier and Type	Field and Description
static TableDerived[]	emptyArray

Fields inherited from class org.hsqldb.Table

columnList

Fields inherited from class org.hsqldb.TableBase

CACHED_TABLE, CHANGE_SET_TABLE, database, FUNCTION_TABLE, INFO_SCHEMA_TABLE, isSessionBased, MEMORY_TABLE, persistenceId, persistenceScope, RESULT_TABLE, SCOPE_FULL, SCOPE_ROUTINE, SCOPE_SESSION, SCOPE_STATEMENT, SCOPE_TRANSACTION, store, SYSTEM_SUBQUERY, SYSTEM_TABLE, TEMP_TABLE, TEMP_TEXT_TABLE, TEXT_TABLE, TRANSITION_TABLE, VIEW_TABLE

Fields inherited from interface org.hsqldb.SchemaObject

ASSERTION, CATALOG, CHARSET, COLLATION, COLUMN, CONSTRAINT, CURSOR, DOMAIN, FUNCTION, GRANTEE, INDEX, LABEL, PARAMETER, PROCEDURE, ROUTINE, SCHEMA, SEARCH, SEQUENCE, SERVER, SPECIFIC_ROUTINE, SUBQUERY, TABLE, TRANSITION, TRIGGER, TYPE, VARIABLE, VIEW, WRAPPER

Constructor Summary

Constructors

Constructor and Description
TableDerived(Database database, HsqlNameManager.HsqlName name, int type)
TableDerived(Database database, HsqlNameManager.HsqlName name, int type, QueryExpression queryExpression, Expression dataExpression, int opType, int depth)
TableDerived(Database database, HsqlNameManager.HsqlName name, int type, Type[] columnTypes, HashMappedList columnList, int[] pkColumns)

Method Summary

Modifier and Type	Method and Description
Table	getBaseTable()
int[]	getBaseTableColumnMap()
Expression	getDataExpression()
int	getId() Used to create row id's
RowSetNavigatorData	getNavigator(Session session)
QueryExpression	getQueryExpression()
int[]	getUpdatableColumns()
java.lang.Object	getValue(Session session)
java.lang.Object[]	getValues(Session session)
boolean	isInsertable()
boolean	isQueryBased()
boolean	isRecompiled()
boolean	isTriggerDeletable()
boolean	isTriggerInsertable()
boolean	isTriggerUpdatable()
boolean	isUpdatable()
boolean	isWritable()
void	materialise(Session session)
void	materialiseCorrelated(Session session)
TableDerived	newDerivedTable(Session session)
void	prepareTable()
void	prepareTable(HsqlNameManager.HsqlName[] columns)
void	setSQL(java.lang.String sql)

Methods inherited from class org.hsqldb.Table

addColumn, addColumnNoCheck, addConstraint, checkDataReadOnly, clearAllData, clearAllData, compareRows, compile, createPrimaryKey, createPrimaryKey, createPrimaryKeyConstraint, enforceRowConstraints, enforceTypeLimits, findColumn, getBestRowIdentifiers, getCatalogName, getChangeTimestamp, getClusteredIndex, getColumn, getColumnIndex, getColumnListSQL, getColumnListWithTypeSQL, getColumnNames, getColumnNameSet, getColumnNameSet, getColumnNameSet, getComponents, getConstraint, getConstraints, getDefaultRanges, getDeleteRowFromLog, getDependentExternalConstraints, getFKConstraints, getIndexRootsArray, getIndexRootsSQL, getName, getNextIdentity, getOwner, getPrimaryConstraint, getReferences, getReferencesForDependents, getRowStore, getSchemaName, getSQL, getSQLForClustered, getSQLForReadOnly, getSQLForTableSpace, getSQLForTextSource, getTriggerIndex, getTriggers, getTriggerSQL, getType, getUniqueConstraintForIndex, getUniqueOrPKConstraintForIndex, getUniquePKConstraintNames, hasGeneratedColumn, hasIdentityColumn, hasLobColumn, insertData, insertFromScript, insertNoCheckFromLog, insertSys, insertSys, isBestRowIdentifiersStrict, isCached, isConnected, isDataReadOnly, isDropped, isFileBased, isReadOnly, isSchemaBaseTable, isTemp, isText, isView, isWithDataSource, rowIteratorClustered, rowIteratorClustered, setDataReadOnly, setGeneratedColumns, setIndexRoots, setName, systemSetIdentityColumn

Methods inherited from class org.hsqldb.TableBase

createAndAddIndexStructure, createIndex, createPrimaryIndex, dropIndex, duplicate, getColumnCount, getColumnNotNull, getColumnTypes, getDataColumnCount, getEmptyRowData, getFullIndex, getIndex, getIndexCount, getIndexList, getNewColumnCheckList, getPersistenceId, getPrimaryIndex, getPrimaryKey, getPrimaryKeyTypes, getSpaceID, getTableType, hasPrimaryKey, isEmpty, isTransactional, onCommitPreserve, rowIterator, rowIterator, setBestRowIdentifiers, setIndexes, setSpaceID, setTransactional

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

emptyArray

public static final TableDerived[] emptyArray

Constructor Detail

TableDerived

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

TableDerived

public TableDerived(Database database,
                    HsqlNameManager.HsqlName name,
                    int type,
                    Type[] columnTypes,
                    HashMappedList columnList,
                    int[] pkColumns)

TableDerived

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

Method Detail

newDerivedTable

public TableDerived newDerivedTable(Session session)

getId

public int getId()

Description copied from class: Table

Used to create row id's

Overrides:

getId in class Table

isQueryBased

public boolean isQueryBased()

Overrides:

isQueryBased in class Table

isWritable

public boolean isWritable()

Overrides:

isWritable in class Table

isInsertable

public boolean isInsertable()

Overrides:

isInsertable in class Table

isUpdatable

public boolean isUpdatable()

Overrides:

isUpdatable in class Table

getUpdatableColumns

public int[] getUpdatableColumns()

Overrides:

getUpdatableColumns in class Table

isTriggerInsertable

public boolean isTriggerInsertable()

Overrides:

isTriggerInsertable in class Table

isTriggerUpdatable

public boolean isTriggerUpdatable()

Overrides:

isTriggerUpdatable in class Table

isTriggerDeletable

public boolean isTriggerDeletable()

Overrides:

isTriggerDeletable in class Table

getBaseTable

public Table getBaseTable()

Overrides:

getBaseTable in class Table

getBaseTableColumnMap

public int[] getBaseTableColumnMap()

Overrides:

getBaseTableColumnMap in class Table

getQueryExpression

public QueryExpression getQueryExpression()

Overrides:

getQueryExpression in class Table

getDataExpression

public Expression getDataExpression()

Overrides:

getDataExpression in class Table

prepareTable

public void prepareTable()

Overrides:

prepareTable in class Table

prepareTable

public void prepareTable(HsqlNameManager.HsqlName[] columns)

materialise

public void materialise(Session session)

Overrides:

materialise in class Table

materialiseCorrelated

public void materialiseCorrelated(Session session)

Overrides:

materialiseCorrelated in class Table

isRecompiled

public boolean isRecompiled()

getValues

public java.lang.Object[] getValues(Session session)

getValue

public java.lang.Object getValue(Session session)

getNavigator

public RowSetNavigatorData getNavigator(Session session)

setSQL

public void setSQL(java.lang.String sql)