phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
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
                 URL: https://issues.apache.org/jira/browse/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: http://postgresql.1045698.n5.nabble.com/String-comparison-and-the-SQL-standard-td5740721.html

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
(v6.2#6252)

Mime
View raw message