[jira] [Created] (PHOENIX-7283) select cast as char does not return the n number of characters as char(n)

[Nikita Pande (Jira)]

Nikita Pande created PHOENIX-7283:
-------------------------------------

             Summary: select cast as char does not return the n number of 
characters as char(n)
                 Key: PHOENIX-7283
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7283
             Project: Phoenix
          Issue Type: Bug
            Reporter: Nikita Pande
         Attachments: Screenshot 2024-03-17 at 11.12.25 PM.png

Currently phoenix returns cast result as the complete string instead of n 
number of characters passed

eg

0: jdbc:phoenix:>  select cast('asdf'  as char(2)) ;

+-----------------+

| TO_CHAR('asdf') |

+-----------------+

| asdf            |

+-----------------+

 

Whereas in MySQL

```

SELECT cast('asdf' as char(2));
Number of Records: 1
||cast('asdf' as char(2))||
|as|

```



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