KFAA34004-E
A regular expression specified for a regular expression string that has the "LIKE_REGEX" predicate is incorrect. (details = aa....aa) (M+J+O)
A regular expression specified for a regular expression character string in the LIKE_REGEX predicate is invalid.
- aa....aa: Cause of the error
-
-
Invalid regular expression: The specified regular expression is invalid. <SQLSTATE: 428T3>
-
Invalid quantifier: The specified quantifier (such as + and *) is invalid. <SQLSTATE: 428T4>
-
Unmatched parenthesis: Pairing of parentheses is invalid. <SQLSTATE: 428T5>
-
Unmatched square bracket: Pairing of square brackets is invalid. <SQLSTATE: 428T6>
-
- S:
-
Ignores this SQL statement.
- Action:
-
The possible errors are as follows.
▪ If aa....aa is Invalid regular expression:
-
A special character in character enumeration might be invalid.
-
An undefined character set identifier might be specified in a character set identifier specification.
▪ If aa....aa is Invalid quantifier:
-
Two quantifiers might be specified in succession.
-
The specified repetition factor might contain the following errors:
- Values other than numeric values might be specified for the maximum and minimum values (for example, a comma specification error or missing closing parenthesis).
- The following condition might not be satisfied: 0 ≤ lower limit ≤ upper limit ≤ 256.
■ If aa....aa is Unmatchedparenthesis:
-
The right parenthesis ()) corresponding to the left parenthesis (() might not be specified.
■ If aa....aa is Unmatchedsquare bracket:
-
A right square bracket (]) might not be specified after a left square bracket ([).
-
A right curly bracket (}) might be specified in an inappropriate position.
-
A right square bracket (]) might be specified in an inappropriate position.
For details about the rules for specifying regular expressions, see LIKE_REGEX predicate in the manual HADB SQL Reference.
-