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

[SuperJDC (JIRA)]

SuperJDC created HAWQ-355:
-----------------------------

             Summary: 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


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)