Class QueryPlan.FunctionalSelectNode

  • All Implemented Interfaces:
    QueryPlanNode, java.io.Serializable, java.lang.Cloneable
    Enclosing class:
    QueryPlan

    public static class QueryPlan.FunctionalSelectNode
    extends QueryPlan.SingleQueryPlanNode
    The node for performing a functional select operation on the child node. Some examples of this type of query are; CONCAT(a, ' ', b) > 'abba boh' TONUMBER(DATEFORMAT(a, 'yyyy')) > 2001 LOWER(a) < 'ook' The reason this is a separate node is because it is possible to exploit a functional indexes on a table with this node.

    The given expression MUST be of the form; 'function_expression' 'operator' 'constant'

    See Also:
    Serialized Form