Package | Description |
---|---|
org.h2.command.ddl |
Contains DDL (data definition language) and related SQL statements.
|
org.h2.command.dml |
Contains DML (data manipulation language) and related SQL statements.
|
org.h2.constraint |
Database constraints such as check constraints, unique constraints, and referential constraints.
|
org.h2.engine |
Contains high level classes of the database and classes that don't fit in another sub-package.
|
org.h2.expression |
Expressions include mathematical operations, conditions, simple values, and functions.
|
org.h2.index |
Various table index implementations, as well as cursors to navigate in an index.
|
org.h2.mvstore.db |
Helper classes to use the MVStore in the H2 database.
|
org.h2.result |
Implementation of row and internal result sets.
|
org.h2.table |
Classes related to a table and table meta data.
|
Modifier and Type | Field and Description |
---|---|
ArrayList<Column> |
CreateTableData.columns
The column list.
|
Modifier and Type | Method and Description |
---|---|
void |
CreateTable.addColumn(Column column) |
abstract void |
CommandWithColumns.addColumn(Column column)
Add a column to this table.
|
void |
AlterTableAlterColumn.addColumn(Column column) |
void |
CreateUserDataType.setColumn(Column column) |
void |
AlterTableAlterColumn.setNewColumn(Column newColumn) |
void |
AlterTableAlterColumn.setOldColumn(Column oldColumn) |
Modifier and Type | Method and Description |
---|---|
protected void |
CommandWithColumns.changePrimaryKeysToNotNull(ArrayList<Column> columns)
For the given list of columns, disable "nullable" for those columns that
are primary key columns.
|
protected ArrayList<Sequence> |
CommandWithColumns.generateSequences(ArrayList<Column> columns,
boolean temporary)
For the given list of columns, create sequences for auto-increment
columns (if needed), and then get the list of all sequences of the
columns.
|
void |
AlterTableAlterColumn.setColumnsToRemove(ArrayList<Column> columnsToRemove) |
Modifier and Type | Method and Description |
---|---|
Column[] |
SelectListColumnResolver.getColumns() |
Column |
SelectListColumnResolver.getRowIdColumn() |
Column[] |
SelectListColumnResolver.getSystemColumns() |
Modifier and Type | Method and Description |
---|---|
void |
Insert.addAssignmentForDuplicate(Column column,
Expression expression)
Keep a collection of the columns to pass to update if a duplicate key
happens, for MySQL-style INSERT ...
|
String |
SelectListColumnResolver.getDerivedColumnName(Column column) |
Value |
SelectListColumnResolver.getValue(Column column) |
Expression |
SelectListColumnResolver.optimize(ExpressionColumn expressionColumn,
Column column) |
void |
Update.setAssignment(Column column,
Expression expression)
Add an assignment of the form column = expression.
|
void |
AlterSequence.setColumn(Column column) |
void |
Replace.setColumns(Column[] columns) |
void |
Merge.setColumns(Column[] columns) |
void |
Insert.setColumns(Column[] columns) |
void |
Replace.setKeys(Column[] keys) |
void |
Merge.setKeys(Column[] keys) |
Modifier and Type | Method and Description |
---|---|
HashSet<Column> |
ConstraintUnique.getReferencedColumns(Table table) |
HashSet<Column> |
ConstraintReferential.getReferencedColumns(Table table) |
HashSet<Column> |
ConstraintCheck.getReferencedColumns(Table table) |
abstract HashSet<Column> |
Constraint.getReferencedColumns(Table table)
Get all referenced columns.
|
Modifier and Type | Method and Description |
---|---|
Column |
UserDataType.getColumn() |
Modifier and Type | Method and Description |
---|---|
void |
GeneratedKeys.add(Column column)
Remembers columns with generated keys.
|
void |
UserDataType.setColumn(Column column) |
Modifier and Type | Method and Description |
---|---|
Column |
ExpressionColumn.getColumn() |
Modifier and Type | Method and Description |
---|---|
static HashSet<Column> |
ExpressionVisitor.allColumnsForTableFilters(TableFilter[] filters)
Get the set of columns of all tables.
|
Modifier and Type | Method and Description |
---|---|
void |
Parameter.setColumn(Column column) |
void |
Function.setDataType(Column col) |
Modifier and Type | Method and Description |
---|---|
static ExpressionVisitor |
ExpressionVisitor.getColumnsVisitor(HashSet<Column> columns)
Create a new visitor to get all referenced columns.
|
void |
TableFunction.setColumns(ArrayList<Column> columns) |
Constructor and Description |
---|
ExpressionColumn(Database database,
Column column) |
Modifier and Type | Field and Description |
---|---|
protected Column[] |
BaseIndex.columns |
Modifier and Type | Method and Description |
---|---|
Column |
IndexCondition.getColumn()
Get the referenced column.
|
Column[] |
MultiVersionIndex.getColumns() |
Column[] |
Index.getColumns()
Get the indexed columns.
|
Column[] |
BaseIndex.getColumns() |
Modifier and Type | Method and Description |
---|---|
int |
PageDelegateIndex.getColumnIndex(Column col) |
int |
PageDataIndex.getColumnIndex(Column col) |
int |
MultiVersionIndex.getColumnIndex(Column col) |
int |
MetaIndex.getColumnIndex(Column col) |
int |
Index.getColumnIndex(Column col)
Get the index of a column in the list of index columns
|
int |
BaseIndex.getColumnIndex(Column col) |
int |
ScanIndex.getColumnIndex(Column col) |
static long |
SpatialTreeIndex.getCostRangeIndex(int[] masks,
Column[] columns)
Compute spatial index cost
|
boolean |
PageDelegateIndex.isFirstColumn(Column column) |
boolean |
PageDataIndex.isFirstColumn(Column column) |
boolean |
MultiVersionIndex.isFirstColumn(Column column) |
boolean |
MetaIndex.isFirstColumn(Column column) |
boolean |
Index.isFirstColumn(Column column)
Check if the given column is the first for this index
|
boolean |
BaseIndex.isFirstColumn(Column column) |
boolean |
ScanIndex.isFirstColumn(Column column) |
Modifier and Type | Method and Description |
---|---|
double |
PageDelegateIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
PageDataIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
PageBtreeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
NonUniqueHashIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MultiVersionIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MetaIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
LinkedIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
Index.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet)
Estimate the cost to search for rows given the search mask.
|
double |
HashIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
FunctionIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
ViewIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
TreeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
SpatialTreeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
ScanIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
RangeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
protected long |
BaseIndex.getCostRangeIndex(int[] masks,
long rowCount,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
boolean isScanIndex,
HashSet<Column> allColumnsSet)
Calculate the cost for the given mask as if this index was a typical
b-tree range index.
|
Modifier and Type | Method and Description |
---|---|
Column |
MVTable.getRowIdColumn() |
Modifier and Type | Method and Description |
---|---|
int |
MVPrimaryIndex.getColumnIndex(Column col) |
int |
MVDelegateIndex.getColumnIndex(Column col) |
boolean |
MVPrimaryIndex.isFirstColumn(Column column) |
boolean |
MVDelegateIndex.isFirstColumn(Column column) |
Modifier and Type | Method and Description |
---|---|
double |
MVSpatialIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MVSecondaryIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MVPrimaryIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MVDelegateIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
Modifier and Type | Method and Description |
---|---|
Column |
SortOrder.getColumn(int index,
TableFilter filter)
Get the column for the given table filter, if the sort column is for this
filter.
|
Modifier and Type | Field and Description |
---|---|
Column |
IndexColumn.column
The column, or null if not set.
|
protected Column[] |
Table.columns
The columns of this table.
|
Modifier and Type | Method and Description |
---|---|
Column |
Column.getClone() |
Column |
Table.getColumn(int index)
Get the column at the given index.
|
Column |
Table.getColumn(String columnName)
Get the column with the given name.
|
Column[] |
TableFilter.getColumns() |
Column[] |
Table.getColumns() |
Column[] |
SingleColumnResolver.getColumns() |
Column[] |
ColumnResolver.getColumns()
Get the column list.
|
Column |
TableFilter.getRowIdColumn() |
Column |
Table.getRowIdColumn()
Get the row id column if this table has one.
|
Column |
SingleColumnResolver.getRowIdColumn() |
Column |
RegularTable.getRowIdColumn() |
Column |
ColumnResolver.getRowIdColumn()
Get the row id pseudo column, if there is one.
|
Column[] |
TableFilter.getSystemColumns()
Get the system columns that this table understands.
|
Column[] |
SingleColumnResolver.getSystemColumns() |
Column[] |
ColumnResolver.getSystemColumns()
Get the list of system columns, if any.
|
Modifier and Type | Method and Description |
---|---|
static List<Column> |
TableView.createQueryColumnTemplateList(String[] cols,
Query theQuery,
String[] querySQLOutput)
Creates a list of column templates from a query (usually from WITH query,
but could be any query)
|
Modifier and Type | Method and Description |
---|---|
void |
TableFilter.addNaturalJoinColumn(Column c)
Add a column to the natural join key column list.
|
void |
Column.copy(Column source)
Copy the data of the source column into the current column.
|
static TableView |
TableView.createTableViewMaybeRecursive(Schema schema,
int id,
String name,
String querySQL,
ArrayList<Parameter> parameters,
Column[] columnTemplates,
Session session,
boolean literalsChecked,
boolean isTableExpression,
boolean isPersistent,
Database db)
Create a view.
|
Value |
TableLink.getDefaultValue(Session session,
Column column)
Get or generate a default value for the given column.
|
Value |
Table.getDefaultValue(Session session,
Column column)
Get or generate a default value for the given column.
|
String |
TableFilter.getDerivedColumnName(Column column) |
String |
SingleColumnResolver.getDerivedColumnName(Column column) |
String |
ColumnResolver.getDerivedColumnName(Column column)
Get derived column name, or
null . |
Index |
Table.getIndexForColumn(Column column,
boolean needGetFirstOrLast,
boolean needFindNext)
Get the index that has the given column as the first element.
|
Value |
Table.getOnUpdateValue(Session session,
Column column)
Generates on update value for the given column.
|
Value |
TableFilter.getValue(Column column) |
Value |
SingleColumnResolver.getValue(Column col) |
Value |
ColumnResolver.getValue(Column column)
Get the value for the given column.
|
Value |
JoinBatch.getValue(int filterId,
Column column)
Get the value for the given column.
|
boolean |
TableFilter.isNaturalJoinColumn(Column c)
Check if the given column is a natural join column.
|
boolean |
Column.isWideningConversion(Column newColumn)
Check whether the new column is of the same type and not more restricted
than this column.
|
Expression |
TableFilter.optimize(ExpressionColumn expressionColumn,
Column column) |
Expression |
SingleColumnResolver.optimize(ExpressionColumn expressionColumn,
Column col) |
Expression |
ColumnResolver.optimize(ExpressionColumn expressionColumn,
Column column)
Get the expression that represents this column.
|
void |
Table.renameColumn(Column column,
String newName)
Rename a column of this table.
|
void |
TableView.replace(String querySQL,
Column[] newColumnTemplates,
Session session,
boolean recursive,
boolean force,
boolean literalsChecked)
Try to replace the SQL statement of the view and re-compile this and all
dependent views.
|
protected void |
Table.setColumns(Column[] columns) |
static IndexColumn[] |
IndexColumn.wrap(Column[] columns)
Create an array of index columns from a list of columns.
|
Modifier and Type | Method and Description |
---|---|
static Table |
TableView.createShadowTableForRecursiveTableExpression(boolean isPersistent,
Session targetSession,
String cteViewName,
Schema schema,
List<Column> columns,
Database db)
Create a table for a recursive query.
|
void |
Table.dropMultipleColumnsConstraintsAndIndexes(Session session,
ArrayList<Column> columnsToDrop)
Check that these columns are not referenced by a multi-column constraint
or multi-column index.
|
PlanItem |
TableView.getBestPlanItem(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
PlanItem |
Table.getBestPlanItem(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet)
Get the best plan for the given search mask.
|
PlanItem |
TableFilter.getBestPlanItem(Session s,
TableFilter[] filters,
int filter,
HashSet<Column> allColumnsSet)
Get the best plan item (index, cost) to use use for the current join
order.
|
Index |
TableView.getScanIndex(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
Index |
Table.getScanIndex(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet)
Get the scan index for this table.
|
Constructor and Description |
---|
TableView(Schema schema,
int id,
String name,
String querySQL,
ArrayList<Parameter> params,
Column[] columnTemplates,
Session session,
boolean allowRecursive,
boolean literalsChecked,
boolean isTableExpression,
boolean isPersistent) |
Copyright © 2020 JBoss by Red Hat. All rights reserved.