Uses of Interface
org.h2.value.Typed
Packages that use Typed
Package
Description
Expressions include mathematical operations, simple values, and others.
Aggregate functions.
Base classes for data analysis operations and implementations of window functions.
Condition expressions.
Functions.
Trace (logging facility) and error message tool.
Utility classes for compatibility with other database, for example MySQL.
Helper classes to use the MVStore in the H2 database.
Implementation of row and internal result sets.
Classes related to a table and table meta data.
Data type and value implementations.
-
Uses of Typed in org.h2.expression
Classes in org.h2.expression that implement TypedModifier and TypeClassDescriptionfinal classA column alias as in SELECT 'Hello' AS NAME ...final classArray value constructor by query.final classArray element reference.classA mathematical expression, or string concatenation.classA compatibility mathematical operation with datetime values.final classCharacter string concatenation as in'Hello' || 'World', binary string concatenation as inX'01' || X'AB'or an array concatenation as inARRAY[1, 2] || 3.final classAn expression representing a value for domain constraint.classAn expression is a operation, a value, or a function in a query.final classA column reference expression that represents a column of a table or view.final classA list of expressions, as in (ID, NAME).final classField reference.final classA format clause such as FORMAT JSON.classA mathematical operation with intervals.classOperation without subexpressions.classOperation with one argument.classOperation with one or two arguments.classOperation with two arguments.classOperation with many arguments.final classA parameter of a prepared statement.final classRepresents the ROWNUM function.final classA searched case.final classWraps a sequence when used in a statement.final classA simple case.final classA query returning a single value.final classA time zone specification (AT { TIME ZONE | LOCAL }).classAn expression representing a constant value with a type cast.classUnary operation.classAn expression representing a constant value.final classA user-defined variable, for example: @ID.final classA wildcard expression as in SELECT * FROM TEST. -
Uses of Typed in org.h2.expression.aggregate
Classes in org.h2.expression.aggregate that implement TypedModifier and TypeClassDescriptionclassA base class for aggregate functions.classImplements the integrated aggregate functions, such as COUNT, MAX, SUM.classThis class wraps a user-defined aggregate. -
Uses of Typed in org.h2.expression.analysis
Classes in org.h2.expression.analysis that implement TypedModifier and TypeClassDescriptionclassA base class for data analysis operations such as aggregates and window functions.classA window function. -
Uses of Typed in org.h2.expression.condition
Classes in org.h2.expression.condition that implement TypedModifier and TypeClassDescriptionfinal classBETWEEN predicate.final classBoolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).final classPattern matching comparison expression: WHERE NAME LIKE ?final classExample comparison expressions are ID=1, NAME=NAME, NAME IS NULL.(package private) classRepresents a condition returning a boolean value, or NULL.classAn 'and' or 'or' condition as in WHERE ID=1 AND NAME=?classAn 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.final classAn 'in' condition with a list of values, as in WHERE NAME IN(...)final classUsed for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.final classA condition with parameter as= ANY(?).final classAn IN() condition with a subquery, as in WHERE ID IN(SELECT ...)classA global condition or combination of local and global conditions.classA NOT condition.classExists predicate as in EXISTS(SELECT ...)final classIS JSON predicate.final classNull predicate (IS [NOT] NULL).(package private) classBase class for predicates with a subquery.classBase class for simple predicates.final classType predicate (IS [NOT] OF).classUnique predicate as in UNIQUE(SELECT ...) -
Uses of Typed in org.h2.expression.function
Classes in org.h2.expression.function that implement TypedModifier and TypeClassDescriptionfinal classAn array function.final classA bitwise function.final classCardinality expression.final classA cast specification.final classA COALESCE, GREATEST, or LEAST function.final classNEXTVAL() and CURRVAL() compatibility functions.final classA COMPRESS or EXPAND function.final classA CONCAT or CONCAT_WS function.final classAn ENCRYPT or DECRYPT function.final classA CSVWRITE function.final classCurrent datetime value function.final classSimple general value specifications.final classDATA_TYPE_SQL() function.final classA date-time format function.final classA date-time function.final classA DAYNAME() or MONTHNAME() function.final classDB_OBJECT_ID() and DB_OBJECT_SQL() functions.final classA FILE_READ or FILE_WRITE function.classFunction with one optional argument.classFunction with one argument.classFunction with two arguments.classFunction with two arguments.classFunction with many arguments.final classA HASH or ORA_HASH function.final classThis class wraps a user-defined function.final classJSON constructor function.final classCHAR_LENGTH(), or OCTET_LENGTH() function.final classA math function.final classA math function with one argument and DOUBLE PRECISION result.final classA math function with two arguments and DOUBLE PRECISION result.final classA NULLIF function.final classA RAND, SECURE_RAND, or RANDOM_UUID function.final classA regular expression function.final classAn ABORT_SESSION() or CANCEL_SESSION() function.final classA SET function.final classA SIGNAL function.final classA SOUNDEX or DIFFERENCE function.final classAn string function with multiple arguments.final classA string function with one argument.final classA string function with two arguments.final classA SUBSTRING function.final classDatabase or session information function.final classA table information function.final classEmulates Oracle's TO_CHAR function.final classA TRIM function.final classA TRUNCATE_VALUE function.final classAn XML function. -
Uses of Typed in org.h2.message
Methods in org.h2.message with parameters of type TypedModifier and TypeMethodDescriptionstatic DbExceptionDbException.getInvalidExpressionTypeException(String param, Typed e) Gets a SQL exception meaning the type of expression is invalid or unknown. -
Uses of Typed in org.h2.mode
Classes in org.h2.mode that implement TypedModifier and TypeClassDescriptionfinal classFunctions forMode.ModeEnum.DB2andMode.ModeEnum.Derbycompatibility modes.classThis class implements some legacy functions not available in Regular mode.final classFunctions forMode.ModeEnum.MSSQLServercompatibility mode.final classThis class implements some MySQL-specific functions.final classFunctions forMode.ModeEnum.Oraclecompatibility mode.final classFunctions forMode.ModeEnum.PostgreSQLcompatibility mode.classBase class for mode-specific functions.final classVALUES(column) function for ON DUPLICATE KEY UPDATE clause.final classA ::regclass expression. -
Uses of Typed in org.h2.mvstore.db
Classes in org.h2.mvstore.db that implement Typed -
Uses of Typed in org.h2.result
Classes in org.h2.result that implement TypedModifier and TypeClassDescriptionclassThe default implementation of a row in a table.classRepresents a row in a table.classThe base class for rows stored in a table, and for partial rows stored in the index.classA simple row that contains data for only one column.final classClass Sparse.Methods in org.h2.result with parameters of type TypedModifier and TypeMethodDescriptionRowFactory.createRowFactory(CastDataProvider provider, CompareMode compareMode, DataHandler handler, Typed[] columns, IndexColumn[] indexColumns, boolean storeKeys) Create a new row factory.RowFactory.DefaultRowFactory.createRowFactory(CastDataProvider provider, CompareMode compareMode, DataHandler handler, Typed[] columns, IndexColumn[] indexColumns, boolean storeKeys) -
Uses of Typed in org.h2.table
Classes in org.h2.table that implement Typed -
Uses of Typed in org.h2.value
Classes in org.h2.value that implement TypedModifier and TypeClassDescriptionclassData type with parameters.classThis is the base class for all value classes.final classImplementation of the ARRAY data type.(package private) classBase class for BigDecimal-based values.final classImplementation of the BIGINT data type.final classImplementation of the BINARY data type.final classImplementation of the BINARY LARGE OBJECT data type.final classImplementation of the BOOLEAN data type.(package private) classBase implementation of byte array based data types.final classImplementation of the CHARACTER data type.final classImplementation of the CHARACTER LARGE OBJECT data type.classBase class for ARRAY and ROW values.final classImplementation of the DATE data type.final classImplementation of the DECFLOAT data type.final classImplementation of the DOUBLE PRECISION data type.final classENUM value.classBase implementation of the ENUM data type.final classImplementation of the GEOMETRY data type.final classImplementation of the INTEGER data type.final classImplementation of the INTERVAL data type.final classImplementation of the JAVA_OBJECT data type.final classImplementation of the JSON data type.classA implementation of the BINARY LARGE OBJECT and CHARACTER LARGE OBJECT data types.final classImplementation of NULL.final classImplementation of the NUMERIC data type.final classImplementation of the REAL data type.final classRow value.final classImplementation of the SMALLINT data type.(package private) classBase implementation of String based data types.final classImplementation of the TIME data type.final classImplementation of the TIMESTAMP data type.final classImplementation of the TIMESTAMP WITH TIME ZONE data type.final classImplementation of the TIME WITH TIME ZONE data type.final classImplementation of the TINYINT data type.final classImplementation of the UUID data type.final classImplementation of the BINARY VARYING data type.final classImplementation of the CHARACTER VARYING data type.final classImplementation of the VARCHAR_IGNORECASE data type.Methods in org.h2.value with parameters of type TypedModifier and TypeMethodDescriptionstatic TypeInfoTypeInfo.getHigherType(Typed[] values) Get the higher data type of all values.Constructors in org.h2.value with parameters of type TypedModifierConstructorDescriptionExtTypeInfoRow(Typed[] fields) Creates new instance of extended parameters of ROW data type.ExtTypeInfoRow(Typed[] fields, int degree) Creates new instance of extended parameters of ROW data type.