phoenix-dev mailing list archives

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


James Taylor commented on PHOENIX-1145:

Thanks for the comment, [~cartershanklin]. Yes, our CHAR type handles all of these cases.

> Ensure CHAR type meets SQL standard
> -----------------------------------
>                 Key: PHOENIX-1145
>                 URL:
>             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