KFAA34004-E

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.