[GitHub] [age] humzakt commented on issue #875: Unexpected Error: `CASE` types agtype and boolean cannot be matched

["humzakt (via GitHub)" <gi...@apache.org>]

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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org