phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2942) Order by incorrect for RVC
Date Thu, 09 Jun 2016 19:36:21 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15323178#comment-15323178
] 

Hudson commented on PHOENIX-2942:
---------------------------------

FAILURE: Integrated in Phoenix-master #1247 (See [https://builds.apache.org/job/Phoenix-master/1247/])
PHOENIX-2942 Order by incorrect for RVC (jamestaylor: rev ec02daf34f46163b8d089eb50257fe43f134dc24)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/RowValueConstructorExpression.java


> Order by incorrect for RVC
> --------------------------
>
>                 Key: PHOENIX-2942
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2942
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Mujtaba Chohan
>            Assignee: James Taylor
>             Fix For: 4.8.0
>
>         Attachments: PHOENIX-2942-utest.patch, PHOENIX-2942_v2.patch
>
>
> {code}
> Incorrect
> select L_DISCOUNT, L_QUANTITY from lineitem_encoded order by (l_discount,L_QUANTITY)
limit 10;
> +-------------+-------------+
> | L_DISCOUNT  | L_QUANTITY  |
> +-------------+-------------+
> | 0.04        | 17          |
> | 0.01        | 4           |
> | 0.09        | 28          |
> | 0.1         | 46          |
> | 0.06        | 27          |
> | 0.04        | 36          |
> | 0.1         | 49          |
> | 0.01        | 15          |
> | 0.1         | 34          |
> | 0.01        | 28          |
> +-------------+-------------+
> {code}
> {code}
> Correct
> select  L_DISCOUNT, L_QUANTITY from lineitem_encoded order by (l_discount) limit 10;
> +-------------+-------------+
> | L_DISCOUNT  | L_QUANTITY  |
> +-------------+-------------+
> | 0           | 38          |
> | 0           | 24          |
> | 0           | 31          |
> | 0           | 41          |
> | 0           | 22          |
> | 0           | 5E+1        |
> | 0           | 1           |
> | 0           | 49          |
> | 0           | 28          |
> | 0           | 15          |
> +-------------+-------------+
> {code}
> {code}
> CREATE TABLE LINEITEM_ENCODED(L_ORDERKEY INTEGER not null, L_PARTKEY  INTEGER, L_SUPPKEY
 INTEGER , L_LINENUMBER  INTEGER not null, L_QUANTITY DECIMAL(15,2), L_EXTENDEDPRICE DECIMAL(15,2),
L_DISCOUNT DECIMAL(15,2), L_TAX DECIMAL(15,2), L_RETURNFLAG  CHAR(1), L_LINESTATUS  CHAR(1),
L_SHIPDATE DATE, L_COMMITDATE DATE, L_RECEIPTDATE DATE, L_SHIPINSTRUCT CHAR(25), L_SHIPMODE
CHAR(10), L_COMMENT VARCHAR(44) constraint pk primary key(l_orderkey, l_linenumber));
> {code}
> I'll get a utest for it soon.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message