[
https://issues.apache.org/jira/browse/PHOENIX-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-1848:
----------------------------------
Description:
With the following schema:
{code}
CREATE TABLE t (k VARCHAR NOT NULL, CONSTRAINT pk PRIMARY KEY (k DESC));
{code}
a query with an ORDER BY k should not output rows in descending order unless
DESC is explicitly specified.
For example, the following query should output rows A and then B:
{code}
UPSERT INTO t VALUES('A');
UPSERT INTO t VALUES('B');
SELECT * FROM t ORDER BY k;
{code}
while the following query should output B and then A:
{code}
SELECT * FROM t ORDER BY k DESC;
{code}
was:
With the following schema:
{code}
CREATE TABLE t (k VARCHAR PRIMARY KEY);
{code}
a query with an ORDER BY k should not output rows in descending order unless
DESC is explicitly specified.
For example, the following query should output rows A and then B:
{code}
UPSERT INTO t VALUES('A');
UPSERT INTO t VALUES('B');
SELECT * FROM t ORDER BY k;
{code}
while the following query should output B and then A:
{code}
SELECT * FROM t ORDER BY k DESC;
{code}
> Do not order rows in descending order on ORDER BY of a column declared as DESC
> ------------------------------------------------------------------------------
>
> Key: PHOENIX-1848
> URL: https://issues.apache.org/jira/browse/PHOENIX-1848
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
>
> With the following schema:
> {code}
> CREATE TABLE t (k VARCHAR NOT NULL, CONSTRAINT pk PRIMARY KEY (k DESC));
> {code}
> a query with an ORDER BY k should not output rows in descending order unless
> DESC is explicitly specified.
> For example, the following query should output rows A and then B:
> {code}
> UPSERT INTO t VALUES('A');
> UPSERT INTO t VALUES('B');
> SELECT * FROM t ORDER BY k;
> {code}
> while the following query should output B and then A:
> {code}
> SELECT * FROM t ORDER BY k DESC;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
