Messages associated with SQLSTATE 42V25

This topic lists the messages associated with the SQLSTATE 42V25.

This topic lists the messages associated with the SQLSTATE 42V25.

SQLSTATE 42V25 description

PATTERN_MATCH_ERROR

Messages associated with this SQLState

ERROR 2227: Argument to test_pattern_event_eval must be > 0 and less
            than the total number of events
ERROR 2228: Argument to test_pattern_event_eval must be a constant
ERROR 2553: Cannot use more than one pattern
ERROR 2555: Cannot use pattern test functions with pattern match
            functions
ERROR 3025: Defining more than 52 events is not supported
ERROR 3288: Event "string" in PATTERN clause is not defined in the DEFINE
            clause
ERROR 3289: Event ANY_ROW cannot be used under *, +, ?, or | when the
            select list contains the pattern function event_name()
ERROR 3290: Event ANY_ROW is a reserved event and cannot be user
            defined
ERROR 3294: Event expressions cannot contain analytic functions
ERROR 3295: Event expressions cannot contain correlated expressions
ERROR 3296: Event expressions cannot contain subqueries
ERROR 3297: Event name "string" defined more than once
ERROR 4353: Pattern events must be mutually exclusive
ERROR 4354: Pattern match query cannot contain having clause, group
            clause, aggregates, or distinct
ERROR 4355: Pattern match query cannot contain timeseries clause
ERROR 4356: Pattern matching recursion limit reached
ERROR 4358: PatternMatchingMaxPartition must be greater than 0
ERROR 4359: PatternMatchingMaxPartitionMatches must be greater than 0
ERROR 4360: PatternMatchingPerMatchWorkspaceSize must be greater than
            0 and less than 1024
ERROR 4494: Queries with user-defined transform functions (string) cannot
            have a MATCH clause
ERROR 4507: Query with analytic function string cannot have a MATCH clause
ERROR 4509: Query with pattern matching function string must include a
            MATCH clause
ERROR 4605: RESULTS GROUPED BY MATCH is not supported
ERROR 5283: Unsupported pattern operator
ERROR 7607: Pattern matching DFA Algorithm work space size limit
            reached
ERROR 8585: Pattern matching just-in-time processing stack memory
            limit reached