[ 
https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jiajun Xie updated CALCITE-6091:
--------------------------------
    Affects Version/s:     (was: 1.34.0)
                           (was: 1.35.0)
          Description: 
{code:java}
select case when true then array('abc')
            when false then array('d') end as c {code}
The sql result type is `CHAR(1) ARRAY`.

If we use the CHAR(1), `array('abc')` will be truncated.

> Char that in array is truncated in CASE WHEN statement
> ------------------------------------------------------
>
>                 Key: CALCITE-6091
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6091
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Jiajun Xie
>            Assignee: Jiajun Xie
>            Priority: Major
>
> {code:java}
> select case when true then array('abc')
>             when false then array('d') end as c {code}
> The sql result type is `CHAR(1) ARRAY`.
> If we use the CHAR(1), `array('abc')` will be truncated.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to