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 ColumnParser. columnIfTableExists(Schema schema, java.lang.String tableName, java.lang.String columnName, boolean ifTableExists, boolean ifExists)private static ColumnParser. getColumnWithDomain(java.lang.String columnName, Domain domain)private ColumnParser. parseColumn(Table table)private ColumnParser. parseColumnForTable(java.lang.String columnName, boolean defaultNullable)private Column[]Parser. parseColumnList(Table table)private ColumnParser. parseColumnWithType(java.lang.String columnName)private ColumnParser. readTableColumn(TableFilter filter)Methods in org.h2.command with parameters of type Column Modifier and Type Method Description private ExpressionParser. addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)private PreparedParser. getAlterTableAlterColumnDropDefaultExpression(Schema schema, java.lang.String tableName, boolean ifTableExists, Column column, int type)static AlterTableAddConstraintParser. newPrimaryKeyConstraintCommand(SessionLocal session, Schema schema, java.lang.String tableName, Column column)Create a new alter table command.private PreparedParser. parseAlterTableAlterColumnIdentity(Schema schema, java.lang.String tableName, boolean ifTableExists, Column column)private PreparedParser. parseAlterTableAlterColumnSet(Schema schema, java.lang.String tableName, boolean ifTableExists, boolean ifExists, java.lang.String columnName, Column column)private booleanParser. parseCompatibilityIdentity(Column column, Mode mode)private voidParser. parseCompatibilityIdentityOptions(Column column)private voidParser. parseInsertSet(Insert command, Table table, Column[] columns)private voidParser. 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 TableViewParser. 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 ColumnAlterSequence. columnprivate ColumnAlterTableAlterColumn. newColumnprivate ColumnAlterTableAlterColumn. oldColumnFields in org.h2.command.ddl with type parameters of type Column Modifier and Type Field Description java.util.ArrayList<Column>CreateTableData. columnsThe column list.private java.util.ArrayList<Column>AlterTableAlterColumn. columnsToAddprivate java.util.ArrayList<Column>AlterTableAlterColumn. columnsToRemoveMethods 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 voidAlterTableAlterColumn. addColumn(Column column)private static java.lang.StringBuilderAlterTableAlterColumn. addColumn(Column column, java.lang.StringBuilder columnNames, java.lang.StringBuilder columnValues)abstract voidCommandWithColumns. addColumn(Column column)Add a column to this table.voidCreateTable. addColumn(Column column)private voidAlterTableAlterColumn. checkClustering(Column c)private TableAlterTableAlterColumn. cloneTableStructure(Table table, Column[] columns, Database db, java.lang.String tempName, java.util.ArrayList<Column> newColumns)private voidAlterTableAlterColumn. convertIdentityColumn(Table table, Column c)private booleanAlterDomainExpressions. copyColumn(Domain domain, Column targetColumn)private booleanDropDomain. copyColumn(Domain domain, Column targetColumn)voidAlterSequence. setColumn(Column column, java.lang.Boolean always)Set the columnvoidAlterTableAlterColumn. setNewColumn(Column newColumn)voidAlterTableAlterColumn. setOldColumn(Column oldColumn)Method parameters in org.h2.command.ddl with type arguments of type Column Modifier and Type Method Description protected voidCommandWithColumns. changePrimaryKeysToNotNull(java.util.ArrayList<Column> columns)For the given list of columns, disable "nullable" for those columns that are primary key columns.private TableAlterTableAlterColumn. cloneTableStructure(Table table, Column[] columns, Database db, java.lang.String tempName, java.util.ArrayList<Column> newColumns)static voidAlterDomain. 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 booleanAlterDomain. 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.voidAlterTableAlterColumn. 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. columnsprivate Column[]Merge. columnsprivate Column[]MergeUsing.WhenNotMatched. columnsprivate Column[]Merge. keysFields in org.h2.command.dml with type parameters of type Column Modifier and Type Field Description private java.util.HashMap<Column,Expression>Insert. duplicateKeyAssignmentMapFor MySQL-style INSERT ...Methods in org.h2.command.dml with parameters of type Column Modifier and Type Method Description voidInsert. addAssignmentForDuplicate(Column column, Expression expression)Keep a collection of the columns to pass to update if a duplicate key happens, for MySQL-style INSERT ...voidSetClauseList. addSingle(Column column, Expression expression)Add a single column.(package private) voidSetClauseList.SetSimple. getSQL(java.lang.StringBuilder builder, int sqlFlags, Column column)(package private) voidSetClauseList.UpdateAction. getSQL(java.lang.StringBuilder builder, int sqlFlags, Column column)voidInsert. setColumns(Column[] columns)voidMerge. setColumns(Column[] columns)voidMerge. setKeys(Column[] keys)Method parameters in org.h2.command.dml with type arguments of type Column Modifier and Type Method Description voidSetClauseList. 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. columnsFields 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. mapMethods in org.h2.command.query that return Column Modifier and Type Method Description ColumnSelectListColumnResolver. findColumn(java.lang.String name)ColumnTableValueConstructor.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 voidAllColumnsForPlan. add(Column newCol)Called by ExpressionVisitor.private intSelect. addExpandedColumn(TableFilter filter, int index, java.util.HashMap<Column,ExpressionColumn> except, java.lang.String schema, java.lang.String alias, Column c)ValueSelectListColumnResolver. getValue(Column column)ValueTableValueConstructor.TableValueColumnResolver. getValue(Column column)static voidTableValueConstructor. 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.ExpressionSelectListColumnResolver. optimize(ExpressionColumn expressionColumn, Column column)ExpressionTableValueConstructor.TableValueColumnResolver. optimize(ExpressionColumn expressionColumn, Column column)TableQuery. 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.TableTableValueConstructor. 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 intSelect. addExpandedColumn(TableFilter filter, int index, java.util.HashMap<Column,ExpressionColumn> except, java.lang.String schema, java.lang.String alias, Column c)private intSelect. 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 ColumnDomainColumnResolver. columnMethods in org.h2.constraint that return Column Modifier and Type Method Description ColumnDomainColumnResolver. 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 booleanConstraintDomain.CheckExistingData. checkColumn(Domain domain, Column targetColumn)ValueDomainColumnResolver. getValue(Column col) -
Uses of Column in org.h2.expression
Fields in org.h2.expression declared as Column Modifier and Type Field Description private ColumnExpressionColumn. columnprivate ColumnParameter. columnMethods in org.h2.expression that return Column Modifier and Type Method Description ColumnExpressionColumn. 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) voidExpressionVisitor. addColumn1(Column column)Add a new column to the set of columns.(package private) voidExpressionVisitor. addColumn2(Column column)Add a new column to the set of columns.private voidExpressionColumn. mapColumn(ColumnResolver resolver, Column col, int level)voidParameter. setColumn(Column column)Method parameters in org.h2.expression with type arguments of type Column Modifier and Type Method Description static ExpressionVisitorExpressionVisitor. 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. columnsMethod parameters in org.h2.expression.function.table with type arguments of type Column Modifier and Type Method Description voidArrayTableFunction. 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 ColumnIndexCondition. columnprotected Column[]Index. columnsTable columns used in this index.private ColumnIndexCursor. inColumnMethods in org.h2.index that return Column Modifier and Type Method Description ColumnIndexCondition. 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 voidLinkedIndex. addParameter(java.lang.StringBuilder builder, Column col)private booleanIndexCursor. canUseIndexFor(Column column)private booleanIndexCursor. canUseIndexForIn(Column column)intIndex. getColumnIndex(Column col)Get the index of a column in the list of index columnsintMetaIndex. getColumnIndex(Column col)booleanIndex. isFirstColumn(Column column)Check if the given column is the first for this indexbooleanMetaIndex. 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 voidDatabaseMetaLocal. addPrivilege(SimpleResult result, Value catalogValue, Value schemaValue, Value tableValue, Value granteeValue, java.lang.String right, boolean isAdmin, CompareLike columnLike, Column[] columns)private voidDatabaseMetaLocal. addPrivileges(SimpleResult result, Value catalogValue, java.lang.String schemaName, java.lang.String tableName, DbObject grantee, int rightMask, CompareLike columnLike, Column[] columns)private voidDatabaseMetaLocal. 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 ColumnOnDuplicateKeyValues. columnMethods in org.h2.mode with parameters of type Column Modifier and Type Method Description private voidPgCatalogTable. 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 ColumnMVTable. rowIdColumnMethods in org.h2.mvstore.db that return Column Modifier and Type Method Description ColumnMVTable. getRowIdColumn()Methods in org.h2.mvstore.db with parameters of type Column Modifier and Type Method Description intMVDelegateIndex. getColumnIndex(Column col)intMVPrimaryIndex. getColumnIndex(Column col)static longMVSpatialIndex. getCostRangeIndex(int[] masks, Column[] columns)Compute spatial index costbooleanMVDelegateIndex. isFirstColumn(Column column)booleanMVPrimaryIndex. isFirstColumn(Column column) -
Uses of Column in org.h2.result
Methods in org.h2.result that return Column Modifier and Type Method Description ColumnSortOrder. 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 ColumnIndexColumn. columnThe column, or null if not set.private Column[]GeneratedColumnResolver. columnsprotected Column[]Table. columnsThe columns of this table.private Column[]TableView. columnTemplatesFields in org.h2.table with type parameters of type Column Modifier and Type Field Description private java.util.HashMap<java.lang.String,Column>GeneratedColumnResolver. columnMapprivate java.util.HashMap<java.lang.String,Column>Table. columnMapprivate java.util.LinkedHashMap<Column,Column>TableFilter. commonJoinColumnsMap of common join columns, used for NATURAL joins and USING clause of other joins.private java.util.LinkedHashMap<Column,Column>TableFilter. commonJoinColumnsMap of common join columns, used for NATURAL joins and USING clause of other joins.private java.util.ArrayList<Column>TableFilter. commonJoinColumnsToExcludeprivate java.util.LinkedHashMap<Column,java.lang.String>TableFilter. derivedColumnMapMap of derived column names.Methods in org.h2.table that return Column Modifier and Type Method Description (package private) ColumnMetaTable. column(java.lang.String name)Creates a column with the specified name and character string data type.protected ColumnMetaTable. column(java.lang.String name, TypeInfo type)Creates a column with the specified name and data type.private Column[]GeneratedColumnResolver. createColumns()ColumnColumnResolver. findColumn(java.lang.String name)Get the column with the specified name.ColumnGeneratedColumnResolver. findColumn(java.lang.String name)ColumnTable. findColumn(java.lang.String columnName)Get the column with the given name if it exists.ColumnTableFilter. findColumn(java.lang.String name)ColumnColumn. getClone()ColumnTable. getColumn(int index)Get the column at the given index.ColumnTable. getColumn(java.lang.String columnName)Get the column with the given name.ColumnTable. getColumn(java.lang.String columnName, boolean ifExists)Get the column with the given name.ColumnTableFilter. 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()ColumnTable. getIdentityColumn()Returns first identity column, ornull.default ColumnColumnResolver. getRowIdColumn()Get the row id pseudo column, if there is one.ColumnGeneratedColumnResolver. getRowIdColumn()ColumnTable. getRowIdColumn()Get the row id column if this table has one.ColumnTableFilter. 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 voidTableFilter. addCommonJoinColumns(Column leftColumn, Column replacementColumn, TableFilter replacementFilter)Add a column to the common join column list for a left table filter.voidTableFilter. addCommonJoinColumnToExclude(Column columnToExclude)Add an excluded column to the common join column list.private voidInformationSchemaTable. addConstraintColumnUsage(SessionLocal session, java.util.ArrayList<Row> rows, java.lang.String catalog, Constraint constraint, Column column)private voidInformationSchemaTableLegacy. addConstraintColumnUsage(SessionLocal session, java.util.ArrayList<Row> rows, java.lang.String catalog, Constraint constraint, Column column)private voidInformationSchemaTable. 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)voidColumn. copy(Column source)Copy the data of the source column into the current column.static TableViewTableView. 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 TableViewTableView. 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.StringColumnResolver. getColumnName(Column column)Get the name of the specified column.java.lang.StringTableFilter. getColumnName(Column column)private ValueTableFilter. getDelegatedValue(Column column)IndexTable. getIndexForColumn(Column column, boolean needGetFirstOrLast, boolean needFindNext)Get the index that has the given column as the first element.ValueColumnResolver. getValue(Column column)Get the value for the given column.ValueGeneratedColumnResolver. getValue(Column column)ValueTableFilter. getValue(Column column)private voidTableView. init(java.lang.String querySQL, java.util.ArrayList<Parameter> params, Column[] columnTemplates, SessionLocal session, boolean allowRecursive, boolean literalsChecked, boolean isTableExpression)booleanTableFilter. isCommonJoinColumnToExclude(Column c)Check if the given column is an excluded common join column.booleanColumn. isWideningConversion(Column newColumn)Check whether the new column is of the same type and not more restricted than this column.default ExpressionColumnResolver. optimize(ExpressionColumn expressionColumn, Column column)Get the expression that represents this column.voidTable. renameColumn(Column column, java.lang.String newName)Rename a column of this table.voidTableView. 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 voidTable. setColumns(Column[] columns)static IndexColumn[]IndexColumn. wrap(Column[] columns)Create an array of index columns from a list of columns.static java.lang.StringBuilderColumn. writeColumns(java.lang.StringBuilder builder, Column[] columns, int sqlFlags)Appends the specified columns to the specified builder.static java.lang.StringBuilderColumn. 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 voidTableLink. addIndex(java.util.List<Column> list, int uniqueColumnCount, IndexType indexType)static TableTableView. 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.voidTable. 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 voidTableLink. readIndexes(java.sql.DatabaseMetaData meta, java.util.HashMap<java.lang.String,Column> columnMap)private voidTableLink. readIndexes(java.sql.ResultSet rs, java.util.HashMap<java.lang.String,Column> columnMap, java.lang.String pkName)private java.lang.StringTableLink. 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)
-