You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "YGY-001 (via GitHub)" <gi...@apache.org> on 2026/08/20 14:53:18 UTC

[I] CASE WHEN IS NULL THEN null ELSE END` fails with a boolean type error [age]

YGY-001 opened a new issue, #2525:
URL: https://github.com/apache/age/issues/2525

   Docker image `apache/age:release_PG18_1.7.0
   
   **Reproduction**
   
   ```sql
   LOAD 'age';
   SET search_path = ag_catalog, public;
   SELECT ag_catalog.create_graph('age_issue_case1');
   
   SELECT *
   FROM ag_catalog.cypher('age_issue_case1', $$
   UNWIND ['GU'] AS alias0
   WITH max(toFloat(1)) AS alias2, avg(toFloat(1)) AS alias3
   WITH CASE WHEN alias2 IS NULL THEN null ELSE alias2 END AS alias2,
        CASE WHEN alias3 IS NULL THEN null ELSE alias3 END AS alias3
   RETURN {alias2: alias2, alias3: alias3} AS result
   $$) AS (result agtype);
   ```
   
   **Expected**
   
   One row containing the two numeric aggregate values.
   
   **Actual**
   
   ```text
   CASE/ELSE could not convert type double precision to boolean
   ```


-- 
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


Re: [I] CASE WHEN IS NULL THEN null ELSE END` fails with a boolean type error [age]

Posted by "gregfelice (via GitHub)" <gi...@apache.org>.
gregfelice commented on issue #2525:
URL: https://github.com/apache/age/issues/2525#issuecomment-5370015439

   Confirmed still reproducing on current master (`4d9b2506`, AGE 1.8.0) built against PostgreSQL 18.4, in a fresh database:
   
   ```
   ERROR:  CASE/ELSE could not convert type double precision to boolean
   LINE 6:      CASE WHEN alias3 IS NULL THEN null ELSE alias3 END AS a...
   ```
   
   Triaged as part of a sweep over the current fuzz-report backlog against master. This one is a clean error rather than a crash — recording it so it is not assumed stale just because it was filed against an older image.
   


-- 
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