[
https://issues.apache.org/jira/browse/PHOENIX-122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13932928#comment-13932928
]
Hudson commented on PHOENIX-122:
--------------------------------
SUCCESS: Integrated in Apache Phoenix - Branch:master #134 (See
[https://builds.apache.org/job/Phoenix/134/])
PHOENIX-122 SELECT * FROM TABLE ORDER BY NONPK COLUMN doesn't return values for
all the columns(Anoop) (anoopsamjohn: rev
2e5e647fccf0a36948c6e3a51afeb5e248e0cd73)
* phoenix-core/src/main/java/org/apache/phoenix/compile/ProjectionCompiler.java
*
phoenix-core/src/test/java/org/apache/phoenix/end2end/ColumnProjectionOptimizationTest.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java
> 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
> Assignee: Anoop Sam John
> Priority: Critical
> Attachments: PHOENIX-122.patch, PHOENIX-122_V2.patch
>
>
> 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)
