Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


MySQL HeatWave User Guide  /  ...  /  Control Flow Functions and Operators

2.11.5 Control Flow Functions and Operators

The following table shows supported control flow operators. The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. See Section 2.7.1, “Encoding String Columns”.

Table 2.5 Control Flow Functions and Operators

Name VARLEN Support Description
CASE Yes Case operator
IF() Yes If/else construct
IFNULL() Yes Null if/else construct
NULLIF() Yes Return NULL if expr1 = expr2