Package org.teiid.translator
Class SourceSystemFunctions
- java.lang.Object
-
- org.teiid.translator.SourceSystemFunctions
-
public class SourceSystemFunctions extends Object
Constants for all the possible standard system push down functions. The names and function forms follow the Open Group CLI functions, with a few exceptions (such as lpad, rpad, bitand, bitor, etc. which are most notably supported by Oracle). Note that not all system functions are listed as some functions will use a common name such as CONCAT vs. the || operator, and other functions will be rewritten and not pushed down, such as SPACE.
-
-
Field Summary
-
Constructor Summary
Constructors Constructor Description SourceSystemFunctions()
-
-
-
Field Detail
-
MULTIPLY_OP
public static final String MULTIPLY_OP
- See Also:
- Constant Field Values
-
ADD_OP
public static final String ADD_OP
- See Also:
- Constant Field Values
-
SUBTRACT_OP
public static final String SUBTRACT_OP
- See Also:
- Constant Field Values
-
DIVIDE_OP
public static final String DIVIDE_OP
- See Also:
- Constant Field Values
-
ASCII
public static final String ASCII
- See Also:
- Constant Field Values
-
CHAR
public static final String CHAR
- See Also:
- Constant Field Values
-
CONCAT
public static final String CONCAT
- See Also:
- Constant Field Values
-
CONCAT2
public static final String CONCAT2
- See Also:
- Constant Field Values
-
INITCAP
public static final String INITCAP
- See Also:
- Constant Field Values
-
INSERT
public static final String INSERT
- See Also:
- Constant Field Values
-
LCASE
public static final String LCASE
- See Also:
- Constant Field Values
-
LPAD
public static final String LPAD
- See Also:
- Constant Field Values
-
LEFT
public static final String LEFT
- See Also:
- Constant Field Values
-
LENGTH
public static final String LENGTH
- See Also:
- Constant Field Values
-
LOCATE
public static final String LOCATE
- See Also:
- Constant Field Values
-
LTRIM
public static final String LTRIM
- See Also:
- Constant Field Values
-
REPEAT
public static final String REPEAT
- See Also:
- Constant Field Values
-
REGEXP_REPLACE
public static final String REGEXP_REPLACE
- See Also:
- Constant Field Values
-
REPLACE
public static final String REPLACE
- See Also:
- Constant Field Values
-
RIGHT
public static final String RIGHT
- See Also:
- Constant Field Values
-
RPAD
public static final String RPAD
- See Also:
- Constant Field Values
-
RTRIM
public static final String RTRIM
- See Also:
- Constant Field Values
-
SUBSTRING
public static final String SUBSTRING
- See Also:
- Constant Field Values
-
TO_BYTES
public static final String TO_BYTES
- See Also:
- Constant Field Values
-
TO_CHARS
public static final String TO_CHARS
- See Also:
- Constant Field Values
-
ENDSWITH
public static final String ENDSWITH
- See Also:
- Constant Field Values
-
TRIM
public static final String TRIM
The trim function is only used for a non-space trim character- See Also:
- Constant Field Values
-
UCASE
public static final String UCASE
- See Also:
- Constant Field Values
-
UNESCAPE
public static final String UNESCAPE
- See Also:
- Constant Field Values
-
ABS
public static final String ABS
- See Also:
- Constant Field Values
-
ACOS
public static final String ACOS
- See Also:
- Constant Field Values
-
ASIN
public static final String ASIN
- See Also:
- Constant Field Values
-
ATAN
public static final String ATAN
- See Also:
- Constant Field Values
-
ATAN2
public static final String ATAN2
- See Also:
- Constant Field Values
-
CEILING
public static final String CEILING
- See Also:
- Constant Field Values
-
COS
public static final String COS
- See Also:
- Constant Field Values
-
COT
public static final String COT
- See Also:
- Constant Field Values
-
DEGREES
public static final String DEGREES
- See Also:
- Constant Field Values
-
EXP
public static final String EXP
- See Also:
- Constant Field Values
-
FLOOR
public static final String FLOOR
- See Also:
- Constant Field Values
-
FORMATINTEGER
@Deprecated public static final String FORMATINTEGER
Deprecated.- See Also:
- Constant Field Values
-
FORMATLONG
@Deprecated public static final String FORMATLONG
Deprecated.- See Also:
- Constant Field Values
-
FORMATDOUBLE
@Deprecated public static final String FORMATDOUBLE
Deprecated.- See Also:
- Constant Field Values
-
FORMATFLOAT
@Deprecated public static final String FORMATFLOAT
Deprecated.- See Also:
- Constant Field Values
-
FORMATBIGINTEGER
@Deprecated public static final String FORMATBIGINTEGER
Deprecated.- See Also:
- Constant Field Values
-
FORMATBIGDECIMAL
public static final String FORMATBIGDECIMAL
- See Also:
- Constant Field Values
-
LOG
public static final String LOG
- See Also:
- Constant Field Values
-
LOG10
public static final String LOG10
- See Also:
- Constant Field Values
-
MOD
public static final String MOD
- See Also:
- Constant Field Values
-
PARSEINTEGER
@Deprecated public static final String PARSEINTEGER
Deprecated.- See Also:
- Constant Field Values
-
PARSELONG
@Deprecated public static final String PARSELONG
Deprecated.- See Also:
- Constant Field Values
-
PARSEDOUBLE
@Deprecated public static final String PARSEDOUBLE
Deprecated.- See Also:
- Constant Field Values
-
PARSEFLOAT
@Deprecated public static final String PARSEFLOAT
Deprecated.- See Also:
- Constant Field Values
-
PARSEBIGINTEGER
@Deprecated public static final String PARSEBIGINTEGER
Deprecated.- See Also:
- Constant Field Values
-
PARSEBIGDECIMAL
public static final String PARSEBIGDECIMAL
- See Also:
- Constant Field Values
-
PI
public static final String PI
- See Also:
- Constant Field Values
-
POWER
public static final String POWER
- See Also:
- Constant Field Values
-
RADIANS
public static final String RADIANS
- See Also:
- Constant Field Values
-
RAND
public static final String RAND
- See Also:
- Constant Field Values
-
ROUND
public static final String ROUND
- See Also:
- Constant Field Values
-
SIGN
public static final String SIGN
- See Also:
- Constant Field Values
-
SIN
public static final String SIN
- See Also:
- Constant Field Values
-
SQRT
public static final String SQRT
- See Also:
- Constant Field Values
-
TAN
public static final String TAN
- See Also:
- Constant Field Values
-
TRANSLATE
public static final String TRANSLATE
- See Also:
- Constant Field Values
-
TRUNCATE
public static final String TRUNCATE
- See Also:
- Constant Field Values
-
BITAND
public static final String BITAND
- See Also:
- Constant Field Values
-
BITOR
public static final String BITOR
- See Also:
- Constant Field Values
-
BITNOT
public static final String BITNOT
- See Also:
- Constant Field Values
-
BITXOR
public static final String BITXOR
- See Also:
- Constant Field Values
-
CURDATE
public static final String CURDATE
- See Also:
- Constant Field Values
-
CURTIME
public static final String CURTIME
- See Also:
- Constant Field Values
-
DAYNAME
public static final String DAYNAME
- See Also:
- Constant Field Values
-
DAYOFMONTH
public static final String DAYOFMONTH
- See Also:
- Constant Field Values
-
DAYOFWEEK
public static final String DAYOFWEEK
- See Also:
- Constant Field Values
-
DAYOFYEAR
public static final String DAYOFYEAR
- See Also:
- Constant Field Values
-
FORMATTIMESTAMP
public static final String FORMATTIMESTAMP
- See Also:
- Constant Field Values
-
HOUR
public static final String HOUR
- See Also:
- Constant Field Values
-
MINUTE
public static final String MINUTE
- See Also:
- Constant Field Values
-
MODIFYTIMEZONE
public static final String MODIFYTIMEZONE
- See Also:
- Constant Field Values
-
MONTH
public static final String MONTH
- See Also:
- Constant Field Values
-
MONTHNAME
public static final String MONTHNAME
- See Also:
- Constant Field Values
-
NOW
public static final String NOW
- See Also:
- Constant Field Values
-
PARSETIMESTAMP
public static final String PARSETIMESTAMP
- See Also:
- Constant Field Values
-
QUARTER
public static final String QUARTER
- See Also:
- Constant Field Values
-
EPOCH
public static final String EPOCH
- See Also:
- Constant Field Values
-
SECOND
public static final String SECOND
- See Also:
- Constant Field Values
-
TIMESTAMPADD
public static final String TIMESTAMPADD
- See Also:
- Constant Field Values
-
TIMESTAMPCREATE
public static final String TIMESTAMPCREATE
- See Also:
- Constant Field Values
-
TIMESTAMPDIFF
public static final String TIMESTAMPDIFF
- See Also:
- Constant Field Values
-
WEEK
public static final String WEEK
- See Also:
- Constant Field Values
-
YEAR
public static final String YEAR
- See Also:
- Constant Field Values
-
FROM_UNIXTIME
public static final String FROM_UNIXTIME
- See Also:
- Constant Field Values
-
UNIX_TIMESTAMP
public static final String UNIX_TIMESTAMP
- See Also:
- Constant Field Values
-
TO_MILLIS
public static final String TO_MILLIS
- See Also:
- Constant Field Values
-
IFNULL
public static final String IFNULL
- See Also:
- Constant Field Values
-
COALESCE
public static final String COALESCE
- See Also:
- Constant Field Values
-
NULLIF
public static final String NULLIF
- See Also:
- Constant Field Values
-
ARRAY_GET
public static final String ARRAY_GET
- See Also:
- Constant Field Values
-
ARRAY_LENGTH
public static final String ARRAY_LENGTH
- See Also:
- Constant Field Values
-
CONVERT
public static final String CONVERT
- See Also:
- Constant Field Values
-
XPATHVALUE
public static final String XPATHVALUE
- See Also:
- Constant Field Values
-
XSLTRANSFORM
public static final String XSLTRANSFORM
- See Also:
- Constant Field Values
-
XMLCONCAT
public static final String XMLCONCAT
- See Also:
- Constant Field Values
-
XMLCOMMENT
public static final String XMLCOMMENT
- See Also:
- Constant Field Values
-
XMLPI
public static final String XMLPI
- See Also:
- Constant Field Values
-
JSONTOXML
public static final String JSONTOXML
- See Also:
- Constant Field Values
-
JSONPATHVALUE
public static final String JSONPATHVALUE
- See Also:
- Constant Field Values
-
JSONQUERY
public static final String JSONQUERY
- See Also:
- Constant Field Values
-
JSONTOARRAY
public static final String JSONTOARRAY
- See Also:
- Constant Field Values
-
UUID
public static final String UUID
- See Also:
- Constant Field Values
-
MD5
public static final String MD5
- See Also:
- Constant Field Values
-
SHA1
public static final String SHA1
- See Also:
- Constant Field Values
-
SHA2_256
public static final String SHA2_256
- See Also:
- Constant Field Values
-
SHA2_512
public static final String SHA2_512
- See Also:
- Constant Field Values
-
AES_ENCRYPT
public static final String AES_ENCRYPT
- See Also:
- Constant Field Values
-
AES_DECRYPT
public static final String AES_DECRYPT
- See Also:
- Constant Field Values
-
ST_ASTEXT
public static final String ST_ASTEXT
- See Also:
- Constant Field Values
-
ST_ASEWKT
public static final String ST_ASEWKT
- See Also:
- Constant Field Values
-
ST_ASBINARY
public static final String ST_ASBINARY
- See Also:
- Constant Field Values
-
ST_ASGEOJSON
public static final String ST_ASGEOJSON
- See Also:
- Constant Field Values
-
ST_ASGML
public static final String ST_ASGML
- See Also:
- Constant Field Values
-
ST_ASKML
public static final String ST_ASKML
- See Also:
- Constant Field Values
-
ST_GEOMFROMTEXT
public static final String ST_GEOMFROMTEXT
- See Also:
- Constant Field Values
-
ST_GEOMFROMWKB
public static final String ST_GEOMFROMWKB
- See Also:
- Constant Field Values
-
ST_GEOMFROMGEOJSON
public static final String ST_GEOMFROMGEOJSON
- See Also:
- Constant Field Values
-
ST_GEOMFROMGML
public static final String ST_GEOMFROMGML
- See Also:
- Constant Field Values
-
ST_INTERSECTS
public static final String ST_INTERSECTS
- See Also:
- Constant Field Values
-
ST_INTERSECTION
public static final String ST_INTERSECTION
- See Also:
- Constant Field Values
-
ST_CONTAINS
public static final String ST_CONTAINS
- See Also:
- Constant Field Values
-
ST_CROSSES
public static final String ST_CROSSES
- See Also:
- Constant Field Values
-
ST_DISJOINT
public static final String ST_DISJOINT
- See Also:
- Constant Field Values
-
ST_DISTANCE
public static final String ST_DISTANCE
- See Also:
- Constant Field Values
-
ST_OVERLAPS
public static final String ST_OVERLAPS
- See Also:
- Constant Field Values
-
ST_TOUCHES
public static final String ST_TOUCHES
- See Also:
- Constant Field Values
-
ST_SRID
public static final String ST_SRID
- See Also:
- Constant Field Values
-
ST_SETSRID
public static final String ST_SETSRID
- See Also:
- Constant Field Values
-
ST_EQUALS
public static final String ST_EQUALS
- See Also:
- Constant Field Values
-
ST_TRANSFORM
public static final String ST_TRANSFORM
- See Also:
- Constant Field Values
-
ST_SIMPLIFY
public static final String ST_SIMPLIFY
- See Also:
- Constant Field Values
-
ST_SIMPLIFYPRESERVETOPOLOGY
public static final String ST_SIMPLIFYPRESERVETOPOLOGY
- See Also:
- Constant Field Values
-
ST_FORCE_2D
public static final String ST_FORCE_2D
- See Also:
- Constant Field Values
-
ST_ENVELOPE
public static final String ST_ENVELOPE
- See Also:
- Constant Field Values
-
ST_WITHIN
public static final String ST_WITHIN
- See Also:
- Constant Field Values
-
ST_DWITHIN
public static final String ST_DWITHIN
- See Also:
- Constant Field Values
-
ST_EXTENT
public static final String ST_EXTENT
- See Also:
- Constant Field Values
-
ST_HASARC
public static final String ST_HASARC
- See Also:
- Constant Field Values
-
DOUBLE_AMP_OP
public static final String DOUBLE_AMP_OP
- See Also:
- Constant Field Values
-
ST_GEOMFROMEWKT
public static final String ST_GEOMFROMEWKT
- See Also:
- Constant Field Values
-
ST_ASEWKB
public static final String ST_ASEWKB
- See Also:
- Constant Field Values
-
ST_GEOMFROMEWKB
public static final String ST_GEOMFROMEWKB
- See Also:
- Constant Field Values
-
ST_AREA
public static final String ST_AREA
- See Also:
- Constant Field Values
-
ST_BOUNDARY
public static final String ST_BOUNDARY
- See Also:
- Constant Field Values
-
ST_BUFFER
public static final String ST_BUFFER
- See Also:
- Constant Field Values
-
ST_CENTROID
public static final String ST_CENTROID
- See Also:
- Constant Field Values
-
ST_CONVEXHULL
public static final String ST_CONVEXHULL
- See Also:
- Constant Field Values
-
ST_COORDDIM
public static final String ST_COORDDIM
- See Also:
- Constant Field Values
-
ST_CURVETOLINE
public static final String ST_CURVETOLINE
- See Also:
- Constant Field Values
-
ST_DIFFERENCE
public static final String ST_DIFFERENCE
- See Also:
- Constant Field Values
-
ST_DIMENSION
public static final String ST_DIMENSION
- See Also:
- Constant Field Values
-
ST_ENDPOINT
public static final String ST_ENDPOINT
- See Also:
- Constant Field Values
-
ST_EXTERIORRING
public static final String ST_EXTERIORRING
- See Also:
- Constant Field Values
-
ST_GEOMETRYN
public static final String ST_GEOMETRYN
- See Also:
- Constant Field Values
-
ST_GEOMETRYTYPE
public static final String ST_GEOMETRYTYPE
- See Also:
- Constant Field Values
-
ST_INTERIORRINGN
public static final String ST_INTERIORRINGN
- See Also:
- Constant Field Values
-
ST_ISCLOSED
public static final String ST_ISCLOSED
- See Also:
- Constant Field Values
-
ST_ISEMPTY
public static final String ST_ISEMPTY
- See Also:
- Constant Field Values
-
ST_ISRING
public static final String ST_ISRING
- See Also:
- Constant Field Values
-
ST_ISSIMPLE
public static final String ST_ISSIMPLE
- See Also:
- Constant Field Values
-
ST_ISVALID
public static final String ST_ISVALID
- See Also:
- Constant Field Values
-
ST_LENGTH
public static final String ST_LENGTH
- See Also:
- Constant Field Values
-
ST_NUMGEOMETRIES
public static final String ST_NUMGEOMETRIES
- See Also:
- Constant Field Values
-
ST_NUMINTERIORRINGS
public static final String ST_NUMINTERIORRINGS
- See Also:
- Constant Field Values
-
ST_NUMPOINTS
public static final String ST_NUMPOINTS
- See Also:
- Constant Field Values
-
ST_ORDERINGEQUALS
public static final String ST_ORDERINGEQUALS
- See Also:
- Constant Field Values
-
ST_PERIMETER
public static final String ST_PERIMETER
- See Also:
- Constant Field Values
-
ST_POINT
public static final String ST_POINT
- See Also:
- Constant Field Values
-
ST_POINTN
public static final String ST_POINTN
- See Also:
- Constant Field Values
-
ST_POINTONSURFACE
public static final String ST_POINTONSURFACE
- See Also:
- Constant Field Values
-
ST_POLYGON
public static final String ST_POLYGON
- See Also:
- Constant Field Values
-
ST_RELATE
public static final String ST_RELATE
- See Also:
- Constant Field Values
-
ST_STARTPOINT
public static final String ST_STARTPOINT
- See Also:
- Constant Field Values
-
ST_SYMDIFFERENCE
public static final String ST_SYMDIFFERENCE
- See Also:
- Constant Field Values
-
ST_UNION
public static final String ST_UNION
- See Also:
- Constant Field Values
-
ST_X
public static final String ST_X
- See Also:
- Constant Field Values
-
ST_Y
public static final String ST_Y
- See Also:
- Constant Field Values
-
ST_Z
public static final String ST_Z
- See Also:
- Constant Field Values
-
ST_MAKEENVELOPE
public static final String ST_MAKEENVELOPE
- See Also:
- Constant Field Values
-
ST_SNAPTOGRID
public static final String ST_SNAPTOGRID
- See Also:
- Constant Field Values
-
ST_GEOGFROMWKB
public static final String ST_GEOGFROMWKB
- See Also:
- Constant Field Values
-
ST_GEOGFROMTEXT
public static final String ST_GEOGFROMTEXT
- See Also:
- Constant Field Values
-
-