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)
