phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <>
Subject [jira] [Created] (PHOENIX-1145) Ensure CHAR type meets SQL standard
Date Tue, 05 Aug 2014 06:22:11 GMT
James Taylor created PHOENIX-1145:

             Summary: Ensure CHAR type meets SQL standard
                 Key: PHOENIX-1145
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor

Phoenix pads CHAR type values with space characters. This can lead to odd results if a character
smaller than a space is used. In addition, our comparison logic ignores trailing spaces, but
there may be issues with this approach. See this Postgres thread:

In addition, CHAR only supports single byte characters as we assume that each CHAR is a one
byte to calculate offsets.

We should investigate making CHAR more conformant.

This message was sent by Atlassian JIRA

View raw message