Error Messages Associated with SQLSTATE 42V25

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

SQLSTATE 42V25 Description

ERRCODE_PATTERN_MATCH_ERROR

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