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
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.