WebFOCUS Hyperstage Optimizer Supported Functions and Operators

In this section:



x
Comparison Functions and Operators

Equal =

YES

Null safe equal <= >

No (MySQL engine)

Not equal <> , !=

YES

Less than or equal <=

YES

Less than <

YES

Greater than >

YES

Greater than or equal >=

YES

IS

No (MySQL engine)

IS NOT

No (MySQL engine)

IS NULL

YES

IS NOT NULL

YES

BETWEEN … AND …

YES (except in JOIN conditions)

NOT BETWEEN … AND ...

YES

COALESCE

YES

GREATEST

No (MySQL engine)

IN

YES

NOT IN

YES

ISNULL

YES

INTERVAL

No (MySQL engine)

LEAST

No (MySQL engine)



x
Logical Operators

NOT, !

YES (except in join conditions)

AND, &&

YES

OR, | |

YES

XOR

No (MySQL engine)



x
Control Flow Functions

CASE

YES

IF

YES

IFNULL

YES

NULLIF

YES



x
String Functions

ASCII

YES

BIN

YES

BIT_LENGTH

YES

CHAR

No (MySQL engine)

CHAR_LENGTH

YES

CHARACTER_LENGTH

YES

CONCAT

YES

CONCAT_WS

YES

CONV

YES

ELT

YES

EXPORT_SET

YES

FIELD

YES

FIND_IN_SET

YES

FORMAT

YES

HEX

YES

INSTR

YES

LCASE

YES

LEFT

YES

LENGTH

YES

LOAD_FILE

No (MySQL engine)

LOCATE

YES

LOWER

YES

LPAD

YES

LTRIM

YES

MAKE_SET

YES

MID

YES

OCT

YES

OCTET_LENGTH

YES

ORD

YES

POSITION

YES

QUOTE

YES

REPEAT

YES

REPLACE

YES

REVERSE

YES

RIGHT

YES

RPAD

YES

RTRIM

YES

SOUNDEX

YES

SOUNDS LIKE

No (MySQL engine)

SPACE

YES

SUBSTR

YES

SUBSTRING

YES

SUBSTRING_INDEX

YES

TRIM

YES

UCASE

YES

UNHEX

No (MySQL engine)

UPPER

YES



x
String Comparison Functions

LIKE

YES

NOT LIKE

YES

RLIKE

YES

REGEXP

YES

NOT REGEXP

YES

STRCMP

YES



x
Numeric Functions

Addition ( + )

YES

Subtraction ( - )

YES

Multiplication ( * )

YES

Division ( / )

YES

Modulo ( % )

YES

ABS

YES

ACOS

YES

ASIN

YES

ATAN2, ATAN

YES

ATAN

YES

CEIL

YES

CEILING

YES

CONV

YES

COS

YES

COT

YES

DEGREES

YES

EXP

YES

FLOOR

YES

LN

YES

LOG10

YES

LOG2

YES

LOG

YES

MOD

YES

OCT

YES

PI

YES

POW

YES

POWER

YES

RADIANS

YES

RAND

YES

ROUND

YES

SIGN

YES

SIN

YES

SQRT

YES

TAN

YES

TRUNCATE

YES

 

 

 



x
Date and Time Functions

ADDDATE

YES

ADDTIME

YES

CURDATE

YES

CURRENT_DATE

YES

CURRENT_TIME

YES

CURRENT_TIMESTAMP

YES

CURTIME

YES

DATE

YES

DATEDIFF

YES

DATE_ADD

YES

DATE_FORMAT

YES

DATE_SUB

YES

DAY

YES

DAYNAME

YES

DAYOFMONTH

YES

DAYOFWEEK

YES

DAYOFYEAR

YES

EXTRACT

YES

FROM_DAYS

No (MySQL engine)

FROM_UNIXTIME

YES

GET_FORMAT

No (MySQL engine)

HOUR

YES

LAST_DAY

No (MySQL engine)

LOCALTIME

YES

LOCALTIMESTAMP

YES

MAKEDATE

No (MySQL engine)

MAKETIME

No (MySQL engine)

MICROSECOND

No (MySQL engine)

MINUTE

YES

MONTH

YES

MONTHNAME

YES

NOW

YES

PERIOD_ADD

YES

PERIOD_DIFF

YES

QUARTER

YES

SECOND

YES

SEC_TO_TIME

No (MySQL engine)

STR_TO_DATE

No (MySQL engine)

SUBDATE

YES

SUBTIME

YES

SYSDATE

YES

TIME

YES

TIMEDIFF

YES

TIMESTAMP

No (MySQL engine)

TIMESTAMPADD

No (MySQL engine)

TIMESTAMPDIFF

No (MySQL engine)

TIME_FORMAT

YES

TIME_TO_SEC

No (MySQL engine)

TO_DAYS

YES

UNIX_TIMESTAMP

YES

UTC_DATE

YES

UTC_TIME

YES

UTC_TIMESTAMP

No (MySQL engine)

WEEK

YES

WEEKDAY

No (MySQL engine)

WEEKOFYEAR

No (MySQL engine)

YEAR

No (MySQL engine)

YEARWEEK

YES



x
Text Search and Other Functions

BINARY

No (MySQL engine)

CAST

YES

CONVERT

YES

MATCH

No (MySQL engine)

Bit Functions

No (MySQL engine)

Encryption, Compression Functions

No (MySQL engine)

Information Functions

No (MySQL engine)



x
Group By Aggregate Functions

AVG

YES

BIT_OR

No (MySQL engine)

BIT_AND

No (MySQL engine)

BIT_XOR

No (MySQL engine)

COUNT

YES

GROUP_CONCAT

No (MySQL engine)

MIN

YES

MAX

YES

STD, STDDEV

YES

STDDEV_POP

YES

STDDEV_SAMP

YES

SUM

YES

VAR_POP

YES

VAR_SAMP

YES

VARIANCE

YES



x
Group By Modifiers

ROLLUP

No (error signalled)


WebFOCUS