humzakt commented on issue #875:
URL: https://github.com/apache/age/issues/875#issuecomment-1535185669
The error message "CASE types agtype and boolean cannot be matched" suggests
that there may be an issue with the data types being used in your CASE
statement. The CASE statement is used to conditionally return a value based on
a set of conditions, and all values returned by the CASE statement must have
the same data type.
It's possible that the true values being used in your CASE statement are
being interpreted as Agtype values instead of boolean values. Agtype is a data
type used in Apache AGE to represent nested JSON-like data structures. If the
true values are being interpreted as Agtype values, this could cause a data
type mismatch when evaluating the AND operator.
To resolve this issue, you can try the following steps:
1. Check that the true values being used in your CASE statement are being
interpreted as boolean values. You can do this by explicitly casting the values
to boolean using the ::boolean operator:
`RETURN (CASE WHEN true THEN (true::boolean AND true::boolean) END)`
2. If the true values are being interpreted as Agtype values, you can try
explicitly casting them to boolean using the agtype_to_bool function:
`RETURN (CASE WHEN agtype_to_bool('true') THEN (agtype_to_bool('true') AND
agtype_to_bool('true')) END)`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
