You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "dehowef (via GitHub)" <gi...@apache.org> on 2023/05/10 20:10:30 UTC
[GitHub] [age] dehowef opened a new issue, #911: Unexpected behavior in CASE statements due to booleans in AGE (Related: #875)
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-unsubscribe@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] dehowef commented on issue #911: Unexpected behavior in CASE statements due to booleans in AGE (Related: #875)
Posted by "dehowef (via GitHub)" <gi...@apache.org>.
dehowef commented on issue #911:
URL: https://github.com/apache/age/issues/911#issuecomment-1542751431
This issue was prematurely created by mistake
--
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
[GitHub] [age] dehowef closed issue #911: Unexpected behavior in CASE statements due to booleans in AGE (Related: #875)
Posted by "dehowef (via GitHub)" <gi...@apache.org>.
dehowef closed issue #911: Unexpected behavior in CASE statements due to booleans in AGE (Related: #875)
URL: https://github.com/apache/age/issues/911
--
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