dehowef opened a new issue, #911:
URL: https://github.com/apache/age/issues/911
**Describe the bug**
The issue at hand is that when a user writes a standalone CASE statement, an
error is thrown because of how AGE handles booleans as PG type booleans.
**How are you accessing AGE (Command line, driver, etc.)?**
- [e.g. JDBC]
AGE via Postgres from the main development branch.
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('empty', $$ RETURN (CASE WHEN true THEN 1 END) $$) as
(a boolean);
```
```
ERROR: cannot cast agtype integer to type boolean
```
**Expected behavior**
RETURN (CASE WHEN true THEN 1 END) should return 1, as that would be the
result.
**Environment (please complete the following information):**
AGE 1.2.0 from the main branch as of 5/10/2023
**Additional context**
This issue was brought to my attention by @DominicWuest, who posted issue
875 re: CASE statement boolean interactions.
--
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-unsubscr...@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
