Support for Item Types

Table 1 lists the item types supported by KOVAE. Other item types are not supported so far.

Table 2 lists the functions supported by KOVAE. Other functions are not supported so far.

**Table 2** Supported functions
Function	Description
+	Addition, arithmetic operations
-	Subtraction, arithmetic operations
*	Multiplication, arithmetic operations
/	Division, arithmetic operations
>	Greater than, assertion
<	Less than, assertion
=	Equal to, assertion
<>	Not equal to, assertion
>=	Greater than or equal to, assertion
<=	Less than or equal to, assertion
like	Substring match
and	AND, logical operation
or	OR, logical operation
sum	Summation
avg	Average
count	Count
min	Minimum value
date_literal	Date literal
between...and...	Between
case	Enumeration processing of CASE THEN
IN	In
not	Negation
isnull	Null or not
substr	Substring of a character string
date	Forcible conversion to the date type
date_add	Date addition
year	Extracting year from data
timestamp	Forcible conversion to the timestamp type
cast	Forcible conversion to a specified type
extract	Extracting a specific part of the date

Parent topic: Support for Execution Plans