[jira] [Updated] (HAWQ-355) order by problem: sorting varchar column with space is not correct.

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang updated HAWQ-355:
---------------------------
    Fix Version/s: backlog

> order by problem: sorting varchar column with space is not correct.
> -------------------------------------------------------------------
>
>                 Key: HAWQ-355
>                 URL: https://issues.apache.org/jira/browse/HAWQ-355
>             Project: Apache HAWQ
>          Issue Type: Bug
>            Reporter: SuperJDC
>            Assignee: Lei Chang
>             Fix For: backlog
>
>
> Firstly, my hawq download from official website:  https://network.pivotal.io/products/pivotal-hdb, a released stable version. 
> My steps:
> DROP TABLE IF EXISTS testorder;
> CREATE TABLE testorder(
> 	ss VARCHAR(10)
> ) distributed randomly;
> INSERT INTO testorder 
> VALUES ('cc'), ('c c'), ('cc'), 
> ('aa'), ('a a'), ('ac'), 
> ('b c'), ('bc'), ('bb');
> SELECT ss FROM testorder 
> ORDER BY ss;
> The result:
> aa
> a a
> ac
> bb
> bc
> b c
> cc
> cc
> c c
> It seems that when a colum has a space char, the sorted result would been not correct.
> I followed the document steps and successfully integrated with the ambari. All of hawq configurations are the default.
> Thanks!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)