[
https://issues.apache.org/jira/browse/PHOENIX-7283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Pande updated PHOENIX-7283:
----------------------------------
Description:
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|
was:
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|
```
> 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
> Priority: Major
> 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)
