[jira] [Created] (PHOENIX-122) SELECT * FROM TABLE ORDER BY NONPK COLUMN doesn't return values for all the columns

["Samarth Jain (JIRA)" <ji...@apache.org>]

Samarth Jain created PHOENIX-122:
------------------------------------

             Summary: SELECT * FROM TABLE ORDER BY NONPK COLUMN doesn't return values for all the columns
                 Key: PHOENIX-122
                 URL: https://issues.apache.org/jira/browse/PHOENIX-122
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 3.0.0
            Reporter: Samarth Jain


CREATE TABLE TEST 
(TEXT VARCHAR, 
INT INTEGER, 
DOUBLE DECIMAL,
CDATE DATE
CONSTRAINT PK PRIMARY KEY
(Text
)
)

UPSERT INTO TEST VALUES ('A', 1, 4.92, current_date())
UPSERT INTO TEST VALUES ('B', 2, 3.69,current_date())
UPSERT INTO TEST VALUES ('C', 3, 2.46,current_date())
UPSERT INTO TEST VALUES ('D', 4, 1.23,current_date())        

SELECT * FROM TEST

A	1	4.92	   2014-03-07
B	2	3.69	   2014-03-07
C	3	2.46	   2014-03-07
D	4	1.23    2014-03-07


SELECT * FROM TEST ORDER BY DOUBLE

TEXT	INT	 DOUBLE 	CDATE
D	      <null>  1.23	       <null>
C	      <null>	  2.46	       <null>
B	      <null>   3.69	       <null>
A	       <null>  4.92              <null>

As you can see, when ordering by a non-pk column, it only displays the PK column Text and the column in order by clause.


When doing an order by a PK column, it displays the records correctly.

select * from test order by TEXT

TEXT	INT	DOUBLE	CDATE
D	          4	1.23	       2014-03-07
C	          3	2.46	       2014-03-07
B	          2	3.69	       2014-03-07
A	          1	4.92        2014-03-07






--
This message was sent by Atlassian JIRA
(v6.2#6252)