Uses of Class
org.hibernate.query.sqm.function.AbstractSqmFunctionDescriptor
-
Packages that use AbstractSqmFunctionDescriptor Package Description org.hibernate.dialect.function Contains implementations ofSqmFunctionDescriptordescribing a range of relatively-sophisticated SQL functions available in various dialects.org.hibernate.dialect.function.array org.hibernate.envers.function org.hibernate.query.sqm.function An SPI for defining, registering, and rendering functions in HQL.org.hibernate.spatial.dialect.hana org.hibernate.spatial.dialect.oracle -
-
Uses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.dialect.function Modifier and Type Class Description classAvgFunctionclassCaseLeastGreatestEmulationSome databases don't have a function likeleast()orgreatest(), and on those platforms we emulate the function usingcase.classCastFunctionANSI SQL-inspiredcast()function, where the target types are enumerated byCastType, and portability is achieved by delegating toDialect.castPattern(CastType, CastType).classCastingConcatFunctionclassCastStrEmulationThe HQLstr()function is now considered a synonym forcast(x as String).classChrLiteralEmulationA chr implementation that translates integer literals to string literals.classCoalesceIfnullEmulationclassConcatPipeFunctionA concat function with a pattern for clob arguments.classCountFunctionclassCurrentFunctionA "function" with no parameters that returns the current date, time, or timestamp.classDateTruncEmulationEmulation oftrunc(datetime, temporal_unit)function that leverages formatting the datetime to string and back to truncate itclassDB2FormatEmulationDB2's varchar_format() can't handle quoted literal strings in the format pattern.classDB2PositionFunctionDB2's position() function always requires a code unit before version 11.classDB2SubstringFunctionDB2's substring() function requires a code unit and substr() can't optionally take it, so we render substr() by default.classDerbyLpadEmulationA derby implementation for lpad.classDerbyRpadEmulationA derby implementation for rpad.classEveryAnyEmulationMost databases don't have a function likeevery()orany().classExtractFunctionANSI SQL-inspiredextract()function, where the date/time fields are enumerated byTemporalUnit, and portability is achieved by delegating toDialect.extractPattern(TemporalUnit).classFormatFunctionA format function with support for composite temporal expressions.classHypotheticalSetFunctionclassHypotheticalSetWindowEmulationclassInsertSubstringOverlayEmulationEmulates the ANSI SQL-standardoverlay()function usinginsert()substring(), andconcat().classIntegralTimestampaddFunctionUsed in place ofTimestampaddFunctionfor databases which don't support fractional seconds in thetimestampadd()function.classInverseDistributionFunctionclassInverseDistributionWindowEmulationclassLengthFunctionA length function with separate patterns for string and clob argument.classListaggFunctionclassListaggGroupConcatEmulationclassListaggStringAggEmulationclassLocatePositionEmulationEmulates the ANSI SQL-standardposition()function usinglocate().classLpadRpadPadEmulationHQL function inspired by the ANSI SQL trim function, with a funny syntax involving aTrimSpec.classMinMaxCaseEveryAnyEmulationMost databases don't have a function likeevery()orany().classModeStatsModeEmulationclassNvlCoalesceEmulationOracle 8i had nocoalesce()function, so we emulate it using chainednvl()s.classOracleExtractFunctionclassOracleTruncFunctionCustomTruncFunctionfor Oracle which uses emulation when truncating datetimes to secondsclassPostgreSQLMinMaxFunctionPostgreSQL doesn't support min/max for uuid yet, but since that type is comparable we want to support this operation.classPostgreSQLTruncFunctionCustomTruncFunctionfor PostgreSQL which uses the dialect-specific function for numeric truncationclassPostgreSQLTruncRoundFunctionPostgreSQL only supports the two-argumenttruncandroundfunctions with the following signatures:trunc(numeric, integer)round(numeric, integer)classQuantifiedLeastGreatestEmulationclassSqlColumnclassSqlFunctionA function to pass through a SQL fragment.classSqlServerConvertTruncFunctionCustomTruncFunctionfor SQL Server versions before 16, which uses the customSqlServerConvertTruncFunction.DateTruncConvertEmulationclassSQLServerEveryAnyEmulationSQL Server doesn't have a function likeevery()orany().classSQLServerFormatEmulationSQL Server behaves strangely when the first argument to format is of the type time, so we cast to datetime.classStandardSQLFunctionSimplified API allowing users to contributeSqmFunctionDescriptors to HQL.classSybaseTruncFunctionCustomTruncFunctionfor Sybase which uses a dialect-specific emulation function for datetimesclassTimestampaddFunctionThetimestampadd()ordateadd()function has a funny syntax which accepts aTemporalUnitas the first argument, and the actual set of accepted units varies widely.classTimestampdiffFunctionThetimestampdiff()ordatediff()function has a funny syntax which accepts aTemporalUnitas the first argument, and the actual set of accepted units varies widely.classTransactSQLStrFunctionA special function that renders a T-SQLstr()function if more than a single argument is given, or otherwise renders acast()expression just likeCastStrEmulation.classTrimFunctionANSI SQL-standardtrim()function, which has a funny syntax involving aTrimSpec, and portability is achieved usingDialect.trimPattern(TrimSpec, boolean).classTruncFunctionCustom 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.array Modifier and Type Class Description classAbstractArrayContainsFunctionEncapsulates the validator, return type and argument type resolvers for the array_contains function.classAbstractArrayFillFunctionEncapsulates the validator, return type and argument type resolvers for the array_contains function.classAbstractArrayIncludesFunctionEncapsulates the validator, return type and argument type resolvers for the array_includes function.classAbstractArrayIntersectsFunctionEncapsulates the validator, return type and argument type resolvers for the array_intersects function.classAbstractArrayPositionFunctionEncapsulates the validator, return type and argument type resolvers for the array_position functions.classAbstractArrayPositionsFunctionEncapsulates the validator, return type and argument type resolvers for the array_positions functions.classAbstractArrayRemoveFunctionEncapsulates the validator, return type and argument type resolvers for the array_remove functions.classAbstractArrayTrimFunctionEncapsulates the validator, return type and argument type resolvers for the array_remove functions.classArrayAggFunctionclassArrayConcatElementFunctionConcatenation function for array and an element.classArrayConcatFunctionConcatenation function for arrays.classArrayConstructorFunctionclassArrayContainsOperatorFunctionSpecial array contains function that also applies a cast to the element argument.classArrayContainsUnnestFunctionImplement the array contains function by usingunnest.classArrayGetUnnestFunctionImplement the array get function by usingunnest.classArrayIncludesOperatorFunctionSpecial array includes implementation that uses the PostgreSQL@>operator.classArrayIncludesUnnestFunctionImplement the array includes function by usingunnest.classArrayIntersectsOperatorFunctionArray intersects function that uses the PostgreSQL&&operator.classArrayIntersectsUnnestFunctionImplement the intersects function by usingunnest.classArrayRemoveIndexUnnestFunctionImplement the array remove index function by usingunnest.classArrayReplaceUnnestFunctionImplement the array replace function by usingunnest.classArraySetUnnestFunctionImplement the array set function by usingunnest.classArraySliceUnnestFunctionImplement the array slice function by usingunnest.classArrayToStringFunctionclassCockroachArrayFillFunctionImplement the array fill function by usinggenerate_series.classH2ArrayContainsFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayFillFunctionImplement the array fill function by usingsystem_range.classH2ArrayIncludesFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayIntersectsFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayPositionFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayPositionsFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayRemoveFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayRemoveIndexFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayReplaceFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArraySetFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classH2ArrayToStringFunctionH2 requires a very special emulation, becauseunnestis pretty much useless, due to https://github.com/h2database/h2database/issues/1815.classHSQLArrayConstructorFunctionclassHSQLArrayFillFunctionImplement the array fill function by usingsequence_array.classHSQLArrayPositionFunctionHSQLDB has a special syntax.classHSQLArrayPositionsFunctionHSQLDB has a special syntax.classHSQLArrayRemoveFunctionHSQLDB array_remove function.classHSQLArraySetFunctionHSQLDB array_set function.classHSQLArrayToStringFunctionHSQLDB has a special syntax.classOracleArrayAggEmulationclassOracleArrayConcatElementFunctionOracle concatenation function for array and an element.classOracleArrayConcatFunctionOracle concatenation function for arrays.classOracleArrayConstructorFunctionclassOracleArrayContainsFunctionclassOracleArrayFillFunctionOracle array_fill function.classOracleArrayGetFunctionOracle array_get function.classOracleArrayIncludesFunctionclassOracleArrayIntersectsFunctionclassOracleArrayLengthFunctionclassOracleArrayPositionFunctionclassOracleArrayPositionsFunctionclassOracleArrayRemoveFunctionOracle array_remove function.classOracleArrayRemoveIndexFunctionOracle array_remove_index function.classOracleArrayReplaceFunctionOracle array_replace function.classOracleArraySetFunctionOracle array_set function.classOracleArraySliceFunctionOracle array_slice function.classOracleArrayToStringFunctionOracle array_to_string function.classOracleArrayTrimFunctionOracle array_trim function.classPostgreSQLArrayConcatElementFunctionPostgreSQL variant of the function to properly returnnullwhen the array argument is null.classPostgreSQLArrayConcatFunctionPostgreSQL variant of the function to properly returnnullwhen one of the arguments is null.classPostgreSQLArrayConstructorFunctionSpecial array constructor function that also applies a cast to the array literal, based on the inferred result type.classPostgreSQLArrayFillFunctionCustom casting for the array fill function.classPostgreSQLArrayPositionFunctionPostgreSQL variant of the function.classPostgreSQLArrayPositionsFunctionPostgreSQL variant of the function.classPostgreSQLArrayTrimEmulationPostgreSQL array_trim emulation, since the function was only introduced in version 14. -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.envers.function
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.envers.function Modifier and Type Class Description classOrderByFragmentFunctionEnvers specific FunctionContributor -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.query.sqm.function
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.query.sqm.function Modifier and Type Class Description classAbstractSqmSelfRenderingFunctionDescriptorclassJdbcEscapeFunctionDescriptorActs as a wrapper to anotherSqmFunctionDescriptor, rendering the standard JDBC escape sequence{fn f(x, y)}around the invocation syntax generated by its delegate.classMultipatternSqmFunctionDescriptorSupport for overloaded functions defined in terms of a list of patterns, one for each possible function arity.classNamedSqmFunctionDescriptorProvides a standard implementation that supports the majority of the HQL functions that are translated to SQL.classPatternBasedSqmFunctionDescriptorSupport 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 Modifier and Type Class Description classHANASpatialAggregateclassHANASpatialFunction -
Uses of AbstractSqmFunctionDescriptor in org.hibernate.spatial.dialect.oracle
Subclasses of AbstractSqmFunctionDescriptor in org.hibernate.spatial.dialect.oracle Modifier and Type Class Description classOracleSpatialFunctionclassOracleSpatialSQLMMFunctionclassSDOGetGeometryTypeclassSDOMethodDescriptorclassSDORelateFunctionclassSTRelateFunction
-