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)