[
https://issues.apache.org/jira/browse/PHOENIX-122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sam John updated PHOENIX-122:
-----------------------------------
Attachment: PHOENIX-122_V2.patch
Solving one more issue with adding where condition columns into Scan. Pls review
> 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)
