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)
