Hitachi

Hitachi Advanced Database Messages


KFAA30401-E

The data types of both operands specified in predicate "aa....aa" are not compatible. (query number = bb....bb) (M+J+O)

The data types of the results of the value expressions specified in predicate aa....aa cannot be compared to each other or converted. <SQLSTATE: 42801>

aa....aa: Type of predicate
  • BETWEEN: A BETWEEN predicate

  • COMPARISON: A comparison predicate

  • IN: An IN predicate

  • LIKE: LIKE predicate

  • LIKE_REGEX: LIKE_REGEX predicate

  • QUANTIFIED: A quantified predicate

bb....bb: Position number of the query that specified aa....aa

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.