Uses of Class
org.hibernate.query.sqm.function.AbstractSqmFunctionDescriptor
Packages that use AbstractSqmFunctionDescriptor
Package
Description
Contains implementations of
SqmFunctionDescriptor
describing a range of relatively-sophisticated SQL functions available in various dialects.An SPI for defining, registering, and rendering functions in HQL.
-
Uses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.functionModifier and TypeClassDescriptionclass
class
Some databases don't have a function likeleast()
orgreatest()
, and on those platforms we emulate the function usingcase
.class
ANSI SQL-inspiredcast()
function, where the target types are enumerated byCastType
, and portability is achieved by delegating toDialect.castPattern(CastType, CastType)
.class
class
The HQLstr()
function is now considered a synonym forcast(x as String)
.class
A chr implementation that translates integer literals to string literals.class
class
A concat function with a pattern for clob arguments.class
class
A "function" with no parameters that returns the current date, time, or timestamp.class
Emulation oftrunc(datetime, temporal_unit)
function that leverages formatting the datetime to string and back to truncate itclass
DB2's varchar_format() can't handle quoted literal strings in the format pattern.class
DB2's position() function always requires a code unit before version 11.class
DB2's substring() function requires a code unit and substr() can't optionally take it, so we render substr() by default.class
Most databases don't have a function likeevery()
orany()
.class
ANSI SQL-inspiredextract()
function, where the date/time fields are enumerated byTemporalUnit
, and portability is achieved by delegating toDialect.extractPattern(TemporalUnit)
.class
A format function with support for composite temporal expressions.class
class
class
Emulates the ANSI SQL-standardoverlay()
function usinginsert()
substring()
, andconcat()
.class
Used in place ofTimestampaddFunction
for databases which don't support fractional seconds in thetimestampadd()
function.class
class
class
A length function with separate patterns for string and clob argument.class
class
class
class
Emulates the ANSI SQL-standardposition()
function usinglocate()
.class
HQL function inspired by the ANSI SQL trim function, with a funny syntax involving aTrimSpec
.class
Most databases don't have a function likeevery()
orany()
.class
class
Oracle 8i had nocoalesce()
function, so we emulate it using chainednvl()
s.class
CustomTruncFunction
for Oracle which uses emulation when truncating datetimes to secondsclass
The HQLordinal()
function returns the ordinal value of an enumclass
PostgreSQL doesn't support min/max for uuid yet, but since that type is comparable we want to support this operation.class
CustomTruncFunction
for PostgreSQL which uses the dialect-specific function for numeric truncationclass
PostgreSQL only supports the two-argumenttrunc
andround
functions with the following signatures:trunc(numeric, integer)
round(numeric, integer)
class
class
class
A function to pass through a SQL fragment.class
CustomTruncFunction
for SQL Server versions before 16, which uses the customSqlServerConvertTruncFunction.DateTruncConvertEmulation
class
SQL Server doesn't have a function likeevery()
orany()
.class
SQL Server behaves strangely when the first argument to format is of the type time, so we cast to datetime.class
Simplified API allowing users to contributeSqmFunctionDescriptor
s to HQL.class
CustomTruncFunction
for Sybase which uses a dialect-specific emulation function for datetimesclass
Thetimestampadd()
ordateadd()
function has a funny syntax which accepts aTemporalUnit
as the first argument, and the actual set of accepted units varies widely.class
Thetimestampdiff()
ordatediff()
function has a funny syntax which accepts aTemporalUnit
as the first argument, and the actual set of accepted units varies widely.class
A special function that renders a T-SQLstr()
function if more than a single argument is given, or otherwise renders acast()
expression just likeCastStrEmulation
.class
ANSI SQL-standardtrim()
function, which has a funny syntax involving aTrimSpec
, and portability is achieved usingDialect.trimPattern(TrimSpec, boolean)
.class
Custom function that manages both numeric and datetime truncation -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function.array
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function.arrayModifier and TypeClassDescriptionclass
Encapsulates the validator, return type and argument type resolvers for the array_contains function.class
Encapsulates the validator, return type and argument type resolvers for the array_contains function.class
Encapsulates the validator, return type and argument type resolvers for the array_includes function.class
Encapsulates the validator, return type and argument type resolvers for the array_intersects function.class
Encapsulates the validator, return type and argument type resolvers for the array_position functions.class
Encapsulates the validator, return type and argument type resolvers for the array_positions functions.class
Encapsulates the validator, return type and argument type resolvers for the array_remove functions.class
Encapsulates the validator, return type and argument type resolvers for the array_remove functions.class
class
Concatenation function for array and an element.class
Concatenation function for arrays.class
class
Special array contains function that also applies a cast to the element argument.class
Implement the array contains function by usingunnest
.class
Implement the array get function by usingunnest
.class
Special array includes implementation that uses the PostgreSQL@>
operator.class
Implement the array includes function by usingunnest
.class
Array intersects function that uses the PostgreSQL&&
operator.class
Implement the intersects function by usingunnest
.class
Implement the array remove index function by usingunnest
.class
Implement the array replace function by usingunnest
.class
Implement the array set function by usingunnest
.class
Implement the array slice function by usingunnest
.class
class
Implement the array fill function by usinggenerate_series
.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
Implement the array fill function by usingsystem_range
.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
H2 requires a very special emulation, becauseunnest
is pretty much useless, due to https://github.com/h2database/h2database/issues/1815.class
class
Implement the array fill function by usingsequence_array
.class
HSQLDB has a special syntax.class
HSQLDB has a special syntax.class
HSQLDB array_remove function.class
HSQLDB array_set function.class
HSQLDB has a special syntax.class
class
Oracle concatenation function for array and an element.class
Oracle concatenation function for arrays.class
class
class
Oracle array_fill function.class
Oracle array_get function.class
class
class
class
class
class
Oracle array_remove function.class
Oracle array_remove_index function.class
Oracle array_replace function.class
Oracle array_set function.class
Oracle array_slice function.class
Oracle array_to_string function.class
Oracle array_trim function.class
PostgreSQL variant of the function to properly returnnull
when the array argument is null.class
PostgreSQL variant of the function to properly returnnull
when one of the arguments is null.class
Special array constructor function that also applies a cast to the array literal, based on the inferred result type.class
Custom casting for the array fill function.class
PostgreSQL variant of the function.class
PostgreSQL variant of the function.class
PostgreSQL array_trim emulation, since the function was only introduced in version 14. -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function.json
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function.jsonModifier and TypeClassDescriptionclass
Standard json_array_append function.class
Standard json_array_insert function.class
Standard json_insert function.class
Standard json_mergepatch function.class
Standard json_remove function.class
Standard json_replace function.class
Standard json_set function.class
CockroachDB json_exists function.class
CockroachDB json_query function.class
CockroachDB json_remove function.class
CockroachDB json_value function.class
DB2 json_arrayagg function.class
DB2 json_array function.class
DB2 json_objectagg function.class
DB2 json_object function.class
DB2 json_value function.class
H2 json_arrayagg function.class
H2 json_exists function.class
Standard json_objectagg function that uses no returning clause.class
H2 json_query function.class
H2 json_value function.class
SAP HANA json_arrayagg function.class
SAP HANA json_array function.class
SAP HANA json_exists function.class
SAP HANA json_objectagg function.class
SAP HANA json_object function.class
HANA json_value function.class
HSQLDB json_arrayagg function.class
HSQLDB json_array function.class
HSQLDB json_object function.class
Standard json_arrayagg function.class
Standard json_array function.class
Standard json_exists function.class
Standard json_objectagg function.class
Standard json_object function.class
Standard json_query function.class
Standard json_value function.class
MariaDB json_arrayagg function.class
MariaDB json_array_append function.class
MariaDB json_array function.class
MariaDB json_objectagg function.class
MariaDB json_query function.class
MariaDB json_value function.class
MySQL json_arrayagg function.class
MySQL json_array function.class
MySQL json_exists function.class
MySQL json_objectagg function.class
MySQL json_object function.class
MySQL json_query function.class
MySQL json_value function.class
Oracle json_arrayagg function.class
Oracle json_array_append function.class
Oracle json_array function.class
Oracle json_array_insert function.class
Oracle json_insert function.class
Oracle json_mergepatch function.class
Oracle json_objectagg function.class
Oracle json_object function.class
Oracle json_remove function.class
Oracle json_replace function.class
Oracle json_set function.class
Oracle json_value function.class
PostgreSQL json_arrayagg function.class
PostgreSQL json_array_append function.class
PostgreSQL json_array function.class
PostgreSQL json_array_insert function.class
PostgreSQL json_exists function.class
PostgreSQL json_insert function.class
PostgreSQL json_mergepatch function.class
PostgreSQL json_objectagg function.class
PostgreSQL json_object function.class
PostgreSQL json_query function.class
PostgreSQL json_remove function.class
PostgreSQL json_replace function.class
PostgreSQL json_set function.class
PostgreSQL json_value function.class
SQL Server json_arrayagg function.class
SQL Server json_array_append function.class
SQL Server json_array function.class
SQL Server json_array_insert function.class
SQL Server json_exists function.class
SQL Server json_insert function.class
SQL Server json_objectagg function.class
SQL Server json_object function.class
SQL Server json_query function.class
SQL Server json_remove function.class
SQL Server json_replace function.class
SQL Server json_set function.class
SQL Server json_value function. -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function.xml
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function.xmlModifier and TypeClassDescriptionclass
H2 xmlconcat function.class
H2 xmlelement function.class
H2 xmlforest function.class
H2 xmlpi function.class
DB2 10.5 xmlexists function.class
DB2 10.5 xmlquery function.class
PostgreSQL xmlquery function.class
SQL Server xmlagg function.class
SQL Server xmlconcat function.class
SQL Server xmlelement function.class
SQL Server xmlexists function.class
SQL Server xmlforest function.class
SQL Server xmlpi function.class
SQL Server xmlquery function.class
Standard xmlagg function.class
Standard xmlconcat function.class
Standard xmlelement function.class
Standard xmlexists function.class
Standard xmlforest function.class
Standard xmlpi function.class
Standard xmlquery function. -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.envers.function
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.envers.functionModifier and TypeClassDescriptionclass
Envers specific FunctionContributor -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.query.sqm.function
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.query.sqm.functionModifier and TypeClassDescriptionclass
class
Acts as a wrapper to anotherSqmFunctionDescriptor
, rendering the standard JDBC escape sequence{fn f(x, y)}
around the invocation syntax generated by its delegate.class
Support for overloaded functions defined in terms of a list of patterns, one for each possible function arity.class
Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.class
Support for HQL functions that have different representations in different SQL dialects, where the difference can be handled via a pattern template. -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.spatial.dialect.hana
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.spatial.dialect.hana -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.spatial.dialect.oracle
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.spatial.dialect.oracleModifier and TypeClassDescriptionclass
class
class
class
class
class