Uses of Class
org.h2.table.Column
-
Packages that use Column Package Description org.h2.command This package contains the parser and the base classes for prepared SQL statements.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.command.query Contains queries.org.h2.constraint Database constraints such as check constraints, unique constraints, and referential constraints.org.h2.expression Expressions include mathematical operations, simple values, and others.org.h2.expression.function Functions.org.h2.expression.function.table Table value functions.org.h2.index Various table index implementations, as well as cursors to navigate in an index.org.h2.jdbc.meta Implementation of the JDBC database metadata API (package java.sql).org.h2.mode Utility classes for compatibility with other database, for example MySQL.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. -
-
Uses of Column in org.h2.command
Methods in org.h2.command that return Column Modifier and Type Method Description private Column
Parser. columnIfTableExists(Schema schema, java.lang.String tableName, java.lang.String columnName, boolean ifTableExists, boolean ifExists)
private static Column
Parser. getColumnWithDomain(java.lang.String columnName, Domain domain)
private Column
Parser. parseColumn(Table table)
private Column
Parser. parseColumnForTable(java.lang.String columnName, boolean defaultNullable)
private Column[]
Parser. parseColumnList(Table table)
private Column
Parser. parseColumnWithType(java.lang.String columnName)
private Column
Parser. readTableColumn(TableFilter filter)
Methods in org.h2.command with parameters of type Column Modifier and Type Method Description private Expression
Parser. addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)
private Prepared
Parser. getAlterTableAlterColumnDropDefaultExpression(Schema schema, java.lang.String tableName, boolean ifTableExists, Column column, int type)
static AlterTableAddConstraint
Parser. newPrimaryKeyConstraintCommand(SessionLocal session, Schema schema, java.lang.String tableName, Column column)
Create a new alter table command.private Prepared
Parser. parseAlterTableAlterColumnIdentity(Schema schema, java.lang.String tableName, boolean ifTableExists, Column column)
private Prepared
Parser. parseAlterTableAlterColumnSet(Schema schema, java.lang.String tableName, boolean ifTableExists, boolean ifExists, java.lang.String columnName, Column column)
private boolean
Parser. parseCompatibilityIdentity(Column column, Mode mode)
private void
Parser. parseCompatibilityIdentityOptions(Column column)
private void
Parser. parseInsertSet(Insert command, Table table, Column[] columns)
private void
Parser. readColumnConstraints(CommandWithColumns command, Schema schema, java.lang.String tableName, Column column)
Method parameters in org.h2.command with type arguments of type Column Modifier and Type Method Description private TableView
Parser. createCTEView(java.lang.String cteViewName, java.lang.String querySQL, java.util.List<Column> columnTemplateList, boolean allowRecursiveQueryDetection, boolean addViewToSession, boolean isTemporary)
-
Uses of Column in org.h2.command.ddl
Fields in org.h2.command.ddl declared as Column Modifier and Type Field Description private Column
AlterSequence. column
private Column
AlterTableAlterColumn. newColumn
private Column
AlterTableAlterColumn. oldColumn
Fields in org.h2.command.ddl with type parameters of type Column Modifier and Type Field Description java.util.ArrayList<Column>
CreateTableData. columns
The column list.private java.util.ArrayList<Column>
AlterTableAlterColumn. columnsToAdd
private java.util.ArrayList<Column>
AlterTableAlterColumn. columnsToRemove
Methods in org.h2.command.ddl that return types with arguments of type Column Modifier and Type Method Description java.util.ArrayList<Column>
CreateTable. getColumns()
Methods in org.h2.command.ddl with parameters of type Column Modifier and Type Method Description void
AlterTableAlterColumn. addColumn(Column column)
private static java.lang.StringBuilder
AlterTableAlterColumn. addColumn(Column column, java.lang.StringBuilder columnNames, java.lang.StringBuilder columnValues)
abstract void
CommandWithColumns. addColumn(Column column)
Add a column to this table.void
CreateTable. addColumn(Column column)
private void
AlterTableAlterColumn. checkClustering(Column c)
private Table
AlterTableAlterColumn. cloneTableStructure(Table table, Column[] columns, Database db, java.lang.String tempName, java.util.ArrayList<Column> newColumns)
private void
AlterTableAlterColumn. convertIdentityColumn(Table table, Column c)
private boolean
AlterDomainExpressions. copyColumn(Domain domain, Column targetColumn)
private boolean
DropDomain. copyColumn(Domain domain, Column targetColumn)
void
AlterSequence. setColumn(Column column, java.lang.Boolean always)
Set the columnvoid
AlterTableAlterColumn. setNewColumn(Column newColumn)
void
AlterTableAlterColumn. setOldColumn(Column oldColumn)
Method parameters in org.h2.command.ddl with type arguments of type Column Modifier and Type Method Description protected void
CommandWithColumns. changePrimaryKeysToNotNull(java.util.ArrayList<Column> columns)
For the given list of columns, disable "nullable" for those columns that are primary key columns.private Table
AlterTableAlterColumn. cloneTableStructure(Table table, Column[] columns, Database db, java.lang.String tempName, java.util.ArrayList<Column> newColumns)
static void
AlterDomain. forAllDependencies(SessionLocal session, Domain domain, java.util.function.BiPredicate<Domain,Column> columnProcessor, java.util.function.BiPredicate<Domain,Domain> domainProcessor, boolean recompileExpressions)
Processes all columns and domains that use the specified domain.private static boolean
AlterDomain. forTable(SessionLocal session, Domain domain, java.util.function.BiPredicate<Domain,Column> columnProcessor, boolean recompileExpressions, Table t)
protected java.util.ArrayList<Sequence>
CommandWithColumns. generateSequences(java.util.ArrayList<Column> columns, boolean temporary)
For the given list of columns, create sequences for identity columns (if needed), and then get the list of all sequences of the columns.void
AlterTableAlterColumn. setColumnsToRemove(java.util.ArrayList<Column> columnsToRemove)
-
Uses of Column in org.h2.command.dml
Fields in org.h2.command.dml declared as Column Modifier and Type Field Description private Column[]
Insert. columns
private Column[]
Merge. columns
private Column[]
MergeUsing.WhenNotMatched. columns
private Column[]
Merge. keys
Fields in org.h2.command.dml with type parameters of type Column Modifier and Type Field Description private java.util.HashMap<Column,Expression>
Insert. duplicateKeyAssignmentMap
For MySQL-style INSERT ...Methods in org.h2.command.dml with parameters of type Column Modifier and Type Method 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 ...void
SetClauseList. addSingle(Column column, Expression expression)
Add a single column.(package private) void
SetClauseList.SetSimple. getSQL(java.lang.StringBuilder builder, int sqlFlags, Column column)
(package private) void
SetClauseList.UpdateAction. getSQL(java.lang.StringBuilder builder, int sqlFlags, Column column)
void
Insert. setColumns(Column[] columns)
void
Merge. setColumns(Column[] columns)
void
Merge. setKeys(Column[] keys)
Method parameters in org.h2.command.dml with type arguments of type Column Modifier and Type Method Description void
SetClauseList. addMultiple(java.util.ArrayList<Column> columns, Expression expression)
Add multiple columns.Constructors in org.h2.command.dml with parameters of type Column Constructor Description WhenNotMatched(Column[] columns, java.lang.Boolean overridingSystem, Expression[] values)
-
Uses of Column in org.h2.command.query
Fields in org.h2.command.query declared as Column Modifier and Type Field Description private Column[]
SelectListColumnResolver. columns
Fields in org.h2.command.query with type parameters of type Column Modifier and Type Field Description private java.util.HashMap<Table,java.util.ArrayList<Column>>
AllColumnsForPlan. map
Methods in org.h2.command.query that return Column Modifier and Type Method Description Column
SelectListColumnResolver. findColumn(java.lang.String name)
Column
TableValueConstructor.TableValueColumnResolver. findColumn(java.lang.String name)
Column[]
SelectListColumnResolver. getColumns()
Column[]
TableValueConstructor.TableValueColumnResolver. getColumns()
Methods in org.h2.command.query that return types with arguments of type Column Modifier and Type Method Description java.util.ArrayList<Column>
AllColumnsForPlan. get(Table table)
Used by index to calculate the cost of a scan.Methods in org.h2.command.query with parameters of type Column Modifier and Type Method Description void
AllColumnsForPlan. add(Column newCol)
Called by ExpressionVisitor.private int
Select. addExpandedColumn(TableFilter filter, int index, java.util.HashMap<Column,ExpressionColumn> except, java.lang.String schema, java.lang.String alias, Column c)
Value
SelectListColumnResolver. getValue(Column column)
Value
TableValueConstructor.TableValueColumnResolver. getValue(Column column)
static void
TableValueConstructor. getVisibleResult(SessionLocal session, ResultTarget result, Column[] columns, java.util.ArrayList<java.util.ArrayList<Expression>> rows)
Appends visible columns of all rows to the specified result.Expression
SelectListColumnResolver. optimize(ExpressionColumn expressionColumn, Column column)
Expression
TableValueConstructor.TableValueColumnResolver. optimize(ExpressionColumn expressionColumn, Column column)
Table
Query. toTable(java.lang.String alias, Column[] columnTemplates, java.util.ArrayList<Parameter> parameters, boolean forCreateView, Query topQuery)
Converts this query to a table or a view.Table
TableValueConstructor. toTable(java.lang.String alias, Column[] columnTemplates, java.util.ArrayList<Parameter> parameters, boolean forCreateView, Query topQuery)
Method parameters in org.h2.command.query with type arguments of type Column Modifier and Type Method Description private int
Select. addExpandedColumn(TableFilter filter, int index, java.util.HashMap<Column,ExpressionColumn> except, java.lang.String schema, java.lang.String alias, Column c)
private int
Select. expandColumnList(TableFilter filter, int index, boolean forAlias, java.util.HashMap<Column,ExpressionColumn> except)
-
Uses of Column in org.h2.constraint
Fields in org.h2.constraint declared as Column Modifier and Type Field Description private Column
DomainColumnResolver. column
Methods in org.h2.constraint that return Column Modifier and Type Method Description Column
DomainColumnResolver. findColumn(java.lang.String name)
Column[]
DomainColumnResolver. getColumns()
Methods in org.h2.constraint that return types with arguments of type Column Modifier and Type Method Description abstract java.util.HashSet<Column>
Constraint. getReferencedColumns(Table table)
Get all referenced columns.java.util.HashSet<Column>
ConstraintCheck. getReferencedColumns(Table table)
java.util.HashSet<Column>
ConstraintDomain. getReferencedColumns(Table table)
java.util.HashSet<Column>
ConstraintReferential. getReferencedColumns(Table table)
java.util.HashSet<Column>
ConstraintUnique. getReferencedColumns(Table table)
Methods in org.h2.constraint with parameters of type Column Modifier and Type Method Description private boolean
ConstraintDomain.CheckExistingData. checkColumn(Domain domain, Column targetColumn)
Value
DomainColumnResolver. getValue(Column col)
-
Uses of Column in org.h2.expression
Fields in org.h2.expression declared as Column Modifier and Type Field Description private Column
ExpressionColumn. column
private Column
Parameter. column
Methods in org.h2.expression that return Column Modifier and Type Method Description Column
ExpressionColumn. getColumn()
Methods in org.h2.expression that return types with arguments of type Column Modifier and Type Method Description java.util.HashMap<Column,ExpressionColumn>
Wildcard. mapExceptColumns()
Returns map of excluded table columns to expression columns and validates that all columns are resolved and not duplicated.Methods in org.h2.expression with parameters of type Column Modifier and Type Method Description (package private) void
ExpressionVisitor. addColumn1(Column column)
Add a new column to the set of columns.(package private) void
ExpressionVisitor. addColumn2(Column column)
Add a new column to the set of columns.private void
ExpressionColumn. mapColumn(ColumnResolver resolver, Column col, int level)
void
Parameter. setColumn(Column column)
Method parameters in org.h2.expression with type arguments of type Column Modifier and Type Method Description static ExpressionVisitor
ExpressionVisitor. getColumnsVisitor(java.util.HashSet<Column> columns, Table table)
Create a new visitor to get all referenced columns.Constructors in org.h2.expression with parameters of type Column Constructor Description ExpressionColumn(Database database, Column column)
Creates a new column reference for metadata of queries; should not be used as normal expression. -
Uses of Column in org.h2.expression.function
Constructors in org.h2.expression.function with parameters of type Column Constructor Description CastSpecification(Expression arg, Column column)
-
Uses of Column in org.h2.expression.function.table
Fields in org.h2.expression.function.table declared as Column Modifier and Type Field Description private Column[]
ArrayTableFunction. columns
Method parameters in org.h2.expression.function.table with type arguments of type Column Modifier and Type Method Description void
ArrayTableFunction. setColumns(java.util.ArrayList<Column> columns)
-
Uses of Column in org.h2.index
Fields in org.h2.index declared as Column Modifier and Type Field Description private Column
IndexCondition. column
protected Column[]
Index. columns
Table columns used in this index.private Column
IndexCursor. inColumn
Methods in org.h2.index that return Column Modifier and Type Method Description Column
IndexCondition. getColumn()
Get the referenced column.Column[]
Index. getColumns()
Get the indexed columns.Methods in org.h2.index with parameters of type Column Modifier and Type Method Description private void
LinkedIndex. addParameter(java.lang.StringBuilder builder, Column col)
private boolean
IndexCursor. canUseIndexFor(Column column)
private boolean
IndexCursor. canUseIndexForIn(Column column)
int
Index. getColumnIndex(Column col)
Get the index of a column in the list of index columnsint
MetaIndex. getColumnIndex(Column col)
boolean
Index. isFirstColumn(Column column)
Check if the given column is the first for this indexboolean
MetaIndex. isFirstColumn(Column column)
-
Uses of Column in org.h2.jdbc.meta
Methods in org.h2.jdbc.meta with parameters of type Column Modifier and Type Method Description private void
DatabaseMetaLocal. addPrivilege(SimpleResult result, Value catalogValue, Value schemaValue, Value tableValue, Value granteeValue, java.lang.String right, boolean isAdmin, CompareLike columnLike, Column[] columns)
private void
DatabaseMetaLocal. addPrivileges(SimpleResult result, Value catalogValue, java.lang.String schemaName, java.lang.String tableName, DbObject grantee, int rightMask, CompareLike columnLike, Column[] columns)
private void
DatabaseMetaLocal. getPseudoColumnsAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, CompareLike columnLike, Column c)
-
Uses of Column in org.h2.mode
Fields in org.h2.mode declared as Column Modifier and Type Field Description private Column
OnDuplicateKeyValues. column
Methods in org.h2.mode with parameters of type Column Modifier and Type Method Description private void
PgCatalogTable. addAttribute(SessionLocal session, java.util.ArrayList<Row> rows, int id, int relId, Table table, Column column, int ordinal)
Constructors in org.h2.mode with parameters of type Column Constructor Description OnDuplicateKeyValues(Column column, Update update)
-
Uses of Column in org.h2.mvstore.db
Fields in org.h2.mvstore.db declared as Column Modifier and Type Field Description private Column
MVTable. rowIdColumn
Methods in org.h2.mvstore.db that return Column Modifier and Type Method Description Column
MVTable. getRowIdColumn()
Methods in org.h2.mvstore.db with parameters of type Column Modifier and Type Method Description int
MVDelegateIndex. getColumnIndex(Column col)
int
MVPrimaryIndex. getColumnIndex(Column col)
static long
MVSpatialIndex. getCostRangeIndex(int[] masks, Column[] columns)
Compute spatial index costboolean
MVDelegateIndex. isFirstColumn(Column column)
boolean
MVPrimaryIndex. isFirstColumn(Column column)
-
Uses of Column in org.h2.result
Methods in org.h2.result that return Column Modifier and Type Method Description Column
SortOrder. getColumn(int index, TableFilter filter)
Get the column for the given table filter, if the sort column is for this filter. -
Uses of Column in org.h2.table
Fields in org.h2.table declared as Column Modifier and Type Field Description Column
IndexColumn. column
The column, or null if not set.private Column[]
GeneratedColumnResolver. columns
protected Column[]
Table. columns
The columns of this table.private Column[]
TableView. columnTemplates
Fields in org.h2.table with type parameters of type Column Modifier and Type Field Description private java.util.HashMap<java.lang.String,Column>
GeneratedColumnResolver. columnMap
private java.util.HashMap<java.lang.String,Column>
Table. columnMap
private java.util.LinkedHashMap<Column,Column>
TableFilter. commonJoinColumns
Map of common join columns, used for NATURAL joins and USING clause of other joins.private java.util.LinkedHashMap<Column,Column>
TableFilter. commonJoinColumns
Map of common join columns, used for NATURAL joins and USING clause of other joins.private java.util.ArrayList<Column>
TableFilter. commonJoinColumnsToExclude
private java.util.LinkedHashMap<Column,java.lang.String>
TableFilter. derivedColumnMap
Map of derived column names.Methods in org.h2.table that return Column Modifier and Type Method Description (package private) Column
MetaTable. column(java.lang.String name)
Creates a column with the specified name and character string data type.protected Column
MetaTable. column(java.lang.String name, TypeInfo type)
Creates a column with the specified name and data type.private Column[]
GeneratedColumnResolver. createColumns()
Column
ColumnResolver. findColumn(java.lang.String name)
Get the column with the specified name.Column
GeneratedColumnResolver. findColumn(java.lang.String name)
Column
Table. findColumn(java.lang.String columnName)
Get the column with the given name if it exists.Column
TableFilter. findColumn(java.lang.String name)
Column
Column. getClone()
Column
Table. getColumn(int index)
Get the column at the given index.Column
Table. getColumn(java.lang.String columnName)
Get the column with the given name.Column
Table. getColumn(java.lang.String columnName, boolean ifExists)
Get the column with the given name.Column
TableFilter. getColumn(java.lang.String columnName, boolean ifExists)
Get the column with the given name.Column[]
ColumnResolver. getColumns()
Get the column list.Column[]
GeneratedColumnResolver. getColumns()
Column[]
Table. getColumns()
Column[]
TableFilter. getColumns()
Column
Table. getIdentityColumn()
Returns first identity column, ornull
.default Column
ColumnResolver. getRowIdColumn()
Get the row id pseudo column, if there is one.Column
GeneratedColumnResolver. getRowIdColumn()
Column
Table. getRowIdColumn()
Get the row id column if this table has one.Column
TableFilter. getRowIdColumn()
default Column[]
ColumnResolver. getSystemColumns()
Get the list of system columns, if any.Column[]
TableFilter. getSystemColumns()
Get the system columns that this table understands.Methods in org.h2.table that return types with arguments of type Column Modifier and Type Method Description static java.util.List<Column>
TableView. createQueryColumnTemplateList(java.lang.String[] cols, Query theQuery, java.lang.String[] querySQLOutput)
Creates a list of column templates from a query (usually from WITH query, but could be any query)java.util.LinkedHashMap<Column,Column>
TableFilter. getCommonJoinColumns()
Returns common join columns map.java.util.LinkedHashMap<Column,Column>
TableFilter. getCommonJoinColumns()
Returns common join columns map.Methods in org.h2.table with parameters of type Column Modifier and Type Method Description void
TableFilter. addCommonJoinColumns(Column leftColumn, Column replacementColumn, TableFilter replacementFilter)
Add a column to the common join column list for a left table filter.void
TableFilter. addCommonJoinColumnToExclude(Column columnToExclude)
Add an excluded column to the common join column list.private void
InformationSchemaTable. addConstraintColumnUsage(SessionLocal session, java.util.ArrayList<Row> rows, java.lang.String catalog, Constraint constraint, Column column)
private void
InformationSchemaTableLegacy. addConstraintColumnUsage(SessionLocal session, java.util.ArrayList<Row> rows, java.lang.String catalog, Constraint constraint, Column column)
private void
InformationSchemaTable. columns(SessionLocal session, java.util.ArrayList<Row> rows, java.lang.String catalog, java.lang.String mainSchemaName, java.lang.String collation, Table table, java.lang.String tableName, Column c, int ordinalPosition)
void
Column. copy(Column source)
Copy the data of the source column into the current column.static TableView
TableView. createTableViewMaybeRecursive(Schema schema, int id, java.lang.String name, java.lang.String querySQL, java.util.ArrayList<Parameter> parameters, Column[] columnTemplates, SessionLocal session, boolean literalsChecked, boolean isTableExpression, boolean isTemporary, Database db)
Create a view.static TableView
TableView. createTempView(SessionLocal session, User owner, java.lang.String name, Column[] columnTemplates, Query query, Query topQuery)
Create a temporary view out of the given query.default java.lang.String
ColumnResolver. getColumnName(Column column)
Get the name of the specified column.java.lang.String
TableFilter. getColumnName(Column column)
private Value
TableFilter. getDelegatedValue(Column column)
Index
Table. getIndexForColumn(Column column, boolean needGetFirstOrLast, boolean needFindNext)
Get the index that has the given column as the first element.Value
ColumnResolver. getValue(Column column)
Get the value for the given column.Value
GeneratedColumnResolver. getValue(Column column)
Value
TableFilter. getValue(Column column)
private void
TableView. init(java.lang.String querySQL, java.util.ArrayList<Parameter> params, Column[] columnTemplates, SessionLocal session, boolean allowRecursive, boolean literalsChecked, boolean isTableExpression)
boolean
TableFilter. isCommonJoinColumnToExclude(Column c)
Check if the given column is an excluded common join column.boolean
Column. isWideningConversion(Column newColumn)
Check whether the new column is of the same type and not more restricted than this column.default Expression
ColumnResolver. optimize(ExpressionColumn expressionColumn, Column column)
Get the expression that represents this column.void
Table. renameColumn(Column column, java.lang.String newName)
Rename a column of this table.void
TableView. replace(java.lang.String querySQL, Column[] newColumnTemplates, SessionLocal 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.static java.lang.StringBuilder
Column. writeColumns(java.lang.StringBuilder builder, Column[] columns, int sqlFlags)
Appends the specified columns to the specified builder.static java.lang.StringBuilder
Column. writeColumns(java.lang.StringBuilder builder, Column[] columns, java.lang.String separator, java.lang.String suffix, int sqlFlags)
Appends the specified columns to the specified builder.Method parameters in org.h2.table with type arguments of type Column Modifier and Type Method Description private void
TableLink. addIndex(java.util.List<Column> list, int uniqueColumnCount, IndexType indexType)
static Table
TableView. createShadowTableForRecursiveTableExpression(boolean isTemporary, SessionLocal targetSession, java.lang.String cteViewName, Schema schema, java.util.List<Column> columns, Database db)
Create a table for a recursive query.void
Table. dropMultipleColumnsConstraintsAndIndexes(SessionLocal session, java.util.ArrayList<Column> columnsToDrop)
Check that these columns are not referenced by a multi-column constraint or multi-column index.private void
TableLink. readIndexes(java.sql.DatabaseMetaData meta, java.util.HashMap<java.lang.String,Column> columnMap)
private void
TableLink. readIndexes(java.sql.ResultSet rs, java.util.HashMap<java.lang.String,Column> columnMap, java.lang.String pkName)
private java.lang.String
TableLink. readPrimaryKey(java.sql.ResultSet rs, java.util.HashMap<java.lang.String,Column> columnMap)
Constructors in org.h2.table with parameters of type Column Constructor Description IndexColumn(Column column)
Creates a new instance with the specified column.TableValueConstructorTable(Schema schema, SessionLocal session, Column[] columns, java.util.ArrayList<java.util.ArrayList<Expression>> rows)
TableView(Schema schema, int id, java.lang.String name, java.lang.String querySQL, java.util.ArrayList<Parameter> params, Column[] columnTemplates, SessionLocal session, boolean allowRecursive, boolean literalsChecked, boolean isTableExpression, boolean isTemporary)
-